Database Design

Rating 4.5 out of 5 (3339 ratings in Udemy)

What you'll 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 …

Rating 4.5 out of 5 (3339 ratings in Udemy)

What you'll 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!

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!

Duration 8 Hours 58 Minutes

Paid

Self paced

All Levels

English (US)

93048

Rating 4.5 out of 5 (3339 ratings in Udemy)

Go to the Course
We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.