MySQL & Live Project Training

Arraysoft Academy is one of the pioneer education institute since 2004. We have 16 years of experience in the field of IT training. We have trained large number of students of diploma and degree engineering as well as we also provides trainning for basic computer courses. 

MySQL is the most popular Open Source Relational SQL Database Management System. MySQL is one of the best RDBMS being used for developing various web-based software applications. We at ArraySoft Computer Academy have expertise in varies field and provide Help . We offer offline material for better performance .

SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems.

Course Content:

• MySQL Functions :
  • MySQL Functions listed alphabetically
  • MySQL Functions listed by category
  • MySQL Keys, Constraints and Indexes :
  • Create, alter, and drop primary keys
  • Create, add, and drop unique constraints
  • Create, drop and rename indexes (performance tuning)
• MySQL Privileges and Passwords :
  • Grant or revoke privileges
  • Change a user's password
• MySQL Programming :
  • Create and drop functions
  • Create and drop procedures
  • Create and drop triggers
  • Create cursors within stored programs
  • String, number, date, time, boolean literals
  • LOOP statement, IF-THEN-ELSE and others
  • Create a sequence of numbers using the AUTO_INCREMENT attribute
  • How to create comments within your SQL statement
• MySQL Database :
  • Introduction to SQL
  • Connecting to the MYSQL
  • Selecting a database
  • Finding out about errors
  • Inserting data
  • Checking for NULL
  • WHERE and ORDER BY
  • AND , OR
  • Order of Evaluation
  • Sub queries, Joins and Unions
  • Sub queries
  • Joins
  • Table Aliases
  • Multi-table Joins
  • Outer Joins
  • Unions
  • UNION ALL
  • UNION Rules
  • Inserting, Updating and Deleting Records
  • INSERT , UPDATE , DELETE
• Live Project Training :
  • Create Live Project Based on MySQL.