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
Course Outline
Foundational SQL Concepts
- Summary of SELECT, WHERE, and GROUP BY syntax
- Overview of various JOIN methodologies
- Analysis of query execution sequencing
Data Modification Commands
- INSERT INTO operations
- UPDATE and DELETE procedures
- Transactional integrity controls (BEGIN, COMMIT, ROLLBACK)
Complex Joins and Set Logic
- FULL OUTER JOIN implementation
- Set operators: UNION, INTERSECT, and EXCEPT
- Recursive SELF JOIN techniques
Nested Queries and Derived Structures
- Differentiation between correlated and non-correlated subqueries
- Integration of subqueries within the FROM clause
- Application of Common Table Expressions (CTEs)
Advanced Analytical Functions
- Ranking functions: ROW_NUMBER, RANK, and DENSE_RANK
- Data segmentation via PARTITION BY and ordering with ORDER BY
- Offset analysis using LEAD and LAG functions
Data Typing and Logic Functions
- Manipulation of string and date fields
- Conditional logic using CASE and IF constructs
- Data type casting and null value management
Query Performance Optimization
- Role of database indexes in query efficiency
- Diagnosing performance via EXPLAIN plans
- Best practices for efficient query architecture
Conclusions and Forward Planning
Requirements
- Familiarity with SQL SELECT syntax
- Practical experience with data filtering, sorting, and basic joins
- Conceptual understanding of relational database architectures
Target Audience
- Data analysts
- Software developers working with SQL database systems
- Business intelligence specialists
Testimonials (1)
Need more self-learning and exercise to improve my skill