Database Design

Learn relational database Design with practical concepts and examples. This series works with any database system!

All Levels 4.2(2,919 Ratings) 88,363 Students enrolled
Created by Caleb Curry Last updated 04/2015 English ["English [Auto-generated]"]
What will i learn?
  • Learn the definition of relations, tuples, attributes, and over one hundred other vocabulary words!
  • Learn all of the types of relationships and how to properly design them all within a database. This includes one to one, one to many, and many to many. You will also learn about the difference between a parent table and a child table
  • Learn about all of the types and categories of keys including superykeys, candidate keys, primary keys, alternate keys, natural keys, surrogate keys, simple keys, compound keys, composite keys, and foreign keys
  • Learn database normalization. We will be learning the first 3 normal forms of database normalization. This will reduce redundant and incorrect data as well as protect our database integrity
  • Learn about data, data types, foreign key constraints, and other important concepts used to create the best database
  • Learn to design a database from beginning to end!

Curriculum for this course
52 Lectures 08:21:37
Introduction to Databases and Database Design
12 Lectures 01:54:44
  • Introduction 00:10:41
  • What is a Database? 00:08:42
  • What is a Relational Database? 00:13:04
  • RDBMS 00:14:04
  • Introduction to SQL 00:06:58
  • Bonus FREE Build Your Dream Website Bundle 00:08:48
  • Naming Conventions 00:03:37
  • What is Database Design? 00:03:24
  • Data Integrity 00:13:28
  • Database Terms 00:15:10
  • More Database Terms 00:10:43
  • Atomic Values 00:06:05
  • Relationships 00:06:23
  • One-to-One Relationships 00:03:20
  • One-to-Many Relationships 00:04:13
  • Many-to-Many Relationships 00:04:43
  • Design One-to-One Relationships 00:11:29
  • Designing One-to-Many Relationships 00:11:00
  • Parent Tables and Child Tables 00:07:00
  • Designing Many-to-Many Relationships 00:16:17
  • Summary of Relationships 00:08:33
  • Introduction to Keys 00:12:57
  • Primary Key Index 00:06:30
  • Look up Table 00:16:55
  • Superkey and Candidate Key 00:19:17
  • Primary Key and Alternate Key 00:07:58
  • Surrogate Key and Natural Key 00:07:36
  • Should I use Surrogate Keys or Natural Keys? 00:09:36
  • Foreign Key 00:12:40
  • NOT NULL Foreign Key 00:13:14
  • Foreign Key Constraints 00:11:48
  • Simple Key, Composite Key, Compound Key 00:12:13
  • Review of Keys and Key Points 00:08:46
  • Introduction to Entity Relationship Modeling 00:08:02
  • Cardinality 00:07:34
  • Modality 00:11:39
  • Introduction to Database Normalization 00:04:58
  • 1NF 00:06:50
  • 2NF 00:08:50
  • 3NF 00:06:19
  • Indexes 00:13:27
  • Data Types 00:11:31
  • Introduction to Joins 00:13:56
  • Inner Join 00:15:41
  • Inner Join on 3+ Tables 00:12:59
  • Inner Join on 3 Tables (Example) 00:16:52
  • Introduction to Outer Joins 00:06:33
  • Right Outer Join 00:05:49
  • JOIN with NOT NULL Columns 00:07:32
  • Outer Join Across 3 Tables 00:05:43
  • Alias 00:03:50
  • Self Join 00:15:08
  • Blog Posts 00:01:23
Requirements
  • Take notes as you go through the course
  • Study the material from each video and memorize the content
  • Memorize the terms given in each video as well as any design techniques, such as using atomic values, the definition of 1NF, etc...
  • You will need tools that allow you to practice designing databases. This could be anything from a pen and paper to premium software. This course will be using a large chalkboard for the first half of the course and then free design software later on. Just know that you will not be required to pay for any design tools!
  • Read any supplementary material provided and attempt to memorize the content and apply it to what you already know
  • Be CREATIVE! Database design is not only a technical skill, but it is also an art! This course will teach you the technical aspects of design as well as the artistic side
  • Be determined. Database design can be a daunting task. It's scary, but easy once you get the hang of things
