We start this session with an overview of relational databases and how SQL works within that context. We also have a look at the database that we will be running out SQL queries on during this course and get comfortable with the interface.
The key topics trained are:
Relational Database Concepts
The role of SQL
Overview of the databases used in the workshop
Understanding Data Types
Data Type Management
The syntax of the SELECT statement
Using the DISTINCT, TOP keywords
Examples of WHERE criteria including AND, OR, LIKE wildcards, comparison operators and BETWEEN, IN
ISNULL() function v IS NULL criterion
Optimising your SELECT statements
The types of functions available in SQL
Performing mathematical calculations
Performing String manipulations
Conversion functions and their uses
• How to write aggregate queries
• COUNT, SUM(), MAX(), MIN()
• GROUP BY
• The principle of including data from multiple tables in queries
Am I Ready For This Course?
This is a beginners’ SQL course, so you do not need prior experience with SQL to attend.
It is recommended that you have good experience of working in Windows and some experience of relational databases.
Please note that for live online courses you are responsible for installing a functioning version of SQL and MS SQL Server Management Studio on your PC prior to the course. On standard PCs this should take less than 10 minutes.
The Training Day
You don’t need to bring anything with you. We provide everything you’ll need for a really fun, productive day of training.
Our courses run from 9.30 am to roughly 4.30 pm with refreshments throughout the day and a break for lunch.
We offer a relaxed, supportive learning environment, fully air-conditioned training facilities and some of the nicest instructors on the planet.
Also, you’ll receive:
✔ A full-colour SQL manual covering everything in the course. ✔ A USB stick for the course exercises to let you practise more. ✔ A Certificate of Attendance.
Online Training Requirements
To attend this SQL Training course online, you will need:
✔ MS SQL Server Management Studio connected to a SQL database on your Windows PC/laptop with a camera, speakers & microphone ✔ A stable internet connection capable of running Zoom ✔ To be a confident computer user and able to use Zoom
If you have access to a second screen, we would encourage you to use it as it improves the experience.