Learn Database Design With Mysql

  1. Home
  2. Mysql
  3. Learn Database Design With Mysql

Tags: MySQL

A Complete Course to Master Database Design using MySQL

Last updated 2022-01-10 | 4.1

- To Learn Database design Process
- To Learn Database Normalization
- To Learn Database development using MySQL

What you'll learn

To Learn Database design Process
To Learn Database Normalization
To Learn Database development using MySQL
To Master SQL
To Learn to use PHP with MySQL

* Requirements

* Understanding of Basic web terminology and experience in HTML

Description

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 the Database technology but will have to master database design process and normalization.

This course will teach you the nuances of proper database design. It will teach you all the hidden tips and tricks and will ensure that you learn all the major concepts of a proper database design. 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 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 comes next.

The next units will teach you SQL and Advance SQL and you will also learn to use PHP with MySQL. So this complete Database course and will surely help you become a Database Design Guru.

Who this course is for:

  • Web Developers and Database designers

Course content

8 sections • 32 lectures

Introduction 1 lectures

Introduction 4 lectures

What is a Database Preview 11:07

Introduction to Data storage

MySQL Overview Preview 08:59

Introduction to MySQL description

Understanding Storage Engines Preview 08:29

Learn all about storage engines in this lecture.

Understanding Data Types Preview 07:41

Data types and storage

Getting Started With MySQL 5 lectures

Windows Installation Preview 10:37

Windows Installation of MySQL

Linux Installation Preview 04:10

Installing MySQL in Linux

Environment Setup With Xampp Preview 07:11

Setting up the environment using Xampp

PHPMyAdmin Preview 13:14

PHPMy Admin and its use.

MySQL Workbench Setup Preview 10:38

Know all about MySQL Workbench

Planning & Design 3 lectures

Principles & Normalization Preview 10:58

Learn all about Normalization of Database

Database Design Process Preview 05:17

The Database design process.

Map Out Structure Preview 14:58

Learn to Map out the Schema

Creating A Database 4 lectures

Create Tables & Columns Preview 12:23

Creating Tables and Columns in a Database

Importing & Exporting Preview 05:16

Learn to import and export the database

Relations & Foriegn Keys Preview 13:15

Learn to create relationships

Junction Tables Preview 04:46

The Junction tables in database

SQL Fundamentals 4 lectures

Command Line & Inserting Data Preview 28:58

Data Insertion using SQL

Basic Select Queries Preview 14:45

The basic select queries in SQL

Updating & Deleting Data Preview 09:06

Updating and Deletion of Data using SQL

Aliases & Joins Preview 18:39

Aliases and Joins using SQL in database

Advanced SQL 4 lectures

Union, Concat & Count Preview 11:18

Master the SQL to union, concat and count

Using The IN Clause Preview 09:11

Learn all out the In clause

Math & Subqueries Preview 09:43

Learn to use SQL for Math and Subquering

Using Group By Preview 07:29

Learn to use the Group By in SQL

PHP & MySQL 7 lectures

PHP Fundamentals Preview 20:59

A short tutorial on PHP

Template & MySQL Connect Preview 19:03

Learn all about Template & MySQL connect

Select & Display With PHP Preview 16:55

Learn to display data using PHP

Insert Data With PHP Preview 29:20

Insert data with PHP

Update & Delete With PHP Preview 22:58

Data Update and deletion using PHP

Wrap up Preview 03:49

Course Summary

Bonus Lecture: More Interesting Stuff, Offers and Discounts Preview 00:24