![]()
Language
English
Course Features
• Over 30 lectures and 6 hours of content!
• 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
Target Audience
• Web Developers and Database designers
System Requirements
• Understanding of Basic web terminology and experience in HTML
Detailed Product Description
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 the Database technology but will have to master database design process and normalization.
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. 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 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 comes next.
The next units will teach you SQL and Advance SQL and you will also learn to use PHP with MySQL. So this complete Database course and will surely help you become a Database Design Guru.
Curriculum
|
SECTION 1: COURSE INTRO |
|
1 |
Course Intro |
|
SECTION 2: INTRODUCTION |
|
2 |
What is A Database |
|
3 |
MySQL Overview |
|
4 |
MySQL Storage Engines |
|
5 |
MySQL Data Types |
|
SECTION 3: GETTING STARTED WITH MYSQL |
|
6 |
MySQL Windows Installation |
|
7 |
MySQL Linux Installation |
|
8 |
Environment Setup With Xampp |
|
9 |
Using PHPMyAdmin |
|
10 |
MySQL Workbench |
|
SECTION 4: PLANNING & DESIGN |
|
11 |
Design Principles and Normalization |
|
12 |
Database Design Process |
|
13 |
Mapping Out Our Schema |
|
SECTION 5: CREATING A DATABASE |
|
14 |
Create Tables and Columns |
|
15 |
Importing and Exporting |
|
16 |
Creating Relationships |
|
17 |
Create a Junction Table |
|
SECTION 6: SQL FUNDAMENTALS |
|
18 |
Command Line and Insert Queries |
|
19 |
Simple Select Queries |
|
20 |
Update and Delete Data |
|
21 |
Aliases and Joins |
|
SECTION 7: ADVANCED SQL |
|
22 |
Union, Concat and Count |
|
23 |
Using The IN Clause |
|
24 |
Math and Subqueries |
|
25 |
Using Group By |
|
SECTION 8: PHP & MYSQL |
|
26 |
PHP Fundamentals |
|
27 |
Template and Database Connect |
|
28 |
Select & Display Using PHP |
|
29 |
Insert Data With PHP |
|
30 |
Update & Delete With PHP |
|
SECTION 9: WRAP UP |
|
31 |
Wrap Up |
Benefits
-
Over 30 lectures and 6 hours of content!
-
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
-
Be JavaScript Expert
USP of the product
Online, Downloadable, you can do it with your own pace at comfort of your home
Learn Everything, Anywhere, Anytime
India's Largest Online Education Marketplace
