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
Revisiting SQL Fundamentals
- Refresher on SELECT, WHERE, and GROUP BY clauses.
- Brief overview of different JOIN types.
- Grasping the logical order of query execution.
Data Modification Statements
- Using INSERT INTO for data entry.
- Applying UPDATE and DELETE commands.
- Managing transactions via BEGIN, COMMIT, and ROLLBACK.
Complex Joins and Set Operations
- Implementing FULL OUTER JOINs.
- Utilizing UNION, INTERSECT, and EXCEPT.
- Performing SELF JOINs.
Subqueries and Derived Tables
- Distinguishing between correlated and non-correlated subqueries.
- Incorporating subqueries in the FROM clause.
- Working with CTEs (Common Table Expressions).
Window Functions
- Applying ROW_NUMBER, RANK, and DENSE_RANK.
- Using PARTITION BY and ORDER BY clauses.
- Leveraging LEAD and LAG functions.
Data Types and Functional Utilities
- String and date manipulation functions.
- Conditional logic with CASE and IF statements.
- Handling type conversions and null values.
Optimizing Query Performance
- The role and mechanics of indexes.
- Analyzing query plans using EXPLAIN.
- Best practices for crafting high-efficiency queries.
Conclusion and Future Path
Requirements
- Familiarity with fundamental SQL SELECT statements.
- Hands-on experience with filtering, sorting, and basic joins.
- A solid grasp of relational database principles.
Target Audience
- Data analysts.
- Developers interacting with SQL databases.
- Business intelligence specialists.
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
