IT Courses - Microsoft SQL Server 2016 and 2017 Introduction to Querying

Venue: Broomfield Hall
Cost (£): 700.00

Course Overview

This course provides a measured and relatively gentle introduction to
querying data stored in a Microsoft SQL Server 2016 or 2017 database
and could also prove beneficial to delegates who want to refresh their
existing querying skills. It is a comprehensive course, with plenty of
illustrated examples and practical hands-on exercises, paving the way
to our Advanced Querying programme.
ldeally, students should be familiar with basic programming concepts
as well as the fundamental design of relational databases, including
the purpose of primary and foreign keys, entity relationships and data
normalisation. You can gain this knowledge on our two-day Microsoft
SQL Server 2016 and 2017 Relational Database Design and Querying
Fundamentals course.

Course Content

• Use SQL Server Management Studio for querying purposes
• Understand the basic structure of SQL Server databases
• Understand the components of Transact-SQL (T-SQL)
• Retrieve data from tables using the SELECT statement
• Filter data using the WHERE clause
• Sort data using the ORDER BY clause
• Query data from multiple tables by using joins
• Summarise and group data using aggregate functions
• Combine and limit result sets
• Work with simple nested subqueries
• Work with correlated subqueries
• Add rows of data to a table using the INSERT statement
• Remove rows from a table using the DELETE statement
• Modify existing rows using the UPDATE statement
Check Available Course Dates & Book »