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

Effective Database Design

Effective Database Design

Sources: Ben Brumm
The course "Effective Database Design" will provide you with an action plan, examples, and instructions for creating a well-designed database.
1 hour 3 minutes 56 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
Make a Google search engine clone: JavaScript PHP and MySQL

Make a Google search engine clone: JavaScript PHP and MySQL

Sources: udemy
Do you want to become an expert in JavaScript, PHP and MySQL?Do you want to build a real search engine just like Google? If so, you’re in the right place!
5 hours 47 minutes 11 seconds
SQL Injections Unlocked - SQLi Web Attacks

SQL Injections Unlocked - SQLi Web Attacks

Sources: udemy
If you want to Master Web Hacking, The fastest way to become an expert would be to study each vulnerability in deep. SQL injection is one of the top 10 vulnerab
4 hours 59 minutes 9 seconds
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