Learn Database Design Using MYSQL

Course

Online

£ 25.61 VAT inc.

*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

Online

Start date

Different dates availableEnrolment now open

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

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

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

WHAT THE STUDENT GETS

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

£ 25.61 VAT inc.

*Indicative price

Original amount in INR:

₹ 2,700