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
- Summary of SELECT, WHERE, and GROUP BY clauses
- Brief examination of various JOIN categories
- Insight into the sequence of query execution
Data Modification Commands
- Usage of INSERT INTO
- Application of UPDATE and DELETE
- Management of transactions (BEGIN, COMMIT, ROLLBACK)
Sophisticated Joins and Set Logic
- Implementation of FULL OUTER JOIN
- Application of UNION, INTERSECT, and EXCEPT
- Techniques for SELF JOIN
Nested Queries and Temporary Tables
- Distinguishing between correlated and non-correlated subqueries
- Incorporating subqueries within the FROM clause
- Leveraging CTEs (Common Table Expressions)
Advanced Windowing
- Application of ROW_NUMBER, RANK, and DENSE_RANK
- Utilization of PARTITION BY and ORDER BY directives
- Employment of LEAD and LAG operations
Data Structures and Built-in Operations
- Functions for text and temporal data
- Logic implementation using CASE and IF constructs
- Managing type transformations and null values
Enhancing Query Efficiency
- Comprehending the role of indexes
- Analyzing performance using EXPLAIN
- Adopting optimal strategies for crafting streamlined queries
Conclusion and Future Directions
Requirements
- Familiarity with fundamental SQL SELECT commands
- Practical experience in filtering, sorting, and basic joining operations
- Grasping of core relational database principles
Intended Participants
- Data analysts
- Software developers interacting with SQL environments
- Professionals in business intelligence
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
