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
Course Outline
Recap of SQL Fundamentals
- Review of SELECT, WHERE, and GROUP BY clauses
- Brief overview of various JOIN types
- Comprehension of the query execution order
Data Manipulation Language (DML)
- INSERT INTO operations
- UPDATE and DELETE procedures
- Transaction management (BEGIN, COMMIT, ROLLBACK)
Advanced Joins and Set Operations
- FULL OUTER JOIN implementation
- Use of UNION, INTERSECT, and EXCEPT
- Application of SELF JOIN
Subqueries and Derived Tables
- Comparison of correlated vs. non-correlated subqueries
- Incorporating subqueries in the FROM clause
- Utilizing CTEs (Common Table Expressions)
Window Functions
- Application of ROW_NUMBER, RANK, and DENSE_RANK
- Implementation of PARTITION BY and ORDER BY
- Use of LEAD and LAG functions
Data Types and Functions
- String and date handling functions
- Conditional logic with CASE and IF statements
- Managing type conversions and null values
Query Optimization
- Comprehending the role of indexes
- Interpreting EXPLAIN plans
- Best practices for crafting efficient queries
Summary and Next Steps
Requirements
- Familiarity with basic SQL SELECT statements
- Practical experience with filtering, sorting, and simple joins
- A solid grasp of relational database concepts
Target Audience
- Data analysts
- Developers working with SQL databases
- Business intelligence professionals
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
