Introduction

Master the basics of SQL on this 1 day (Structured Query Language) SQL training course.

It will show you the key features and capabilities of SQL and get you using it as quickly as possible.

It is a hands-on course. It includes plenty of time for experimenting with what you are being taught, trying things out for yourself and asking questions.

By the time you finish, you’ll have a thorough grounding in SQL.

✔ A complete beginners’ SQL course that covers all of the basics.
✔ Plenty of one to one attention and time to ask questions.
✔ Friendly expert trainers, small groups and a comfortable place to learn.
✔ All the materials and extras that you’ll ever need.
✔ Ongoing support and help with issues you have after the course.

What Will I Learn?

This course will give you a thorough introduction to the features and capabilities of Structured Query Language (SQL).

It is suitable for anyone who wants to learn the basics of SQL, and uses Microsoft SQL Server as an example database for you to practise on.

By the end you will be able to:

  • Write basic SELECT statements including wildcard characters and comparison operators.
  • Carry out mathematical calculations in SQL
  • Group and Count your data.

Am I Ready For This Course?

You do not need prior experience with SQL to attend this course.

It is recommended that you have good experience of working in Windows and some experience of relational databases.

The Training Day

Our courses run from 9.30am to roughly 4.15pm with refreshments throughout the day and a break for a tasty, freshly prepared lunch.

We offer a relaxed, supportive learning environment, fully air-conditioned training facilities and some of the nicest instructors on the planet.

Also, you’ll receive:

✔ A full-colour manual covering everything in the course so that you can recap.
✔ A USB stick for the course exercises to let you practise more in your own time.
✔ 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