Главная

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

Кадры Database Design Course - Learn how to design and plan a database for beginners

Описание Database Design Course - Learn how to design and plan a database for beginners

Коментарии Database Design Course - Learn how to design and plan a database for beginners

I'm honored to be featured here 🙂brIf you'd like to be notified of new content from me, please join my newsletter! calcurtech/newsletterbrbr⭐ Timestamps ⭐br⌨ (0:00:00) Introductionbr⌨ (0:03:12) What is a Database?br⌨ (0:11:04) What is a Relational Database?br⌨ (0:23:42) RDBMSbr⌨ (0:37:32) Introduction to SQLbr⌨ (0:44:01) Naming Conventionsbr⌨ (0:47:16) What is Database Design?br⌨ (1:00:26) Data Integritybr⌨ (1:13:28) Database Termsbr⌨ (1:28:28) More Database Termsbr⌨ (1:38:46) Atomic Valuesbr⌨ (1:44:25) Relationshipsbr⌨ (1:50:35) One-to-One Relationshipsbr⌨ (1:53:45) One-to-Many Relationshipsbr⌨ (1:57:50) Many-to-Many Relationshipsbr⌨ (2:02:24) Designing One-to-One Relationshipsbr⌨ (2:13:40) Designing One-to-Many Relationshipsbr⌨ (2:23:50) Parent Tables and Child Tablesbr⌨ (2:30:42) Designing Many-to-Many Relationshipsbr⌨ (2:46:23) Summary of Relationshipsbr⌨ (2:54:42) Introduction to Keysbr⌨ (3:07:24) Primary Key Indexbr⌨ (3:13:42) Look up Tablebr⌨ (3:30:19) Superkey and Candidate Keybr⌨ (3:48:59) Primary Key and Alternate Keybr⌨ (3:56:34) Surrogate Key and Natural Keybr⌨ (4:03:43) Should I use Surrogate Keys or Natural Keys?br⌨ (4:13:07) Foreign Keybr⌨ (4:25:15) NOT NULL Foreign Keybr⌨ (4:38:17) Foreign Key Constraintsbr⌨ (4:49:50) Simple Key, Composite Key, Compound Keybr⌨ (5:01:54) Review and Key PointsHA GET IT? KEY points!br⌨ (5:10:28) Introduction to Entity Relationship Modelingbr⌨ (5:17:34) Cardinalitybr⌨ (5:24:41) Modalitybr⌨ (5:35:14) Introduction to Database Normalizationbr⌨ (5:39:48) 1NF (First Normal Form of Database Normalization)br⌨ (5:46:34) 2NF (Second Normal Form of Database Normalization)br⌨ (5:55:00) 3NF (Third Normal Form of Database Normalization)br⌨ (6:01:12) Indexes (Clustered, Nonclustered, Composite Index)br⌨ (6:14:36) Data Typesbr⌨ (6:25:55) Introduction to Joinsbr⌨ (6:39:23) Inner Joinbr⌨ (6:54:48) Inner Join on 3 Tablesbr⌨ (7:07:41) Inner Join on 3 Tables (Example)br⌨ (7:23:53) Introduction to Outer Joinsbr⌨ (7:29:46) Right Outer Joinbr⌨ (7:35:33) JOIN with NOT NULL Columnsbr⌨ (7:42:40) Outer Join Across 3 Tablesbr⌨ (7:48:24) Aliasbr⌨ (7:52:13) Self Join Comment from : Caleb Curry

Thank you! Comment from : Local Nerd

I am taking database design this semester I am here to watch your videos as i understands it better than what my professor is teaching me Thank you!!!! Comment from : JiBzee JaY

Thank you for such an amazing video Comment from : Hiếu Lê

aww so funny, I'm really enjoying this course and learning SO much, thank you Caleb! Comment from : Gini

“Off with their headsss” Omg that shouldn’t have been so funny 😆 Not what I was expecting for a database design lecture but I enjoyed this video series Comment from : CanterOn!

Thank you for the excellent video! Comment from : Ernest Blackthorn

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

Your teaching skills are just next level 👍👍 Comment from : Muhammad Zohaib

Bro is entertaining as heck Thank you for explaining what my college profs could not Comment from : Programming

Amazing Teaching Style!! Thank you !! Comment from : Δημητρης Νουβακης

2:33:40 I think it would be possible to do a classes table (2 column, id, class name) and a student table And a taken classes table where class id and student id is stored with both 1 to many Comment from : Saul Goodman

Well done, great job Comment from : Daban

@codebreakthrough you have earned the highest degree of respect brother, would have loved you having as a mentor because you showed me that important things can be learnt within very less time as well as in simple ways without complicating the concepts Love from India ❤ Comment from : raghav

Which video need to complete first? This one or SQL? Comment from : Mohamed Azimal

