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
Retrieving data
- Best practices for constructing SQL queries
- SELECT statement syntax
- Retrieving all columns
- Using arithmetic operations in queries
- Defining column aliases
- Utilizing literals
- String concatenation
Filtering results
- Implementing the WHERE clause
- Using comparison operators
- Pattern matching with LIKE
- Range filtering with BETWEEN ... AND
- Checking for NULL values with IS NULL
- Membership testing with IN
- Combining conditions with logical operators
- Combining multiple conditions within the WHERE clause
- Operator precedence rules
- Eliminating duplicates with the DISTINCT clause
Data sorting
- Implementing the ORDER BY clause
- Sorting by multiple columns or calculated expressions
SQL Functions
- Distinguishing between scalar and aggregate functions
- Text, numeric, and date functions
- Using conversion functions
- Nesting functions within queries
- Managing NULL values in function outputs
Aggregating data with grouping functions
- Overview of aggregate functions
- Behavior of aggregate 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
- Using table aliases
- Defining joins within the WHERE clause
- Using INNER JOIN
- Using LEFT and RIGHT OUTER JOINs
- Understanding the Cartesian product
Subqueries
- Embedding subqueries in the SELECT statement
- Differences between scalar and subqueries returning multiple rows
- Operators for scalar subqueries
- Operators for subqueries returning sets: IN, ALL, ANY
Set operators
- Combining result sets with UNION
- Finding common rows with INTERSECT
- Excluding common rows with EXCEPT
Inserting, updating, and deleting data
- Using the INSERT statement
- Using the UPDATE statement
- Using the DELETE statement
Transactions
Requirements
- Computer literacy
- Knowledge of any 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,