MySQL Training

Duration: 2 Days

MySQL, being one of the most popular open source relational SQL database management systems is used for developing web-based software applications. This Training will help you in giving a quick start with MySQL and make you feel comfort with MySQL programming.

Prerequisites:

This training is meant for Corporates and the Industrialists, who are already aware of database especially, RDBMS and computer programming language.

Why learn MySQL Database?

MySQL is fast and easy to use RDBMS used for several small and big businesses. A few reasons we could attribute for its popularity are briefed as follows:

  • Released as an open source license and thus cost effective
  • Handles a large subset of functionality of the most expensive and powerful database packages
  • Uses standard form of the SQL data language
  • Works easily with many operating systems and languages namely PHP, Perl, C, C++, Java, and, etc.
  • Quick even for large data sets
  • Friendly to PHP, the most popular language for web development
  • Supports large database and is customizable

Highlights of the Two Days course:

  • MySQL: Introduction and Basic use
  • Connecting DB, Basic Operation (SELECT, INSERT, UPDATE and DELETE).
  • Practical use of Joins (Inner/Outer/Left/Right) and MySQL Function (IF/AVG/SUM etc.)
  • Advance MYSQL (Engine Type/Indexing/Batch) and SQL Injection Prevention

Method of Instruction:

his customized workshop program is designed in an intelligent way with interactive spirit which provides the participants an opportunity to design, create and script their own ideas. This workshop is intended to provide a practical approach of the acquired knowledge in a more efficient way using illustrations.

An Introduction to MySQL and its Uses

  • Revision of RDBMS Terminologies
  • An Introduction to MySQL
  • Installation of MySQL required version on different platforms
  • Post installation steps and its administration
  • MySQL in PHP environment

Connecting DB, Basic Operation (SELECT, INSERT, UPDATE and DELETE)

  • Create database by using MySQL admin [emphasis on using PHP script]
  • Drop database using MySQL admin
  • Selection of a particular database from the MySQL server
  • Data Types
  • Creation of tables
  • Insertion of data into MySQL table
  • Update the existing data
  • Delete a data from the MySQL table

Practical use of Joins (Inner/Outer/Left/Right) and MySQL Function (IF/AVG/SUM etc.)

  • An understanding of Joins in MySQL
  • A note on frequently used clause- Inner Join
  • Right & Left Joins and rare use of right Joins
  • Outer Join and its implementation in MySQL

An understanding of MySQL Function

  • Practical uses
  • A list of MySQL Functions
  • Explanation of each function with suitable illustrations

Advance MYSQL (Engine Type/Indexing/Batch) and SQL Injection Prevention

  • A note on Advanced MySQL
  • Understanding MySQL table types or storage engines
  • Understanding MySQL Index & Batch
  • Advanced MySQL queries; Altering tables; Backing up and restoring of MySQL database

SQL Injection Prevention

  • An introduction to SQL Injection with example
  • Serious SQL Injection attacks
  • Ways to prevent SQL Injection

Understanding the Aftermath:

  • Let’ s test what we have learnt for the day
  • What is MySQL
  • Reasons to use MySQL
  • When to use MySQL
  • MySQL with PHP script

Summary of the session:

  • What have you learnt?
  • Doubt Clearing Sessions
  • FAQs

Deliverables to the Participants:

  • The Participants will be receiving ‘Certificate of Completion’ from Orange Mantra
  • Project assistance and e-mail support after the workshop
test