I've just done half of the course and I'm enjoying it! 4 years ago and still relevant! Comment from : Etornam Tsyawo

nice one, are you a character in Good Doctor? Comment from : James Mwangi

Thanks guy, this is cool and never boring Comment from : Rahi Rai

This channel should be nominated for an educational Nobel prize Mad respect for Caleb Curry for recording this absolutely amazing course Comment from : Abbigail Greene

what problems can I solve after learning this? What are the jobs available in the freelance marketplace? Comment from : College of Knowledge

The class was awesome Comment from : Gaji Md Abdul Hannan

The guy loose his sanity at 2:54:45 if anyone interested 😂😂 Comment from : Ŧгคภ๔չ

Is this worth watching in 2023? or too outdated? Comment from : August Alison

Damn I watched this video for about 4 hours without noticing he was writing by his left hand Comment from : Phuong Nguyen

I am only three hours in and wow, I am so glad to have stumbled upon this video! Comment from : Catriece Gilbert

but in islame a husband and a wife is a one to many relation because we can marry 4 wives Comment from : Anime time

1hr in so far, this is really great! Thank you Comment from : K G

How know a good course like that with application in real program Comment from : dz shop

better than my college professor Comment from : Joseph

1 Comment from : Rahul Raj

“super-“ is a prefix, so it’s supposed to be one word when it’s combined with another noun This, it’s “superkey”, rather “super key” Comment from : Choon Woon Ngo

Claire gets 666 lol Comment from : hroman_codes

You can literally see the evolution throughout this tutorial Comment from : Rouhi memar

Hey, thanks for this free course! But I want to make you aware of an error when explaining modality The modality is on the wrong side In 5:35:00 for example, you say that each card is required to have an owner But actually this side is talking about the least and max amount of cards an owner can have This can also be read on p 125 of "Database Systems - Design, Implementation and Management", 12th ed Comment from : Louna

Thank you so very much ❤ Comment from : pratibha mishra

does this course cover erd material as well? Comment from : Ikhsan Maulana

Verme do krl fazendo os bgl na lousa porra, cade seu pc irmão Comment from : Rating

I'm 100 sure your password is "pie" LolbrbrThank you very much for this awesome course man! Appreciate it! Comment from : Juan Manuel Gentili

Daunting this course but i need it so i will comment in a couple of weeks again when i finished it cyaaaa soon Comment from : a4cfee

@codebreakthroughbrbrIs a look up table basically like a dictionary or "index" used as a way to reference information? It looks as if it a look up table was like a contianer holding different variables Instead of hardcoding the membership "gold" multiple times, the key inside the lookup table acts as a variable that dynamically changes when we modify its value Comment from : Mohit Verma

'One husband can't have multiple wives' - This kid has never been to Utah apparently Comment from : Katsparrow

bro turned into a foreign key constraint at 3:29:17 Comment from : keemkorn

What knowledge we need before taking this course pls help 😢 Comment from : Phong Trần Quốc

I am a senior software engineer and I would like to say that your explanations are brilliant Thank you for sharing your knowledge for free Comment from : Àlex Blasco Brasó

I finally finished this whole video, after rewatching some parts quite a few times I watched a shorter SQL tutorial before, and also a couple of tutorial projects where they built simple applications using PHP and SQL But I’m feeling so much more confident now, and am starting to feel like I could actually begin building projects of my own rather than just making some small modifications and substitutions to a tutorial projectbrbrThis really is the sort of material that you need to understand WHY things are done a certain way It’s all well and good understanding how different tables in someone’s project relate to each other, and how primary and foreign keys are used to connect things etc But it’s a whole different thing understanding why you’d make those design choices! It feels very empowering, which is exactly how a really good course or tutorial should make you feel So many possibilities!brbrThanks a lot for this! Comment from : Tomas Johansson

Fin Comment from : idc20627

Yoooooooo whats up my homie homies! Comment from : idc20627

Awesome video, thanks Caleb! How did this not bore the pants off of me? brAnd yeah, to hell with Claire 666! Comment from : Chris

Wow, that intermediary table system really solved my main problems The thing that I wonder if I am making a project that can have millions of users, how do I make it so that I don't reach the limits of 65535 columns in a table? Would I have to make some kind of array of tables? Comment from : Marko Viitanen

Shout out for Database Monogamy ! Comment from : CrescentDoll

With one to many relationship I would use the example of a mother and three daughters too Comment from : Sonia Machin

excellent Comment from : Kamal Ali

husband can have multiple wives it depends where you are located Comment from : Johongir Rahimov

It does sound like NOLL instead of NULL but whoever pointed that out its like cmon dude Comment from : idc20627

This guy is like a God in my country Comment from : Frank Kavanagh

Good content, congrats Comment from : Jordan Code

