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
Overview of SQL Fundamentals
- Recapitulation of SELECT, WHERE, and GROUP BY clauses
- Rapid review of various JOIN types
- Comprehension of query execution sequence
Data Manipulation Statements
- INSERT INTO operations
- UPDATE and DELETE operations
- Transaction control mechanisms (BEGIN, COMMIT, ROLLBACK)
Advanced Joins and Set Operations
- FULL OUTER JOIN
- UNION, INTERSECT, and EXCEPT operations
- SELF JOIN
Subqueries and Derived Tables
- Differentiating between correlated and non-correlated subqueries
- Utilizing subqueries within the FROM clause
- Implementation of CTEs (Common Table Expressions)
Window Functions
- Functions such as ROW_NUMBER, RANK, and DENSE_RANK
- Application of PARTITION BY and ORDER BY clauses
- Use of LEAD and LAG functions
Data Types and Functions
- String and date manipulation functions
- Implementation of CASE and IF statements
- Managing type conversions and null values
Query Optimization
- Understanding the role of indexes
- Utilization of the EXPLAIN tool
- Adopting best practices for writing efficient queries
Summary and Future Directions
Requirements
- Fundamental understanding of SQL SELECT statements
- Hands-on experience with filtering, sorting, and basic joins
- Comprehension of relational database principles
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
