Learn Database Design with MySQL

Learn Database Design with MySQL, available at $44.99, has an average rating of 4.45, with 32 lectures, based on 4121 reviews, and has 76623 subscribers.

You will learn about 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 This course is ideal for individuals who are Web Developers and Database designers It is particularly useful for Web Developers and Database designers.

Enroll now: Learn Database Design with MySQL

Summary

Title: Learn Database Design with MySQL

Price: $44.99

Average Rating: 4.45

Number of Lectures: 32

Number of Published Lectures: 32

Number of Curriculum Items: 32

Number of Published Curriculum Objects: 32

Original Price: $29.99

Quality Status: approved

Status: Live

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

Who Should Attend

Web Developers and Database designers

Target Audiences

Web Developers and Database designers

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: intro

Chapter 2: Introduction

Lecture 1: What is a Database

Lecture 2: MySQL Overview

Lecture 3: Understanding Storage Engines

Lecture 4: Understanding Data Types

Chapter 3: Getting Started With MySQL

Lecture 1: Windows Installation

Lecture 2: Linux Installation

Lecture 3: Environment Setup With Xampp

Lecture 4: PHPMyAdmin

Lecture 5: MySQL Workbench Setup

Chapter 4: Planning & Design

Lecture 1: Principles & Normalization

Lecture 2: Database Design Process

Lecture 3: Map Out Structure

Chapter 5: Creating A Database

Lecture 1: Create Tables & Columns

Lecture 2: Importing & Exporting

Lecture 3: Relations & Foriegn Keys

Lecture 4: Junction Tables

Chapter 6: SQL Fundamentals

Lecture 1: Command Line & Inserting Data

Lecture 2: Basic Select Queries

Lecture 3: Updating & Deleting Data

Lecture 4: Aliases & Joins

Chapter 7: Advanced SQL

Lecture 1: Union, Concat & Count

Lecture 2: Using The IN Clause

Lecture 3: Math & Subqueries

Lecture 4: Using Group By

Chapter 8: PHP & MySQL

Lecture 1: PHP Fundamentals

Lecture 2: Template & MySQL Connect

Lecture 3: Select & Display With PHP

Lecture 4: Insert Data With PHP

Lecture 5: Update & Delete With PHP

Lecture 6: Wrap up

Lecture 7: Bonus Lecture: More Interesting Stuff, Offers and Discounts

Instructors

Eduonix Learning Solutions
1+ Million Students Worldwide | 200+ Courses

Eduonix-Tech .

Rating Distribution

1 stars: 65 votes

2 stars: 145 votes

3 stars: 660 votes

4 stars: 1471 votes

5 stars: 1780 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!