English | MP4 | AVC 1920×1080 | AAC 48KHz 2ch | 1h 27m | 273 MB
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
Resolve the captcha to access the links!