Database Administration and Database Development Courses
These are the courses we currently offer. If you don't see the course, enquire and we can create a customized course for you.
The MySQL for Database Administrators training is designed for DBAs and other database professionals. Expert instructors will teach you how to install and configure the MySQL Server, set up replication and security, perform database backups and performance tuning and protect MySQL databases. This course specifically covers the MySQL 5.6 Oracle Certified Professional Database Administrator. You will learn to describe the MySQL architecture, install and upgrade MySQL, configure MySQL server options at runtime, evaluate data types and character sets for performance issues, understand the use of the InnoDB storage engine with MySQL, and perform backup and restore operations.explore
This course is designed to give the right amount of internal knowledge and wealth of practical tuning and optimization techniques that you can put into production. The 5 day class offers a comprehensive coverage of SQL Server architecture, indexing and statistics strategies, optimize transaction log operations, tempdb and data file configuration, transactions and isolation levels, and locking and blocking. The course has a special focus on SQL Server I/O, CPU usage, memory usage, query plans, statement execution, parameter sniffing and procedural code, deadlocking, plan cache, wait and latch statistics, Extended Events, DMVs and PerfMonexplore
The Oracle Database 12c Administration course will teach you about the Oracle Database architecture. You will discover how to effectively manage an Oracle Database instance, configure the Oracle Network Environment and perform database maintenance.explore
Learn everything you need to know to administer a MongoDB installation in production. This course begins by assuming you have no experience with MongoDB, taking you through the basics of installation. Then you will learn about JSON and Mongo's extensive query capabilities through the Mongo shell.explore
This is what our clients have to say