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:
⭐️ 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:
🐦Follow Caleb on Twitter:
—
Learn to code for free and get a developer job:
Read hundreds of articles on programming:
And subscribe for new videos on technology every day: .
Images related to the topic c squared financial
Database Design Course – Learn how to design and plan a database for beginners
Search related to the topic Database Design Course – Learn how to design and plan a database for beginners
#Database #Design #Learn #design #plan #database #beginners
Database Design Course – Learn how to design and plan a database for beginners
c squared financial
See all the latest ways to make money online: See more here
See all the latest ways to make money online: See more here
Is this course suitable for someone going into data science?
Nice
Nice bro………
It's an amazing way of teaching ..thanks a lot
Is database the same as Dbase3
Were are you from?
How old are you
Get this man a whiteboard!
thank you so much!
Thanks for taking all of the time you put into this and sharing it, very much appreciated!
Oh hey
One slight correction . . . it's pronounced "AT-rib-yutes" not "a-TRIB-yutes". The stress should be on the first syllable not the second.
Great talk, but just a tip: when you're saying "attribute" around the 13 minute mark, you're pronouncing it using its verb form when you should be pronouncing it using the noun form. "I attTRIbute my success to watching youtube videos about databases" vs "database tables have ATtributes".
Is it conventional to say the word attribute as if it were a verb rather than a noun in this context or is this just a regional thing? 😀
In the end he got long hair so he did this on several weeks 🙂
It reminds me of traditional course in my engineering cours …in the old days since I know all this already I just reviewed it at 1.75x speed 😀
By far it was greatest video i had seen
Awesome video, learned a lot from it, thanks! 🙂
Comuter see only 1/0, so data IS always same
Thanks => https://youtube.com/playlist?list=PLjPCqQYX_TNriEcLOMuuMtZ1ZaIiloTyb
Good => https://youtube.com/playlist?list=PLjPCqQYX_TNriEcLOMuuMtZ1ZaIiloTyb
OMG i just realize it is over 8 hrs long video…. 🙁 Interesting subject but way too long. Maybe better to split up on shorter videos. Time stams fine but is is looks like a video with a ton of commecrcial with those vertical lines. Harder to get the right jumps between timestams. A small mouse movement will cause 10-20 min jump.
teaching databases on a chalkboard is probably the stupidest thing ive seen all day
database lessons on a blackboard? wth man? thanks but no thanks.
Hello everyone, I have one question, I am very new to programming, is the lecture useful for me.
If anyone reads this, I took a SQL class at very good program. This video condenses that class and covers everything it did in 8 hours 🙂
I literally just watched you grow a beard or two throughout the course of this video lol
my highlights.
1:42:00 waaat
1:57:00 hahah
At 6 hours and 26 minutes, we are seeing a "White Board" with erasable markers instead of chalk and a chalkboard!
5:33:38 nice
i love you caleb
Thanks!
"Sorry for for yelling and getting intense" – xD Gold xD Please someone, do the timestamp of all Caleb's jokes throughout this course xD
relation in between entity (caleb) and the entity-attributes(name, telephone, sex)
1:38:51 self note.
8 HOURS!??! Man…. couldn't you have shortened it to like 8 minutes or sumphin.
You should allow people to change email. Costco had this mistake. So I failed to find my history once changed my email. Only employee may use office email.