This course is aimed at those who need to extract information from a relational database system.
Although it provides an overview of relational database design principals it does not cover the teaching of formal database design processes and database/table creation.
The course assumes no previous knowledge of SQL and SELECT statements, and takes delegates from simple queries, through to complex queries involving multiple tables, introducing the vast collection of built-in functions along the way.
This course is suited to Database Administrators, Developers, Report Writers and Data Analysts - anyone who needs to extract information from data stored in a relational database.
This course, along with the Creating Databases in SQL Server and Advanced 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.