MySQL Online Training

Home / MySQL Online Training

MySQL Online Training Course

Duration: 4 – 5 Weeks

MySQL Introduction
  • A brief history of databases
  • Relational database concepts
  • Database tables
  • MySQL Data types
  • SQL Commands – DDL,DML,DCL,DQL
  • Data Constraints
  • Clauses – Group by, Order by
  • Types of Joins
  • Set Operations
  • Aggregate Functions
  • Indexes & Sequences
  • Transaction Control
  • Queries
  • Sub Queries
  • Procedures & Functions
  • Working with Triggers
  • Working with Views
  • Introduction to PHPMyadmin
  • Creating and Checking Tables
  • Auto_increment and Primary Keys
  • Inserting Values into Tables
Mini Project with PHP and MySQL
  • Creation of database and required tables using PHPMyadmin
  • Creation of required templates, pages and managing site using IDEDreamweaver
  • Keeping structure, style and behavior of created pages apart
  • Creating login and logout pages for maintaining sessions
  • Creating forms to insert data into address book-personal details, image etc
  • Creating page to view the data from address book
  • Adding PHPScript for form validation
  • Adding server side validation
  • Adding mouse events like mouseout and mouseover dynamically
  • Creating page to edit or delete the records in the address book
  • Creating page to enable searching the address book
Introduction to Ajax
  • What is ajax
  • Connecting to server using PHPScript
  • Downloading data behind scenes
  • Modifying web pages on the fly
  • Creating an XMLHttpRequest Object in different browsers
  • Checking the XMLHttpRequest Object’s readyState property
  • Checking the XMLHttpRequest Object’s status property
  • Getting Your Data With the XMLHttpRequest Object
  • Problems creating an XMLHttpRequest Object
  • Fetching Text Data From the server
  • Using the text data received through XMLHttpRequest