Database Admin & Development

Responsive Image
Oracle
Responsive Image
Microsoft SQL
Responsive Image
MySQL

Oracle Databases

Courses for Oracle Databases

7 Day Course

This official Oracle Database 12c Administrator Certified Associate course was designed cover Oracle Database 12c: Install and Upgrade Workshop and the Oracle Database 12c: Administration Workshop contents over seven days.

This course will teach students about the Oracle Database architecture and how to install Oracle Database 12c software, create a container database, provision pluggable databases, manage an Oracle Database instance, configure the Oracle Network Environment and perform database maintenance.

5 Day Course

This course delivers the fundamentals of SQL and PL/SQL along with the benefits of the programming languages using Oracle Database technology. You’ll explore the concepts of relational databases.

Ensure fast, reliable, secure and easy to manage performance. Optimise database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds. Demonstrations and hands-on practice reinforce the fundamental concepts that you’ll learn in this course. By enrolling in this course, you’ll begin using Oracle SQL Developer to develop these programme units. SQL*Plus is available as optional tools.

Microsoft SQL

Courses for MS SQL

4 Day Course

This course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.

5 Day Course

This course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

3 Day Course

This course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.

3 Day Course

The main purpose of this course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.

The course will very likely be well attended by SQL power users who arent necessarily database-focused; namely, report writers, business analysts and client application developers.

MySQL

Courses for MySQL

4 Day Course

This course is the first step in mastering MySQL, the world’s most popular open source database. Develop solid understanding and practical experience using relational databases, SQL and the MySQL Server and tools.

This course will teach you everything you need to know to start using the incredibly popular MySQL database in your Web, Cloud and embedded applications. In learning about MySQL you will also gain an understanding of relational databases in general, learning how to design your database so it’s robust and efficient. Furthermore, you will harness that power by learning SQL and using it to build databases, populate them with data and query that data through extensive hands-on practices.