Basic Relational Database Design

Basic Relational Database Design
Basic Relational Database Design

English | MP4 | AVC 1920×1080 | AAC 48KHz 2ch | 1h 27m | 273 MB
eLearning | Skill level: All Levels


Understand the relationship between data and databases through this course and build efficient databases

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.

This course supplies mix of theoretical and practical notions, starting with a bit of theory and extending it via practical examples using a business case.

What You Will 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
+ Table of Contents

GETTING STARTED WITH RELATIONAL DATABASES
The Course Overview
Setup and Installation
A Database Story
Relational Databases for the Naked Eye
Database Management Systems

DATABASE DESIGN
StarCars’s Database
Database Design and the Design Process
Tables
Keys
Fields Specifications

RELATIONSHIPS
What Is a Relationship?
One-to-One
One-to-Many
Many-to-Many

PRACTICE – LOGICAL AND PHYSICAL MODELS
Part 1 – Define the Entities
Part 2 – Columns and Keys
Part 3 – Relationships

NORMALIZATION FORMS
Normal Forms
First Normal Form
Second Normal Form
Third Normal Form


Download from Rapidgator

Download from Turbobit