About SQL Server and T-SQL
This course provides an in-depth look at Microsoft’s relational database management system, SQL Server, as well as Microsoft’s proprietary flavor of SQL technology, T-SQL. The course material builds upon prior coursework with SQL, and explores topics including T-SQL queries, query tuning, multi-table queries, grouping, pivots, windowing, T-SQL for Microsoft BI, objects, OLTP, graphs, and recursive queries. Upon completion of the course, students will be confident performing detailed and complex SQL and RDBMS operations in a Microsoft environment.
Students must have completed ASD225 with a satisfactory grade.