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
Review of SQL Fundamentals
- Recap of SELECT, WHERE, and GROUP BY clauses.
- Quick review of various JOIN types.
- Comprehension of query execution order.
Data Manipulation Statements
- INSERT INTO operations.
- UPDATE and DELETE commands.
- Transaction control mechanisms (BEGIN, COMMIT, ROLLBACK).
Advanced Joins and Set Operations
- FULL OUTER JOIN.
- UNION, INTERSECT, and EXCEPT operations.
- SELF JOIN techniques.
Subqueries and Derived Tables
- Distinguishing between correlated and non-correlated subqueries.
- Utilizing subqueries within the FROM clause.
- Implementation of CTEs (Common Table Expressions).
Window Functions
- Application of ROW_NUMBER, RANK, and DENSE_RANK.
- Using PARTITION BY and ORDER BY.
- Employing LEAD and LAG functions.
Data Types and Functions
- String and date manipulation functions.
- Utilization of CASE and IF statements.
- Type conversions and handling of null values.
Query Optimization
- Understanding the role of indexes.
- Using the EXPLAIN command for analysis.
- Best practices for writing efficient queries.
Summary and Next Steps
Requirements
- Fundamental understanding of SQL SELECT statements.
- Practical experience with filtering, sorting, and basic joins.
- Comprehension of relational database concepts.
Target Audience
- Data analysts.
- Developers interacting with SQL databases.
- Business intelligence professionals.
14 Hours
Testimonials (3)
It was very interactive and it kept us interested.
Raluca Alexandra PUNGA
Course - SQL Fundamentals
Small group, in-person for 3 days,
Annina - Ricardo AG
Course - SQL: Basics to Intermediate
I liked the pace of the training and the level of interaction. All participants were encouraged to actively partake in discussions around exercise solutions, etc.
