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
Refresher on SQL Fundamentals
- Summary of SELECT, WHERE, and GROUP BY commands
- Overview of various JOIN categories
- Grasping the sequence of query execution
Statements for Modifying Data
- Usage of INSERT INTO
- Operations for UPDATE and DELETE
- Managing transactions (BEGIN, COMMIT, ROLLBACK)
Sophisticated Joins and Set Manipulation
- Implementation of FULL OUTER JOIN
- Operations with UNION, INTERSECT, and EXCEPT
- Techniques for SELF JOIN
Subqueries and Virtual Tables
- Distinguishing between correlated and non-correlated subqueries
- Incorporating subqueries within the FROM clause
- Application of CTEs (Common Table Expressions)
Utilizing Window Functions
- Application of ROW_NUMBER, RANK, and DENSE_RANK
- Use of PARTITION BY and ORDER BY clauses
- Implementation of LEAD and LAG
Data Classification and Functions
- Handling string and date manipulations
- Logic control with CASE and IF
- Managing type casting and null values
Enhancing Query Efficiency
- Concepts behind database indexes
- Analysis using EXPLAIN
- Conventions for creating high-performance queries
Conclusions and Future Learning
Requirements
- Foundational understanding of SQL SELECT commands
- Practical experience with data filtering, ordering, and basic joins
- Familiarity with the principles of relational database design
Intended Participants
- Analysts specializing in data
- Engineers maintaining SQL-based applications
- Specialists in business intelligence
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
