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 models
- Architecture of relational databases
- Relational operators
Data acquisition
- Principles for constructing SQL queries
- SELECT statement syntax
- Retrieving all columns
- Executing arithmetic operations within queries
- Defining column aliases
- Using literal values
- String concatenation
Filtering results
- Application of the WHERE clause
- Comparison operators
- LIKE condition syntax
- BETWEEN ... AND condition logic
- IS NULL condition usage
- IN condition syntax
- Logical operators
- Combining multiple conditions within the WHERE clause
- Operator precedence rules
- Elimination of duplicates via the DISTINCT clause
Data ordering
- Implementation of the ORDER BY clause
- Sorting based on multiple columns or expressions
SQL functions
- Distinctions between single-row and multi-row functions
- Text, numeric, and date functions
- Data type conversion functions
- Nested function execution
- Management of NULL values
Data aggregation via grouping functions
- Aggregate grouping functions
- Handling of NULL values by grouping functions
- Creating data groups using the GROUP BY clause
- Grouping across multiple columns
- Filtering grouped results with the HAVING clause
Retrieving data from multiple tables
- Classification of join types
- Assigning table aliases
- Defining joins within the WHERE clause
- INNER JOIN operations
- External joins including LEFT and RIGHT
- Cartesian product implications
Subqueries
- Integrating subqueries within SELECT statements
- Single-row and multi-row subqueries
- Operators for single-row subqueries
- Operators for multi-row subqueries, including IN, ALL, and ANY
Set operators
- UNION operator functionality
- INTERSECT operator functionality
- EXCEPT operator functionality
Data manipulation: Insert, update, and delete
- Executing the INSERT command
- Executing the UPDATE command
- Executing the DELETE command
Transactions
Requirements
- Proficiency in computer operation
- 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,
