Duration :3 Months
Study Type : Full Time
Classes :On Projector
100% placement assistance
Job Oriented Training
Step by step training
Daily assignments
Go through the Course Module brochure
MySQL Core and SQL Basics
- MYSQL Server Basics
- Database models
- ER Model Overview
- Data types
- Understanding Test Database
- 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
- Security - User Management Basics
Routines
- Programming Basics
- Programming Concepts in PLSQL
- Cursors / Nested Cursors
- Functions / Procedures
- Interoperability between Functions & Procedures
- Query Optimization Techniques
- Project / Case Study
