Relational Database Design

4.3 /5

(3 Ratings)

Offered byUDEMY

Relational Database Design
at
UDEMY
Overview

Learn how to create an effective relational database design to use in your IT career or even a personal project.

Duration	1 hour
Total fee	₹455
Mode of learning	Online
Credential	Certificate

Relational Database Design
at
UDEMY
Highlights

Earn a certificate from Udemy
Get a 30 day money back guarantee
Students will get full lifetime access of the course

Relational Database Design
at
UDEMY
Course details

Skills you will learn

Software development

Who should do this course?

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

What are the course deliverables?

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

More about this course

This course will teach students 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 students want to improve their software development career, get into database admin or database design, or are just curious on this topic, this course is for them
Students don't need to know SQL or have any programming experience to be able to take this Relational Database Design course

Relational Database Design
at
UDEMY
Curriculum

Introduction

Benefits of Relational Databases

Consider the Current System

Gathering Requirements of the Database

Finding Exceptions to the Rules

Identifying Entities

Defining the Attributes

Normalisation

First Normal Form

First Normal Form: Student

First Normal Form: Subject

First Normal Form: Teacher

First Normal Form: University

Relationships

Second Normal Form

Second Normal Form: Student and Subject

Second Normal Form: Teacher

Second Normal Form: University

Third Normal Form

Third Normal Form: Student and Subject

Third Normal Form: Teacher and University

Third Normal Form Completed

Data Types and Precision

Integrity Constraints

Naming Conventions

Lookup Tables and Auditing

Auditing Tables

Implementation and Next Steps

Relational Database Design
at
UDEMY
Faculty details

Ben Brumm

Ben Brumm is a software consultant that has a passion for databases, and teaching others. He has 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.