Learn Database Design with MySQL

Esoft

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

DOWNLOAD:

Tags: , , ,

Leave a Reply