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
- Relational database architecture
- Application of relational operators
Data acquisition
- Standards for constructing SQL queries
- SELECT statement syntax
- Retrieval of all columns
- Queries involving arithmetic calculations
- Column aliasing
- Use of literals
- String concatenation
Result set restriction
- Utilization of the WHERE clause
- Comparison operators
- LIKE condition logic
- BETWEEN ... AND conditions
- IS NULL condition handling
- IN condition application
- Logical operators
- Complex conditions within the WHERE clause
- Operator precedence rules
- Use of the DISTINCT clause
Data sorting
- Implementation of the ORDER BY clause
- Sorting by multiple columns or expressions
SQL functions
- Distinction between single-row and multi-row functions
- Text, numeric, and date functions
- Data type conversion functions
- Nested function usage
- Handling of NULL values
Data aggregation via grouping functions
- Overview of grouping functions
- Treatment of NULL values in grouping functions
- Data grouping using the GROUP BY clause
- Grouping by multiple columns
- Filtering grouped results with the HAVING clause
Retrieving data from multiple tables
- Categories of joins
- Table aliasing
- Join conditions within the WHERE clause
- INNER JOIN implementation
- External joins: LEFT and RIGHT
- Cartesian product concept
Subqueries
- Incorporating subqueries into SELECT commands
- Single-row versus multi-row subqueries
- Operators for single-row subqueries
- Operators for multi-row subqueries: IN, ALL, ANY
Set operators
- UNION operator usage
- INTERSECT operator usage
- EXCEPT operator usage
Data modification: Insert, update, and delete
- INSERT command syntax
- UPDATE command syntax
- DELETE command syntax
Transactions
Requirements
- General computer literacy
- Familiarity with operating system environments
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.