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
- The fundamental structure of relational databases
- Core relational operators
Data Retrieval
- Best practices for crafting SQL queries
- The SELECT statement syntax
- Retrieving all columns from a table
- Performing arithmetic operations in queries
- Assigning aliases to columns
- Using literals in SQL
- String concatenation techniques
Filtering Results
- Applying the WHERE clause
- Utilizing comparison operators
- The LIKE condition for pattern matching
- Defining ranges with BETWEEN ... AND
- Checking for NULL values with IS NULL
- Filtering with the IN condition
- Combining conditions with logical operators
- Combining multiple conditions within the WHERE clause
- Understanding operator precedence
- Eliminating duplicates with the DISTINCT clause
Data Sorting
- Using the ORDER BY clause
- Sorting by multiple columns or expressions
SQL Functions
- Distinguishing between scalar and aggregate functions
- Text, numeric, and date functions
- Data type conversion functions
- Nesting functions within queries
- Strategies for managing NULL values
Data Aggregation via Grouping
- Overview of aggregate functions
- How aggregate functions handle NULL values
- Creating data groups using the GROUP BY clause
- Grouping by multiple columns
- Filtering group results with the HAVING clause
Joining Multiple Tables
- Types of database joins
- Assigning table aliases
- Placing join logic in the WHERE clause
- Using INNER JOIN
- External joins (LEFT, RIGHT)
- The concept of the Cartesian product
Subqueries
- Embedding subqueries in the SELECT command
- Scalar versus multi-row subqueries
- Operators for scalar subqueries
- IN, ALL, and ANY operators for multi-row subqueries
Set Operators
- The UNION operator
- The INTERSECT operator
- The EXCEPT operator
Data Modification: Insert, Update, Delete
- The INSERT command
- The UPDATE command
- The DELETE command
Transaction Management
Requirements
- Basic computer proficiency
- Familiarity with a standard operating system
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2600 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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,
