PAC | Learn Database Design With MySQL (2018 EN)

Company: Packt Publishing
Author: Eduonix
Full Title: Learn Database Design With MySQL
Year: 2018
Language: English
Genre: Educational: Application development
Skill Level: -
Price: €39.99
-
Files: MP4 (+ Code Files)
Time: 06:14:44
Video: AVC, 1280 x 720 (1.778) at 15.000 fps, 300 kbps
Audio: AAC at 120 Kbps, 2 channels, 48.0 KHz



A Complete Course to Master Database Design using MySQL.

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. 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 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.

Style and Approach:
This course will teach you the nuances of proper database design. It will teach you all the hidden tips and tricks and will ensure that you learn all the major concepts of a proper database design.


Learn:
✓ To Learn Database design Process
✓ To Learn Database Normalization
✓ To Learn Database development using MySQL
✓ To Master SQL
✓ To Learn to use PHP with MySQL

Features:
✓ Good course for starting up & covers quickly the important topics and shows for beginners what MySQL can be used for.


Lessons:
1. Introduction
01. Intro
2. Introduction
02. What is a Database?
03. MySQL Overview
04. Understanding Storage Engines
05. Understanding Data Types
3. Getting Started With MySQL
06. Windows Installation
07. Linux Installation
08. Environment Setup With Xampp
09. PHPMyAdmin
10. MySQL Workbench Setup
4. Planning & Design
11. Principles & Normalization
12. Database Design Process
13. Map Out Structure
5. Creating A Database
14. Create Tables & Columns
15. Importing & Exporting
16. Relations & Foriegn Keys
17. Junction Tables
6. SQL Fundamentals
18. Command Line & Inserting Data
19. Basic Select Queries
20. Updating & Deleting Data
21. Aliases & Joins
7. Advanced SQL
22. Union, Concat & Count
23. Using the IN Clause
24. Math & Subqueries
25. Using Group By
8. PHP & MySQL
26. PHP Fundamentals
27. Template & MySQL Connect
28. Select & Display With PHP
29. Insert Data With PHP
30. Update & Delete With PHP
31. Wrap up

Our members see more. Join us!
-------------
Our members see more. Join us!