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
- Understanding the structure of a relational database
- Exploring relational operators
Data Retrieval Basics
- Guidelines for writing effective SQL queries
- Mastering the SELECT syntax
- Selecting all columns
- Performing inquiries from arithmetic operations
- Creating column aliases
- Working with literals
- Concatenating strings
Filtering Results
- Utilizing the WHERE clause
- Applying comparison operators
- Using the LIKE condition
- Implementing the BETWEEN ... AND condition
- Handling IS NULL conditions
- Using the IN condition
- Combining logical operators
- Managing multiple conditions within the WHERE clause
- Understanding operator precedence
- Using the DISTINCT clause to eliminate duplicates
Sorting Data
- Using the ORDER BY clause
- Sorting data by multiple columns or expressions
SQL Functions
- Understanding the differences between single-row and multi-row functions
- Utilizing text, numeric, and date functions
- Applying conversion functions
- Nesting functions for complex calculations
- Properly handling NULL values
Aggregating Data with Grouping Functions
- Overview of grouping functions
- How grouping functions manage NULL values
- Creating data groups using the GROUP BY clause
- Grouping by multiple columns
- Refining grouped results with the HAVING clause
Retrieving Data from Multiple Tables
- Understanding types of joins
- Using table aliases for clarity
- Performing joins within the WHERE clause
- Executing INNER JOINs
- Utilizing outer joins (LEFT and RIGHT)
- Understanding Cartesian products
Subqueries
- Incorporating subqueries into the SELECT command
- Differentiating between single-row and multi-row subqueries
- Applying operators for single-row subqueries
- Using operators for multi-row subqueries (IN, ALL, ANY)
Set Operators
- Using the UNION operator
- Using the INTERSECT operator
- Using the EXCEPT operator
Inserting, Updating, and Deleting Data
- Executing the INSERT command
- Executing the UPDATE command
- Executing the DELETE command
Transactions
Requirements
- Basic computer literacy
- Familiarity with 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,
