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 Models
- Relational database architecture and structure
- Core relational operators
Data Acquisition and Query Fundamentals
- SQL query drafting standards
- SELECT statement syntax
- Retrieval of all columns
- Arithmetic operations within queries
- Column aliasing
- Use of literal values
- String concatenation techniques
Filtering Query Results
- Implementation of the WHERE clause
- Comparison operators
- PATTERN matching with the LIKE condition
- Range filtering using BETWEEN ... AND
- Null value identification with IS NULL
- Set membership evaluation with IN
- Logical operator application
- Complex conditional logic in the WHERE clause
- Operator precedence and evaluation order
- Deduplication of results using the DISTINCT clause
Data Sorting and Organization
- Application of the ORDER BY clause
- Multilevel sorting via multiple columns or expressions
SQL Functionality
- Distinctions between single-row and aggregate functions
- Text, numeric, and date functions
- Data conversion utilities
- Function nesting protocols
- Management of NULL values
Data Aggregation and Grouping
- Aggregate function types
- Null value handling within aggregate functions
- Data segmentation using the GROUP BY clause
- Multi-column grouping strategies
- Post-aggregation filtering using the HAVING clause
Multi-Table Data Retrieval
- Join methodologies and types
- Table aliasing conventions
- Implicit joins within the WHERE clause
- Inner joins (INNER JOIN)
- Outer joins (LEFT, RIGHT)
- Cartesian product operations
Nested Queries
- Subquery implementation within the SELECT command
- Single-row and multi-row subqueries
- Operators for single-row subqueries
- Set operators (IN, ALL, ANY) for multi-row subqueries
Set Operations
- UNION operator
- INTERSECT operator
- EXCEPT operator
Data Modification Operations
- Inserting records (INSERT)
- Updating records (UPDATE)
- Removing records (DELETE)
Transaction Management
Requirements
The following core competencies are required for government personnel:
* Demonstrated proficiency in computer operations.
* Working knowledge of at least one 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,
