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 (2 days)
Course Outline
Refresher on SQL Fundamentals
- Overview of SELECT, WHERE, and GROUP BY clauses
- Brief revisit of different JOIN types
- Comprehension of the query execution sequence
Data Modification Commands
- Inserting records with INSERT INTO
- Modifying and removing data via UPDATE and DELETE
- Managing transactions using BEGIN, COMMIT, and ROLLBACK
Complex Joins and Set Logic
- Utilizing FULL OUTER JOIN
- Combining results with UNION, INTERSECT, and EXCEPT
- Executing SELF JOIN operations
Subqueries and Derived Data
- Distinguishing between correlated and non-correlated subqueries
- Incorporating subqueries within the FROM clause
- Leveraging CTEs (Common Table Expressions)
Advanced Analytics with Window Functions
- Ranking data using ROW_NUMBER, RANK, and DENSE_RANK
- Grouping and ordering with PARTITION BY and ORDER BY
- Accessing adjacent rows using LEAD and LAG functions
Data Handling and Utility Functions
- Processing strings and dates with built-in functions
- Conditional logic using CASE and IF statements
- Managing type conversions and null values
Performance Tuning
- The role and structure of indexes
- Analyzing query plans using EXPLAIN
- Adopting best practices for efficient query design
Conclusion and Future Learning
Requirements
- Familiarity with fundamental SQL SELECT statements
- Practical experience with filtering, sorting, and basic joins
- Conceptual understanding of relational databases
Target Audience
- Data analysts
- Developers interacting with SQL databases
- Business intelligence specialists
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
