Relational Database Design

Relational Database Design, available at $69.99, has an average rating of 4.45, with 41 lectures, based on 35369 reviews, and has 93573 subscribers.

You will learn about 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 This course is ideal for individuals who are Software developers or web developers or Students wishing to know more about database design or Those looking to get into a database role It is particularly useful for Software developers or web developers or Students wishing to know more about database design or Those looking to get into a database role.

Enroll now: Relational Database Design

Summary

Title: Relational Database Design

Price: $69.99

Average Rating: 4.45

Number of Lectures: 41

Number of Published Lectures: 32

Number of Curriculum Items: 41

Number of Published Curriculum Objects: 32

Original Price: $39.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome

Lecture 2: What Is A Database?

Lecture 3: Different Types of Databases?

Lecture 4: Benefits of Relational Databases

Chapter 2: Data Modelling Process

Lecture 1: What Is Data Modelling And The Design Process?

Lecture 2: Determine The Goal Of The Database

Lecture 3: Consider the Current System

Lecture 4: Gathering Requirements of the Database

Lecture 5: Finding Exceptions to the Rules

Lecture 6: Identifying Entities

Lecture 7: Defining the Attributes

Chapter 3: Database Design

Lecture 1: Normalisation

Lecture 2: First Normal Form

Lecture 3: First Normal Form: Student

Lecture 4: First Normal Form: Subject

Lecture 5: First Normal Form: Teacher

Lecture 6: First Normal Form: University

Chapter 4: Second Normal Form

Lecture 1: Relationships

Lecture 2: Second Normal Form

Lecture 3: Second Normal Form: Student and Subject

Lecture 4: Second Normal Form: Teacher

Lecture 5: Second Normal Form: University

Chapter 5: Third Normal Form

Lecture 1: Third Normal Form

Lecture 2: Third Normal Form: Student and Subject

Lecture 3: Third Normal Form: Teacher and University

Lecture 4: Third Normal Form Completed

Chapter 6: Design Considerations

Lecture 1: Data Types and Precision

Lecture 2: Integrity Constraints

Lecture 3: Naming Conventions

Lecture 4: Lookup Tables and Auditing

Lecture 5: Auditing Tables

Lecture 6: Implementation and Next Steps

Instructors

Ben Brumm
IT Software Consultant

Rating Distribution

1 stars: 312 votes
2 stars: 698 votes
3 stars: 5163 votes
4 stars: 14560 votes
5 stars: 14635 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu