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
- Relational operators
Data Retrieval Fundamentals
- Best practices for constructing SQL queries
- SELECT statement syntax
- Retrieving all columns
- Performing arithmetic calculations
- Column aliasing
- Working with literals
- String concatenation
Filtering and Refining Results
- Utilizing the WHERE clause
- Comparison operators
- Pattern matching with LIKE
- Range specifications using BETWEEN ... AND
- Handling NULL values with IS NULL
- Membership testing with IN
- Combining conditions with logical operators
- Complex WHERE clause scenarios
- Operator precedence and order
- Eliminating duplicates with DISTINCT
Data Ordering
- The ORDER BY clause
- Sorting by multiple columns or calculated expressions
SQL Functions
- Distinguishing between single-row and multi-row functions
- Text, numeric, and date functions
- Data type conversion functions
- Nested function calls
- Managing NULL values within functions
Data Aggregation and Grouping
- Aggregate functions
- Null value handling in aggregations
- Creating data groups with GROUP BY
- Grouping by multiple columns
- Filtering aggregated results with HAVING
Multi-Table Data Access
- Types of joins
- Table aliasing
- Join conditions in WHERE clauses
- INNER JOIN operations
- LEFT and RIGHT outer joins
- Understanding Cartesian products
Subqueries
- Embedding subqueries in SELECT statements
- Scalar versus multi-row subqueries
- Operators for scalar subqueries
- Operators for multi-row subqueries (IN, ALL, ANY)
Set Operations
- The UNION operator
- The INTERSECT operator
- The EXCEPT operator
Data Manipulation: Insert, Update, Delete
- INSERT statement
- UPDATE statement
- DELETE statement
Transaction Management
Requirements
- General computer proficiency
- 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,
