Relational Database Design

Learn how to create an effective relational database design to use in your IT career or even a personal project.
Relational Database Design
File Size :
408.99 MB
Total length :
1h 42m

Category

Instructor

Ben Brumm

Language

Last update

Last updated 6/2020

Ratings

4.3/5

Relational Database Design

What you’ll learn

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

Relational Database Design

Requirements

Internet connection
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!

Description

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 lessonsIncluded 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 databaseReason or why the database is neededSome advantages of relational databasesIdentify entities for the tables and attributesCreate tables and columnsReorganise 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!

Overview

Section 1: Introduction

Lecture 1 Welcome

Lecture 2 What Is A Database?

Lecture 3 Different Types of Databases?

Lecture 4 Benefits of Relational Databases

Section 2: Data Modelling Process

Lecture 5 What Is Data Modelling And The Design Process?

Lecture 6 Determine The Goal Of The Database

Lecture 7 Consider the Current System

Lecture 8 Gathering Requirements of the Database

Lecture 9 Finding Exceptions to the Rules

Lecture 10 Identifying Entities

Lecture 11 Defining the Attributes

Section 3: Database Design

Lecture 12 Normalisation

Lecture 13 First Normal Form

Lecture 14 First Normal Form: Student

Lecture 15 First Normal Form: Subject

Lecture 16 First Normal Form: Teacher

Lecture 17 First Normal Form: University

Section 4: Second Normal Form

Lecture 18 Relationships

Lecture 19 Second Normal Form

Lecture 20 Second Normal Form: Student and Subject

Lecture 21 Second Normal Form: Teacher

Lecture 22 Second Normal Form: University

Section 5: Third Normal Form

Lecture 23 Third Normal Form

Lecture 24 Third Normal Form: Student and Subject

Lecture 25 Third Normal Form: Teacher and University

Lecture 26 Third Normal Form Completed

Section 6: Design Considerations

Lecture 27 Data Types and Precision

Lecture 28 Integrity Constraints

Lecture 29 Naming Conventions

Lecture 30 Lookup Tables and Auditing

Lecture 31 Auditing Tables

Lecture 32 Implementation and Next Steps

Software developers or web developers,Students wishing to know more about database design,Those looking to get into a database role

Course Information:

Udemy | English | 1h 42m | 408.99 MB
Created by: Ben Brumm

You Can See More Courses in the Developer >> Greetings from CourseDown.com

New Courses

Scroll to Top