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
Revisiting SQL Fundamentals
- Review of SELECT, WHERE, and GROUP BY clauses
- Brief overview of various JOIN categories
- Comprehending the sequence of query execution
Data Manipulation Commands
- INSERT INTO syntax
- UPDATE and DELETE operations
- Managing transactions (BEGIN, COMMIT, ROLLBACK)
Advanced Join Strategies and Set Logic
- FULL OUTER JOIN implementation
- Use of UNION, INTERSECT, and EXCEPT
- Techniques for SELF JOINs
Nested Queries and Derived Structures
- Distinguishing between correlated and non-correlated subqueries
- Incorporating subqueries within the FROM clause
- Application of CTEs (Common Table Expressions)
Implementation of Window Functions
- ROW_NUMBER, RANK, and DENSE_RANK
- Utilizing PARTITION BY and ORDER BY
- LEAD and LAG analytical functions
Data Typing and Functional Utilities
- Operations on strings and date values
- Conditional logic using CASE and IF
- Managing type conversions and null values
Enhancing Query Efficiency
- The role and mechanics of indexes
- Analyzing query plans with EXPLAIN
- Adhering to best practices for efficient query design
Conclusion and Further Progression
Requirements
- Fundamental understanding of SQL SELECT commands
- Practical experience with filtering, ordering, and basic joins
- Conceptual grasp of relational database principles
Target Audience
- Analysts specializing in data
- Software developers interacting with SQL databases
- Professionals in the business intelligence sector
Testimonials (2)
The SQL simulator designed by Philippe
Jean-Pierre ABRIAL - AGL
Course - SQL Fundamentals
Machine Translated
Small group, in-person for 3 days,
