Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Basic Relational Database Design
Rating: 4.2 out of 5(30 ratings)
110 students

Basic Relational Database Design

Build and design efficient databases for your applications
Last updated 1/2019
English
English [Auto],

What you'll learn

  • Get an understanding of databases and database design
  • Build a database scheme in a proper way
  • Learn how to normalize your database
  • Learn to design a database from scratch
  • Master all types of relationship and properly design them all within a database

Course content

5 sections21 lectures1h 27m total length
  • The Course Overview2:49
  • Setup and Installation3:38

    Install a MySQL Workbench for the Practical Examples

    • Download MySQL Workbench

    • Install it

    • Configure it

     

  • A Database Story3:59

    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

     

  • Relational Databases for the Naked Eye3:57

    Why is it called a Relational Database?

    • Definition of Relational Database

    • Benefits of Relational Database Model

     

  • Database Management Systems1:43

    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

     

Requirements

  • Basics knowledge of Database is required

Description

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. 

Who this course is for:

  • This course is intended for beginners and intermediate developers looking to build and design efficient databases for their applications.