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 Architecture
- Understanding the structure of relational databases
- Application of relational operators
Data Retrieval
- Best practices for crafting SQL queries
- Understanding SELECT syntax
- Retrieving all columns
- Executing arithmetic operations
- Defining column aliases
- Working with literals
- String concatenation
Filtering Results
- Using the WHERE clause
- Comparison operators
- The LIKE condition
- The BETWEEN ... AND condition
- The IS NULL condition
- The IN condition
- Logical operators
- Combining multiple conditions within the WHERE clause
- Operator precedence
- Eliminating duplicates with the DISTINCT clause
Data Sorting
- Implementing the ORDER BY clause
- Sorting by multiple columns or expressions
SQL Functions
- Differences between single-row and multi-row functions
- Text, numeric, and date functions
- Conversion functions
- Nested function usage
- Managing NULL values
Data Aggregation via Grouping
- Overview of grouping functions
- How grouping functions handle NULL values
- Creating data groups with the GROUP BY clause
- Grouping by multiple columns
- Filtering group results using the HAVING clause
Querying Multiple Tables
- Types of table joins
- Table aliases
- Defining joins in the WHERE clause
- INNER JOIN
- Outer joins (LEFT and RIGHT)
- Understanding the Cartesian product
Subqueries
- Placing subqueries within SELECT statements
- Scalar (single-row) and multi-row subqueries
- Single-row subquery operators
- Multi-row subquery operators (IN, ALL, ANY)
Set Operators
- Using the UNION operator
- Using the INTERSECT operator
- Using the EXCEPT operator
Data Manipulation: Insert, Update, and Delete
- The INSERT command
- The UPDATE command
- The DELETE command
Transaction Management
Requirements
- Basic computer proficiency
- Familiarity with any 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,
