MySQL Training for Developers at Bangalore by Aghreni Technologies

The training is intended for programmers to learn basic and advanced concepts of Relational Databases using MySQL for building applications.

The program enables programmers to understand the Basics of Relational databases, Client/Server concepts, Data types, Creating databases, Basic Select statement, Selecting data from multiple tables using JOIN, Grouping and Sorting output, Sub-queries, String, temporal and Numeric functions, Creating, altering and dropping tables, Creating, altering and dropping Views, Primary and foreign key constraints, Creating and dropping indexes, Inserting, updating and deleting data, Controlling
access and SQL performance tuning.



Course Outline:

Day 1 : Introduction to Relational databases, Client/Server
concepts, Data types, Creating databases

Day 2 : Basic Select statement, Selecting data from multiple tables
using JOIN, Grouping and Sorting output

Day 3 : Sub-queries, String, temporal and Numeric functions,
Creating, altering and dropping tables

Day 4 : Creating, altering and dropping Views, Primary and foreign
key constraints, Creating and dropping indexes

Day 5 : Inserting, updating and deleting data, Controlling access,
Performance tuning



Instructor Profile:
Anil Menon, with 10 years of professional experience, has a Bachelor of Science from Bharatiyar University. He started working with open source technologies in 1999. He has strong architecting and project management skills. With exceptional technology focus, he has a expertise provide optimum solutions to clients and to manage large development and quality assurance teams. Anil is passionate about long distance biking.



Contact:

Aghreni Technologies
335 Double Road
Indiranagar 1st Stage
Bangalore – 560038, INDIA
Ph: +91 80 25216514
Email: info@aghreni.com
Web: www.aghreni.com