Learn how to create an effective relational database design to use in your IT career or even a personal project.
All Levels, – 2.5 hours, 31 lectures
Average rating 3.9/5 (3.9 (160 ratings) Instead of using a simple lifetime average, Udemy calculates a course’s star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.)
Ability to download software (or a preferred data modelling tool)
Windows, Mac or Linux (chosen software works on all three)
Willingness to learn about designing a quality database, and not just putting data into tables!
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:
Almost three hours of video lessons
Included PDF files of the database diagrams at keys steps will help you learn all about database design.
The topics covered include normalisation and the normal forms, identifying tables and columns, primary and foreign keys, and setting up relationships.
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:
We’ll walk through a sample database
Reason or why the database is needed
Some advantages of relational databases
Identify entities for the tables and attributes
Create tables and columns
Reorganise them to make the layout and design more efficient.
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!
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
Software developers or web developers
Students wishing to know more about database design
Those looking to get into a database role
“Good primer on database design. Covers First, Second, and Third normal form. After this you should be able to design a database well. You won’t be able to actually build one, enter data, run SQL queries, etc. But that’s not the scope of this class. However, the design is the first step, and a good design will make everything else much easier.” (Scott Adams)
“Es un curso que contiene las bases para un adecuado diseño de una base de datos-” (Miguel Guzman)
“Great content. Great examples and guidance through them in the tutorials applying the content taught. However, the content lessons are pretty droll and very redundant—basically reading the slides.” (Shawn Wood)
I’m a software consultant that has a passion for databases, and teaching others. I have over seven years experience in the IT industry in many roles, including database support, database development, database design, reporting, business analysis, project management, and even Excel.
I obtained the Oracle SQL Expert certification and currently looking into the next certification on my list!
I’d like to teach others about databases and database topics, such as SQL, database design, and performance.
Instructor Other Courses:
Introduction to Oracle SQL Ben Brumm, IT Software Consultant (40) $10 $50
Ben Brumm coupons
Development course coupon
Udemy Development course coupon
Databases course coupon
Udemy Databases course coupon
Relational Database Design
Relational Database Design course coupon
Relational Database Design coupon