Zomalex | Data and AI Training

Home | Power BI | Excel | Python | SQL | Generative AI | Visualising Data | Analysing Data | Prices | Contact Us | info@zomalex.co.uk

SQL Intermediate Course Outline

Who should attend

People who have attended the foundation course and want to improve their SQL skills.

Course Length

1 day (short version) or 2 days (preferred, full version)

Learning Objectives

You will learn how to combine data held across several tables and more powerful SQL techniques to help you retrieve exactly the data you need

Pre-requisites

Basic familiarity with the SQL SELECT statement. Completion of the foundation course.

Course Content

• Get data from several tables using JOINs. Create a SQL statement that retrieves data more than one table
• Use the JOIN clause to specify the common columns. The JOIN keyword. Types of JOIN (INNER, LEFT, others)
• Subqueries and CTEs. Subqueries and common table expressions (CTEs) increase the analytical power of our SQL statements.
• Temporary tables and their uses.
• CASE statements. The CASE statement gives great flexibility to create new calculated columns. The basic CASE WHEN THEN ELSE END structure.
• NULL values for missing data. Dealing with NULL

A few comments from attendees of previous courses

“Mark was an amazing trainer, thank you!”

“Another great course , very clear and easy to follow. Much appreciated. Very enjoyable course and Mark was brilliant.”

“Very engaging and found it useful”