by Smail Oubaalla | Released December 2018 | ISBN: 9781838557201

Understand the relationship between data and databases through this course and build efficient databasesAbout This VideoPractical learning and graphical explanations teach you the concepts of database relationshipsDelve into the core concepts of Relational databases and normalization techniquesStore, retrieve, and manipulate your data and design efficient database solutionsIn DetailWith 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. Show and hide more

1. Chapter 1 : Getting Started with Relational Databases
   • The Course Overview 00:02:49
   • Setup and Installation 00:03:38
   • A Database Story 00:04:00
   • Relational Databases for the Naked Eye 00:03:57
   • Database Management Systems 00:01:44
2. Chapter 2 : Database Design
   • StarCars’s Database 00:01:55
   • Database Design and the Design Process 00:05:13
   • Tables 00:04:47
   • Keys 00:03:10
   • Fields Specifications 00:04:05
3. Chapter 3 : Relationships
   • What Is a Relationship? 00:03:18
   • One-to-One 00:02:19
   • One-to-Many 00:03:19
   • Many-to-Many 00:05:24
4. Chapter 4 : Practice – Logical and Physical Models
   • Part 1 – Define the Entities 00:02:43
   • Part 2 – Columns and Keys 00:09:32
   • Part 3 – Relationships 00:08:10
5. Chapter 5 : Normalization Forms
   • Normal Forms 00:02:39
   • First Normal Form 00:04:22
   • Second Normal Form 00:03:49
   • Third Normal Form 00:06:50
Show and hide more