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
Foundations of SQL
- Review of SELECT, WHERE, and GROUP BY
- Brief overview of various JOIN types
- Comprehending the order of query execution
Statements for Data Manipulation
- INSERT INTO syntax
- Executing UPDATE and DELETE operations
- Managing transactions (BEGIN, COMMIT, ROLLBACK)
Advanced Joins and Set Operations
- Implementing FULL OUTER JOIN
- Applying UNION, INTERSECT, and EXCEPT
- Utilizing SELF JOINs
Subqueries and Derived Tables
- Distinguishing between correlated and non-correlated subqueries
- Incorporating subqueries in the FROM clause
- Using CTEs (Common Table Expressions)
Window Functions
- Employing ROW_NUMBER, RANK, and DENSE_RANK
- Configuring PARTITION BY and ORDER BY
- Working with LEAD and LAG functions
Data Types and Functions
- String and date manipulation functions
- Using CASE and IF statements
- Handling type conversions and null values
Optimizing Queries
- Gaining insights into index usage
- Interpreting EXPLAIN output
- Adopting best practices for efficient query writing
Conclusion and Further Learning
Requirements
- Familiarity with fundamental SQL SELECT statements
- Practical experience with filtering, sorting, and basic joins
- A foundational understanding of relational database concepts
Target Audience
- Data analysts
- Developers interacting with SQL databases
- Business intelligence professionals
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
