Microsoft SQL Server 2016 and 2017 Introduction to Querying
This 2 day course is intended for students who are new to querying data stored in either a Microsoft SQL Server 2016 or 2017 database, and who need a measured and relatively gentle introduction to the subject. It could also prove beneficial to delegates wanting to refresh their existing querying skills.
You will find that this is a comprehensive course for this level, with plenty of illustrated examples and augmented with practical hands-on exercises.
This course is also intended as a prerequisite to the 2 day “Microsoft SQL Server 2016 and 2017 Advanced Querying” course.
Students should ideally be familiar with basic programming concepts.
They should also understand the fundamental design of relational databases including, but not restricted to, the purpose of primary and foreign keys, entity relationships, and data normalization. These prerequisites can be met by taking the 2 day “Microsoft SQL Server 2016 and 2017 Relational Database Design and Querying Fundamentals” course.
Upon successful completion of this course, students will be able to:
Identifying the Elements of SSMS
Objects in a SQL Server Database
Database Diagrams
Components of a SQL Server Database Table
The Querying Environment
Creating a Script
Adding Comments to your Code
Categories of SQL Statements
ANSI-SQL and Transact-SQL (T-SQL)
Examine the Basic Syntax of the SELECT Statement
Using String Literals and Expressions
Retrieving Columns of Data from a Table
Using Aliases for Column Names
How to Use the WHERE Clause
Overview of Operators
Filter Data by Using Comparison Operators
Filter Data by Using String Comparisons
Filter Data by Using Logical Operators
Filter Data Using a Range of Values
Filter Data Using a List of Values
Filter Data with NULL Values
Filtering Date and Time Data
Sorting Data Using the ORDER BY Clause
Eliminating Duplicate Rows with DISTINCT
Introduction to Joins
Using Inner Joins
Using Outer Joins
Using Cross Joins
Using Aliases for Table Names
Joining More than Two Tables
Using Aggregate Functions Native to SQL Server
Using Aggregate Functions with NULL Values
Grouping Summarized Data with GROUP BY
Filtering Grouped Data Using the HAVING Clause
Combining Result Sets Using the UNION Operator
Limiting Result Sets Using the TOP Operator
Introduction to Subqueries
Using Subqueries as Expressions and Derived Tables
Using Correlated Subqueries
Using EXISTS with Correlated Subqueries
Inserting a Single Row into a Table
Inserting Multiple Rows into a Table
Inserting Values into Identity Columns
Differentiating Various INSERT Statements
Deleting Rows from a Table
Truncating a Table
Deleting Rows Based on Data in Other Tables
Updating Rows in a Table
Updating Rows Based on Data in Other Tables
Group discount | ||
1 place | £ 1500 | n/a |
2 places | £ 1800 | n/a |
3 places | £ 4500 | £ 2100 |
4 places | £ 6000 | £ 2400 |
5 places | £ 7500 | £ 2700 |
6 places | £ 9000 | £ 3000 |
7 places | £ 10500 | £ 3300 |
8 places | £ 12000 | £ 3600 |