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
- Refresher on 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 usage
- UNION, INTERSECT, and EXCEPT operators
- Implementing SELF JOINs
Subqueries and Derived Tables
- Distinction between correlated and non-correlated subqueries
- Integrating subqueries within the FROM clause
- Application of CTEs (Common Table Expressions)
Window Functions
- Utilizing ROW_NUMBER, RANK, and DENSE_RANK
- Employing PARTITION BY and ORDER BY within windows
- Implementing LEAD and LAG functions
Data Types and Functions
- String and date manipulation functions
- Conditional logic using CASE and IF statements
- Handling type conversions and null values
Query Optimization
- Concepts behind indexing
- Interpreting EXPLAIN output
- Best practices for writing efficient queries
Summary and Future Steps
Requirements
- Fundamental understanding of SQL SELECT statements
- Practical experience with filtering, sorting, and basic joins
- Conceptual grasp of relational database principles
Target Audience
- Data analysts
- Developers working 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
The lecture about cte
