Your would need this course if:

• You have business applications that use SQL Server to store data and want query that data yourself
• You are developing client/server applications that will store data in SQL Server

You don't need any previous experience of Structured Query Language (SQL) before attending this course. However, general knowledge of databases, tables and relationships will help.

• Introduction - Basic architecture and concepts of SQL Server, Azure SQL and T-SQL
• Retrieving Data - Writing SELECT queries on single and multiple tables along with sorting filtering
• Data Types -  Defining and using different data types, variables and parameters
• Modify Data - Inserting, deleting and updating while considering locking and data consistency
• Summarise Data - Built-in functions, group and aggregate data, sub-queries
• Programming Statements - Procedural statements IF...ELSE, WHILE and GOTO, BEGIN...END and PRINT
• Error Handling - Intercepting with TRY...CATCH and communicate with RAISEERROR
• Transact SQL - Use views to hide complexity, calculate values and use triggers to execute T-SQL

Introduction to SQL Server

• The Basic Architecture of SQL Server
• SQL Server Editions and Versions
• Getting Started with SQL Server Management Studio

Introduction to T-SQL

• Introducing T-SQL
• Understanding Sets
• Understanding Predicate Logic
• Understanding the Logical Order of Operations in SELECT statements

Select Queries

• Writing Simple SELECT Statements
• Eliminating Duplicates with DISTINCT
• Using Column and Table Aliases
• Writing Simple CASE Expressions

Multiple Tables

• Understanding Joins
• Querying with Inner Joins
• Querying with Outer Joins
• Querying with Cross Joins and Self Joins

Sort and Filter

• Sorting Data
• Filtering Data with Predicates
• Filtering with the TOP and OFFSET-FETCH Options
• Working with Unknown Values

Data Types

• Introducing SQL Server 2016 Data Types
• Working with Character Data
• Working with Date and Time Data

Modify Data

• Inserting Data
• Modifying and Deleting Data

Built-in Functions

• Writing Queries with Built-In Functions
• Using Conversion Functions
• Using Logical Functions
• Using Functions to Work with NULL

Group and Aggregate

• Using Aggregate Functions
• Using the GROUP BY Clause
• Filtering Groups with HAVING

Subqueries

• Writing Self-Contained Subqueries
• Writing Correlated Subqueries
• Using the EXISTS Predicate with Subqueries

Set Operators

• Writing Queries with the UNION Operator
• Using EXCEPT and INTERSECT
• Using APPLY

The course runs from 9:30am through to 4:30pm.

You will learn in a relaxed environment with a small group of people. A specialist tutor will guide and encourage you through all the learning necessary to develop your skills and questions are always welcome.

Included with your course
We provide the following with online and training centre delivered courses.

• Course notes
• Certificate of attendance
• 90 days post course support

Online Delivery
A link to the online training platform will be sent before the course, simply click the link and follow the instructions.

• See Virtual / Remote training information for more details
• Contact us if you'd like to test the platform before the morning of the course
• You can be located anywhere in the world with an internet connection and your computer
• Collaboration - if you have a Power BI Pro licence assigned to your own 365 account then you can sign-in to Power BI to try out these options

Our Training Centres
For training courses run at one of our training centres we include.

• Free onsite parking
• Lunch and refreshments
• Notepad, pen and Polos

Our Norwich on-site parking (NR3 1UB) is free and situated 5 minutes walk along the river to our training centre at St James Mill. If you arrive by train it is about 20 minutes on the Riverside walk or a short taxi ride to get to us. View full directions for Norwich and all our other venues.