DATABASE TECHNOLOGIES

GuruTeam offers various Database Technology courses, all of which can be customised to suit your team’s current and required skill level, and meeting your business needs. This means that courses can be condensed where necessary, and irrelevant modules removed if required.

Oracle 12c courses now available! See below or why not contact us if you wish to have a bespoke course for your team. Training can be delivered anywhere in Ireland!

ORACLE12C RELEASE 1 SQL AND PL/SQL FASTTRACK – GTD20 – 5 days

This course provides a complete, hands-on introduction to both SQL and PL/SQL including the use of both SQL Developer and SQL*Plus. This coverage is appropriate for both users of Oracle12c and Oracle11g. A full presentation of the basics of relational databases and their use are also covered.

More information…

ORACLE DATABASE 12c R1: SQL FUNDAMENTALS – GTD18 – 5 days

This course is a common starting point in the Oracle database curriculum for administrators, developers and business users.

More information…

ORACLE DATABASE 12c R1: PL/SQL FUNDAMENTALS – GTD19 – 5 days

This Oracle 12C course will provide an introduction to the PL/SQL database programming language, based upon the latest features available with the Oracle database.

This course can be taken as a closed training event and tailored to suit your business objectives. Contact us for more details.

More information…

ORACLE12C R1 DATABASE ADMINISTRATION I – GTD21 – 5 days

This course provides a complete, hands-on introduction to Oracle Database Administration including the use of Enterprise Manager Database Express (EMDE), SQL Developer and SQL*Plus.

More information…

ORACLE 12C R1 DATABASE ADMINISTRATION 1 – GTD21A – 3 days

This 3-day course provides a complete, hands-on introduction to Oracle Database Administration including the use of Enterprise Manager Database Express (EMDE), SQL Developer and SQL*Plus.

More information…

ORACLE 12C RELEASE 1 NEW FEATURES FOR ADMINISTRATORS – GTD22 – 5 days

This course provides a complete, hands-on introduction to the newest release of Oracle Enterprise Edition. Key features of this product are fully discussed and demonstrated.

More information…

ORACLE 12C RELEASE 1 MULTITENANT ARCHITECTURE – GTD23 – 3 days

This course provides a comprehensive, hands-on introduction to by far the most significant new feature in Oracle history, multitenant architecture.

More information…

ORACLE DATABASE 11G R2: SQL FUNDAMENTALS I– GTD1 – 3 days

This course is a common starting point in the Oracle database curriculum for administrators, developers and business users.

More information…

ORACLE DATABASE 11G R2: SQL FUNDAMENTALS II– GTD2 – 3 days

This course is well suited for non-Oracle professionals already experienced in the SQL but who wish to become acquainted with the unique and advanced features of Oracle SQL.

More information…

ORACLE DATABASE 11G R2: PL/SQL FUNDAMENTALS I – GTD3 – 2 days

This Oracle 11g course will provide an introduction to the PL/SQL database programming language, based upon the latest features available with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming.

More information…

ORACLE DATABASE 11G R2: PL/SQL FUNDAMENTALS II-DEVELOP PROGRAM UNITS – GTD4 – 3 days

This Oracle 11g course will equip students to develop database server-side PL/SQL program units within an Oracle database.

More information…

ORACLE DATABASE 11G R2: ADVANCED PL/SQL PROGRAMMING AND TUNING– GTD5 – 5 days

This Oracle 11g course will give attention to three fundamental pillars of effective implementation of PL/SQL applications. The PL/SQL programming language is at the core of most Oracle database applications.

First, we will explore the advanced features of the language which allow powerful and effective database applications to be built. Next, we will discuss performance tuning techniques which allows these applications to run efficiently.

Finally, we will consider critical security measures which should be implemented to counter hacker attacks and other security threats.

More information…

ORACLE DATABASE 11G R2: NEW AND ADVANCED FEATURES FOR DEVELOPERS– GTD6 – 3 days

This Oracle 11g course will present some of the most advanced features available to database developers

More information…

ORACLE DATABASE 11G R2: SQL TUNING– GTD7 – 3-4 days

This course will equip database administrators and application developers to build efficient SQL statements and to tune database applications. When this effort is complemented by database server and PL/SQL application tuning, then a highly efficient application execution environment is created. One will learn about the internals of SQL statement execution, how to monitor the performance of such execution, and how one can influence the behaviour of the database to achieve performance gains.

More information…

ORACLE DATABASE 11G R2: ADMINISTRATION I– GTD8 – 5 days

Administration of the Oracle database management system (DBMS) software environment and of the server systems on which the DBMS runs is one of the primary tasks required of database administrators. While it is true that the hardware and software platforms on which the DBMS runs have become increasingly complex, as has the database software itself, the capabilities provided by the Oracle database have correspondingly become more sophisticated.

More information…

ORACLE DATABASE 11G R2: ADMINISTRATION II – GTD9 – 5 days

