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
Review of SQL Fundamentals
- Recap of SELECT, WHERE, and GROUP BY clauses
- Brief review of different JOIN types
- Comprehending the order of query execution
Data Manipulation Statements
- INSERT INTO operations
- Using UPDATE and DELETE statements
- Transaction control via BEGIN, COMMIT, and ROLLBACK
Advanced Joins and Set Operations
- Implementing FULL OUTER JOIN
- Utilizing UNION, INTERSECT, and EXCEPT
- Performing SELF JOINs
Subqueries and Derived Tables
- Distinguishing between correlated and non-correlated subqueries
- Employing subqueries within the FROM clause
- Working with CTEs (Common Table Expressions)
Window Functions
- Applying ROW_NUMBER, RANK, and DENSE_RANK
- Utilizing PARTITION BY and ORDER BY
- Leveraging LEAD and LAG functions
Data Types and Functions
- String and date manipulation functions
- Conditional logic using CASE and IF statements
- Handling type conversions and null values
Query Optimization
- Understanding the role of indexes
- Analyzing performance using EXPLAIN
- Adhering to best practices for writing efficient queries
Summary and Next Steps
Requirements
- Familiarity with basic SQL SELECT statements
- Practical experience with filtering, sorting, and simple joins
- A foundational understanding of relational database concepts
Target Audience
- Data analysts
- Developers working 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
