Skip to content
FenvoraTechReal projects. Real skills.

IT training

SQL and Database Design with MySQL and PostgreSQL

Design schemas, write efficient queries and speed up applications with indexing and caching.

Enquire About This CourseRequest a Callback

Course overview

Learn how to model data, write reliable SQL and diagnose slow queries. The course ends with an introduction to caching with Redis for read-heavy applications.

What you will learn

  • Model data with normalised relational schemas
  • Write joins, aggregations and subqueries confidently
  • Read query plans and add the right indexes
  • Use transactions and migrations safely
  • Apply Redis caching to reduce database load

Syllabus

  1. Module 1: Relational modelling

    • Entities and relationships
    • Normalisation
    • Keys and constraints

  2. Module 2: SQL in depth

    • Joins and aggregation
    • Subqueries and CTEs
    • Window functions

  3. Module 3: Performance

    • Indexes
    • Reading query plans
    • Query optimisation

  4. Module 4: Reliability

    • Transactions
    • Migrations
    • Backups

  5. Module 5: Caching with Redis

    • Cache patterns
    • Expiry and invalidation
    • Measuring the impact

Projects and assignments

  • A normalised schema for an e-commerce application
  • A query optimisation exercise on a realistic dataset

Instructor

Amol Kharate

Founder and technical lead at FenvoraTech. Senior full-stack developer with 10+ years of experience working with MySQL, PostgreSQL, MongoDB and Redis, including schema design and query optimisation.

Enquire about this course

Ask about batches, fees, the syllabus or whether this course suits you.

For example weekday evenings or weekends.

Request a callback

Prefer to talk? Leave your number and we will call you.

Related courses

MERN Stack Development

Build complete web applications with MongoDB, Express, React and Node.js.

View programme

Full-Stack Web Development

Learn front end, back end, databases and deployment in one structured path.

View programme

Frontend Development with HTML, CSS, JavaScript and React

Create fast, accessible and responsive user interfaces.

View programme

Learning resources: see our blog for tutorials and career guidance.