Get in Touch
 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

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories