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
- Foundations of relational database structure
- Application of relational operators
Data Extraction
- Best practices for composing SQL queries
- SELECT statement syntax
- Retrieving all columns
- Executing arithmetic operations in queries
- Assigning column aliases
- Using literals
- String concatenation
Filtering Results
- Implementing the WHERE clause
- Utilizing comparison operators
- The LIKE condition
- The BETWEEN ... AND clause
- Handling NULL values with IS NULL
- The IN condition
- Combining logical operators
- Complex conditions within the WHERE clause
- Operator precedence rules
- Removing duplicates with the DISTINCT clause
Data Ordering
- Applying the ORDER BY clause
- Sorting by multiple columns or calculated expressions
SQL Functionality
- Distinguishing between single-row and multi-row functions
- Text, numeric, and date functions
- Data type conversion functions
- Nested function usage
- Managing NULL values
Aggregation via Grouping Functions
- Overview of aggregation functions
- Behavior of aggregation functions with NULL values
- Creating data groups using the GROUP BY clause
- Grouping across multiple columns
- Filtering group results with the HAVING clause
Multitable Data Retrieval
- Categorization of join types
- Assigning table aliases
- Defining joins within the WHERE clause
- INNER JOIN mechanics
- LEFT and RIGHT OUTER JOINs
- Understanding the Cartesian product
Subqueries
- Embedding subqueries in SELECT statements
- 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
Data Modification: Insert, Update, Delete
- Using the INSERT command
- Using the UPDATE command
- Using the DELETE command
Transaction Management
Requirements
- Basic computer proficiency
- Familiarity with any major operating system
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,
