Querytech Academy Querytech Academy Academy
← BACK TO ALL COURSES COURSE_SQL-103

Relational Database Design & Theory

DURATION 12h Medium
CERTIFICATION Querytech Academy

Course Overview

This course teaches the theoretical foundations and best practices of relational database design. Learners will master normalization, entity-relationship modeling, and both transactional and dimensional (Star/Snowflake) modeling techniques.

Curriculum Structure

Comprehensive modules designed for real-world impact

1

Database Design Principles

Learn goals, intergrity, and best practices in database design

2

Keys & constraints

Master primary, Foreign, unique, check, and Default Constraint

3

Normalization (1NF-3NF+BCNF)

Reduce redundancy and anomalies through proper normalization

4

Entity-Relationship (ER) Modeling

create and read ER diagrams effectively

5

Relational Schema Design Best Practices

convert conceptual models into physical schemas

6

Star & snowflakes Schema (Dimensional modeling )

Design fact and dimension tables for analystics

7

Slowly changing dimensions (SCD) awareness

understand SCD concepts (type 1,2,3, )

Available Bootcamps

Choose a cohort and begin your journey to becoming job-ready

No active cohorts at the moment.
No upcoming cohorts scheduled yet.
No past cohorts available yet.