This advanced T-SQL course focuses on writing and tuning queries and programming with T-SQL in SQL Server 2012, 2014, 2016, 2017 and in Azure SQL Database. In this course you will learn the details and capabilities of T-SQL in the following areas: Logical Query Processing; Query Tuning (Internals and Index Tuning, including Columnstore Indexes, Query … Continue reading SQL417: Advanced T-SQL Querying, Programming and Tuning for SQL Server 2012 – 2017

This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. The main purpose of the course is to prepare people for the exam “70-461: Writing Queries Using Microsoft® SQL Server® 2014 Transact-SQL.” This exam will be the underlying exam for all SQL Server-related disciplines; namely, Database Administration, … Continue reading 20461: Querying Microsoft SQL Server 2014 (See Course SQL250)

The course will very likely be well attended by SQL power users who aren’t necessarily database-focused; namely, report writers, business analysts and client application developers. Also see course SQL250: Transact-SQL for Developers

In this course, you’ll establish a solid foundational understanding of database concepts and terminology. Then you’ll master the use of various Microsoft tools to submit queries to quickly and efficiently get the results you want. We teach students how to write a query the same way that SQL Server processes a SQL statement – following … Continue reading SQL250: Transact-SQL for Developers

In this course, you’ll master the skills needed to write Transact-SQL SELECT statements accessing one or more tables. You’ll also learn the various techniques for combining data, filtering the results and how to control and format the statement output. You’ll gain a foundation understanding of a SQL Server database and use the tools available to … Continue reading SQL101: Introduction to Transact SQL