Introduction to SQL

Benefits

Introduction to SQL

Explanation of SQL
Importance and common application of SQL
Types of Databases that use SQL

Relational Databases

What is a database?
Relational databases
Components of a relational database

SQL Basics

Understanding SQL syntax
Using SQL to manipulate data
Common SQL commands

Creating Databases and Tables

Creating databases
Creating tables
Defining table relationships

Data Manipulation with SQL

Retrieving data using SELECT statement
Filtering data with WHERE clause
Sorting data with ORDER BY clause

Advanced SQL Commands

JOIN clauses
Subqueries
Aggregate functions

SQL Functions

String Functions
Date and Time Functions
Numeric Functions

Managing Data with SQL

Inserting data into tables
Updating data in tables
Deleting data from tables

Data Integrity

Primary keys and foreign keys
Indexes
Constraints

Face-to-face training

Training is held in our modern, comfortable, air-conditioned suites.

Modern-spec IT, fully networked with internet access

Lunch, breaks and timing

A hot lunch is provided at local restaurants near our venues:

• Bloomsbury
• Limehouse

Courses start at 9:30am.

Please aim to be with us for 9:15am.

Browse the sample menus and view joining information (how to get to our venues).

Refreshments

Available throughout the day:

• Hot beverages
• Clean, filtered water
• Biscuits

Virtual training

Regular breaks throughout the day.

Learning tools

In-course handbook

Contains unit objectives, exercises and space to write notes

Reference material

Available online. 100+ pages with step-by-step instructions

24 months access to Microsoft trainers

Your questions answered on our support forum.