SQL Training – Introduction

This 1 day (Structured Query Language) SQL training course will rapidly give you a thorough grounding in the basics of SQL. It will show you the key features and capabilities of SQL and get you using it as quickly as possible.  The course covers elements of ANSI SQL using SQL Server as an example database.

To give delegates an introduction to the features and capabilities of Structured Query Language (SQL). The course covers elements of ANSI SQL using Microsoft SQL Server as an example database.
This course is suitable for anyone who wants to learn the basics of SQL whether using Microsoft SQL Server, Microsoft Access, Oracle, MySQL, Google BigQuery or other database systems.

It is recommended that delegates have good experience of windows and some experience of relational databases.

Our courses run from 9.30 am to approximately 4.30 pm. While you are with us we are focused on offering you a relaxed and productive learning environment. When you book a course with use you get the following:
  • A full colour SQL course manual.
  • The exercises that you have worked on during your course to allow you to practice afterwards.
  • USB stick to take the exercises away.
  • Freshly prepared lunch
  • Refreshments though out the day.
  • Training in fully air conditioned facilities from an experienced SQL instructor.
  • A certificate of attendance.

We start this session with an overview of relational databases and how SQL works within that context. We also have a look at the database that we will be running out SQL queries on during this course and get comfortable with the interface.

The key topics trained are:

  • Relational Database Concepts
  • The role of SQL
  • Overview of the databases used in the workshop

• The syntax of the SELECT statement
• Using the DISTINCT keyword
• ORDER BY
• Examples of WHERE criteria including wildcards, comparison operators, BETWEEN, LIKE, IN

• Performing mathematical calculations
• The types of functions available in SQL
• Useful date functions
• GetDate( )
• DateADD( )
• DateDIFF( )
• Conversion functions and their uses
• Column aliases

• How to write aggregate queries
• COUNT Vs Count(*)
• GROUP BY
• HAVING

• The principle of including data from multiple tables in queries
• Joining multiple tables in the FROM clause
• Different join types including INNER and OUTER joins and SELF joins