Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
6 Hour(s) 15 Minute(s)
Language
English
Rating
Course Overview
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 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.
Course Content
- 8 section(s)
- 32 lecture(s)
- Section 1 Introduction
- Section 2 Introduction
- Section 3 Getting Started With MySQL
- Section 4 Planning & Design
- Section 5 Creating A Database
- Section 6 SQL Fundamentals
- Section 7 Advanced SQL
- Section 8 PHP & MySQL
What You’ll 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
Reviews
-
OOntlametse Tsumake
It is a good match for me because i develop applications based on the sql database
-
PPhillipa
This is a great course. It was a definite help for setting up my own database and online CRM. The points where the educator makes errors is also very informative as it highlights where errors can easily occur and a fix to the error is given. Didnt give 5 stars as update on information of mysqli is needed.
-
MMuhammadu Rawshan
Really awesome!!! but I guess, he didn't mention the video for delete customers:)
-
LLearnZ
Too basic!!!!! not even intermediate!! 1. Better to teach all by codes on command line. Not use any UI client. 2. More focus on how to design a database not only the basic operation which can easily learn from wiki
