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.

Designing and Implementing Cloud Data Platform Solutions (MOC 55247A)

This three-day instructor-led course is intended for data professionals who want to design and implement Microsoft Azure solutions for SQL Server, Azure SQL Database, MySQL and PostgreSQL. Microsoft Azure subscriptions will be issued to each student so they can practice Migration, Security, Availability, Disaster Recovery, Scalability, Monitoring and Troubleshooting features. Note: The Microsoft Azure environment…

MCSA SQL 2016 Database Administration Training & Certification Boot Camp (8 Days)

Our 8-Day MCSA SQL 2016 Database Administration Certification Boot Camp covers topics such as database installation, maintenance, configuration, and provisioning tasks with SQL Server 2016. This comprehensive training focuses on learning beyond the core content of standard Microsoft courses. Our program incorporates interactive demonstrations with exam focused explanations. This program will teach you the skills…

Administering a SQL Database Infrastructure (10764 Class Pack)

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.

Power BI Bootcamp

Power BI is Microsoft’s amazing data preparation and visualization tool. It is seemingly so simple, but looks can be deceiving. Hidden beneath an easy tool are amazing abilities to clean data, organize data, calculate data, and present that data in a logical and simple matter. In this class, we seek to unlock all the power…

Power BI for Developers

In this code-heavy, instructor-led course, developers will discover and experience the potential of Microsoft Power BI, the Power BI REST API, and Power BI Embedded, as it relates to providing business intelligence and reporting insight for organizations. This fast-paced course focuses heavily on real-world, organization and enterprise data and report integration, including concepts relating to…

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.”