Course

In Kolkata

Rs 10001-20000

Description

  • Type

    Course

  • Level

    Beginner

  • Location

    Kolkata

  • Class hours

    2h

  • Duration

    16 Weeks

  • Start date

    Different dates available

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, Nokia.com, 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.

Facilities

Location

Start date

Kolkata (West Bengal)
See map
96L, S.P. Mukherjee Road, 2nd Floor, Hazra More, Kolkata, 700026

Start date

Different dates availableEnrolment now open

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • 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

FACULTY

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
Functions
  • 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

MYSQL

Rs 10001-20000