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!
An outline of a few things you should know before starting the course.
You'll need a few tools for this course. They're all free though!
Information on what a database is and what it's used for.
A description of different types of databases, including the relational database.
An advantage of a relational database means you can store data for each component.
Another advantage of relational database is that it removes duplicate information.
Another advantage means that you can ensure records are complete.
Another advantage is that you can prevent inconsistent and conflicting data.
Another advantage of a relational database means you can easily combine different data sets.
You can increase the security in a few ways with a relational database.
An explanation of what data modelling is, and what the database design process is.
The first step is to determine the goal of the database.
We sometimes need to consider the current system in our database design.
How to gather the requirements for creating your database.
Exceptions to rules may exist, and we need to consider them.
Instructions on how to identify entities for your database.
We look at how to define the attributes for our entities.
Learn what normalisation is and what is involved.
An explanation of first normal form and applying to our sample database.
Continue to apply first normal form to our database.
An explanation of different types of relationships.
An explanation of second normal form, and how to apply it to our sample database.
Continue to apply second normal form to our database.
An explanation of third normal form, and how to apply it to our sample database.
Learn about data types and precision, and why they are important to a database.
Explanation of what integrity constraints are.
Naming conventions are important for a good database design.
Explanation of what lookup tables are and what auditing can be done on a database.
How to implement this database, and what your next steps are.
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.