SQL Data Modeling
Design database tables, keys and relations before you write any code.
What you'll learn
- Turn requirements into entities and attributes
- Choose primary and foreign keys
- Model one-to-many and many-to-many relations
- Normalize to third normal form
About this course
You model the data for three small apps: a blog, a shop and a booking system. You learn entities, keys, relations and normalization, and draw diagrams for each.
Course curriculum
4 modules and 12 lessons over 3 weeks. Plan for about 9 learning hours.
01EntitiesWeek 1 · 3 lessons
- Reading requirements
- Entities and attributes
- ER diagrams
02Keys and relationsWeek 1 · 3 lessons
- Primary keys
- Foreign keys
- Join tables
03NormalizationWeek 2 · 3 lessons
- First to third normal form
- When to denormalize
- Constraints
04Three modelsWeek 3 · 3 lessons
- Blog
- Shop
- Booking system
Project
Three data models. ER diagrams and SQL schemas for a blog, a shop and a booking system.
Who this course is for
Developers who create tables as they go and regret it later.
Prerequisites
You know basic SQL.
What's included
- 120-day course access
- Step-by-step lessons
- Practice files
- Reusable code templates
- A graded final exercise
- A digital completion certificate
Learning format
Self-paced practical course, part of our self-paced courses. Graded final exercise with written feedback.
Access and delivery
- Enrollment is activated within 15 minutes after payment.
- Final exercise feedback is delivered within 2 business days of submission, and the completion certificate is issued within 2 business days after passing the final exercise.
Certificate
You receive a digital completion certificate. Final exercise feedback is delivered within 2 business days of submission, and the completion certificate is issued within 2 business days after passing the final exercise.
Frequently asked questions
When does access start?
Enrollment is activated within 15 minutes after payment.
Is payment taken on this website?
No. After you submit your enrollment request, we reply by email with payment details and enrollment confirmation.
Does this course guarantee a job or income?
No. It is an education and training service and does not include employment, income or placement guarantees.
Can I cancel?
Our Refund and Cancellation Policy lists the terms for self-paced course programs.
