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
- Architecture of relational databases
- Relational operators
Retrieving data
- Standards for constructing SQL queries
- SELECT statement syntax
- Retrieving all columns
- Performing arithmetic operations
- Defining column aliases
- Using literals
- String concatenation
Filtering results
- Utilizing the WHERE clause
- Comparison operators
- Applying LIKE conditions
- Using the BETWEEN ... AND operator
- Checking for NULL values
- Employing the IN operator
- 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
- Distinguishing between single-row and multi-row functions
- Text, numeric, and date functions
- Conversion functions
- Nesting functions
- Managing NULL values
Data aggregation via grouping functions
- Overview of grouping functions
- Handling NULL values within aggregation
- Creating data groups with the GROUP BY clause
- Grouping by multiple columns
- Filtering group results with the HAVING clause
Accessing data across multiple tables
- Categorizing join types
- Assigning table aliases
- Joining tables within the WHERE clause
- INNER JOIN
- LEFT and RIGHT OUTER JOINS
- The Cartesian product
Subqueries
- Incorporating subqueries into the SELECT statement
- Scalar vs. multi-row subqueries
- Operators for scalar subqueries
- IN, ALL, and ANY operators for multi-row subqueries
Set operators
- The UNION operator
- The INTERSECT operator
- The EXCEPT operator
Inserting, updating, and deleting data
- The INSERT statement
- The UPDATE statement
- The DELETE statement
Transactions
Requirements
- Basic computer proficiency
- Familiarity with any 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,
