Get in Touch
 Duration 10 hours

Course Outline

Introduction to SQL and Relational Databases

  • Grasping database structures
  • Overview of SQL syntax
  • Interacting with tables and schemas

Fundamental Querying Techniques

  • Selecting and projecting data
  • Filtering rows using WHERE clauses
  • Ordering results with ORDER BY

Connecting Multiple Tables

  • Inner, left, right, and full joins
  • Merging datasets from various sources
  • Defining join conditions

Aggregation and Grouping Strategies

  • Utilizing COUNT, SUM, AVG, MIN, and MAX
  • Effective application of GROUP BY
  • Filtering grouped results with HAVING

Subqueries and Nested Logic

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

Data Manipulation and Alteration

  • Inserting new records
  • Updating existing entries
  • Safe deletion of data

Database Objects and Constraints

  • Comprehending primary and foreign keys
  • Working with views
  • Implementing constraints and rules

Advanced SQL Methodologies

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

Recap and Future Directions

Requirements

  • Foundational knowledge of data concepts
  • Experience working with spreadsheets or tabular data
  • General familiarity with business applications

Target Audience

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

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
  • Flexible Schedule: Dates and times adapted to your team's agenda.
  • Format: Online (live), In-company (at your offices), or Hybrid.
Investment

Price per private group, online live training, starting from 2900 € + VAT*

Contact us for an exact quote and to hear our latest promotions

Testimonials (3)

Upcoming Courses

Related Categories