Database Design Course - Learn how to design and plan a database for beginners

Channel:
United States freeCodeCamp.org
Subscribers:
10,700,000
Published on ● Video Link: https://www.youtube.com/watch?v=ztHopE5Wnpc


Duration: 8:07:20
2,608,986 views
63,120

This database design course will help you understand database concepts and give you a deeper grasp of database design.

Database design is the organisation of data according to a database model. The designer determines what data must be stored and how the data elements interrelate. With this information, they can begin to fit the data to the database model.

Learn more about this course on Caleb Curry's website: https://www.calebcurry.com/freecodecamp-database-design-full-course/

⭐️ Contents ⭐
⌨️ (0:00:00) Introduction
⌨️ (0:03:12) What is a Database?
⌨️ (0:11:04) What is a Relational Database?
⌨️ (0:23:42) RDBMS
⌨️ (0:37:32) Introduction to SQL
⌨️ (0:44:01) Naming Conventions
⌨️ (0:47:16) What is Database Design?
⌨️ (1:00:26) Data Integrity
⌨️ (1:13:28) Database Terms
⌨️ (1:28:28) More Database Terms
⌨️ (1:38:46) Atomic Values
⌨️ (1:44:25) Relationships
⌨️ (1:50:35) One-to-One Relationships
⌨️ (1:53:45) One-to-Many Relationships
⌨️ (1:57:50) Many-to-Many Relationships
⌨️ (2:02:24) Designing One-to-One Relationships
⌨️ (2:13:40) Designing One-to-Many Relationships
⌨️ (2:23:50) Parent Tables and Child Tables
⌨️ (2:30:42) Designing Many-to-Many Relationships
⌨️ (2:46:23) Summary of Relationships
⌨️ (2:54:42) Introduction to Keys
⌨️ (3:07:24) Primary Key Index
⌨️ (3:13:42) Look up Table
⌨️ (3:30:19) Superkey and Candidate Key
⌨️ (3:48:59) Primary Key and Alternate Key
⌨️ (3:56:34) Surrogate Key and Natural Key
⌨️ (4:03:43) Should I use Surrogate Keys or Natural Keys?
⌨️ (4:13:07) Foreign Key
⌨️ (4:25:15) NOT NULL Foreign Key
⌨️ (4:38:17) Foreign Key Constraints
⌨️ (4:49:50) Simple Key, Composite Key, Compound Key
⌨️ (5:01:54) Review and Key Points....HA GET IT? KEY points!
⌨️ (5:10:28) Introduction to Entity Relationship Modeling
⌨️ (5:17:34) Cardinality
⌨️ (5:24:41) Modality
⌨️ (5:35:14) Introduction to Database Normalization
⌨️ (5:39:48) 1NF (First Normal Form of Database Normalization)
⌨️ (5:46:34) 2NF (Second Normal Form of Database Normalization)
⌨️ (5:55:00) 3NF (Third Normal Form of Database Normalization)
⌨️ (6:01:12) Indexes (Clustered, Nonclustered, Composite Index)
⌨️ (6:14:36) Data Types
⌨️ (6:25:55) Introduction to Joins
⌨️ (6:39:23) Inner Join
⌨️ (6:54:48) Inner Join on 3 Tables
⌨️ (7:07:41) Inner Join on 3 Tables (Example)
⌨️ (7:23:53) Introduction to Outer Joins
⌨️ (7:29:46) Right Outer Join
⌨️ (7:35:33) JOIN with NOT NULL Columns
⌨️ (7:42:40) Outer Join Across 3 Tables
⌨️ (7:48:24) Alias
⌨️ (7:52:13) Self Join

🎥Course developed by Caleb Curry. Check out his YouTube channel: https://www.youtube.com/user/CalebTheVideoMaker2

🐦Follow Caleb on Twitter: https://twitter.com/calebcurry

--

Learn to code for free and get a developer job: https://www.freecodecamp.org

Read hundreds of articles on programming: https://medium.freecodecamp.org



Other Videos By freeCodeCamp.org


2018-09-06How to Build a RESTful API using Node, Express, and Mongo
2018-09-06C# Tutorial - Full Course for Beginners
2018-09-06Development environment for web developers using VS Code and iTerm
2018-09-05Elasticsearch Tutorial for Beginners
2018-09-05Why You Don't Need jQuery Anymore
2018-09-04Data Structures and Algorithms in JavaScript - Full Course for Beginners
2018-09-04Day in the life of a PayPal software engineer
2018-09-04Becoming a Better Programmer, Without Actually Programming
2018-09-03Build a Markdown Previewer with Vue.js
2018-09-03Taking Javascript to the Edge Devices
2018-08-31Database Design Course - Learn how to design and plan a database for beginners
2018-08-31Getting Started with Freelancing (web development and design)
2018-08-30Live React Coding Part 2 (P5D95) - Live Coding with Jesse
2018-08-30GitHub Basics Tutorial - How to Use GitHub
2018-08-30The Algorithms of CSS
2018-08-29How to Use Vim - Tutorial
2018-08-29The Cost Of JavaScript
2018-08-28Full stack Python Flask tutorial - Build a social network
2018-08-27Intro to GitHub Pages
2018-08-24C++ Tutorial for Beginners - Full Course
2018-08-24How to Create a Portfolio Website


Tags:
Database Design Tutorial
Database Design
Relational Database Design
Database Design Overview
Database Normalization
database design course
database design tutorial
database design for beginners
er models
relational database
relational database design tutorial
database
caleb curry
freecodecamp
SQL Server Design Overview
join
inner join
database index
database key
sql
sql tutorial