MySQL Training for Developers
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
Leave Your Comments