+ View more
Description

Whichever database application you use does not matter! This course will cover design concepts for all relational database management systems. This course is designed for those who want to download this course or watch it ad free. This is a course for relational database design. Here are some examples of the most popular databases:

  • MySQL
  • Oracle
  • Microsoft SQL Server
  • PostgreSQL
  • SQLite
  • MiariaDB
  • and MORE!

We start off this course by taking our time to first look at what a database is and how it differs from a spreadsheet, website, filing cabinet, and so forth. We introduce SQL and talk about data definition language and data manipulation language. After about 4 solid videos of explaining databases and SQL, we dive into learning about entities and attributes. We apply all of these concepts to structure tables and relationships. We learn to design all of the relationships and I explain everything in depth.

Most of the videos are on my chalkboard, explaining concepts. This is because it helps to fully understand database design before you dive into designing your own database. Once we go over all of the concepts of database design we will be designing databases from start to finish.

No programming skills are required. This course does not program a database. This course will only be teaching how to best design your database. You may be wondering why such a large course is required for only designing a database. Well, designing a database is an extremely important part of database management. The best design will get us the best results and make programming our database really easy.

After this course you should be able to tackle almost any database design project with confidence and skill. Keep in mind though that learning database design takes a lot of time and effort. Be sure to take notes and stop after each video to reflect on what you've learned. Keeping notes will make this video course a whole lot easier!

+ View more
Other related courses
03:09:50
4.4 792 $124.99 Free
07:48:19
4.6 8,707 $99.99 Free
01:01:46
Updated Fri, 24-May-2019
4.5 1,866 Free
00:58:08
Updated Sun, 07-Jun-2020
4.3 10,314 Free
01:03:59
Updated Wed, 29-Jan-2020
3.9 6,902 Free
00:43:06
Updated Sun, 01-Jun-2014
4.1 146,858 Free
03:12:13
4.2 76,954 $194.99 Free
14:18:39
4.5 2,687 $199.99 Free
03:20:33
3.4 2,683 $19.99 Free
04:42:14
Updated Sat, 02-Dec-2017
4 6,323 Free
03:25:07
4.4 52,604 Free
05:37:42
3.9 11,911 Free
10:11:26
Updated Wed, 25-Mar-2015
4 59,299 Free
02:16:25
Updated Thu, 16-Jan-2020
3.7 327 Free
00:50:32
4.7 1,682 $34.99 Free
00:33:51
0 2,650 Free
19:48:09
4.6 187,958 $179.99 Free
01:48:02
4.1 4,435 $19.99 Free
02:41:15
Updated Wed, 01-Jun-2016
4.2 62,236 Free
08:32:17
4 5,642 $19.99 Free
02:37:36
Updated Tue, 31-Oct-2017
4.1 8,674 $19.99 Free
01:47:14
4.6 14,732 Free
00:32:54
Updated Wed, 13-Sep-2017
4.2 13,637 Free
03:31:30
5 1,956 $19.99 Free
02:19:11
4.3 13,216 Free
35:04:57
4.3 3,511 $59.99 Free
18:49:14
3.6 2,400 $59.99 Free
00:40:32
Updated Sat, 11-Jan-2020
4 5,205 Free
15:11:13
4.5 2,627 $109.99 Free
00:44:33
4.1 4,938 $19.99 Free
02:38:15
4.1 10,520 $19.99 Free
01:27:31
3.9 3,896 $29.99 Free
18:06:28
4.4 25,119 $169.99 Free
21:15:27
4.2 19,162 $144.99 Free
02:59:08
4.1 94,280 $194.99 Free
07:48:47
4.7 9,541 $19.99 Free
About the instructor
  • 34 Students
  • 4 Courses
+ View more
Educator, YouTube Partner.
Student feedback
4.2
Average rating
  • 5%
  • 8%
  • 31%
  • 68%
  • 85%
Comments
Free
Includes:
  • 08:21:37 On demand videos
  • 52 Lessons
  • Full lifetime access
  • Access on mobile and tv