Effective Database Design
Have you ever had an idea for an application or project, and not been sure how to turn it into tables?
It's easy to start creating tables and work it out as you go. But it's hard to know if your design will actually handle the data you need, and it's a bit of a hassle to change once it's built.
Effective Database Design gives you a step-by-step process to go from an idea to a working database, including the SQL to create it.
You'll be able to:
- Write down the requirements for your database, so you know what it needs to store
- Turn those requirements into an Entity Relationship Diagram, with tables, columns and relationships
- Test your design against different scenarios and fix any gaps before you build it
- Convert your design into SQL to create the tables, insert data and query it
The process works for any relational database, and you can use it on your own work, school or personal project.
What's included
- 4 modules and 16 short video lessons
- Table Assessment Guide, a series of questions to help you decide what to store in each table
- Common Database Design Solutions for scenarios like names, addresses, soft deletes and similar records
- The complete course as a PDF for offline reading
- Lifetime access, plus a comments section to ask me questions
"The thing I enjoyed the most was how you presented your thinking behind the creating of databases in general. This subject has always been a mystery to me... I think your approach to thinking in simpler terms, like when we had to think in sentences and write what we were expecting out of the database, I think that part brought home a lot of “mysterious concepts” I had never seen before." Eduardo R
"I run a small business and I need to setup a database to track products. This course uses video and text and examples to help me to learn how to use a database... This is money well spent." William S
30-Day Money Back Guarantee
If you're not happy with the course, let me know within 30 days of purchasing and I'll refund the full purchase price.
Frequently Asked Questions
Who is this course for?
It's for data analysts, developers and anyone who creates tables for an application or project. It suits you if you're learning database design from scratch, or if you design databases already and want to check you're doing it right. The lessons are short and focused on a repeatable process, so if you design complex databases every day, a lot of it may be familiar.
What do I need to know before I join?
You'll need a basic understanding of databases, such as what tables and columns are. For the SQL part, it helps to know basic statements like CREATE TABLE and INSERT.
Which databases does it work with?
The design process works for any relational database. The SQL is demonstrated in MySQL, and you can apply it to Oracle, SQL Server, PostgreSQL or any other SQL database.
Do I get access to everything at once?
Yes. You get all the lessons and bonuses as soon as you enrol, and you keep access for life.
