DP-300: Administering Relational Databases on Microsoft Azure

This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.

DP-050: Migrate SQL Workloads to Azure

In this course, the students will explore the 7 R objectives of data platform modernization. They will learn the reasons why they should choose each objective and why each objective is most suitable for a variety of different business requirements. Students will also explore each phase of the data platform modernization process and define what…

Delivering High Quality Databases using Visual Studio

This two-day, instructor-led course provides students with the knowledge and skills to effectively develop, test, and deliver modern SQL Server databases. Student will experience how to manage changes to database schema, ensure quality through T-SQL unit testing and static code analysis, and automate the building and deploying of SQL Server databases.

Mastering SQL Server 2016 Business Intelligence

SQL Server 2016 is now the market leader as a Business Intelligence Platform. It is one of the rare stacks that covers all the bases: cubes, mobile reports, ETL, Big Data, data storage, In-Memory Data Structures, and data cleansing services.

Mastering SQL Performance Tuning

Nearly every enterprise business system talks to a database, and if that database is slow, the ramifications can be huge across all applications – a speedy database is critical. The black box of the SQL Server query processor makes things interesting for performance tuning, and this class is all about tuning T-SQL code to teach developers how to think and do “fast.”

Mastering Entity Framework

With Entity Framework (EF), Microsoft provides an object-relational mapper (ORM) for managing relational data, allowing developers to leverage the power of object-oriented programming (OOP) in their data-driven applications. Mastering Entity Framework provides you with the essential knowledge and skills needed to leverage the power and flexibility of the Entity Framework, while avoiding common mistakes and pitfalls.