Sort

    MySQL

    Select All Courses
  • 2 Days
    This course is designed to give you hands-on practice working with a MySQL database.  Although the focus is to enable students to meet the standards of MySQL 5.0 OCA Certification (the latest version for which an official MySQL Certification Guide is available until May 2012), the enhancements in versions 5.1,…
  • 2 Days
    This course is designed to give you hands-on practice working with a MySQL database.  Although the focus is to enable students to meet the standards of MySQL 5.0 Certification (the latest version for which an official MySQL Certification Guide is available until May 2012), the enhancements in versions 5.1, 5.5…
  • 3 Days
    This course is designed to give you hands-on practice working with a MySQL database.  The class will be conducted using a MySQL Version 5.5 database. This course focuses on advanced Database Administration tools and techniques including replication, the use of binary logs in high availability, scale-out,  MySQL storage and replication…
  • 2 Days
    This course is designed to give you hands-on practice working with a MySQL database. The class will be conducted using a MySQL Version 5.5 database. The total focus of this class is MySQL Cluster and includes an overview of the cluster environment, configuration, available cluster programs, cluster management and replication.…
    • Developers, SQL and PL/SQL

      Select All Courses
    • 5 Days
      This course provides a complete, hands-on introduction to 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.
    • 5 Days
      This course provides the fundamentals of interacting with an Oracle 9i, 10g, or 11g database from a command-line environment. SQL syntax is thoroughly covered, and writing SQL statements that will perform well is emphasized from the very beginning of the course. Commands for formatting as well as scripting with SQL*Plus…
    • 1 Day
      Attendees will learn to use SQL to aggregate, analyze and report, and model data. Attendees will learn how to use the CUBE and ROLLUP statements to aggregate their data and the RANK function to analyze their data. They will also learn to build and interpret hierarchical queries, create a tree-structured…
    • 3 Days
      This course provides the fundamentals of interacting with an Oracle 9i, 10g, or 11g database from a command-line environment, but at an accelerated pace for users already familiar with another SQL-based database product (Sybase, SQL Server, DB2, etc.). SQL syntax is reviewed from the Oracle perspective. The SQL*Plus command-line environment…
    • 5 Days
      This course provides a complete, hands-on comprehensive introduction to PL/SQL including the use of both SQL Developer and SQL*Plus. This coverage is appropriate for both users of Oracle12c and Oracle11g.
    • 2 Days
      This course is intended for intermediate to advanced-level PL/SQL programmers. It focuses on advanced topics, many of which are new features released in Oracle 9i, 10g, or 11g that can have performance benefits over existing practices.
    • 3 Days
      This course will introduce the developer to techniques used to provide minimize response times in and Oracle database.
    • 2 Days
      This course teaches the new features of SQL and PL/SQL in Oracle Database 11g. Students will learn about language usability enhancements and how to utilize the performance improvement features such as in lining and code trigger enhancements to achieve more control over the triggers. Enhancements to the dynamic SQL features…
      • Database Administration (DBA)

        Select All Courses
      • 4 Days
        This course provides a basis for determining database content and organization. Students learn to analyze text from user interviews and garner requirements from these sources. Students use user interviews to determine appropriate entities, attributes and relationships. Entity-relationship diagrams are drawn, and normalized. Once an ERD exists, students learn to convert…
      • 3 Days
        This course will introduce the developer to techniques used to provide minimize response times in and Oracle database.
      • 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. 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.
      • 3 Days
        This quick start intensive course is specifically designed to support the OPN Certified Specialist Certification. This course covers the basics of Oracle database installation, configuration and administration. Ten hands-on labs conducted on a fully functional server will provide real world experience.
      • 5 Days
        One of the most challenging tasks ever presented to database administrators is that of recovery from failure, especially if the recovery must not result in a loss of any data. This course presents all the standard failure scenarios and the best recovery strategies for each. Backup strategies for cold backups,…
      • 5 Days
        This course teaches how to deploy Oracle Enterprise Manager and effectively use the tool to administer and monitor the Oracle Database and Operating System. During this class participants learn the Oracle Enterprise Manager architecture, setup the console, use a variety of integrated applications, learn about reports, implement job- and event-based…
      • 5 Days
        This course gives students the opportunity to explore and do hands-on exercises with the new change management features and other key enhancements in Oracle Database 11g. The course covers benefits and use of the new features in managing change, diagnosing and recovering from problems, ensuring high availability, improving scalability and…
      • 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. This course is appropriate for anyone needing to learn key new features of Oracle 12c. That would include end users, business analysts, application developers, database…
      • 5 Days
        With every release of Oracle, the architecture behind RAC implementation has been changing significantly to provide a more robust and intelligent solution towards Oracle grid strategy. This course discusses Oracle 11g Release 2 features in a RAC implementation. The course covers architecture, design, implementation and administration features specifically to a…
        • Application Express (APEX)

          Select All Courses
        • 4 Days
          Application Express is Oracle’s lightweight database-centric web development tool that can be used to easily create small, simple web applications.  It is ideally suited for the developer coming from the Oracle Forms/Reports world that wants to learn to develop a web application from scratch.  It is equally useful for data…