Home >> MYSQL Training Centre

 Course Details

MYSQL

A database is a separate application that stores a collection of data. Each database has one or more distinct APIs for creating, accessing, managing, searching, and replicating the data it holds.Other kinds of data stores can be used, such as files on the file system or large hash tables in memory but data fetching and writing would not be so fast and easy with those type of systems.MySQL is a fast, easy-to-use RDBMS used being used for many small and big businesses. MySQL is developed, marketed, and supported by MySQL AB, which is a Swedish company. MySQL is becoming so popular because of many good reasons.

• Module 1: Introduction to MySQL
  • Understanding MySQL
  • History of MySQL
  • Other Database Systems
  • SQL BASICS
  • Installing MySQL

• Module 2: Managing Database
  • Design a Database
  • Create a Database
  • Select a Database
  • Create a Simple table

• Module 3: Relational Model
  • One-To-Many
  • Many-To-Many
  • Normal Forms
  • Query Languages

• Module 4: Modify Tables
  • Using ALTER TABLE Queries
  • Add a Column
  • Add an Index
  • Add a Primary Key

• Module 5: Add and Delete Data
  • DATA TYPES
  • Using INSERT and DELETE Queries
  • Add a Row to a Table
  • Insert Rows from another table
  • Delete a Specific Row

• Module 6 : Update Data in Tables
  • Using UPDATE Queries
  • Modify Rows
  • Update Columns

• Module 7: Using Select Queries
  • SELECT
  • WHERE
  • LIMIT
  • ORDER BY
  • GROUP BY
  • JOIN

• Module 8: Using MySQL Functions
  • Math Functions
  • Compare String values
  • Work with Dates

• Module 9: Import and Export Data
  • Import and Export Tools
  • Export with SELECT
  • Backup Data
  • Manage Backups

• Module 10: Using MySQL with PHP
  • Intro to PHP
  • Test Installation
  • Manage Data
  • Insert Records
  • Keeping sessions

• Module 11: Advanced MySql Topics
  • DB Engines
  • Stored Procedures
  • MySql Injection
  • MySql Date & Time