Learn Database Design Using MYSQL
Course
Online
*Indicative price
Original amount in INR:
₹ 2,700
Description
-
Type
Course
-
Level
Intermediate
-
Methodology
Online
-
Duration
Flexible
-
Start date
Different dates available
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.
Facilities
Location
Start date
Start date
About this course
To Learn Database Principles
Web Developer
Database Administrator
Database designer
Understanding of Basic web terminology and experience in HTML.
You should also have access to internet and basic text editor.
Reviews
Subjects
- Install
- Design
- Database training
- SQL
- Database
- MySQL
- PHP
- Database Design
- Planning
- Operation Management
- Environment Setup
- Linux installation
- Database Principles
- Windows Installation
- Importing and Exporting
- SQL Fundamentals
- Advance SQL
- PHP fundamentals
Teachers and trainers (1)
Name Name
Teacher
Course programme
Section 1 – Introduction
- What is a Database – Learn what a relational database is
- MySQL Over View- Learn the basics of MySQL
- Learn all about Storage Engines – Get the basics of Storage engine
- Understanding Data types – Learn the data types for Database design
Section 2 – Getting Started with MYSQL
- Windows Installation – learn to install on windows
- Linux Install – Learn to install on Linux
- Environment Setup with Xampp
- PHPMyAdmin – get to know all about PHPMyAdmin
- MySQL Workbench setup – MySQL workbench setup- Learn to setup mySQL workbench
Section 3 – Planning and Design
- Principles and Normalization – Learn all about table normalization
- Database design process – Learn the database design process
- Map out structure - Learn to create a Map out structure
Section 4 – Creating a Database
- Create Tables and Columns – learn to create tables in a Database
- Importing and Exporting – Learn to import and export databases
- Relations and foreign keys – Learn to make the database work with keys
- Lecture 16 – Junction tables – Learn all about Junction tables
Section 5 – SQL Fundamentals
- Command Line and inserting data – Learn to use command line to insert data
- Basic Select Queries – Learn the basic operations in SQL
- Updating and Deleting Data – Basic SQL continued
- Aliases and Joins – Learn all about Aliases and Joins
Section 6 – Advance SQL
- Union, Concat and count – Learn the advance commands for union and concatenation
- Using the IN clause – Learn to use IN clause in SQL
- Math and Sub queries – Learn to use maths in SQL
- Using Group By – learn to use the SQL Group By Statements
Section 7 – PHP and MySQL
- PHP fundamentals – Learn basics of PHP
- Template & MySQL Connect – Learn to use templates
- Select and Display with PHP – Learn to use PHP to display content from DB
- Insert Data with PHP – Learn to use PHP for inserting Data
- Update and Delete with PHP – Learn the update and Delete operation with PHP
- Course summary
Additional information
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
Learn Database Design Using MYSQL
*Indicative price
Original amount in INR:
₹ 2,700