|
Provided by: Aghreni Technologies Private Limited MYSQL TrainningComputer |
 |
Training
Provided by Aghreni Technologies Private Limited
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.
|
|
||||||||||
MYSQL Trainning
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
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
About The Training Provider: Aghreni Technologies Private Limited
Aghreni Technologies Private Limited - Aghreni Technologies is a startup company focused on building open source competencies in India for the needs of the industry.
Aghreni has several years of experience working in the open source software in products and services for world wide clients. Aghreni's professionals brings in years of experience working with latest tools and techniques in open source technologies.
Aghreni...
