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
- Core relational operators
Data retrieval
- Best practices for constructing SQL queries
- SELECT statement syntax
- Retrieving all available columns
- Performing arithmetic calculations in queries
- Assigning column aliases
- Using literals
- String concatenation
Filtering results
- Utilizing the WHERE clause
- Comparison operators
- Pattern matching with LIKE
- Range filtering using BETWEEN ... AND
- Handling missing data with IS NULL
- Membership testing with IN
- Combining conditions with logical operators
- Applying multiple criteria in WHERE clauses
- Operator precedence rules
- Removing duplicates with DISTINCT
Ordering data
- The ORDER BY clause
- Sorting by multiple columns or calculated expressions
SQL Functions
- Differences between single-row and multi-row functions
- Text, numeric, and date functions
- Data type conversion functions
- Nesting functions effectively
- Managing NULL values
Data aggregation and grouping
- Overview of aggregate functions
- Impact of NULL values on aggregation
- Creating data groups with GROUP BY
- Grouping across multiple columns
- Filtering aggregated results with HAVING
Combining data from multiple tables
- Various join types
- Using table aliases
- Defining joins within the WHERE clause
- INNER JOIN implementation
- External joins (LEFT, RIGHT)
- Understanding Cartesian products
Subqueries
- Incorporating subqueries in SELECT statements
- Single-row and multi-row subqueries
- Operators for single-row subqueries
- Operators for multi-row subqueries (IN, ALL, ANY)
Set operations
- Merging results with UNION
- Finding common elements with INTERSECT
- Identifying differences with EXCEPT
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,
