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
- Revisit SELECT, WHERE, and GROUP BY clauses
- Brief overview of various JOIN types
- Comprehending the order of query execution
Data Modification Statements
- INSERT INTO operations
- UPDATE and DELETE commands
- Managing transactions (BEGIN, COMMIT, ROLLBACK)
Advanced Join Strategies and Set Operations
- FULL OUTER JOIN implementation
- UNION, INTERSECT, and EXCEPT operations
- SELF JOIN techniques
Subqueries and Derived Tables
- Distinguishing between correlated and non-correlated subqueries
- Incorporating subqueries within the FROM clause
- Applying CTEs (Common Table Expressions)
Utilizing Window Functions
- ROW_NUMBER, RANK, and DENSE_RANK functions
- Employing PARTITION BY and ORDER BY
- LEAD and LAG function usage
Data Types and Functional Tools
- String and date-related functions
- CASE and IF logical statements
- Managing type conversions and null values
Optimizing Query Performance
- The role of indexes in database performance
- Analyzing query plans using EXPLAIN
- Best practices for developing efficient queries
Conclusion and Future Directions
Requirements
- Familiarity with fundamental SQL SELECT statements
- Practical experience with data filtering, sorting, and basic joins
- A solid grasp of relational database principles
Intended 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
