Day 1 PM

Welcome back!

The topics you will cover on the afternoon of the first day are listed below.

Groups of commands in SQL

In this session, you will be given an overview of SQL and start your practice by identifying main groups of commands.

SQL Databases and Tables

Here, you will learn how to create, populate and delete databases and tables.

SQL Databases and Tables exercise

In this practical activity, you are asked to create and populate a table on your own.

The Northwind Database

In this task, you will use the Northwind database, made available by Microsoft.

SELECT statement: overview

Here, you will be provided with an overview of the SELECT statement.

SELECT statement: retrieving data

In this session, you will be provided with a recap and practise selecting columns, calculated columns, and aliases.

Retrieving data exercise

In this practical activity, you will perform practical tasks using the Northwind database. You will create simple SELECT statement queries.

SELECT statement: filtering rows

Here, you will be provided with a recap and practice extracting only the rows satisfying given conditions.

Filtering rows exercise

In this practical activity, you will perform practical tasks using the Northwind database. You will use basic WHERE clauses and the IN and BETWEEN operators.

SELECT statement: sorting rows

In this session, you will be provided with a recap and practice sorting rows.

Sorting rows exercise

In this practical activity, you will perform practical tasks using the Northwind database. You will use basic ORDER BY clauses and add an ORDER BY clause to an earlier query.

Common functions

Here, you will explore common scalar functions in SQL.

Common functions exercise

In this practical activity, you will use the QAStore database and write SQL SELECT statements to query the contents of its tables using some common functions.

When you’re ready, select Next to continue.