List of Available Courses – Microsoft SQL Server 2017/2016
| Course ID | term | Price |
|---|---|---|
| MS55352A | 3 days | 650 euros + VAT |
See more information about "Introduction to SQL Databases (SQL Server 2016)": SESSIONS / DESCRIPTION / ASSOCIATED EXAMS
Planned sessions: 30.09 – 02.10.2024
Brief description: This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs.
Querying Microsoft SQL Server with Transact-SQL (SQL Server 2016)
| Course ID | term | Price |
|---|---|---|
| MS55366C | 5 days | 850 euros + VAT |
See more information about "Querying Microsoft SQL Server with Transact-SQL": SESSIONS / DESCRIPTION / ASSOCIATED EXAMS
Planned sessions: 18 – 22.11.2024
Brief description: This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling.
Querying Data with Transact-SQL
| Course ID | term | Price |
|---|---|---|
| DP-080T00A | 2 days | 400 euros + VAT |
See more information about "Querying Data with Transact-SQL": SESSIONS / DESCRIPTION / ASSOCIATED EXAMS
Planned sessions: 25 – 26.03.2024
Brief description: This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.
Querying Data with Transact-SQL - Beginner to Advanced
| Course ID | term | Price |
|---|---|---|
| DP-080T02A | 4 days | 650 euros + VAT |
See more information about "Querying Data with Transact-SQL - Beginner to Advanced": SESSIONS / DESCRIPTION / ASSOCIATED EXAMS
Scheduled Sessions: TBD
Brief description: This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.
Developing SQL Databases (SQL Server 2016)
| Course ID | term | Price |
|---|---|---|
| MS20762C | 5 days | 750 euros + VAT |
See more information about "Developing SQL Databases (SQL Server 2016)": SESSIONS / DESCRIPTION / ASSOCIATED EXAMS
Scheduled Sessions: TBD
Brief description: This five-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database.
The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.
Administering a SQL Database Infrastructure
| Course ID | term | Price |
|---|---|---|
| MS55353A | 5 days | 850 euros + VAT |
See more information about "Administering a SQL Database Infrastructure": SESSIONS / DESCRIPTION / ASSOCIATED EXAMS
Planned sessions: 01 – 05.04.2024
Brief description: This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.
Provisioning SQL Databases (SQL Server 2016)
| Course ID | term | Price |
|---|---|---|
| MS20765C | 5 days | 750 euros + VAT |
See more information about "Provisioning SQL Databases (SQL Server 2016)": SESSIONS / DESCRIPTION / ASSOCIATED EXAMS
Scheduled Sessions: TBD
Brief description: This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.
SQL Server Integration Services
| Course ID | term | Price |
|---|---|---|
| MS55321A | 5 days | 850 euros + VAT |
See more information about "Implementing a SQL Data Warehouse (SQL Server 2016)": SESSIONS / DESCRIPTION / ASSOCIATED EXAMS
Planned sessions: 23 – 27.10.2023
Brief description: This five-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing installation.
Developing SQL Data Models (using SQL Server Analysis Services)
| Course ID | term | Price |
|---|---|---|
| MS20768C | 3 days | 550 euros + VAT |
See more information about "Developing SQL Data Models (using SQL Server Analysis Services)": SESSIONS / DESCRIPTION / ASSOCIATED EXAMS
Scheduled Sessions: TBD
Brief description: The focus of this 3-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups.
Performance Tuning and Optimizing SQL Databases (SQL Server 2016)
| Course ID | term | Price |
|---|---|---|
| MS10987C | 4 days | 650 euros + VAT |
See more information about "Performance Tuning and Optimizing SQL Databases (SQL Server 2016)": SESSIONS / DESCRIPTION / ASSOCIATED EXAMS
Scheduled Sessions: TBD
Brief description: This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to perform tune and optimize their databases.
Managing SQL BI Operations (SQL Server 2016)
| Course ID | term | Price |
|---|---|---|
| MS10988C | 3 days | 500 euros + VAT |
See more information about "Managing SQL BI Operations (SQL Server 2016)": SESSIONS / DESCRIPTION / ASSOCIATED EXAMS
Scheduled Sessions: TBD
Brief description: This three-day instructor-led course is aimed at database professionals who manage Business Intelligence (BI) operations.
This course looks at various options that provide the ability of business users to analyze data and share their findings, starting with managed BI data sources and expanding to personal and external/public data sources.
Analyzing Data with Power BI (SQL Server 2016)
| Course ID | term | Price |
|---|---|---|
| MS20778C | 3 days | 500 euros + VAT |
See more information about "Analyzing Data with Power BI (SQL Server 2016)": SESSIONS / DESCRIPTION / ASSOCIATED EXAMS
Scheduled Sessions: TBD
Brief description: This three-day instructor-led course provides students with the knowledge and skills to analyze data with Power BI.
Analyzing Data with Power BI on Microsoft Azure
| Course ID | term | Price |
|---|---|---|
| DA-100T00A | 4 days | 650 euros + VAT |
See more information about "Analyzing Data with Power BI on Microsoft Azure": SESSIONS / DESCRIPTION / ASSOCIATED EXAMS
Scheduled Sessions: TBD
Brief description: This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Finally, this course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.
Analyzing Data with SQL Server Reporting Services (SQL Server 2016)
| Course ID | term | Price |
|---|---|---|
| MS10990C | 5 days | 750 euros + VAT |
See more information about "Analyzing Data with SQL Server Reporting Services (SQL Server 2016)": SESSIONS / DESCRIPTION / ASSOCIATED EXAMS
Scheduled Sessions: TBD
Brief description: This three-day instructor-led course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.
Upgrading Your Skills to SQL Server 2017
| Course ID | term | Price |
|---|---|---|
| MS10998A | 2 days | 450 euros + VAT |
See more information about "Upgrading your skills to SQL Server 2017": SESSIONS / DESCRIPTION / ASSOCIATED EXAMS
Scheduled Sessions: TBD
Brief description: This two-day instructor-led course is aimed at database professionals looking to update their skills to cover SQL Server 2017.
Upgrading Your Skills to SQL Server 2016
| Course ID | term | Price |
|---|---|---|
| MS10986A | 3 days | 550 euros + VAT |
See more information about "Upgrading your skills to SQL Server 2016": SESSIONS / DESCRIPTION / ASSOCIATED EXAMS
Scheduled Sessions: TBD
Brief description: This three-day instructor-led course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.
Data Analysis Fundamentals using Excel 2016
| Course ID | term | Price |
|---|---|---|
| MS10994A | 2 days | 370 euros + VAT |
See more information about "Data analysis fundamentals using Excel 2016": SESSIONS / DESCRIPTION / ASSOCIATED EXAMS
Scheduled Sessions: TBD
Brief description: The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets and to provide students with a foundation to learn about more advanced data analytics with Excel or Power BI.
Analyzing Data with Excel 2016
| Course ID | term | Price |
|---|---|---|
| MS20779A | 3 days | 450 euros + VAT |
See more information about "Analyzing data with Excel 2016": SESSIONS / DESCRIPTION / ASSOCIATED EXAMS
Scheduled Sessions: TBD
Brief description: The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI
Course Registration Form
Complete and send the attached form. In the shortest time, you will be contacted by a representative of our company.
