CF

Effective Database Design

1h 3m 56s
English
Paid

Before I tell you everything about this program, let’s make sure it’s right for you. If you are:

  • A data analyst who occasionally creates tables for their work
  • A developer or database professional creating or designing tables for an application or system
  • A software developer working with a database and wanting to create an optimal structure that meets your requirements

You are in the right place!

The course "Effective Database Design" will provide you with a roadmap, examples, and instructions for creating a well-designed database.

By the end of this program, you will receive:

  • A good understanding of the "entity-relationship" diagram: Learn to create such a diagram for database design using a course example or your own database.
  • A database project based on your requirements: Create a database following good practices and techniques.
  • Validation of your project: Learn how to validate your project for different scenarios and make changes if necessary.
  • Conversion of the project into SQL queries: Learn to write SQL queries to create tables based on your project to start working with the database.

What's inside the course "Effective Database Design":

  • Module 1: Introduction
    • You will learn how to determine database requirements and create an "entity-relationship" diagram.
  • Module 2: Database Design
    • Translate requirements into a database project: add tables, attributes, and establish relationships between tables.
  • Module 3: Project Testing
    • Verify the project by creating scenarios and analyzing their compliance with the requirements.
  • Module 4: SQL Conversion
    • Use the project to create an SQL script for table creation and data insertion.

Additional

The SQL scripts used for the examples later in the course are available here: GitHub Repo

Convert to SQL

In this lesson, we'll start writing some SQL to create our database by creating a table.

The SQL scripts used in this lesson are available here: GitHub Repo

About the Author: Ben Brumm

Ben Brumm thumbnail

Ben Brumm is an Australian database developer and educator focused on the practical craft of database design — a skill most working developers learn the hard way through years of production data-model mistakes. He runs databasestar.com, a long-running tutorial site on database fundamentals.

His CourseFlix listing carries Effective Database Design — a structured treatment of normalisation, schema design, indexing strategy, and the modeling decisions that lock in early in a project's life and become expensive to change later.

Material is paid and aimed at developers ready to take database design as a deliberate professional skill rather than a side-effect of using whatever ORM ships with their framework. For broader content, see CourseFlix's Databases and SQL category pages.

Watch Online 16 lessons

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 16 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: Welcome
All Course Lessons (16)
#Lesson TitleDurationAccess
1
Welcome Demo
01:18
2
Your Requirements
03:03
3
Creating a Diagram
02:46
4
Add Your First Table
04:09
5
Add Attributes
04:17
6
Relate Your Tables
07:48
7
Repeat These Steps
08:49
8
Considerations
05:44
9
Capture Scenarios
03:20
10
Model the Scenarios
06:38
11
Follow a Checklist
03:20
12
Create a Table
04:11
13
Write All Statements
02:54
14
Add Some Data
03:25
15
View Your Data
01:27
16
Conclusion
00:47
Unlock unlimited learning

Get instant access to all 15 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription

Books

Read Book Effective Database Design

#TitleTypeOpen
1Table Assessment Guide PDF
2Common Database Design Solutions PDF
3Effective Database Design PDF

Related courses

Frequently asked questions

What is Effective Database Design about?
Before I tell you everything about this program, let’s make sure it’s right for you. If you are: A data analyst who occasionally creates tables for their work A developer or database professional creating or designing tables for an…
Who teaches this course?
It is taught by Ben Brumm. You can find more courses by this instructor on the corresponding source page.
How long is the course?
It contains 16 lessons with a total runtime of 1 hour 3 minutes. Every lesson is available to watch online at your own pace.
Is it free to watch?
It is part of CourseFlix's premium catalog. A subscription unlocks the full video player; the course description, table of contents, and preview information are available to everyone.
Where can I watch it online?
The course is available to watch online on CourseFlix at https://courseflix.net/course/effective-database-design. The page hosts every lesson with the integrated video player; no download is required.