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 Architecture
- Understanding the structure of relational databases
- Utilizing relational operators
Retrieving Data
- Best practices for constructing SQL queries
- Mastering SELECT statement syntax
- Retrieving all columns from a table
- Performing arithmetic operations in queries
- Assigning column aliases
- Using literals in SQL
- String concatenation techniques
Filtering Query Results
- Applying the WHERE clause
- Using comparison operators
- Implementing the LIKE condition
- Applying the BETWEEN ... AND operator
- Handling NULL values with IS NULL
- Using the IN condition
- Combining conditions with logical operators
- Managing multiple conditions within the WHERE clause
- Understanding operator precedence
- Eliminating duplicates with the DISTINCT clause
Data Sorting
- Utilizing the ORDER BY clause
- Sorting by multiple columns or complex expressions
SQL Functions
- Distinguishing between single-row and multi-row functions
- Text, numeric, and date functions
- Data type conversion functions
- Nesting functions for complex logic
- Managing NULL values within functions
Data Aggregation via Grouping
- Overview of grouping functions
- How grouping functions process NULL values
- Creating data groups using the GROUP BY clause
- Grouping across multiple columns
- Filtering grouped results with the HAVING clause
Multi-Table Data Retrieval
- Understanding different types of joins
- Assigning table aliases
- Specifying joins in the WHERE clause
- Performing INNER JOINs
- Using LEFT and RIGHT OUTER JOINs
- The concept of the Cartesian product
Subqueries
- Incorporating subqueries into SELECT statements
- Differences between single-row and multi-row subqueries
- Operators for single-row subqueries
- Operators for multi-row subqueries (IN, ALL, ANY)
Set Operations
- Combining results with the UNION operator
- Intersecting results with the INTERSECT operator
- Excluding results with the EXCEPT operator
Managing Data Records
- Adding new records with the INSERT command
- Modifying existing records with the UPDATE command
- Removing records with the DELETE command
Transaction Management
Requirements
- Familiarity with basic computer operations
- Working knowledge of any major 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.
