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
- Anatomy of a relational database
- Application of relational operators
Data Retrieval
- Best practices for composing SQL queries
- SELECT statement syntax
- Retrieving entire columns
- Performing arithmetic calculations within queries
- Using column aliases
- Utilizing literal values
- String concatenation
Filtering Outcomes
- Implementation of the WHERE clause
- Comparison operators
- Pattern matching with LIKE
- Range checking using BETWEEN... AND
- Checking for NULL values with IS NULL
- Membership testing with the IN operator
- Logical operators
- Combining multiple conditions in the WHERE clause
- Operator precedence and execution order
- Removing duplicates with the DISTINCT clause
Data Ordering
- Implementing the ORDER BY clause
- Sorting by multiple columns or calculated expressions
SQL Functionality
- Distinguishing between scalar and aggregate functions
- Text, numeric, and date manipulation functions
- Data type conversion functions
- Nested function calls
- Strategies for managing NULL values
Data Aggregation via Grouping
- Core grouping functions
- Impact of NULL values on aggregation
- Segmenting data using the GROUP BY clause
- Grouping across multiple columns
- Filtering aggregated results with the HAVING clause
Multi-Table Data Extraction
- Variations of SQL joins
- Assigning table aliases
- Defining join conditions within the WHERE clause
- INNER JOIN implementation
- LEFT and RIGHT OUTER JOINs
- Understanding the Cartesian product
Nested Queries
- Integrating subqueries within the SELECT statement
- Differentiating between scalar and table subqueries
- Operators for scalar subqueries
- Operators for table subqueries: IN, ALL, and ANY
Set Operations
- Combining results with UNION
- Finding common rows with INTERSECT
- Excluding rows with EXCEPT
Data Manipulation: Insert, Update, and Delete
- Executing the INSERT statement
- Modifying records with UPDATE
- Removing records with DELETE
Transaction Management
Requirements
- Basic computer proficiency
- Familiarity with common operating systems
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,
