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.
Duration 14 hours
Course Outline
Relational Database Architecture
- Structural components of relational databases
- Core relational operators
Data Retrieval
- Standards for constructing SQL queries
- Syntax of the SELECT statement
- Retrieving all columns
- Executing arithmetic operations in queries
- Using column aliases
- Handling literals
- String concatenation
Filtering Results
- The WHERE clause
- Comparison operators
- Implementing LIKE conditions
- Using the BETWEEN ... AND condition
- IS NULL conditions
- IN conditions
- Logical operators
- Combining multiple conditions within the WHERE clause
- Operator precedence rules
- The DISTINCT clause
Data Sorting
- Utilizing the ORDER BY clause
- Sorting by multiple columns or expressions
SQL Functions
- Distinguishing between scalar and aggregate functions
- Text, numeric, and date functions
- Data type conversion functions
- Nested function usage
- Managing NULL values
Data Aggregation via Grouping Functions
- Core grouping functions
- How aggregate functions handle NULL values
- Forming data groups using the GROUP BY clause
- Grouping across multiple columns
- Filtering group results with the HAVING clause
Retrieving Data from Multiple Tables
- Different types of joins
- Assigning table aliases
- Executing joins within the WHERE clause
- INNER JOIN mechanics
- Outer joins (LEFT and RIGHT)
- Understanding the Cartesian product
Subqueries
- Embedding subqueries in SELECT commands
- Single-row versus multi-row 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
Inserting, Updating, and Deleting Data
- The INSERT command
- The UPDATE command
- The DELETE command
Transactions
Requirements
- Basic computer proficiency
- Familiarity with standard operating systems
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,
