Introduction

Master the basics of SQL on this 1 day introduction to SQL training course.

This is a hands-on course. Our experienced trainers will have you writing your own SQL queries in no time.

We make sure that you have plenty of time to try things out and ask questions if you’re not sure of anything.

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.

The Trainer

 

Our usual trainer for this course is Serena.

Serena began her career as a business analyst before moving into IT training.

She is a Microsoft certified and TPMA qualified trainer and has 20+ years’ experience of leading training courses, managing training projects and writing training materials.

What Will I Learn?

By the end of this course you will be able to write your own basic SQL queries.

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 practice 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.

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

Am I Ready For This Course?

This is a beginners SQL course, you do not need prior experience with SQL to attend.

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

Please note that for live online courses you are responsible for installing a functioning version of SQL and MS SQL Server Management Studio on your PC prior to the course. On standard PCs this should take less than 10 minutes.

The Training Day

You don’t need to bring anything with you. We provide everything you’ll need for a really fun, productive day of training.

Our courses run from 9.30 am to roughly 4.30 pm 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 SQL manual covering everything in the course.
A USB stick for the course exercises to let you practise more in your own time.
A Certificate of Attendance.