This course brings database administrators beyond a basic understanding of their duties and to transfer advanced skills needed to effectively administer an Oracle database installation within a large-scale enterprise. Important subject areas include advanced database configuration, performance monitoring and tuning, configuring for recovery, troubleshooting and fault diagnosis, and use of the extensive advisory framework. Sometimes configuration and operational problems can exist within an Oracle database installation because important technologies are either not fully understood or not properly implemented.

Advanced technologies which should be applied to any mission-critical database installation. The Database Resource Manager is an essential tool for database tuning and achieving optimum performance, and is often used in combination with the advisors. The Database Scheduler is a sophisticated tool which can automate many administration tasks and integrate the database into the larger data centre and systems infrastructure. All of the data

within a database installation is at risk unless one has designed, tested and implemented a robust backup and recovery strategy.

When a major failure occurs, a variety of recovery and troubleshooting techniques must be employed. The Oracle Recovery Manager (RMAN) tool is discussed with additional facilities including the Data Recovery Advisor, Redo Log File Size Advisor and MTTR Advisor. It is tempting to short-cut appropriate backup procedures if they perform poorly, so special attention is giving to performance optimization.

More information…

SQL FUNDAMENTALS – GTPL72 – 2 days

This SQL training course is designed for students new to writing SQL queries. A typical student will need to learn SQL to build applications or to generate business reports. For the most part, the SQL learned in the course is applicable to all major databases. In the few cases in which there are differences between the databases, these differences will be pointed out.

Class Goals

  • Understand how relational databases work
  • Learn to use SQL to output reports
  • Learn to write queries getting data from multiple tables

More information…

INTRODUCTION TO MySQL DATABASES – GTLP6 – 3 days

This MySQL training class teaches the configuration, security management, administration, backup and restore, and optimization of MySQL databases.

More information…

ORACLE APEX (Version 4.2.5) – GTD24 – 5 days

This course provides a complete, hands-on introduction to Oracle APEX 4.2.5, Oracles premier Rapid Application Development tool. With this revolutionary tool, developers can quickly and efficiently create highly complex web-based applications that will run on any operating system environment including smart phones. Interactive reports can be created that allow for full customization including:

  • Searching and sorting
  • Creating control break reports
  • Performing highlighting to focus on specific rows or values
  • Adding custom computations including aggregations
  • Charting and custom dashboards

In this class, students will actually build a fully functioning application from the ground up.

More information…

XCELSIUS 2008 INTRODUCTION– GTD10 – 2 days

This Xcelsius training class will serve as an introduction to building dashboards with Xcelsius 2008. Students will create, design, and publish business dashboards using the Xcelsius application.

More information…

INTRODUCTION TO CRYSTAL REPORTS 2011– GTD11 – 2 days

This Crystal Reports course is intended for students who have little to no experience with Crystal Reports. The course will provide students with a general overview of the basic functionality and a general understanding of report design, including the need to provide quality reports in various presentation formats. Students will gain practical experience through hands-on exercises.

Please note that XI is the older version of Crystal Reports and should not be confused with 2011.

More information…

ADVANCED CRYSTAL REPORTS 2011– GTD12 – 2 days

This Crystal Reports class is intended for those experienced in Crystal Reports and who want to learn more about database functionality and the more advanced features of Crystal Reports. This will be enhanced through the use of hands-on exercises throughout the course.

Please note that XI is the older version of Crystal Reports and should not be confused with 2011.

More information…

INTRODUCTION TO CRYSTAL REPORTS 2008/2011– GTD13 – 2 days

This two day, interactive workshop was designed for new users of Crystal Reports 2008 – 2011. Some of the topics covered include a review of the software features, report design, and the creation of presentation quality reports. The course incorporates a number of hands-on exercises to reinforce the learning process.

More information…

INTERMEDIATE CRYSTAL REPORTS 2008– GTD14 – 2 days

This Crystal Reports training class is designed to enhance your basic report writing skills and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of advanced report writing along with a good amount of hands on practice. In addition, you will cover professional design, techniques, sub-reporting and advanced formulas.

More information…

ADVANCED CRYSTAL REPORTS 2008– GTD15 – 2 days

This advanced Crystal Reports training class is designed for people experienced with Crystal Reports who want to solidify their expertise by learning the most advanced features. Students get practical experience through plenty of hands-on exercises.

More information…

MySQL ADMINISTRATION – GTLP6 – 3 days

This MySQL training course teaches the configuration, security management, administration, backup and restore, and optimization of MySQL databases.

More information…

MySQL ADMINISTRATION AND DEVELOPMENT – GTLP7 – 4 days

MySQL®is the open source community’s most popular Relational Database Management System (RDBMS)

offering, and is a key part of LAMP – Linux™, Apache™, MySQL®, PHP/Perl/Python®. Many Fortune 500 companies adopt MySQL to reap the benefits of an open source, platform-independent RDMS, such as simplifying conversion from other platforms and lowering database Total Cost of Ownership by 90%. This class encourages the student to explore database fundamentals, as well as MySQL features. Students learn the basics of MySQL use and the programming of stored routines and triggers. Students also participate in database design discussions, perform administrative functions, learn about optimization and performance tuning, and explore various APIs. This course covers MySQL 5.0.

More information…