Course Description
Although the certification related to this course has been retired by Microsoft, the content is still relevant in learning and managing the technology. The Querying Microsoft SQL Server 2014 show is for those who are seeking to validate their skills and knowledge in writing Transact SQL queries. The show helps the certification candidate by describing, discussing and demonstrating SQL query writing skills in multiple areas. The episodes will cover the advanced SELECT statements, grouping sets, aggregates, SET operators, basic T-SQL programming and Performance Improvement. The show focuses heavily on demonstrating the syntax and logic of writing the queries. This particular exam is intended for candidates that have two or more years of experience in writing queries with Microsoft SQL Server