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
- The framework of relational databases
- Applying relational operators
Retrieving Data
- Best practices for composing SQL queries
- SELECT statement syntax
- Retrieving all columns
- Queries involving arithmetic operations
- Using column aliases
- Working with literals
- String concatenation
Filtering Results
- The WHERE clause in action
- Utilizing comparison operators
- Pattern matching with LIKE
- Range conditions with BETWEEN ... AND
- Handling null values with IS NULL
- Set membership with IN
- Combining conditions with logical operators
- Composing complex WHERE clauses
- Operator precedence rules
- Eliminating duplicates with DISTINCT
Data Sorting
- Using the ORDER BY clause
- Sorting by multiple columns or computed expressions
SQL Functionality
- Distinguishing between scalar and aggregate functions
- Text, numeric, and date functions
- Data type conversion functions
- Nesting functions within expressions
- Managing NULL values
Data Aggregation and Grouping
- Overview of grouping functions
- How aggregate functions handle NULLs
- Forming data groups with GROUP BY
- Grouping across multiple columns
- Filtering aggregated results with HAVING
Querying Multiple Tables
- Various types of joins
- Assigning table aliases
- Executing joins within the WHERE clause
- INNER JOIN mechanics
- LEFT and RIGHT OUTER JOINs
- The Cartesian product concept
Subquery Implementation
- Embedding subqueries in SELECT statements
- Single-row vs. multi-row subqueries
- Operators for single-row subqueries
- Operators for multi-row subqueries (IN, ALL, ANY)
Set Operations
- The UNION operator
- The INTERSECT operator
- The EXCEPT operator
Data Modification
- The INSERT statement
- The UPDATE statement
- The DELETE statement
Transaction Management
Requirements
- General computer literacy
- 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,
