Learn Database Design with MySQL

6h 14m 51s
English
Paid

Course description

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

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 31 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: Intro

All Course Lessons (31)

#Lesson TitleDurationAccess
1
Intro Demo
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

Unlock unlimited learning

Get instant access to all 30 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

SQL for Data Engineers

SQL for Data Engineers

Sources: Andreas Kretz
SQL is the foundation for working with relational databases. And if you are planning to work in the field of Data Engineering, knowing SQL is not just a...
1 hour 51 minutes
Mastery with SQL

Mastery with SQL

Sources: masterywithsql.com
Packed with high quality videos, practical examples, and interesting and challenging exercises to practice what you've learned. The course is broad and deep, taking you from beg...
9 hours 15 minutes 2 seconds
Master SQL Queries From Basic to Advanced

Master SQL Queries From Basic to Advanced

Sources: Kamran Ahmed
The course is designed for developers, data analysts, and anyone working with databases. It covers the entire range of SQL queries - from basics to advanced...
Database Design & Implementation

Database Design & Implementation

Sources: Amigoscode (Nelson Djalo)
Backend starts from Your Database. When you have a solid database design coding is easy. In this course you will learn how to design databases for your backend applications. You...
2 hours 7 minutes 49 seconds