Enquiry
Courses Images

Course Details

My SQL is an open-source relational database management system. It deals with the development of web applications.

We provide the best My SQL Training in Chennai, where one can get in-depth knowledge on MYSQL Server, Query Design & Functions, Database Operations, Data Sorting, Procedures and PLSQL.

Get certification on My SQL in 45 days. We offer one-on-one training sessions by experts. Both online & classroom training is available. Learn on your flexible timings.

Lessons 1: Basics

  • MYSQL Server Basics
  • Database models
  • ER Model Overview
  • Data types
  • Understanding Test Database
  • Basics Queries
  • Removing Duplicates
  • Data Filters Using Operators
  • Data Sorting
  • Grouping
  • Joins
  • Arithmetic and String functions
  • Advanced Functions
  • SET Operators
  • Creating Complex Queries
  • DML operations - Insert, Update & Delete
  • TSQL
  • Database Objects - Create, Alter and Drop Tables
  • Views
  • Complex Views
  • Indexes
  • Advanced Index Concepts
  • How Data is Stored
  • Security - User Management
  • PLSQL Basics
  • Programming Concepts in PLSQL
  • Cursors
  • Nested Cursors
  • Functions & Procedures
  • Functions & Procedures
  • Interoperability between Functions & Procedures
  • Query Optimization Techniques

Reviews

CLIENTS

Infodot WhatsApp