Database Design (Udemy.com)

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

( 262 Reviews )

Created by: Caleb Curry

Produced in 2015

What you will 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!

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 88 / 100

Course 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! Who this course is for:
Anyone working with relational databases. This course starts from the beginning. No prior knowledge is required but will of course make things easier and more clear to youThis 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

Time: 8.5h

Instructor Details

Caleb Curry

4.4 Rating
262 Reviews

Hi! I'm Caleb. I have created over 1,500 tutorials on data, software development, cryptocurrency, etc. I believe that the way I teach is what matters. I dont flash big words without explaining them and I dont assume knowledge.
Ikeep it simple
My goal is to simplify complex problems for anyone to understand. I'm not your typical "teachers who can create an entire course without actually explaining anything.
Ikeep it detailed
I also like to be thorough. If you watch my content and dont leave with a new understanding, then I am not doing my job.

I keep it fun
My primary goal is not to put you to sleep as I read an encyclopedia from slides (I prefer dictionaries). Actually, I kinda hate Powerpoint. My unique approach has caused my videos to be watched 91 years (thats 800K hours of watchtime on YouTube alone).

I am now a tech trainer with this resume:
170k+ YouTube subscribers
180k+ Udemy students
Ex-IBMer and Ex-Software Engineer
Oreilly Live trainer and course author
International speaker on data and Software Development
10 years of coding experience

I love teaching, and Im beyond excited to have you join me in the learning process.
~~~~~~~~~~~
June 4th, 2012. I decided to take my skill set to the next level and learn how to professionally program databases as well as websites. After just graduating my Junior year of high school, I did not have a typi

Reviews

4.4

262 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Jubril Akintayo on 12/20/2020

Yes

By Dusko Petrovic on 12/20/2020

Unconsistent, unclear, followed by annoying comments and breaks, such as subscribe, subscribe, subscribe. Time consuming explanations of simple terms, a lot of useless comments. Dissapointing! The presenter is improvising and losing the focus on topics. It could be organized on more sistematic, efficient and clearer way, spending at least 30% less time by better preparation and more fluent presentation. Just take a look to the lesson 19 and you will understand what Im talking about. A bad spent time. Big minus for you Udemy, so think about of your reputation!

By Wilson ASH on 11/16/2020

Great course, Caleb has done a good job of simplifying complex concepts. I am a data scientist and I wish I did a similar course at the beginning of my career. I would recommend this course to anyone interested in data analytics or/and data science.

By Fatemeh Rajabi on 10/20/2020

I like it. I hope it will be useful.

By Felix Centeno on 10/16/2020

only whitboard please use something more usefull

By Endah on 10/15/2020

Great course

By Mulugeta Adugna Furgassa on 10/11/2020

very nice course for my experiences

By Alison Buck on 9/27/2020

Excellent and easy for me to understand

By Ralph Linares on 9/15/2020

Great tutor, very energetic and knowledgeable about his subject!

By Malik Hamza Nawaz on 9/14/2020

Amazing

By Eric Eduardo Sols Montufar on 9/9/2020

The instructor is always playing the funny guy in the videos and the content is not good at all. I got this course for free and still dont recommend it.

By Rohitash Choudhary on 9/6/2020