Aims

This course is designed for those who need to manipulate data held in a standard relational database using basic SQL.

Objectives

On completion of this course, attendees will be able to retrieve and manipulate data held within relational databases using the SQL querying language.

Pre-Requistites

There are no pre-requisites, however, delegates would be assumed to have good general IT skills.

Versions

Courses are delivered in 2007, 2010, 2013, 2016.

What will I learn?

Introduction to SQL

  • History of the SQL language, where it came from and its different variants.

Relational Databases

  • Overview of relational database design and its different forms.
  • 1st Normal Form
  • 2nd Normal Form
  • 3rd Normal Form

Select Statement

  • How to retrieve data from the database in the form of a query.
  • Distinct
  • Top

Where Clause

  • How to filter your retrieved data.
  • Operators
  • IN
  • LIKE
  • BETWEEN
  • AND
  • OR

Order By

  • How to sort your retrieved data ascending or descending.

Insert Into

  • How to insert new data into and existing table.

Update

  • How to update existing table data.

Delete

  • How to delete data from and existing table.

Truncate

  • How to truncate data from and existing table.

Joins

  • How to retrieve data from multiple tables using a join.
  • Inner
  • Left
  • Right
  • Outer

Union

  • How to join data from two different datasets.

SQL Functions

  • Overview of SQL Functions and an overview of the most commonly used ones.
  • Substring
  • Left
  • Right
  • Replace
  • Charindex
  • Getdate

Group By

  • How to group and aggregate the results for your retrieved data.
  • Aggregation functions
  • Max
  • Min
  • Avg
  • Sum
  • Count

Stay up to date

Subscribe to our mailing lists:

I would like to receive the following emails:
Mailing lists

We are collecting your email address to send you the emails you select above and we require your consent. By clicking the Subscribe button, we are treating this as your consent. To withdraw your consent, please use the unsubscribe option at the bottom of the received email(s)