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 Concepts
- Understanding the architecture of relational databases
- Application of relational operators
Data Retrieval Fundamentals
- Best practices for structuring SQL queries
- Mastering SELECT statement syntax
- Retrieving all columns in a table
- Performing calculations within queries
- Assigning aliases to columns
- Working with literal values
- Concatenating data strings
Filtering and Restricting Results
- Utilizing the WHERE clause
- Applying comparison operators
- Using LIKE for pattern matching
- Defining ranges with BETWEEN ... AND
- Checking for NULL values
- Filtering with the IN condition
- Combining logic with AND, OR, and NOT
- Managing multiple conditions within a single clause
- Understanding operator precedence
- Removing duplicates with the DISTINCT clause
Data Sorting
- Using the ORDER BY clause
- Sorting by multiple columns or calculated expressions
Working with SQL Functions
- Distinguishing between scalar and aggregate functions
- Text, numeric, and date functions
- Data type conversion functions
- Nesting functions for complex logic
- Managing NULL values in calculations
Data Aggregation
- Overview of aggregate functions
- How aggregates handle NULL values
- Creating data groups with GROUP BY
- Grouping by multiple fields
- Filtering aggregate results using HAVING
Multi-Table Data Retrieval
- Various types of joins
- Using table aliases for clarity
- Defining joins in the WHERE clause
- Implementing INNER JOINs
- Working with LEFT and RIGHT OUTER JOINs
- Understanding Cartesian products
Subqueries
- Embedding subqueries in SELECT statements
- Single-row and multi-row subqueries
- Single-row comparison operators
- Multi-row operators: IN, ALL, and ANY
Set Operations
- Combining results with UNION
- Finding common results with INTERSECT
- Identifying differences with EXCEPT
Data Manipulation: Insert, Update, and Delete
- Adding new records with INSERT
- Modifying existing data with UPDATE
- Removing records with DELETE
Transaction Management
Requirements
- Proficiency with computer systems
- 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,
