Remote Training - All our taught courses can now be attended from any location.
Click to Learn More ››

banner image

Course Information


Students will learn what SQL is and how it can help them query a database to answer business questions.

Target Student

Students should be familiar with the components that make up the PC, including input, output, and storage devices. They should also be familiar with concepts related to database structure and terminology.


Students will learn how to use SQL statements to query a database.


Windows Introduction or equivalent knowledge.


  • Database concepts
  • Understanding SQL concepts
  • An overview of the SELECT statement
  • Syntax rules you’ll want to know
  • Aggregate functions
  • Column aliases
  • Performing calculations
  • Date functions
  • The WHERE clause
  • The ORDER BY clause
  • Searching for text
  • Logical operators
  • NULLs
  • The GROUP BY clause
  • The HAVING clause
  • Comparing the WHERE and HAVING clauses
  • Joins
  • Joining tables
  • Outer joins
  • Connecting to a database
  • Querying a database
  • Generating a report of the data
  • Querying multiple tables with unions
  • Advanced Joins
  • Calculating with COMPUTE
  • Subqueries
  • Inserting data
  • Updating records
  • Deleting records
  • Deleting the contents of tables
  • Creating tables
  • Modifying tables
  • Deleting tables
  • Adding and removing views
  • Adding and removing indexes
  • Transactions
  • Creating a database with SQL
  • Deleting a database
Public Dates & Prices

If you would like onsite training for this course, request a quote.

course icon
2 Days

Upcoming Public Dates

Remote Mon 24th Aug 2020 £595
Remote Tue 15th Sep 2020 £595
Remote Mon 12th Oct 2020 £595
Remote Mon 26th Oct 2020 £595
Remote Mon 16th Nov 2020 £595
More Dates


  • Noel was an excellent tutor. He did check all of the group was able to keep up and if there were any problems or questions of the attendants, he was always willing to help.

    Marianne Seager - Wincanton
  • This was a really good training, nicely paced, very useful and well presented. Thank you, Stuart!

    Joris Latinne - Oracle