Software Development / Big Data & Analytics

Learn Database Design with MySQL From Scratch

A Complete Course to Master Database Design using 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

Full details

Curriculum

  • Course Intro
    Course Intro
    3:34
    What is a Database
    Introduction to Data storage
    11:08
    MySQL Overview
    Introduction to MySQL description
    9:00
    MySQL Storage Engines
    Learn all about storage engines in this lecture.
    8:30
    MySQL Data Types
    Data types and storage
    7:42
    Chapter 1 - Questions
  • Getting Started With MySQL
    MySQL Windows Installation
    Windows Installation of MySQL
    10:38
    MySQL Linux Installation
    Installing MySQL in Linux
    4:11
    Environment Setup With Xampp
    Setting up the environment using Xampp
    7:12
    Using PHPMyAdmin
    PHPMy Admin and its use
    13:15
    MySQL Workbench
    Know all about MySQL Workbench
    10:39
    Chapter 2 - Program Files
    Chapter 2 - Questions
  • Planning & Design
    Design Principles and Normalization
    Learn all about normalization of databases
    10:59
    Database Design Process
    The database design process
    5:18
    Mapping Out Our Schema
    Learn to map out the schema
    14:59
    Chapter 3 - Program Files
    Chapter 3 - Questions
  • Creating A Database
    Create Tables and Columns
    Creating tables and columns in a database
    12:24
    Importing and Exporting
    Learn to import and export the database
    5:17
    Relations & Foreign Keys
    Learn to create relationships
    13:16
    Junction Tables
    The junction tables in database
    4:47
    Chapter 4 - Program Files
    Chapter 4 - Questions
  • SQL Fundamentals
    Command Line and Insert Queries
    Data insertion using SQL
    28:59
    Simple Select Queries
    The basic select queries in SQL
    14:46
    Update and Delete Data
    Updating and deleting data using SQL
    9:07
    Aliases and Joins
    Aliases and joins using SQL in database
    18:40
    Chapter 5 - Program Files
    Chapter 5 - Questions
  • Advanced SQL
    Union, Concat and Count
    Master the SQL to union, concat and count
    11:19
    Using The IN Clause
    Learn all out the In clause
    9:12
    Math and Subqueries
    Learn to use SQL for math and subquerying
    9:44
    Using Group By
    Learn to use 'Group By' in SQL
    7:30
    Chapter 6 - Program Files
    Chapter 6 - Questions
  • PHP & MySQL
    PHP Fundamentals
    A short tutorial on PHP
    21:00
    Template and Database Connect
    Learn all about template & MySQL connect
    19:04
    Select & Display Using PHP
    Learn to display data using PHP
    16:56
    Insert Data With PHP
    Insert data with PHP
    29:21
    Update & Delete With PHP
    Data update and deletion using PHP
    22:59
    Chapter 7 - Program Files
    Chapter 7 - Questions
  • Course Summary
    Course Summary
    3:50

Skills

  • Database
  • Database Management
  • MySQL

Similar Courses

More Courses by this Instructor