Learn Database Design with MySQL

A Complete Course to Master Database Design using MySQL
4.2 (792 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.
17,219 students enrolled
Free
Start Learning Now
  • Lectures 31
  • Contents Video: 6.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2014 English

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

What are the requirements?

  • Understanding of Basic web terminology and experience in HTML

What am I going to get from this course?

  • 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

What is the target audience?

  • Web Developers and Database designers

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
intro
03:33
Section 2: Introduction
11:07

Introduction to Data storage

08:59

Introduction to MySQL description

08:29

Learn all about storage engines in this lecture.

07:41

Data types and storage

Section 3: Getting Started With MySQL
10:37

Windows Installation of MySQL

04:10

Installing MySQL in Linux

07:11

Setting up the environment using Xampp

13:14

PHPMy Admin and its use.

10:38

Know all about MySQL Workbench

Section 4: Planning & Design
10:58

Learn all about Normalization of Database

05:17

The Database design process.

14:58

Learn to Map out the Schema

Section 5: Creating A Database
12:23

Creating Tables and Columns in a Database

05:16

Learn to import and export the database

13:15

Learn to create relationships

04:46

The Junction tables in database

Section 6: SQL Fundamentals
28:58

Data Insertion using SQL

14:45

The basic select queries in SQL

09:06

Updating and Deletion of Data using SQL

18:39

Aliases and Joins using SQL in database

Section 7: Advanced SQL
11:18

Master the SQL to union, concat and count

09:11

Learn all out the In clause

09:43

Learn to use SQL for Math and Subquering

07:29

Learn to use the Group By in SQL

Section 8: PHP & MySQL
20:59

A short tutorial on PHP

19:03

Learn all about Template & MySQL connect

16:55

Learn to display data using PHP

29:20

Insert data with PHP

22:58

Data Update and deletion using PHP

03:49

Course Summary

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

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.

Instructor Biography

Ready to start learning?
Start Learning Now