MySQL DEVELOPER

Establish the strongest possible foundation in database development by learning how to use MySQL - the most popular open source database in the world - write queries, create reports at will, build web applications, incorporate MySQL as the database layer - make your development dreams a reality by taking this course and putting a check mark next to your growing development skillset.

Database development with MySQL is one of the most fundamental skills that a technology professional needs to thrive in today's workplace. This course gives you that skill. 

Subscribe to our newsletter

Get updates on latest developments on emerging and trending technologies

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

Anything to ask?

If you have any question about training, fees, courses or anything else, feel free to ask us anytime!


Address

Nexperts Academy Sdn Bhd,
Unit 313, Block E, Phileo Damansara 1, Jalan 16/11 off Jalan Damansara 46350, PJ Selangor, Malaysia

Working Hours

Monday Tuesday Wednesday Thursday Friday

09:00 - 17:30 09:00 - 17:30 09:00 - 17:30 09:00 - 17:30 09:00 - 17:30

Contact

Email: vaheed@nexpertsacademy.com
Phone: +6 011 1221 6872
Office: +6 03 7931 8872