SQL Server Database Querying

SQL Training Course

This introduction to SQL course is the first of a series of SQL programming courses and focuses on the foundation topics you will need to get started with writing SELECT statements and querying a SQL Server Database.

No matter what you do with databases you should start with a SQL Programming Course and learn how to write SQL queries and our SQL Database Querying Course is step 1 in preparing yourself for your career with SQL databases.

This introductory SQL training course is offered in a face to face classroom or virtual setting and can be tailored to your needs.

You will learn about the key components of relational databases - tables, columns, relationships, keys, and how to use SQL for:

• Writing SQL queries with the SELECT Statement

• Restricting record sets with filters

• Combining table data with joins

• Working with common SQL functions to transform stored data and derive new business values

• Grouping and summarising data to derive aggregate values such as sub totals, record counts and averages

This course is relevant to: SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, Azure SQL Database, Azure SQL Data Warehouse, Azure Synapse, Microsoft Fabric.

What Next?

On completion of this course, delegates will have met the pre-requisites to attend the Advanced SQL Server Database Querying Course.

Delegates would benefit from a basic understanding of what a relational database is a familiarity with the terms tables, columns, and relationships, these concepts will be overviewed at the start of the course.