10985 - Introduction to SQL Databases
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.
10990 - Analyzing Data with SQL Server Reporting Services
This five-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.
20761 - Querying Data With Transact-SQL (Incl. Exam Voucher)
This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761.
20762 - Developing SQL Databases (Incl. Exam Voucher)
This five-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server database. The course focuses on teaching individuals how to use SQL Server product features and tools related to developing a database
20764 - Administering a SQL Database Infrastructure (Incl. Exam Voucher)
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.
20765 - Provisioning SQL Databases (Incl. Exam Voucher)
This course is designed to teach students how to provision SQL Server databases both on-premise and in SQL Azure.
20767 - Implementing a SQL Data Warehouse (Incl. Exam Voucher)
This five-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server database. The course covers SQL Server provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.
20768 - Developing SQL Data Modes (Incl. Exam Voucher)
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. This course helps you prepare for the Exam 70-768.
20778 - Analyzing Data with Power BI (Incl. Exam Voucher)
This three-day instructor-led course provides students with the knowledge and skills to analyze data with Power BI.
20779 - Analyzing Data with Excel (Incl. Exam Voucher)
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.