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
Revision of SQL Fundamentals
- Refresher on SELECT, WHERE, and GROUP BY
- Overview of various JOIN types
- Clarification of query execution sequences
Data Manipulation Operations
- INSERT INTO statements
- UPDATE and DELETE operations
- Managing transactions with BEGIN, COMMIT, and ROLLBACK
Complex Joins and Set Logic
- FULL OUTER JOIN implementations
- Using UNION, INTERSECT, and EXCEPT
- Applying SELF JOINs
Subqueries and Derived Tables
- Distinguishing between correlated and non-correlated subqueries
- Incorporating subqueries into FROM clauses
- Utilizing CTEs (Common Table Expressions)
Application of Window Functions
- Using ROW_NUMBER, RANK, and DENSE_RANK
- Leveraging PARTITION BY and ORDER BY
- Employing LEAD and LAG functions
Data Typing and Functional Operations
- Handling string and date functions
- Using CASE and IF logic
- Managing type conversions and null values
Optimizing Query Performance
- Analyzing the role of indexes
- Interpreting EXPLAIN outputs
- Adhering to best practices for efficient query design
Conclusion and Future Pathways
Requirements
- Familiarity with fundamental SQL SELECT statements
- Practical experience with filtering, sorting, and basic joins
- A solid grasp of relational database principles
Target Audience
- Data analysts
- Developers managing SQL databases
- Business intelligence specialists
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
