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
- Brief overview of JOIN types
- Comprehending the order of query execution
Data Manipulation Statements
- INSERT INTO
- UPDATE and DELETE
- Transaction management (BEGIN, COMMIT, ROLLBACK)
Advanced Joins and Set Operations
- FULL OUTER JOIN
- UNION, INTERSECT, and EXCEPT
- SELF JOIN
Subqueries and Derived Tables
- Comparison of correlated and non-correlated subqueries
- Employing subqueries in the FROM clause
- CTEs (Common Table Expressions)
Window Functions
- ROW_NUMBER, RANK, and DENSE_RANK
- Utilizing PARTITION BY and ORDER BY
- LEAD and LAG functions
Data Types and Functions
- String and date manipulation functions
- CASE and IF statements
- Type conversions and null value handling
Query Optimization
- Understanding the role of indexes
- Using EXPLAIN for query analysis
- Best practices for crafting efficient queries
Summary and Next Steps
Requirements
- Fundamental understanding of SQL SELECT statements
- Practical experience with filtering, sorting, and basic joins
- Conceptual grasp of relational database structures
Intended 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
