Main Topics for this Beginners SQL Training Course
The SQL language is the foundation of all database tasks and job roles and is the fundamental way of creating and retrieving database content
This database query writing 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 cover:
- Understanding the key components of relational databases - tables, columns, relationships, keys
- 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.
Should you be interested in SQL Server certification:
The Microsoft certification program has now moved away from MCSA and MCSE to fundamental and role-based certifications. The SQL based MCSA and MCSE exams and certifications are being retired at the end of January 2021. Although there are now no exams focusing solely on SQL or SQL Server the SQL language remains a core pre-requisite requirement for both your data job role and the new Microsoft certifications.
What Next?
On completion of this course, delegates will have met the pre-requisites to attend the (SQL) Advanced SQL Server Database Querying Course.
Target Audience:
This basic SQL training course is aimed at data analysts, SQL developers, SQL Server database administrators or anyone working with data who need to get started with SQL query writing. Delegates attending this introductory SQL course require no previous SQL or database skills.