Comprehensive and intensive, this five-day course includes plenty of

illustrated examples and practical hands-on exercises to enhance your

learning experience.

 

Delegates should be familiar with basic programming concepts and

also understand the fundamental design of relational databases,

including the purpose of primary and foreign keys, entity relationships

and data normalisation. Our SQL Server 2016 and 2017 Relational

Database Design and Querying Fundamentals course would be the

ideal way for you to gain this knowledge.

• Identify the primary components of a typical SQL Server 2016 or 2017 installation

• Identify the tools available in SQL Server 2016 or 2017

• Use SQL Server Management Studio (SSMS)

• Understand the components of Transact-SQL (T-SQL)

• Retrieve, filter and sort data

• Work with the native SQL Server data types

• Query data from multiple tables using joins

• Summarise and group data

• Use window functions for ranking and aggregating data

• Combine and limit result sets

• Work with subqueries

• Use crosstab queries

• Use common table expressions

• Work with SQL Server date and time data

• Modify data with INSERT, DELETE and UPDATE

• Merge data with the MERGE statement

• Understand and implement transactions

• SQL Server locks

• SQL Server indexes

• Understand query performance issues

• Create and manage views