Skip to main content
Eden Datawize
← Back to catalogue
Enrollment openProgramming & DatabasesBeginner

SQL and Database Management

Learn to query, structure and manage relational databases with SQL, from beginner level to complex queries.

Objectives

  • Understand the structure of a relational database
  • Write SQL queries (SELECT, JOIN, GROUP BY, subqueries)
  • Create and modify tables and relationships
  • Optimize queries for better performance

Target audience

Analysts, data managers and professionals who want to work with databases.

Prerequisites

No technical prerequisite; comfort with computers is recommended.

Skills you will gain

SQL queriesRelational modellingJoins and aggregationsQuery optimization

Detailed programme

  1. Modules 1

    SQL fundamentals

    SELECT, WHERE, sorting and filtering data.

  2. Modules 2

    Joins and aggregations

    JOIN, GROUP BY, aggregate functions.

  3. Modules 3

    Data modelling

    Designing relational schemas and foreign keys.

  4. Modules 4

    Advanced queries

    Subqueries, views and optimization.

Tools used

PostgreSQLMySQL