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
Relational database models
- Architecture of a relational database
- Relational operators
Data Retrieval
- Best practices for constructing SQL queries
- SELECT statement syntax
- Retrieving all columns
- Queries involving arithmetic operations
- Column aliases
- Literals
- String concatenation
Filtering Results
- Utilizing the WHERE clause
- Comparison operators
- LIKE condition
- BETWEEN ... AND condition
- IS NULL condition
- IN condition
- Logical operators
- Combining multiple conditions in the WHERE clause
- Operator precedence
- DISTINCT clause
Data Sorting
- ORDER BY clause
- Sorting by multiple columns or expressions
SQL Functions
- Distinctions between single-row and multi-row functions
- Text, numeric, and date functions
- Conversion functions
- Nested functions
- Managing NULL values
Data Aggregation with Grouping Functions
- Overview of grouping functions
- Handling of NULL values in aggregation
- Creating data groups using the GROUP BY clause
- Grouping by multiple columns
- Filtering grouped results with the HAVING clause
Querying Multiple Tables
- Different types of joins
- Table aliases
- Joins specified in the WHERE clause
- INNER JOIN operations
- LEFT and RIGHT OUTER joins
- Cartesian product
Subqueries
- Incorporating subqueries in SELECT statements
- Scalar and table-valued subqueries
- Operators for single-row subqueries
- Operators for multi-row subqueries: IN, ALL, ANY
Set Operators
- UNION operator
- INTERSECT operator
- EXCEPT operator
Data Modification: Insert, Update, Delete
- INSERT statement
- UPDATE statement
- DELETE statement
Transactions
Requirements
- Basic computer proficiency
- Familiarity with any 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.
