Learn Database Design with MySQL
4.3 (2,761 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
63,112 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn Database Design with MySQL to your Wishlist.

Add to Wishlist

Learn Database Design with MySQL

A Complete Course to Master Database Design using MySQL
4.3 (2,761 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
63,112 students enrolled
Last updated 2/2016
English
English
Price: Free
Includes:
  • 6.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • Web Developers and Database designers
Students Who Viewed This Course Also Viewed
Curriculum For This Course
31 Lectures
06:14:45
+
Introduction
1 Lecture 03:33
intro
03:33
+
Introduction
4 Lectures 36:16

Introduction to Data storage

What is a Database
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
6 Lectures 01:53:04

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
About the Instructor
Eduonix Learning Solutions
4.2 Average rating
47,797 Reviews
781,559 Students
189 Courses
1+ Million Students Worldwide | 200+ Courses

Eduonix creates and distributes high quality technology training content. Our team of industry professionals have been training manpower for more than a decade. We aim to teach technology the way it is used in industry and professional world. We have professional team of trainers for technologies ranging from Mobility, Web to Enterprise and Database and Server Administration.

Eduonix-Tech .
4.3 Average rating
45,829 Reviews
759,266 Students
146 Courses