Introduction to SQL (all variants of SQL including Oracle and MySQL)

This course is designed to give users an understanding of SQL Language. The course covers SQL commands for DML, DDL, Query, and Transaction Control operations.

Introduction to Oracle SQL and PL/SQL

This course is designed to give users an understanding of Oracle SQL and Oracle PL/SQL languages using Oracle’s SQL*Plus and iSQL*Plus tools. The course covers SQL commands for DML, DDL, Query, and Transaction Control operations. Students are also introduced to procedural programming using PL/SQL. The course topics are applicable to all versions of Oracle through Oracle 10g.

Oracle Database: Program with PL/SQL (ekit)

This course starts with an introduction to PL/SQL and proceeds to list the benefits of this powerful programming language. Participants are made aware of how to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. In addition, creation of anonymous PL/SQL blocks as well as stored procedures and functions are covered in this course. Participants enhance their developer skills by learning to develop, execute, and manage PL\SQL stored program units such as procedures, functions, packages, and database triggers. Understanding the basic functionality of how to debug functions and procedures using the SQL Developer Debugger gives way to refined lines of code. Participants also learn to manage PL/SQL subprograms, triggers, declaring identifiers, and trapping exceptions. The utilization of some of the Oracle-supplied packages is also in the course. Additionally participants learn to use Dynamic SQL, understand design considerations when coding using PL/SQL, understand and influence the PL/SQL compiler, and manage dependencies. This is appropriate for a 10g and 11g audience. There are minor changes between 10g and 11g features.

Oracle Database 11g: Introduction to SQL (ekit)

In this course students learn the concepts of relational databases. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. Students learn to control privileges at the object and system level. This course covers creating indexes and constraints, and altering existing schema objects. Students also learn how to create and query external tables. Students learn to use the advanced features of SQL in order to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Students also learn some of the date-time functions available in the Oracle Database. This course discusses how to use the regular expression support in SQL. In this course, students use Oracle SQL Developer as the main development tool. SQL*Plus is introduced as an optional development tool.

Oracle Database 11g: SQL Tuning Workshop (ekit)

The SQL Tuning Workshop class covers investigative methods that reveal varying levels of detail about how the Oracle database executes a SQL statement. Students learn the different ways in which data can be accessed, which ones are most efficient under specific circumstances, and how to ensure that the best method is used. Partitioning topics are covered, in addition to taking advantage of hints, bind variables, and different types of indexes.

Oracle Database 11g: Administration Workshop I R2 (ekit)

This course is designed to give students a firm foundation in basic database administration. Lesson topics are reinforced with structured hands-on practices that will prepare them for the corresponding Oracle Certified Associate exam. Students will learn how to install Oracle Grid Infrastructure, create and manage users, install and configure an Oracle Database, and create and manage storage structures. They will also learn how to administer the Oracle Database, perform backup and recovery, and create an Operational Database. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner. This includes performance monitoring, database security, user management and backup/recovery techniques.

Oracle Database 11g: Administration Workshop II (ekit)

In this course, the concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test your own backup and recovery scenarios. Also, the students learn to manage memory effectively and to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are covered. Topics are reinforced with hands-on practices.

Oracle Database 11g: New Features for Administrators Accelerated Release 2

This course gives you the opportunity to learn about and practice with the new change management features and other key enhancements in Oracle Database 11g Release 1 and Release 2. Topics covered include the benefits and use of the new features in managing change, diagnosing and recovering from problems, ensuring high availability, improving scalability and performance, strengthening security, and several other areas of particular interest to database administrators. In addition, hands-on practice sessions help reinforce understanding of the new capabilities. This course also gives students the opportunity to learn about the general new features of the Oracle Database 11g (11.2.0.2). Students examine the benefits and use of the new features in managing storage and space, strengthening resource management and database manageability.

Oracle Database 11g: Performance Tuning (ekit)

Students learn how to use Oracle Database 11g automatic tuning features such as SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor, and practice these tuning methods. The course focuses on the tuning tasks expected of a DBA: reactive tuning of SQL statements, maintaining SQL statement performance, and tuning the Oracle Database Instance components. Throughout the course, students practice the art of tuning an Oracle Instance through a series of workshops. The methodology is practiced in the workshops rather than taught.

Oracle Database 11g: Backup & Recovery (ekit)

Oracle Database 11g: Backup and Recovery training teaches students how to backup and recover a portion or all of an Oracle 11g database.

Oracle Database 11G: Security Release 2

In this course, students will learn how to use Oracle Database features to meet the security, privacy and compliance requirements of their organization. The current regulatory environment of the Sarbanes-Oxley Act, HIPAA, the UK Data Protection Act and others requires better security at the database level.

High Performance MySQL: Optimization, Backups, and Replication

This class requires 5 or more students

In this course, students will learn how to build fast, reliable systems with MySQL. It covers every aspect of MySQL performance in detail, and focuses on robustness, security, and data integrity. The course teaches students advanced techniques in depth so they can bring out MySQL's full power. Specifically, students will learn how to design schemas, indexes, queries and advanced MySQL features for maximum performance, and get detailed guidance for tuning your MySQL server, operating system, and hardware to their fullest potential. They will also learn practical, safe, high-performance ways to scale your applications with replication, load balancing, high availability, and failover.

Postgre SQL 9 Database Administration

The class covers the tasks that a PostgreSQL database administrator faces daily, from basic operations to advanced techniques. Course notes use pgAdmin as a graphical administration tool.

PostgreSQL Immersion

This course covers administration, performance, advanced development, and replication—into a continuous sequence. Hands-on workshop exercises are provided for the performance and replication classes. Students are encouraged to ask questions about features the instructor can demonstrate at any time. The examples target PostgreSQL versions 9.0 and 9.1. Instructors for this class know PostgreSQL works at a deep level, including the common challenges when the database is deployed onto real-world production systems at scale. The ideal student will not just want to know what to do with PostgreSQL, they'll want to understand how the database works and makes its decisions.

PostgreSQL 9 Development

The 3-day class covers important Basic and Intermediate level details for developers interacting with PostgreSQL. Suitable for developers using Java, PHP, Python, perl, .Net and other client languages.