Home | Power BI | Excel | Python | SQL | Generative AI | Visualising Data | Analysing Data
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