NEXPERTS ACADEMY 

GET THE RIGHT CERTIFICATION

Live Online Training 
Classroom Training 

Online Training 

Learning is now made easy with the advancement of technology. In Nexperts Academy, we engage and collaborate with industry experts and committed trainers to provide quality training with best user experience.

Learn from anywhere with our most flexible training hours

DATABASE COURSE

COURSE OUTLINE

MySQL DEVELOPER


RDBMS
Architecture of MySQL
Database ACID properties
Installation and Configuring MySQL
Features of DBMS 


Database Table and Constraints
ACID and Transactions
Deadlocks, Isolation Levels and Logging
Designing and Normalization  


Creating users and granting privileges
User Backup
Security practices and changing password  


Performance problems
Performance monitoring
Impact of Indexing on Database performance
Performance Optimization  


Database creation
Database manipulation - Add, Edit, Retrieve and Delete
Table creation
Table manipulation - Add, Edit, Retrieve and Delete 


Building and Updating VIEWs
SQL Select Statements
Using Joins to combine Related Table
Insert, Update and Delete commands
Sub queries