Introduction

Master the basics of SQL (Structured Query Language) on this 1 day SQL training course that is instructor-led.

You will learn the key features and capabilities of SQL so that you can start using it as quickly as possible.

This a hands-on course that includes plenty of time actually querying a database and experimenting with what you are being taught in real time. This way, you can try things out for yourself and get to ask questions.

You will have a thorough grounding in SQL by the time you finish.

✔ A total beginners’ SQL course designed to cover all of the basics.

✔ Good one to one attention and time to ask questions.

✔ Friendly expert trainers, small groups and a comfortable place to learn.

✔ Materials and extras that you’ll need.

✔ Support and help with issues you encounter after the course.

What Will I Learn?

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

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

By the end of the course, 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?

No prior experience with SQL is needed to attend this course.

We do recommend that you have experience working in Windows. Also, any knowledge of relational databases will be useful, although this is not required.

The Training Day

This course will start from 9:30am and end around 4:30pm. We offer refreshments throughout the day and a break for a tasty, freshly prepared lunch.

We offer a relaxed learning environment, with friendly and supportive instructors.

You will also receive:

✔ Material covering everything you learned so that you can recap.

✔ A USB stick for the course exercises so you practice more in your own time.

✔ A Certificate of Attendance.

Summary of Course Details

Getting Started

We will start the training with an overview of relational databases and how SQL works in that context. We will also look at the database that will run our SQL queries on during the training so we can get comfortable with its interface.

Key topics will be:

• Relational Database Concepts
• The role of SQL
• A familiarization with the databases that we will use during the training.

Writing Basic SQL Statements

• The SELECT statement syntax and its options
• The use of the DISTINCT keyword
• ORDER BY
• The use of criteria such as wildcards, comparison operators, BETWEEN, LIKE, IN

Single Row Functions

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

Grouping Data

• Writing aggregate queries
• COUNT Vs Count(*)
• GROUP BY
• HAVING

SQL Joins

• Including data from multiple tables in queries
• Joining multiple tables in the FROM clause
• Different join types such as INNER and OUTER joins and SELF joins

Refund Policy