MySQL Training Syllabus

MySQL Course Content

·       A brief history of databases

·       Relational database concepts

·       Database tables

·       MySQL Data types

·       Introduction to P HPMyadmin

·       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

Theory, Terminology and Concepts

·       Client/Server Concepts

·       Database and Database Objects

Data Definition using SQL

·       Databases

·       Data Types

·       Tables

·       Constraints and Indexes

·       Views

Basic Data Manipulation using SQL

·       Recurring SQL Constructs

·       Adding data

·       Modifying data

·       Removing data

·       Searching data

Advanced Data Manipulation using SQL

·       Expressions

·       Grouping and Aggregate Functions

·       Joining Tables


·       Transaction Concepts

·       SQL for working with Transaction


·       Tools for Import/Export

·       SQL for Import/Export

robertsonjohn0011 • 2019 Aug 13

Be the first to comment.