Get in Touch
 Duration 10 hours

Course Outline

Introduction to SQL and Relational Databases

  • Grasping database architectures
  • A look at SQL syntax rules
  • Managing tables and schemas

Fundamental Querying Methods

  • Extracting and mapping data
  • Narrowing results via the WHERE clause
  • Ordering output with ORDER BY

Connecting Multiple Tables

  • Inner, left, right, and full outer joins
  • Merging data from various sources
  • Defining join criteria

Aggregation and Grouping

  • Leveraging COUNT, SUM, AVG, MIN, and MAX
  • Utilizing GROUP BY for categorization
  • Filtering aggregate sets using HAVING

Subqueries and Nested Logic

  • Scalar subqueries
  • Correlated subqueries
  • Employing subqueries for filtering and computations

Data Manipulation and Editing

  • Adding new entries
  • Modifying current records
  • Securely removing data

Database Objects and Constraints

  • Comprehending primary and foreign keys
  • Creating and using views
  • Setting up constraints and validation rules

Advanced SQL Strategies

  • Window functions
  • Common Table Expressions (CTEs)
  • Performance optimization and basic query tuning

Conclusion and Future Directions

Requirements

  • A solid grasp of fundamental data principles
  • Prior interaction with spreadsheets or tabular structures
  • General familiarity with corporate applications

Target Audience

  • Data analysts
  • IT specialists
  • Individuals responsible for managing, querying, and analyzing data

Number of participants


Price per participant (excl. VAT)

Testimonials (3)

Upcoming Courses

Related Categories