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.
Learn Database Design with MySQL
6h 14m 51s
English
Paid
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.
About the Author: oreillymedia
O’Reilly’s mission is to change the world by sharing the knowledge of innovators. For over 40 years, we’ve inspired companies and individuals to do new things—and do things better—by providing them with the skills and understanding that are necessary for success.
At the heart of our business is a unique network of experts and innovators who share their knowledge through us. O’Reilly online learning offers exclusive live training, interactive learning, a certification experience, books, videos, and more, making it easier for our customers to develop the expertise they need to get ahead. And our books have been heralded for decades as the definitive place to learn about the technologies that are shaping the future. Everything we do is to help professionals from a variety of fields learn best practices and discover emerging trends that will shape the future of the tech industry.
Watch Online 31 lessons
0:00
/ #1: Intro
All Course Lessons (31)
| # | Lesson Title | Duration | Access |
|---|---|---|---|
| 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