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 Architectures
- Anatomy of a relational database
- Applying relational operators
Data Extraction
- Best practices for constructing SQL queries
- Understanding the SELECT syntax
- Retrieving all available fields
- Executing arithmetic operations within queries
- Assigning column aliases
- Using literal values
- String concatenation
Result Filtering
- Utilizing the WHERE clause
- Applying comparison operators.
- Implementing LIKE conditions
- Defining ranges with BETWEEN ... AND
- Checking for NULL values with IS NULL
- Specifying lists with the IN condition.
- Combining logic with logical operators
- Combining multiple conditions within the WHERE clause
- Understanding operator precedence
- Eliminating duplicates with the DISTINCT clause
Data Ordering
- Using the ORDER BY clause
- Sorting by multiple fields or calculated expressions
SQL Functionality
- Distinguishing between scalar and aggregate functions
- Text, numeric, and date functions
- Data type conversion functions
- Nesting functions
- Managing NULL values
Data Aggregation via Grouping
- Overview of grouping functions
- Impact of NULL values on aggregation
- Forming data groups using the GROUP BY clause
- Grouping by multiple columns
- Filtering grouped results with the HAVING clause
Multi-Table Data Retrieval
- Categories of joins
- Creating table aliases
- Performing joins within the WHERE clause
- INNER JOIN implementation
- LEFT and RIGHT external joins
- The Cartesian product
Subqueries
- Embedding subqueries in SELECT statements
- Single-row versus multi-row subqueries
- Operators for single-row subqueries
- Operators for multi-row subqueries (IN, ALL, ANY)
Set Operations
- The UNION operator
- The INTERSECT operator
- The EXCEPT operator
Data Modification: Insert, Update, and Delete
- The INSERT statement
- The UPDATE statement
- The DELETE statement
Transaction Management
Requirements
- Proficiency with general computer usage
- Familiarity with a modern operating system
14 Hours
Testimonials (2)
The SQL simulator designed by Philippe
Jean-Pierre ABRIAL - AGL
Course - SQL Fundamentals
Machine Translated
personalised to our understanding and data
