4.27 (10384 reviews)
☑ Learn how to design a relational database
☑ Learn what normalisation is, and each of the three normal forms
☑ Start designing a database from nothing
☑ Learn how to identify tables, and how to create relationships
Learn how to design a proper relational database with this course!
This course will teach you how to create an effective relational database design using proven concepts and industry knowledge.
Effective database designs will help make systems faster, improve data quality, and ensure future changes are easier.
If you want to improve your software development career, get into database admin or database design, or are just curious on this topic, this course is for you.
You don't need to know SQL or have any programming experience to be able to take this Relational Database Design course.
This course includes:
The videos include explanations of the key topics in the process, as well as demonstrations on how to set up a database using an Entity Relationship Diagram.
I also show you how to download and install the software that is being used for this.
What topics are covered in this database design course?
The topics covered are:
If you want to know how to design a database and improve the overall quality of your databases and software, then this is the course for you.
You'll learn all you need to be able to design an effective database!
Things You Should Know Before Starting This Course
Tools You Need For Database Design
How To Set Up MySQL Workbench
What Is A Database?
Different Types of Databases?
Store Data for Each Component
Removes Duplicate Information
Ensure Records are Complete
Prevent Inconsistent and Conflicting Data
Combine Different Data Sets Easily
Data Modelling Process
What Is Data Modelling And The Design Process?
Determine The Goal Of The Database
Consider the Current System
Gathering Requirements of the Database
Finding Exceptions to the Rules
Defining the Attributes
First Normal Form - Part 1
First Normal Form - Part 2
Second Normal Form - Part 1
Second Normal Form - Part 2
Third Normal Form
Data Types and Precision
Lookup Tables and Auditing
Implementation and Next Steps
Simple and rapid explanation of how to use Normalization to design a database and lay it out before jumping into any actual building.
This course really helps to create an effective relational database design. Most importantly the summary and the action that is explained in the end of each lecture really helps to recollect all the things you've understood.
Cleared many doubts on the topic of databases and learned the use of charts and their helpfulness. Good course
On moving from lesson to lesson, each new lesson does not start automatically. I have to fast forward it 5 seconds, pause and manually wind back. Very, very basic and incomplete view of database technology. Also presenter doesn’t know how to pronounce “data”, which is really irritating.
The details are much better toward the end as the demos and interaction give you a better feel for what you would have initially expected to have been learning Again, the narrator uses a lot of white-space reciting the bullet points without embellishing them enough to make them a full value add and for the most part the information is only useful from S313 - First Normalisation where it gives you useful and practical information Still worth it for an hour and a half though if you want to expand or fill gaps in your current (really helps if you understand a bit of SQL to see how the data would join in a live environment)
The installed software (MySQL Workbench) failed to work. There were other prerequisites that I had to google to find. A reboot was necessary. Also, twice when my browser froze, I was unable to pick up where I left off. I had to manually advance to where I was prior.
great course, the explanation of the different terms in the course were clear and easy to follow, i learned a lot
Very easy to follow along and using the MySQL Workbench Model really helped with getting through the overwhelming part of the database that I am working to build.
This course gives a good introduction to database modelling, especially the normal forms are well explained.
This course sets a very high standard. Ben is very clear in the areas he describes and very disciplined in not digressing from the points he is explaining. He is an excellent teacher and explains things very clearly. I can now see how I need to design and set up my own relational database. The way in which normalization was covered in this course and moreover it's importance was very impressive. I would definitely recommend this course to anyone who needs to understand relational databases.
The subtitles were not matching the words that he was saying otherwise the flow of the course was good and ya thanks.
Good course to understand the key data modeling concepts via several practical examples. Would be nice if there was more lessons covering the conceptual and logical data models (focus seems to be on the physical data model only).
I didn't understand the concept of transitive dependency in 3NF quite well with the given example, also the explanation was a bit quick.
I had very bad experience while learning this course , audio quality is very bad that while the expert is speaking i hear a background sound which is interrupting and annoying makes me difficult to watch and the concepts are not crisp enough to understand in a simple manner which makes the lecture sessions , a boring one
This is one of the best and most concise classes I've taken via Udemy. I was able to understand everything he said and his teaching methods are great. I will definitely try to find other classes in Udemy that he instructs!