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.
Duration 14 hours
Course Outline
Foundations of Relational Data Models
- Architecture of relational databases
- Application of relational operators
Data Extraction
- Best practices for composing SQL queries
- Syntax rules for the SELECT statement
- Retrieving all columns from a table
- Performing arithmetic calculations within queries
- Assigning aliases to columns
- Working with literal values
- Concatenating data strings
Filtering Query Results
- Utilizing the WHERE clause
- Applying comparison operators
- Implementing LIKE conditions
- Using the BETWEEN ... AND condition
- Checking for IS NULL values
- Employing the IN condition
- Combining conditions with logical operators
- Managing multiple conditions within the WHERE clause
- Understanding operator precedence
- Eliminating duplicates with the DISTINCT clause
Ordering Data
- Implementing the ORDER BY clause
- Sorting results by multiple columns or calculated expressions
SQL Functionality
- Distinguishing between single-row and multi-row functions
- Working with text, numeric, and date functions
- Using conversion functions
- Nesting functions within queries
- Managing NULL values
Data Aggregation via Grouping
- Overview of aggregate functions
- How aggregate functions handle NULL values
- Creating data groups with the GROUP BY clause
- Grouping by multiple columns
- Filtering aggregate results with the HAVING clause
Combining Data from Multiple Tables
- Types of SQL joins
- Assigning table aliases
- Executing joins within the WHERE clause
- Performing INNER JOINs
- Using LEFT and RIGHT OUTER JOINs
- Understanding the Cartesian product
Working with Subqueries
- Placing subqueries in the SELECT statement
- Differences between single-row and multi-row subqueries
- Operators for single-row subqueries
- Operators for multi-row subqueries: IN, ALL, and ANY
Set Operations
- The UNION operator
- The INTERSECT operator
- The EXCEPT operator
Managing Data Records
- Using the INSERT command
- Using the UPDATE command
- Using the DELETE command
Transaction Management
Requirements
- Basic computer literacy
- Familiarity with a general-purpose operating system
Testimonials (3)
Need more self-learning and exercise to improve my skill
Alvin Wilta - PT LENTERA DANA NUSANTARA
Course - SQL Intermediate
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.
