Learn Database Design with MySQL

Learn Database Design with MySQL
English | Size: 822.46 MB
Category: CBTs

Database 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 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.

Table of Contents
Chapter 1 : Introduction
Intro 00:03:33
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
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
Chapter 4 : Planning & Design
Principles & Normalization 00:10:58
Database Design Process 00:05:18
Map Out Structure 00:14:59
Chapter 5 : Creating A Database
Create Tables & Columns 00:12:23
Importing & Exporting 00:05:16
Relations & Foriegn Keys 00:13:16
Junction Tables 00:04:46
Chapter 6 : SQL Fundamentals
Command Line & Inserting Data 00:28:59
Basic Select Queries 00:14:46
Updating & Deleting Data 00:09:06
Aliases & Joins 00:18:39
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
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
Wrap up 00:03:49

Buy Long-term Premium Accounts To Support Me & Max Speed

DOWNLOAD:

If any links die or problem unrar, send request to http://goo.gl/aUHSZc

About WoW Team

I'm WoW Team , I love to share all the video tutorials. If you have a video tutorial, please send me, I'll post on my website. Because knowledge is not limited to, irrespective of qualifications, people join hands to help me.