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.
Introduction to Data storage
Introduction to MySQL description
Learn all about storage engines in this lecture.
Data types and storage
Windows Installation of MySQL
Installing MySQL in Linux
Setting up the environment using Xampp
PHPMy Admin and its use.
Know all about MySQL Workbench
Learn all about Normalization of Database
The Database design process.
Learn to Map out the Schema
Creating Tables and Columns in a Database
Learn to import and export the database
Learn to create relationships
The Junction tables in database
Data Insertion using SQL
The basic select queries in SQL
Updating and Deletion of Data using SQL
Aliases and Joins using SQL in database
Master the SQL to union, concat and count
Learn all out the In clause
Learn to use SQL for Math and Subquering
Learn to use the Group By in SQL
A short tutorial on PHP
Learn all about Template & MySQL connect
Learn to display data using PHP
Insert data with PHP
Data Update and deletion using PHP
Eduonix creates and distributes high quality technology training content. Our team of industry professionals have been training manpower for more than a decade. We aim to teach technology the way it is used in industry and professional world. We have professional team of trainers for technologies ranging from Mobility, Web to Enterprise and Database and Server Administration.