Website Designed and Developed By Panacea Infotech Pvt. Ltd.
Courses Offered :: PHP :: MySQL :: .NET

PIIT's MySQL Training program:
Why MySQL Training?

When our consultants are asked to recommend an RDBMS, their stock response is to ask: “What do you want the database to do?”, “What skills have you already got?” “What database systems have you already committed resources and data to?”
We are most likely to recommend an investment in MySQL training, if you are resourcing a new project, especially one with a web focus, because supporting database-driven websites is one of the things that MySQL does best. MySQL is probably the world’s most popular website backend (on all major operating systems, Windows, Linux, Unix, Mac, etc), because it is stunningly fast at reading data, i.e. the thing that data-driven websites do most of the time. The price isn’t bad either!
MySQL is also a pretty good choice for generic database applications in small and medium sized business (SME/SMB) environments, providing power and reliability beyond the likes of MS Access, and price/performance advantages over unnecessarily heavy duty RDBMSes like Oracle, DB2 and SQL Server.
MySQL is not currently the best choice for massively complex data centre operations in very large enterprises (e.g. processing hundreds of millions of records in highly interdependent systems), but it is rapidly acquiring many of the features which have previously excluded it from this domain (e.g. transactions, sub-selects, triggers, etc). Although most of these features appear in the latest MySQL development releases, we are not yet confident enough of their maturity to recommend them for the largest business-critical applications.

Synopsis

The MySQL database has become the world's leading open source database. With consistent fast performance, high reliability and ease of use it is the open source database of choice for many organizations. This introductory course covers all the basics of MySQL.

Objectives
By the end of the program, delegates will be able to:
::
Understand MySQL Client/Server concepts
::
Use advanced features of the MySQL Client
::
Understand various types of Connector
::
Use advanced data types
::
Manage databases, tables, indexes, views
::
Write complex SQL query statements
::
Use advanced SQL expressions and functions
::
Modify, Import and export data
::
Perform complex joins and sub queries
::
Use variables and prepared statements
::
Create and use stored routines
::
Create and use triggers
::
Obtain database metadata
::
Debug MySQL applications
::
Understand Basic Optimizations
 Suitable For
MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course
Course Prerequisites
::
 A working knowledge of any RDBMS is required.
Contents
1.
Client/Server Concepts and Architecture
2.
The MySQL Client Program and Connectors
3.
Data Types including Bit and Binary
4.
Managing Databases, Tables, Indexes and Views
5.
Retrieving and Aggregating Data
6.
Advanced SQL Expressions and Functions
7.
Modifying, Importing and Exporting Data
8.
Complex Joins and Sub queries
9.
User Variable Syntax and Properties
10.
Prepared Statements
11.
Stored Routine Definition
12.
Creating, Dropping and Altering Stored Routines
13.
Invoking Stored Routines
14.
Trigger Concepts, Creation and Use
15.
Privileges for Stored Routines and Triggers
16.
 Obtaining Database Metadata
17.
Debugging MySQL Applications
18.
Optimization Principles
19.
Storage Engines
20.
Procedures and Functions
^ Top

Website Designed and Developed By Panacea Infotech Pvt. Ltd.                                                    © All Rights Reserved 2007