SQL Training Courses - Live Online training

SQL Code Introduction Course

This one day course will equip you with the knowledge to extract meaningful data from a database. Our Introduction level course covers retrieval of data including filters, sums, calculations and updating and deleting data. Delegates will also learn to extract data from multiple tables. Delegates do not require any previous knowledge of SQL. However, an understanding of relational database design is a preference, but not essential.

Read More

SQL Code Introduction training course outline

Understanding Relational Databases
Understand how a relational database is structured
Identify Primary and Foreign keys
Write statements to extract data from multiple tables

The Basics and Writing Comments
Write the SELECT Clause
Use the FROM Clause
Create different types of comments

Sorting and Filtering
Use Order By
Work with AND
Work with OR
Apply AND and OR together
Use IN
Work with wildcards to extract data

Work with Alias and Mathematical Fields
Concatenate columns
Create an alias using AS
Use Mathematical Operators
Apply Aggregate functions - SUM, AVG, MIN, MAX, COUNT
Apply the Group By Clause

Apply Changes to Data
Use the INSERT Clause
Apply an Update
Change specific values
Use the DELETE Clause

Training Dates - Live Online

Fri 1st October 2021

Fri 5th November 2021

Thu 9th December2021

Delivered live online, or at your offices. Please contact us to arrange a date to suit you. Group booking rates are available on request.

Price

£325

Download Course Details

Book this course

SQL Code Intermediate Course

The aim of this one day course is to further develop SQL querying skills. The course builds on our SQL Introduction elements and covers some of the more advanced Clauses & Statements and includes an introduction to functions. The course covers more complex joining of tables.

Course Prerequisite: Delegates must have either attended our SQL Introduction course or be comfortable with the course objectives covered at Introductory level.

Read More

SQL Code Intermediate training course outline

Standard Clauses
Use the DISTINCT Clause
Work with AND and OR
Understand IN and NOT
Review of wildcards
Group Information
Understand the HAVING Clause

Advanced Clauses and Functions
Apply Advanced mathematical operators
Work with various DATE functions
Understand uses of TOP
Work with IS NULL
Apply the CONVERT Clause
An introduction to Working with CASE

Creating and Deleting
Create Databases
Create Tables
Add Columns
Create Views
Create Indexes
Delete databases
Clear data from a table
Delete Tables
Delete Columns
Delete Indexes

Table Joins
Apply an INNER Join
Use a LEFT Join
Use a RIGHT Join
Use a FULL OUTER Join
Work with UNION

Training Dates - Live Online

Fri 15th October 2021

Tue 23rd November 2021

Thu 14th December 2021

Delivered live online, or at your offices. Please contact us to arrange a date to suit you. Group booking rates are available on request.

Price

£345

Download Course Details

Book this course

SQL Code Advanced Course

SQL querying skills building on SQL Intermediate elements and covering more advanced functions and statements including transactions and stored procedures.

Course Prerequisite: Delegates must have either attended our SQL Intermediate course or be comfortable with the course objectives covered at Intermediate level.

Read More

SQL Code Advanced training course outline

Working with CASE

Build Sub-queries
Creating and using Views

Introduction to Variables

Create and apply User Defined Functions

Create and use Stored Procedures

Introduction to Transactions

Introduction to Cursors

Using Loops and Cursors in a Stored Procedure

Training Dates - Live Online

Wed 20th October 2021

Mon 29th November 2021

Wed 15th December 2021

Delivered live online, or at your offices. Please contact us to arrange a date to suit you. Group booking rates are available on request.

Price

£395

Download Course Details

Book this course