About this course
The Intermediate SQL Queries course is designed for delegates who are comfortable with basic SQL queries and need to work with more complex data retrieval tasks.
The course covers query techniques involving subqueries, joins, and set operators, with emphasis on flexible data selection and filtering.
The course is not linked to any specific database system. The concepts apply across platforms.
Delegate feedback
Feedback from delegates attending this course:
Intended audience
The Intermediate SQL Queries course is useful if:- You can write basic SQL queries and need to retrieve data from multiple tables.
- You need to write more complex queries using joins or subqueries.
Prerequisites
You should be comfortable with writing basic SQL queries.
We recommend attendance of the SQL Fundamentals course or equivalent experience.
Course details
Price: R8,900 excluding VAT per delegate.Included:
- Electronic course material.
- Attendance certificate (PDF).
Duration: 3 days.
Delivery: Virtual classroom
See how virtual training works.
See the course schedule for upcoming dates.
Booking information
Email your booking to info@incusdata.com. A purchase order, or completed enrolment form is sufficient.
We will confirm the booking and issue an invoice.
Detailed course contents
Core Query Concepts
- 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.
- Window functions (core concepts and common patterns).
- Pivoting data (including common DBMS differences).
- Using functions in other clauses.
- Limiting rows (including common DBMS differences).
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.
Derived Data and Transactions
- Derived or temporary tables.
- Rotating rows into columns.
- Creating and using views.
- Introduction to procedures.
- Introduction to transactions.
- Commit and rollback in transactions.