This course is aimed at SQL Server database developers, administrators and analysts who need to take the basics of SQL Server SQL Data Manipulation Language (DML) statements to the next level. The aim of the course is to show the more advanced use of SELECT, UPDATE and DELETE statements providing delegates with the necessary knowledge and hands on experience to construct complex queries to satisfy complex information extraction requirements. The course focuses on real world business needs and shows how to make the extensive SQL Server library of functions work together to manipulate and extract data values. It also explores the many different ways of retrieving information from multiple tables from simple multi-table SELECT statements through to complex correlated sub-queries as well as introducing the many ways of analysing and processing data through methods such as grouping of data and implementing computed columns. The course will do more than just teach each topic as an isolated subject; it will show delegates how to integrate all these query methods and more to help satisfy their business information extraction needs.
This course, along with the Creating Databases in SQL Server and SQL Server Database Querying Courses, helps to prepare delegates for the Microsoft 70-761 exam: Querying Data with Transact-SQL and the Microsoft 70-762 exam: Developing SQL Databases, which credits towards MCSA and MCSE certifications.. It should be noted, however, that all course attendances should be complemented by reference to the skills measured by the exam, a period of self-study and test exams before sitting the actual exam.
Covers SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017.