About this course
The Intermediate SQL Queries course is for people with some SQL knowledge who want to write more advanced queries. It focuses on subqueries, joins and set operators.
Please note that the course is not specific to any particular database system.
What others say
Why you want to attend
You should attend the Intermediate SQL Queries course if:
- You can write basic SQL queries but need to be able to extract data from multiple tables.
- You want to improve your SQL queries.
What you need to know first
Before you attend the Intermediate SQL Queries course:
- You must have attended our SQL Fundamentals course or already be comfortable with writing basic SQL queries.
Price and duration
Price: R8,400.00 excluding VAT per delegate.
This price includes everything that you need:
- All course material, provided in an electronic format.
- An attendance certificate after the course, in PDF format.
Duration: 3 days (with effect February 2024).
The Intermediate SQL Queries course is presented virtually. Find out more about our virtual training and how it works.
Please check the course schedule for the next available date.
How to book
It’s so easy to book for the Intermediate SQL Queries course.
Just email us at info@incusdata.com. You can send us a purchase order, or fill in our course enrolment form.
After we have received your booking, we will confirm that you are booked, and we’ll send you an invoice.
Detailed course contents
SQL Fundamentals
- Entity integrity and referential integrity.
- Structure of the SELECT statement.
- Arithmetic, comparison, assignment and logical operators.
- Special SQL operators: BETWEEN, IS NULL, LIKE, IN.
- Aggregate functions: SUM, AVERAGE, MAX, MIN and COUNT.
- The GROUP BY and HAVING clauses.
Intermediate SQL Functions
- Functions for string and number manipulation.
- Date functions and date arithmetic.
- Converting data types.
- Formatting numeric values.
- The COALESCE function.
- CASE statements.
- Window functions.
- Using functions in other clauses.
- The LIMIT clause.
Subqueries
- Creating sub-queries.
- The use of ALL and ANY in subqueries.
- Correlated subqueries.
- Subqueries in the FROM clause.
- Subqueries in INSERT and UPDATE statements.
Table Joins
- Extracting data from multiple tables through table joins.
- Types of joins.
- Combining multiple tables with different joins.
- Using GROUP BY on joined tables.
- Using HAVING on joined tables.
Set Operations
- The UNION operator.
- The INTERSECT operator.
- The EXCEPT operator.
Additional Topics
- Derived or temporary tables.
- Rotating rows into columns.
- Creating and using views.
- Introduction to procedures.
- Introduction to transactions.
- Commit and rollback in transactions.
Download the course outline
Download the Intermediate SQL Queries course outline in PDF format.