Database Design The Complete Guide 2020

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Database Design. 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:

  1. MySQL
  2. Oracle
  3. Microsoft SQL Server
  4. PostgreSQL
  5. SQLite
  6. MariaDB
  7. and MORE!

We start 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 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!

Who this course is for:

  1. Anyone working with relational databases. This course starts at the beginning. No prior knowledge is required but will of course make things easier and more clear for you
  2. This course is perfect for anyone with an intermediate level of skill. We will be discussing all of the major concepts in database design and this course will help you refresh your skills or bring you to the advanced level
Show More

Course Content

Database Design

  • Introduction
    00:00
  • What is a Database?
    00:00
  • What is a Relational Database?
    00:00
  • RDBMS
    00:00
  • Introduction to SQL
    00:00
  • Naming Conventions
    00:00
  • What is Database Design?
    00:00
  • Data Integrity
    00:00
  • Database Terms
    00:00
  • More Database Terms
    00:00
  • Atomic Values
    00:00
  • Relationships
    00:00
  • One-to-One Relationships
    00:00
  • One-to-Many Relationships
    00:00
  • Many-to-Many Relationships
    00:00
  • Designing One-to-One Relationships
    00:00
  • Designing One-to-Many Relationships
    00:00
  • Parent Tables and Child Tables
    00:00
  • Designing Many-to-Many Relationships
    00:00
  • Summary of Relationships
    00:00
  • Introduction to Keys
    00:00
  • Primary Key Index
    00:00
  • Look up Table
    00:00
  • Superkey and Candidate Key
    00:00
  • Primary Key and Alternate Key
    00:00
  • Surrogate Key and Natural Key
    00:00
  • Should I use Surrogate Keys or Natural Keys?
    00:00
  • Foreign Key
    00:00
  • NOT NULL Foreign Key
    00:00
  • Foreign Key Constraints
    00:00
  • Simple Key, Composite Key, Compound Key
    00:00
  • Review and Key Points
    00:00
  • Introduction to Entity Relationship Modeling
    00:00
  • Cardinality
    00:00
  • Modality
    00:00
  • Introduction to Database Normalization
    00:00
  • 1NF (First Normal Form of Database Normalization)
    00:00
  • 2NF (Second Normal Form of Database Normalization)
    00:00
  • 3NF (Third Normal Form of Database Normalization)
    00:00
  • Indexes (Clustered, Nonclustered, Composite Index)
    00:00
  • Data Types
    00:00
  • Introduction to Joins
    00:00
  • Inner Join
    00:00
  • Inner Join on 3 Tables
    00:00
  • Inner Join on 3 Tables (Example)
    00:00
  • Introduction to Outer Joins
    00:00
  • Right Outer Join
    00:00
  • JOIN with NOT NULL Columns
    00:00
  • Outer Join Across 3 Tables
    00:00
  • Alias
    00:00
  • Self Join
    00:00
  • Database Design All-in-One Tutorial Series (8 HOURS!)
    00:00

Student Ratings & Reviews

No Review Yet
No Review Yet
ResearcherStore

Want to receive push notifications for all major on-site activities?