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 (ekit)

This course is designed to give students a firm foundation in basic administration of Oracle Database 11g. In this class, students learn how to install and maintain Oracle Database 11g. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices.

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 (ekit)

This course gives students the opportunity to learn about-and practice with the new change management features and other key enhancements in Oracle Database 11g Release 1. Students examine 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 that concern database administrators. In addition, the hands-on practice sessions help reinforce students understanding of these new capabilities in Oracle Database 11g Release 1.

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 (ekit)

In Oracle Database 11g: Security course students learn how they can 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. Students learn how to secure their database and how to use the database features that enhance security. The course provides suggested architectures for common problems. This course covers the following security features of the database: auditing, encryption for Payment Card Industry Data Security Standard (PCI DSS ) including encryption at the column, tablespace and file levels, virtual private database, label security and enterprise user security. Some of the Oracle Network security topics covered are: securing the listener and restricting connections by IP address.

Introduction to MySQL/PHP

This class requires 5 or more students

This five day class is broken down into three sections: Part I - learning PHP syntax which weds well with HTML/XHTML; Part II - learning how to create MySQL databases and querying them with SQL; and Part III - applying this knowledge in the development of an application. The student will be able to run three tier applications by the end of the class. The core of the curriculum is focused on the Middle tier using the PHP scripting language to develop the application logic.

Building and Securing Web Applications Using MySQL and PHP

This class requires 5 or more students

This course examines the issues associated with the development of a dynamic web page. Emphasis is placed on using the power of PHP to link to server side databases (MySQL), files, and directories for creating pages that mine data about past user interactions. Taking data from a user can be a security issue if your code is insecure. This course will examine functions and techniques essential for securing your system while providing a rich user experience. Best practices for development of the page are covered to provide guidelines while creating a dynamic web page. A web application is developed as the student progresses through each chapter.

SQLite 3 with PHP Essential Training

Databases aren't just for the IS group any more. You can build database-backed applications for the desktop, Web, embedded systems, or operating systems without linking to heavy-duty client-server databases such as Oracle and MySQL. This course teaches you how to use SQLite, a small and lightweight relational database engine that you can build directly into your application. With SQLite, you'll discover how to develop a database-backed application that remains manageable in size and complexity. You'll get a crash course in data modeling, become familiar with SQLite's dialect of the SQL database language, and much more.