Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Relational database models
- Architectural components of a relational database
- Application of relational operators
Extracting data
- Best practices for constructing SQL queries
- Syntax structure of the SELECT statement
- Retrieving all columns from a table
- Performing calculations via arithmetic operations
- Defining column aliases
- Utilizing literal values
- String concatenation techniques
Filtering results
- Application of the WHERE clause
- Utilization of comparison operators
- Implementing LIKE conditions
- Specifying ranges with BETWEEN ... AND
- Checking for NULL values
- Using the IN condition
- Combining logic with operators
- Handling multiple conditions within the WHERE clause
- Operator precedence rules
- Removing duplicates with the DISTINCT clause
Sorting Data
- Using the ORDER BY clause
- Sorting by multiple columns or calculated expressions
SQL Functions
- Distinguishing between scalar and aggregate functions
- Text, numeric, and date functions
- Data type conversion functions
- Nesting function calls
- Managing NULL values in functions
Aggregating data using the grouping function
- Overview of grouping functions
- Behavior of grouping functions with NULL values
- Creating data groups using the GROUP BY clause
- Grouping by multiple columns
- Filtering group results with the HAVING clause
Retrieving data from multiple tables
- Classification of join types
- Assigning table aliases
- Defining joins within the WHERE clause
- Inner joins
- Left and Right outer joins
- Understanding the Cartesian product
Subqueries
- Positioning subqueries in the SELECT command
- Differences between scalar and row-returning subqueries
- Operators for single-row subqueries
- Operators for multi-row subqueries: IN, ALL, ANY
Set operators
- The UNION operator
- The INTERSECT operator
- The EXCEPT operator
Modifying data: Insert, update, and delete
- The INSERT command
- The UPDATE command
- The DELETE command
Transactions
Requirements
- Basic computer literacy
- Familiarity with a modern operating system
14 Hours
Testimonials (3)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
It was very interactive and it kept us interested.
Raluca Alexandra PUNGA
Course - SQL Fundamentals
Small group, in-person for 3 days,
