IT Brain Training

8-2-619/2/1/1 Suite 304-A
Banjara Hills, Road No 11
Hyderabad, 500034
Ph:770-702-0398
E: info@itbraintraining.com

MySql

MySQL is a popular, open-source relational database management system owned by Oracle. While MySQL is often thought of as a component of the LAMP (Linux-Apache-MySQL-PHP) stack, MySQL runs on a wide array of other operating systems, including Windows, Solaris, and Mac OS X.

Overview:

  •  An Introduction to Relational Databases and SQL
  •  MySQL Workbench and Other Development Tools
  •  How to Retrieve Data From A Single Table
  •  How to Retrieve Data From Two Or More Tables
  •  How to Insert, Update, and Delete Data
  •  Coding Summary Queries
  •  Coding Subqueries
  •  The Data Types
  •  How to Use Functions
  •  How to Design A Database
  •  Creating Databases, Tables, and Indexes
  •  How to Create Views
  •  Language Skills For Writing Stored Programs
  •  Transactions and Locking
  •  How to Create Stored Procedures and Functions
  •  How to Create Triggers and Events
  •  Conclusion