Versicle Institute of Technology
In Kolkata

Compare this course with other similar courses
See all

Important information

  • Course
  • Beginner
  • Kolkata
  • 2 hours of class
  • Duration:
    16 Weeks
  • When:

MySQL database is the world's most popular open source database. Its tools make SLAs speedy and simple to manage database performance, accessibility, diagnostics, alteration, configuration and releases. With MySQL's high performance, high reliability and ease of use management there is no need left to deal with tedious, manual tasks.

My SQL has ample range of database tools, support, guidance and consulting services so that it can be successfully used by a person new to database technology or by an experienced developer or by a DBA. It runs as a server providing multi-user access to a number of databases. MySQL management makes software, business-services and end-user management significantly simpler. It powers 'High-Volume Websites', 'Business-Critical Systems' and 'Packaged Softwares'.

MySQL is used in many high-profile, large-scale World Wide Web products that is in some of the most frequently visited websites on the Internet including Flickr,, YouTube, Facebook, Google, Adobe, Alcatel Lucent and Zappos. These world's largest and fastest-growing organizations rely on MySQL to save time and money. It is the best choice for a new generation of applications built on the LAMP stack.

Some features of MySQL management that makes it superior over others includes 'Multiple storage engines', 'Native storage engines', 'Community-developed storage engines' and 'Custom storage engines'. Also it commits grouping, gathering multiple transactions from multiple connections together to increase the number of commits per second.

Important information

Where and when

Starts Location Timetable
96L, S.P. Mukherjee Road, 2nd Floor, Hazra More, Kolkata, 700026, West Bengal, India
See map

What you'll learn on the course

Features and Benefits of MySQL
SQL Language
Creating a Database
The INSERT Command
Categories of Sub queries
Exporting Data
Delete an Entire Database
Indexes and Constraints

Teachers and trainers (1)

Versicle Institute TechnoloGY
Versicle Institute TechnoloGY

Course programme

Course OutlineIntroduction
  • Features and Benefits of MySQL
  • MySQL Architecture
  • Install and Start MySQL
Database Basics
  • Data Types
  • What is NULL?
  • SQL Language
  • Keys
  • Normalization
Database Creation
  • Creating a Database
  • Creating a Table
Basic Queries
  • The SELECT Command
  • MySQL Query Browser
Delete/Modify Table row Data
  • The INSERT Command
  • The REPLACE Command
  • The UPDATE Statement
  • The DELETE Command
  • Simple Functions
  • Grouping With Functions
Joining Tables
  • Combining Multiple Tables
  • Inner Joins
  • Outer Joins
Sub queries
  • What is a Sub query?
  • Categories of Sub queries
  • Sub query Uses
Exporting/Importing Data
  • Exporting Data
  • Importing Data
Database Maintenance
  • Delete an Entire Database
  • Maintaining Tables and Columns
  • Indexes and Constraints
  • Data Manipulation

Compare this course with other similar courses
See all