Learn Database Design with MySQL

A Complete Course to Master Database Design using MySQL

4.85 (4113 reviews)
Udemy
platform
English
language
Databases
category
76,607
students
6.5 hours
content
Dec 2018
last update
$44.99
regular price

What you will 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

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.

Content

Introduction

intro

Introduction

What is a Database
MySQL Overview
Understanding Storage Engines
Understanding Data Types

Getting Started With MySQL

Windows Installation
Linux Installation
Environment Setup With Xampp
PHPMyAdmin
MySQL Workbench Setup

Planning & Design

Principles & Normalization
Database Design Process
Map Out Structure

Creating A Database

Create Tables & Columns
Importing & Exporting
Relations & Foriegn Keys
Junction Tables

SQL Fundamentals

Command Line & Inserting Data
Basic Select Queries
Updating & Deleting Data
Aliases & Joins

Advanced SQL

Union, Concat & Count
Using The IN Clause
Math & Subqueries
Using Group By

PHP & MySQL

PHP Fundamentals
Template & MySQL Connect
Select & Display With PHP
Insert Data With PHP
Update & Delete With PHP
Wrap up
Bonus Lecture: More Interesting Stuff, Offers and Discounts

Screenshots

Learn Database Design with MySQL - Screenshot_01Learn Database Design with MySQL - Screenshot_02Learn Database Design with MySQL - Screenshot_03Learn Database Design with MySQL - Screenshot_04

Reviews

Luis
January 23, 2023
did not tell in which environment will talk about it, I was expecting to learn mysql through CLI on linux environments.
Andrew
June 24, 2022
Project files do not work and needs to be updated. its been many years since version updated have been added
Terry
March 21, 2022
There is a lecture where you spoke about normalization, and one of the description of the characteristic of a NF was "unprimed columns should be linked to a PK". I think your explanation is mostly good, but this particular case it would be more helpful to just say what an unprimed is using a few words or just with one sentence.
Annette
November 17, 2020
I have some SQL experience, but I really appreciate the introduction to the various tools that could be used. I also appreciate when the queries do not work and he debugs why. Great examples of real life.
Anand
January 12, 2018
As a DBA, i was expecting more from this course. But, I guess its my mistake. The course is for anyone trying to learn MySQL for the first time. I already knew MySQL.
LearnZ
January 11, 2018
Too basic!!!!! not even intermediate!! 1. Better to teach all by codes on command line. Not use any UI client. 2. More focus on how to design a database not only the basic operation which can easily learn from wiki
Roman
January 10, 2018
Nice course on basics of MySQL and PHP, definitely applicable to the real world experiences. Good job!
Jeff
January 8, 2018
I liked his short, simple explanations and examples. He started from the ground up and gave real-world examples and how to solve them. The tools were a bit outdated and I needed to figure out some stuff on my own when screens didn't match up. There were many mistakes made and the instructor worked through them in real-time when he could. A couple of them were fine because it came across as honest and we could see his thought process on how to fix the errors, but sometimes it seemed to waste too much time and I was itching to just get on with the video.
Chris
January 5, 2018
I already understand so much more about databases than I did with other courses and even at University which can't come close to explaining it like the lecturer does in this course. This course actually shows you how the relationships work, and properly shows you the coding behind it. I've seen a few courses on Udemy which just talk about it, and to be honest it doesn't help whatsoever. Just using MYSQL Workbench to make little connection lines without seeing what it actually does in terms of the relationships is not good for someone learning databases from the start. As for this course though, it really is great, and it really helps you understand relationships which I think is the most important thing to learn in order to wrap your mind around dynamic data in web applications. I'm at University and they use ridiculous terminology without explaining it, which puts you completely off database design. But with a course like this, it's priceless. If you're like me and need to understand database design using practical work to show it working, then this is the course for you, it's a no-brainer.
Jay
December 20, 2017
The course material starts by establishing a good foundation - definitions, some comparisons, etc - and I am able to easily understand the instructor.
Marcus
December 12, 2017
This is a very basic crash course. While useful, it's out of date, and far from professionally produced.
Theodosis
November 30, 2017
The lesson taught me an easy way to create dynamic web applications using mySQL and PHP. It is a great starting point for people who first start developing full-stack web applications and for those who are more advanced to undestand the fundamentals better.
Jean
November 20, 2017
took me too long to set up phpmyadmin because the instructions weren't too clear for mac... also, on this last video, the zip code cannot be the primary id for the address of the customer because there will be several customers who live in the same zip code, and their addresses will be different... just not quite getting what the course promised from this...
Yik
November 20, 2017
The course is good for beginners. The instructor explains clearly so I am easy to get a clear understanding of MYSQL.
Nicholas
November 17, 2017
A very informative course that gives a very thorough grounding in the use of MySQL in database design.

Charts

Price

Learn Database Design with MySQL - Price chart

Rating

Learn Database Design with MySQL - Ratings chart

Enrollment distribution

Learn Database Design with MySQL - Distribution chart
172572
udemy ID
2/25/2014
course created date
7/20/2019
course indexed date
Bot
course submited by