1:44:00br3:04:00 key Comment from : Sal M

👌👍 Comment from : Alejandro Gonzalez

Good Job Comment from : Sumit Raut

Interviewers care about jargon too, forget my professors Comment from : idc20627

Nice sir to shared data base information Comment from : Kalawatie Roop

You're a wonderful teacher Thank you for sharing Comment from : Vi

I think the only thing people need from youtube is the youtube learning certificate - this is a good class Comment from : Tosin Oyebade

LOL! "This eraser is crap – DIE AARGGH!" 1:46:03 Comment from : rawdelicious

👍 Comment from : Tenebrae

Left handed curly hairedweirdothis guy is basically me 😊 Comment from : Rupaj Chowdhury

outstanding brother Caleb hilarious and informative LEGIT!!!!!! Comment from : MINISTER BOAN

2:41:39 Claire did my man dirty, can't tell me nothing Comment from : internet bro

Loved it ❤ Comment from : Hari kiran Kante

The subtitles after the fifth hour in the video are completely messed up！ Comment from : xiangge su

чёрт, почему это видео нельзя перевести через нейросеть, это фиаско Comment from : Алексей Емельянов

Thank you for the 8 hour long tutorial Caleb Comment from : L0nE_W0Lf

What Caleb said starting at 2:35:40 also blew my mind! Comment from : defremix

Joao Felix lookalike Comment from : Vin Nin

MS Access, Oracle and other ERP Databases , actually operated under same principles? ( primary key , relation, Normalization , etc ) Comment from : David

No one’s name is NAME 😂😂 Comment from : Karthik Goudar

How does he make it so simple Comment from : Stoners National

Sunil motwani krishna Comment from : Sunil Motwani

1:28:31 Comment from : casual anime

I want that guy to my home for some dirty thing Comment from : Bruce Willis

Obrigado! Comment from : Andrade

in this video you mentioned a previous video, where can we watch it where is the full playlist Comment from : Rashmi

😊 I’m ev3rRy topic onn business & data base building isz terribly long Comment from : ev3goddess yo Chandler

pretty basic, excellent for absolute beginners like me Thx😊 Comment from : saad chaudhry

Plz anyone have a information about database design requirements ? Comment from : Charu Ranasingha

Thanks a lot I have watched this masterpiece Comment from : KAF

2 days with 175speed to finish this class! Thank you for the course, Caleb Comment from : Konstantinos Polemis

It is the masterpiece I'm work as an android developer and I'm also interested in backend development I like this video so much Everything is clear thanks a lot Comment from : KAF

I just love this guy Comment from : Brainy

🙃l Comment from : Qais Jor

Watching this at 15 speed is perfect Also, this guy seems like the friend everyone needs but only some deserve Comment from : Boss Level Pro

Dont freek outi get it even at my age Comment from : K P

Похожие на Database Design Course - Learn how to design and plan a database for beginners видео

Tour Travel Sales Marketing Poster Design in Ms Word | Learn Flyer Brochure Banner Design РѕС‚ : Backbenchers Classroom Download Full Episodes | The Most Watched videos of all time

Air Ticketing Course Online | What is air Ticketing | Travel Tourism Course | Learn Amadeus GDS РѕС‚ : India Travel Tourism Institute I.T.T.I Download Full Episodes | The Most Watched videos of all time

IATA Air Ticketing Course | Diploma course In Travel Tourism | Course Details For Travel Tourism РѕС‚ : India Travel Tourism Institute I.T.T.I Download Full Episodes | The Most Watched videos of all time

Air Ticketing Course 2022 | Air Ticketing Course Syllabus | Travel Tourism course Syllabus | Amadeus РѕС‚ : India Travel Tourism Institute I.T.T.I Download Full Episodes | The Most Watched videos of all time

Best Office Design 2021 | Latest Office Design Inspirations and Ideas | Travel agency Office-2 РѕС‚ : Abhishek Shah Download Full Episodes | The Most Watched videos of all time

Travel and tourism course - Is travel and tourism a good course? РѕС‚ : Zabeel Institute- Official UAE Download Full Episodes | The Most Watched videos of all time

Learn English for Hotel and Tourism: "Checking into a hotel" | English course by LinguaTV РѕС‚ : LinguaTV.com Download Full Episodes | The Most Watched videos of all time

A4 Brochure Design in MS Word | Brochure Design Tutorial | Microsoft Word РѕС‚ : Office Desk Download Full Episodes | The Most Watched videos of all time

Travel Brochure Design Concept Timelapse | Freelance Graphic Design РѕС‚ : SJ Creatives Download Full Episodes | The Most Watched videos of all time

How To make A Handmade AESTHETIC BROCHURE For School Project|Front Page Design| With Design Ideas РѕС‚ : John Polentinos Download Full Episodes | The Most Watched videos of all time