
Install a MySQL Workbench for the Practical Examples
Download MySQL Workbench
Install it
Configure it
What is a Database and how it evolved through history
Understand what a database is
Explore the history of database
Difference between various database models
Why is it called a Relational Database?
Definition of Relational Database
Benefits of Relational Database Model
How we can use Databases and what are some of the most famous DBMS used currently.
What is Database Management System (DBMS)?
Examples of DBMS
Introduction to the fictional company called StarCars and their database
Summary of the situation
What steps should we follow in order to design a database?
Define Database Design
Benefits of doing Database Design
Database Design process
How we organize the data in a relational Database?
Introduction to tables
Examples
What are keys in a database?
Introduction to keys
Types of keys
What data types we can use in our columns?
Explore Character strings data types
Explore Numbers data types
Explore data and time and Binary data types
What is a relationship in a database? What types of relationships we have?
Understand Relationships
Explore Foreign keys
One to one relationship? And how we can build one?
Definition
Example
One to many relationship? And how we can build one?
Definition
Example
Many to many relationship? And how we can build one?
Definition
Example
Analyzing the Requirements to Define the tables and entities
Review StarCars requirements
Identify the tables/entities
Defining the columns, data types and keys
Discover the columns for each tables and their data types
Build StarCars database Scheme
Define the Primary Keys
Define the Relationships of StarCars database
Identify the logical relationships between StarCars tables
Use MySQL Workbench to build the relationships easily in the Scheme
What do we mean by Normal Forms?
Definition
Benefits
Types
What is the first normal form?
Definition
Example
What is the second normal form?
Definition
Example
What is the third normal form?
Definition
Example
With growing market demands, every developer working on various programming languages plans to become a full-stack developer and database management is key to developing every web, desktop, or cloud application.
You'll start by preparing your own database tables, then create an advanced database design to manage your data efficiently, which is necessary when you are working with a large set of data for any project. Along the way, you will also experience the power of database models and relationships to reuse a particular set of data.
By the end of the course, you will be able to build and design efficient databases. You will also be able to use normalization to restructure your database and reduce redundancy.
About the Author
Smail Oubaalla is a talented software engineer with an interest in building the most effective, beautiful, and correct software possible. He has helped companies build excellent programs. He also manages projects and has experience in designing and managing new products. When not working, he loves hanging out with friends, hiking, and playing sports (football, basketball, rugby, and more). He also loves working his way through every recipe he can find in the family cookbook or elsewhere, and indulging his love for seeing new places.