Learn Database Design with MySQL

6h 14m 51s
English
Paid

Good course for starting up & covers quickly the important topics and shows for beginners what MySQL can be used for. 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 database technology but will also have to master database design process and normalization.

Read more about the course

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 a basic introduction to data storage and will follow it up with storage engines and other tools. You will also learn about MySQL installation and the database design process. Database design, normalization, structure mapping, keys, and junction tables come next. The next units will teach you SQL and Advance SQL and you will also learn to use PHP with MySQL. This complete database course will help you become a database design guru.

Watch Online Learn Database Design with MySQL

Join premium to watch
Go to premium
# Title Duration
1 Intro 03:33
2 MySQL overview 09:00
3 Understanding data types 07:41
4 Understanding storage engines 08:29
5 What is a database? 11:07
6 Environment setup with Xampp 07:12
7 Linux installation 04:11
8 MySQL Workbench setup 10:38
9 PHPMyAdmin 13:14
10 Windows installation 10:37
11 Database design process 05:18
12 Map out structure 14:58
13 Principles & normalization 10:58
14 Create tables & columns 12:23
15 Importing & exporting 05:16
16 Junction tables 04:46
17 Relations & foreign keys 13:15
18 Aliases & joins 18:39
19 Basic select queries 14:45
20 Command line & inserting data 28:58
21 Updating & deleting data 09:06
22 Math & subqueries 09:43
23 Union, concat & count 11:18
24 Using group by 07:29
25 Using the IN clause 09:12
26 Insert data with PHP 29:20
27 PHP fundamentals 21:00
28 Select & display with PHP 16:55
29 Template & MySQL connect 19:03
30 Update & delete with PHP 22:58
31 Wrap up 03:49

Similar courses to Learn Database Design with MySQL

PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours

PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hoursudemy

Category: Sql
Duration 67 hours 20 minutes 55 seconds
The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert

The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expertudemy

Category: Sql
Duration 36 hours 35 minutes 57 seconds
Complete SQL + Databases Bootcamp: Zero to Mastery

Complete SQL + Databases Bootcamp: Zero to Masteryzerotomastery.io

Category: Sql, Redis
Duration 24 hours 6 minutes 52 seconds
Node, SQL, & PostgreSQL - Mastering Backend Web Development

Node, SQL, & PostgreSQL - Mastering Backend Web Developmentudemy

Category: Sql, Node.js, Other (Backend)
Duration 4 hours 59 minutes 41 seconds
Ultimate Expert Guide: Mastering PostgreSQL Administration

Ultimate Expert Guide: Mastering PostgreSQL Administrationudemy

Category: Sql
Duration 10 hours 19 minutes 42 seconds
SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL

SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQLudemy

Category: Sql, Data processing and analysis
Duration 12 hours 32 minutes 7 seconds
Database Design & Implementation

Database Design & Implementationamigoscode (Nelson Djalo)

Category: Sql, Other (Backend)
Duration 2 hours 7 minutes 49 seconds
Complete SQL Mastery

Complete SQL Masterycodewithmosh (Mosh Hamedani)

Category: Sql
Duration 10 hours 47 minutes 7 seconds