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
Foundational SQL Recap
- Revisiting SELECT, WHERE, and GROUP BY constructs
- Refresher on various JOIN mechanisms
- Analysis of logical query execution sequence
Data Modification Commands
- Inserting records via INSERT INTO
- Modifying and removing data using UPDATE and DELETE
- Managing transaction integrity (BEGIN, COMMIT, ROLLBACK)
Advanced Join Strategies and Set Logic
- Implementing FULL OUTER JOINs
- Combining result sets with UNION, INTERSECT, and EXCEPT
- Techniques for SELF JOINs
Subqueries and Derived Structures
- Differentiating between correlated and non-correlated subqueries
- Integrating subqueries within the FROM clause
- Applying CTEs (Common Table Expressions)
Advanced Analytical Functions
- Utilizing ROW_NUMBER, RANK, and DENSE_RANK
- Structuring partitions and ordering with PARTITION BY and ORDER BY
- Retrieving preceding and following rows with LEAD and LAG
Data Typing and Functional Logic
- Manipulating strings and date values
- Conditional logic using CASE and IF structures
- Managing data type conversion and null values
Performance Tuning
- Analyzing the role of database indexes
- Interpreting execution plans using EXPLAIN
- Adhering to best practices for high-efficiency query design
Conclusions and Future Directions
Requirements
- Familiarity with foundational SQL SELECT commands
- Practical experience in data filtering, ordering, and basic joining operations
- Comprehension of core relational database principles
Target Audience
- Data analysts
- Software developers interacting with SQL environments
- Professionals in business intelligence
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
