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
- Review of SELECT, WHERE, and GROUP BY clauses
- Brief overview of various JOIN types
- Insight into the order of query execution
Data Modification Commands
- Using INSERT INTO statements
- Executing UPDATE and DELETE operations
- Managing transactions with BEGIN, COMMIT, and ROLLBACK
Sophisticated Joins and Set Logic
- Implementing FULL OUTER JOINs
- Applying UNION, INTERSECT, and EXCEPT operations
- Utilizing SELF JOINs
Subqueries and Derived Tables
- Distinguishing between correlated and non-correlated subqueries
- Incorporating subqueries within the FROM clause
- Employing CTEs (Common Table Expressions)
Advanced Window Functions
- Using ROW_NUMBER, RANK, and DENSE_RANK
- Applying PARTITION BY and ORDER BY clauses
- Leveraging LEAD and LAG functions
Data Types and Utility Functions
- Handling string and date functions
- Implementing CASE and IF logic
- Managing type conversions and null values
Enhancing Query Performance
- Gaining an understanding of database indexes
- Interpreting EXPLAIN output
- Adopting best practices for efficient query design
Concluding Summary and Future Pathways
Requirements
- Familiarity with fundamental SQL SELECT commands
- Practical experience with data filtering, sorting, and basic joins
- A solid grasp of relational database architecture
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
