Development
Databases
MySQL
Learn Database Design with MySQL
4.2 (3,992 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
76,344 students enrolled

Learn Database Design with MySQL

A Complete Course to Master Database Design using MySQL
4.2 (3,991 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
76,344 students enrolled
Created by Eduonix Learning Solutions, Eduonix-Tech .
Last updated 12/2018
English
English [Auto]
Preview this course
Learn Database Design with MySQL
Current price: $27.99 Original price: $39.99 Discount: 30% off
5 hours left at this price!
Buy now
30-Day Money-Back Guarantee
This course includes
  • 6.5 hours on-demand video
  • 1 article
  • 17 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Course content
Expand all 32 lectures 06:15:09
+ – Introduction
4 lectures 36:16

Introduction to Data storage

What is a Database
Preview 11:07

Introduction to MySQL description

MySQL Overview
08:59

Learn all about storage engines in this lecture.

Understanding Storage Engines
08:29

Data types and storage

Understanding Data Types
07:41
+ – Getting Started With MySQL
5 lectures 45:50

Windows Installation of MySQL

Windows Installation
10:37

Installing MySQL in Linux

Linux Installation
04:10

Setting up the environment using Xampp

Environment Setup With Xampp
07:11

PHPMy Admin and its use.

PHPMyAdmin
13:14

Know all about MySQL Workbench

MySQL Workbench Setup
10:38
+ – Planning & Design
3 lectures 31:13

Learn all about Normalization of Database

Principles & Normalization
10:58

The Database design process.

Database Design Process
05:17

Learn to Map out the Schema

Map Out Structure
14:58
+ – Creating A Database
4 lectures 35:40

Creating Tables and Columns in a Database

Create Tables & Columns
12:23

Learn to import and export the database

Importing & Exporting
05:16

Learn to create relationships

Relations & Foriegn Keys
13:15

The Junction tables in database

Junction Tables
04:46
+ – SQL Fundamentals
4 lectures 01:11:28

Data Insertion using SQL

Command Line & Inserting Data
28:58

The basic select queries in SQL

Basic Select Queries
14:45

Updating and Deletion of Data using SQL

Updating & Deleting Data
09:06

Aliases and Joins using SQL in database

Aliases & Joins
18:39
+ – Advanced SQL
4 lectures 37:41

Master the SQL to union, concat and count

Union, Concat & Count
11:18

Learn all out the In clause

Using The IN Clause
09:11

Learn to use SQL for Math and Subquering

Math & Subqueries
09:43

Learn to use the Group By in SQL

Using Group By
07:29
+ – PHP & MySQL
7 lectures 01:53:28

A short tutorial on PHP

PHP Fundamentals
20:59

Learn all about Template & MySQL connect

Template & MySQL Connect
19:03

Learn to display data using PHP

Select & Display With PHP
16:55

Insert data with PHP

Insert Data With PHP
29:20

Data Update and deletion using PHP

Update & Delete With PHP
22:58

Course Summary

Wrap up
03:49
Bonus Lecture: More Interesting Stuff, Offers and Discounts
00:24
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