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

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

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

Sources: udemy
Subqueries? Yes, Recursive CTEs? Yes, Server programming with SQL and PL/pgSQL, Stored Procedures? Yes, Window Functions? Yes indeed and much more... This compr
67 hours 20 minutes 55 seconds
Complete SQL + Databases Bootcamp: Zero to Mastery

Complete SQL + Databases Bootcamp: Zero to Mastery

Sources: zerotomastery.io
With so many online resources available, it can be paralyzing not only figuring out where to start but more importantly which courses will actually teach you the skills you need...
24 hours 6 minutes 52 seconds
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
Ludicrous Speed Postgres

Ludicrous Speed Postgres

Sources: Creston Jamison
This course is dedicated to optimizing PostgreSQL performance with a focus on proper schema design and efficient database usage. It is designed for those...
12 hours 27 minutes 44 seconds