by Eduonix | Released April 2018 | ISBN: 9781789343038

A Complete Course to Master Database Design using MySQLAbout This VideoGood course for starting up & covers quickly the important topics and shows for beginners what MySQL can be used for.In DetailDatabase design is one of the most important aspects of web programming. Successful implementation of any system with data storage will always need proper database design. In order to create great database design you will not only have to master database technology but will also have to master database design process and normalization. This course will also teach you SQL and you will be a SQL power user by the end of this course. You will start with a basic introduction to data storage and will follow it up with storage engines and other tools. You will also learn about MySQL installation and the database design process. Database design, normalization, structure mapping, keys, and junction tables come next. The next units will teach you SQL and Advance SQL and you will also learn to use PHP with MySQL. This complete database course will help you become a database design guru. Show and hide more

1. Chapter 1 : Introduction
   • Intro 00:03:33
2. Chapter 2 : Introduction
   • What is a Database? 00:11:08
   • MySQL Overview 00:09:00
   • Understanding Storage Engines 00:08:29
   • Understanding Data Types 00:07:42
3. Chapter 3 : Getting Started With MySQL
   • Windows Installation 00:10:37
   • Linux Installation 00:04:11
   • Environment Setup With Xampp 00:07:12
   • PHPMyAdmin 00:13:14
   • MySQL Workbench Setup 00:10:39
4. Chapter 4 : Planning & Design
   • Principles & Normalization 00:10:58
   • Database Design Process 00:05:18
   • Map Out Structure 00:14:58
5. Chapter 5 : Creating A Database
   • CREATE TABLE IF NOT EXISTSs & Columns 00:12:23
   • Importing & Exporting 00:05:16
   • Relations & Foriegn Keys 00:13:16
   • Junction Tables 00:04:46
6. Chapter 6 : SQL Fundamentals
   • Command Line & Inserting Data 00:28:58
   • Basic Select Queries 00:14:46
   • Updating & Deleting Data 00:09:06
   • Aliases & Joins 00:18:39
7. Chapter 7 : Advanced SQL
   • Union, Concat & Count 00:11:18
   • Using the IN Clause 00:09:12
   • Math & Subqueries 00:09:43
   • Using Group By 00:07:29
8. Chapter 8 : PHP & MySQL
   • PHP Fundamentals 00:21:00
   • Template & MySQL Connect 00:19:03
   • Select & Display With PHP 00:16:55
   • Insert Data With PHP 00:29:20
   • Update & Delete With PHP 00:22:59
Show and hide more