MYSQL
MySQL is an open-source relational database management system. Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter My, and “SQL”, the abbreviation for Structured Query Language.
Basics
- MYSQL Server Basics
- Database models
- ER Model Overview
- Data types
- Understanding Test Database
- Basics Queries
- Removing Duplicates
- Data Filters Using Operators
- Data Sorting
Query Design & Functions
- Grouping
- Joins
- Arithmetic and String functions
- Advanced Functions
- SET Operators
- Creating Complex Queries
- DML operations – Insert, Update & Delete
- TSQL
Database Operations
- Database Objects – Create, Alter and Drop Tables
- Views
- Complex Views
- Indexes
- Advanced Index Concepts
- How Data is Stored
- Security – User Management
Procedures
- PLSQL Basics
- Programming Concepts in PLSQL
- Cursors
- Nested Cursors
- Functions
- Procedures
- Interoperability between Functions & Procedures
- Query Optimization Techniques
- Live Project
Book A Live Class to Know More
For any further queries and doubts, kindly fill in the details given below and hit send. You will get a callback within 24 hours.
ENQUIRE NOW OR CALL : +91-9318356685
Latest Updates
Menu
