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
- Anatomy of a relational database
- Relational operations
Retrieving Data
- Best practices for composing SQL queries
- SELECT statement syntax
- Retrieving all columns
- Performing arithmetic calculations in queries
- Using column aliases
- Literals
- String concatenation
Filtering Results
- Utilizing the WHERE clause
- Comparison operators
- Pattern matching with LIKE
- Range filtering with BETWEEN ... AND
- Handling null values with IS NULL
- Membership testing with IN
- Logical operators
- Combining multiple conditions in WHERE clauses
- Operator precedence
- Eliminating duplicates with DISTINCT
Data Sorting
- Implementing the ORDER BY clause
- Sorting by multiple columns or calculated expressions
SQL Functions
- Distinction between scalar and aggregate functions
- Text, numeric, and date functions
- Data type conversion functions
- Nested function usage
- Managing NULL values
Data Aggregation with Grouping Functions
- Overview of aggregate functions
- Impact of NULL values on aggregations
- Creating data groups with the GROUP BY clause
- Grouping across multiple columns
- Filtering group results with the HAVING clause
Combining Data from Multiple Tables
- Categories of joins
- Assigning table aliases
- Performing joins within WHERE clauses
- INNER JOIN operations
- External joins (LEFT, RIGHT)
- The Cartesian product
Subqueries
- Incorporating subqueries into SELECT statements
- Single-row versus multi-row subqueries
- Operators for single-row subqueries
- Operators for multi-row subqueries (IN, ALL, ANY)
Set Operators
- Combining results with UNION
- Finding common records with INTERSECT
- Excluding records with EXCEPT
Modifying Data: Insert, Update, and Delete
- The INSERT statement
- The UPDATE statement
- The DELETE statement
Transactions
Requirements
- Basic computer proficiency
- Familiarity with any 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,
