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 composing SQL queries
- SELECT statement syntax
- Retrieving all columns
- Performing arithmetic calculations in queries
- Assigning column aliases
- Using literals
- String concatenation
Filtering Results
- Implementation of the WHERE clause
- Utilization of comparison operators
- Pattern matching with the LIKE condition
- Range specification using BETWEEN ... AND
- Handling missing data with the IS NULL condition
- Membership testing with the IN condition
- Combining conditions with logical operators
- Composing multiple conditions within the WHERE clause
- Evaluation order of operators
- Eliminating duplicates with the DISTINCT clause
Sorting Data
- Applying the ORDER BY clause
- Sorting by multiple columns or custom expressions
SQL Functions
- Distinguishing between single-row and multi-row functions
- Text, numeric, and date functions
- Data conversion functions
- Nested function execution
- Managing NULL values
Aggregating Data with Grouping Functions
- Overview of aggregate functions
- Impact of NULL values on grouping functions
- Forming data groups using the GROUP BY clause
- Grouping by multiple columns
- Filtering aggregated results with the HAVING clause
Combining Data from Multiple Tables
- Categories of joins
- Defining table aliases
- Specifying joins within the WHERE clause
- INNER JOIN implementation
- Outer joins (LEFT, RIGHT)
- Understanding the Cartesian product
Subqueries
- Embedding subqueries in the SELECT statement
- Single-row versus multi-row subqueries
- Operators for single-row subqueries
- Operators for multi-row subqueries (IN, ALL, ANY)
Set Operators
- Combining results with the UNION operator
- Identifying common rows with the INTERSECT operator
- Excluding common rows with the EXCEPT operator
Data Manipulation: Insert, Update, and Delete
- Adding records with the INSERT command
- Modifying records with the UPDATE command
- Removing records with the DELETE command
Transactions
Requirements
- Basic computer literacy
- Familiarity with a standard 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,
