Oracle_Architecture-DATABASES by yvtong


  Revised 3/5/2012
This Page Intentionally Left Blank
                                                                Table of Contents

            Introduction to SQL (all variants of SQL including Oracle and MySQL)...............................................................                 1
            Introduction to Oracle SQL and PL/SQL.......................................................................................................        2
            Oracle Database: Program with PL/SQL (ekit)...............................................................................................          3
            Oracle Database 11g: Introduction to SQL (ekit)............................................................................................         4
            Oracle Database 11g: SQL Tuning Workshop (ekit)........................................................................................             5
            Oracle Database 11g: Administration Workshop I (ekit)...................................................................................            6
            Oracle Database 11g: Administration Workshop II (ekit)..................................................................................            7
            Oracle Database 11g: New Features for Administrators (ekit)...........................................................................              8
            Oracle Database 11g: Performance Tuning (ekit)...........................................................................................           9
            Oracle Database 11g: Backup & Recovery (ekit)............................................................................................          10
            Oracle Database 11g: Security (ekit)...........................................................................................................    11
            Introduction to MySQL/PHP.......................................................................................................................   12
            Building and Securing Web Applications Using MySQL and PHP......................................................................                   13
            High Performance MySQL: Optimization, Backups, and Replication...................................................................                  14
            SQLite 3 with PHP Essential Training..........................................................................................................     15                                                      i                             Phone: 410-290-8383 / Fax: 410-290-9427
                             This Page Intentionally Left Blank                 ii           Phone: 410-290-8383 / Fax: 410-290-9427
                                                                                                                                        Course Length
                                           Introduction to SQL (all variants of SQL                                                         3 Days
                                                including Oracle and MySQL)                                                             TE1966_20100128

    Course Description: 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.

    Who Should Attend: Application course. and developers, database administrators and operators, and end users should
                       attend this

    Prerequisites:                  There are no prerequisites for this course.

    Benefits of Attendance: Upon completion of this course, students will be able to:
   • Explain the difference between SQL, DML, and DDL statements            • Use transaction control statements to commit and rollback
   • Write basic SQL queries to retrieve desired data                       • Write advanced queries
   • Use DML statements (insert, update, and delete)                        • Write scripts to perform queries and display reports
   • Use DDL statements (create, alter, and drop)                           • Control access to your database objects
    Course Outline:
   Database Design                                                              SQL FUNCTIONS
   Database Models                                                              Introduction
   Beginnings                                                                   The DISTINCT Keyword
   Some Introductory Terminology                                                Aliases
   Codd's 12 Rules                                                              Miscellaneous Functions
   Normalization                                                                Mathematical Functions
   First Normal Form                                                            String Functions
   Higher Order Normal Forms                                                    Date Functions
                                                                                Conversion Functions
   Standard Interfaces                                                          Pseudo Columns
   Architecture                                                                 Joining Tables
   Command Line Interface                                                       Joins
   Viewing a Sample Table                                                       Cartesian Product
                                                                                Inner joins
   The Sample Database                                                          Equi-Join
   The Entity Relationship Model                                                Table Aliases
   Entity Relationship Diagrams                                                 Non-Equi Join
   The Sample Database                                                          Non-Key Join
   ER Diagram for Sample Database                                               Reflexive Join
   Creating the Sample Data                                                     Natural Join
   Viewing Sample Data                                                          Outer Joins
   Data Types of the Sample Data                                                Right Outer Join
                                                                                Left Outer Join
   Data Definition Language                                                     Full Outer Join
   Categories of SQL Statements                                                 Syntax for Outer Joins
   The CREATE Statement                                                         Set Operators
   The DROP Command                                                             Introduction
   The ALTER Command                                                            Selection Criteria
   Integrity Constraints                                                        Union
   Entity Integrity Constraints                                                 Union All
   Referential Integrity Constraints                                            Intersect
   Modifying Table to Use Constraints                                           Minus
   Checking Constraints
   The Data Dictionary                                                          SQL Subqueries
   Data Manipulation Language                                                   Using a Subquery with a DML Statement
   DML Statements                                                               Typical Subqueries
   The SELECT Statement                                                         Subquery Operators
   The INSERT Statement                                                         Standard vs. Correlated Subqueries
   The DELETE Statement                                                         Correlated Subquery Example
   The UPDATE Statement                                                         Predicate Operators
   Transaction Control                                                          Groups
   Transactions                                                                 SQL Statements
   Command Classification                                                       GROUP BY Clause
                                                                                HAVING Clause
   SQL Operators                                                                Order of a SELECT Statement
   Simple Selects
   Comparison Operators                                                         More Database Objects
   IN and NOT IN Operators                                                      More Database Objects
   BETWEEN Operator                                                             Relational Views
   The LIKE Operator                                                            Updating a View
   Logical Operators                                                            Create or Replace
   IS NULL and IS NOT NULL                                                      Forcing a View
   ANY                                                                          The Data Dictionary Revisited
   ALL                                                                          Indexes
                                                                                Synonyms                                                  1                                   Phone: 410-290-8383 / Fax: 410-290-9427
                                                                                                                                                            Course Length

                                              Introduction to Oracle SQL and PL/SQL                                                                              5 Days

    Course Description: 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.

    Who Should Attend: Application course. and developers, database administrators and operators, and end users should
                       attend this

    Prerequisites:                  There are no prerequisites for this course.

    Benefits of Attendance: Upon completion of this course, students will be able to:
   • Explain the difference between SQL, PL/SQL and SQL*PLUS.                              • Control access to your database objects.
   • Write basic SQL queries to retrieve desired data.                                     • Write a PL/SQL block using all elements of block structure.
   • Use DML statements (insert, update, and delete).                                      • Write PL/SQL statements using lexical units, declared variables,
   • Use DDL statements (create, alter, and drop).                                           and assignment statements.
   • Use transaction control statements to commit, rollback, and                           • Use control structures to loop, branch, and jump.
     create savepoints.                                                                    • Use PL/SQL named exceptions and user-defined exceptions.
   • Write advanced queries.                                                               • Use explicit cursors.
   • Write scripts to do queries and display SQL*PLUS reports.
    Course Outline:
   Database Design                      The UPDATE Statement               Selection Criteria
   Database Models                      More SQL*Plus Commands             Union                           Declarations and Data            Functions and
   Beginnings                                                              Union All                       Types                            Procedures
   Some Introductory Terminology        Transaction Control                Intersect                       Declarations                     Introduction
   Codd's 12 Rules                      Transactions                       Minus                           Standard Data Types              Creating a Procedure
   Normalization                        Command Classification                                             Initialization                   Example Procedure
   First Normal Form                    Savepoints                         SQL Subqueries                  Variable Names                   Using Parameters
   Higher Order Normal Forms            The SET TRANSACTION                Introduction                    Specialized Data Types - %TYPE   Functions
                                          Command                          Using a Subquery with a DML     Specialized Data Types -         Procedures and Exceptions
   Oracle Standard                                                            Statement                       %ROWTYPE
   Interfaces                           SQL Operators                      Typical Subqueries              Building Your Own Data Types -   Appendix A: An SQL
   SQL                                  Simple Selects                     Subquery Operators                 Records                       and SQL*Plus
   SQL*Plus                             Comparison Operators               Standard vs. Correlated         A Quick look at Loops            Reference
   Oracle Architecture                  IN and NOT IN Operators               Subqueries                   Arrays                           DDL Statements
   Interfaces to Oracle                 BETWEEN Operator                   Correlated Subquery Example     Tables                           DML Statements
   Command Line Interface               The LIKE Operator                  Predicate Operators             Nested Blocks                    Transaction Control Statements
   Viewing a Sample Table               Logical Operators                                                                                   Operators
   The Graphical User Interface         IS NULL and IS NOT NULL            Groups                          Language Components              Common SQL*Plus Commands
   The SQL Buffer                       ANY                                SQL Statements                  Introduction
   The Web-Based Interface              ALL                                GROUP BY Clause                 Assignments
   Describe                                                                HAVING Clause                   Decision Making Statements
                                        SQL FUNCTIONS                      Order of a SELECT Statement     Simple Loops
   The Sample Database                  Introduction                                                       Loops - for
   The Entity Relationship Model        The DISTINCT Keyword               More Database Objects           Loops - indefinite
   Entity Relationship Diagrams         Aliases                            More Database Objects           Loops - while
   The Sample Database                  Miscellaneous Functions            Relational Views                Simple Loops
   ER Diagram for Sample Database       Mathematical Functions             Updating a View                 Nested Loops
   Creating the Sample Data             String Functions                   Create or Replace               Boolean Variables
   Viewing Sample Data                  Date Functions                     Forcing a View                  PL/SQL Relational Operators
   Data Types of the Sample Data        Conversion Functions               The Data Dictionary Revisited   PL/SQL Logical Operators
                                        Pseudo Columns                     Indexes                         The CASE Construct
   Data Definition                                                         Synonyms
   Language                             Joining Tables                                                     Cursors
   Categories of SQL Statements         Joins                              Reports                         Introduction
   Oracle Datatypes                     Cartesian Product                  Report Features                 Cursor Manipulation
   The CREATE Statement                 Inner Joins                        Session Control                 Using the Cursor
   The DROP Command                     Equi-Join                          The SET Command                 For Loops Cursors
   The ALTER Command                    Table Aliases                      The COLUMN Command              Cursor Attributes
   Integrity Constraints                Non-Equi Join                      The BREAK Command               Cursor Parameters
   Entity Integrity Constraints         Non-Key Join                       The COMPUTE Command             Nested Cursors
   Referential Integrity Constraints    Reflexive Join                                                     Cursor Exceptions
                                        Natural Join                       Introduction
   Modifying Table to Use Constraints
                                        Outer Joins                        SQL vs. PL/SQL                  Exceptions
   Checking Constraints
                                        Right Outer Join                   A Few Simple Examples           Errors in Programs
   The Data Dictionary
                                        Left Outer Join                    Saving Procedures               Run Time Exceptions
   Data Manipulation                    Full Outer Join                    A More Complete Picture         Oracle Built In Exceptions
   Language                             Oracle-Specific Syntax for Outer   Comments                        Unnamed Exceptions
   DML Statements                         Joins                            Variable Substitution           Built in Exception Functions
   The SELECT Statement                                                    Simple Exception Handling       Creating Your Own Exceptions
   The INSERT Statement                 Set Operators                      Advantages of PL/SQL            Building Non Terminating
   The DELETE Statement                 Introduction                       Assignments                       Exceptions                                                                  2                           Phone: 410-290-8383 / Fax: 410-290-9427
                                                                                                                                                                                                                                     Course Length

                                                      Oracle Database: Program with PL/SQL (ekit)                                                                                                                                            5 Days

    Course Description: 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.

    Who Should Attend: Database Administrators, Forms Developers, Portal Developers, Developers, Technical Consultants,
                       System Analysts, Application Developers, and PL/SQL Developers will benefit from this course.

    Prerequisites:                                 Students should have taken an introductory Oracle Database 10g: Introduction to SQL course.

    Benefits of Attendance: Upon completion of this course, students will be able to:
   • Create and debug stored procedures and functions                                                                             • Describe the features and syntax of PL/SQL
   • Use conditional compilation to customize the functionality in a                                                              • Use PL/SQL programming constructs and conditionally control
     PL/SQL application without removing any source code                                                                            code flow (loops, control structures, and explicit cursors)
   • Design PL/SQL packages to group related constructs                                                                           • Manage dependencies between PL/SQL subprograms
   • Create overloaded package subprograms for more flexibility                                                                   • Handle runtime errors
   • Design PL/SQL anonymous blocks that execute efficiently                                                                      • Create triggers to solve business challenges
   • Use the Oracle supplied PL/SQL packages to generate screen                                                                   • Design PL/SQL code for predefined data types, local
     output, file output and mail output                                                                                           subprograms, additional pragmas, standardized constants and
   • Write dynamic SQL for more coding flexibility                                                                                 exceptions
    Course Outline:
   Introduction                                 Data Manipulation in the Server using   Create a Modularized and Layered              Overloading Subprograms in PL/SQL      The Cross-Session PL/SQL Function            Warnings for Subprograms
   Course Objectives                              PL/SQL                                   Subprogram Design                          Use the STANDARD Package                 Result Cache                            List the benefits of Compiler Warnings
   Course Agenda                                Understand the SQL Cursor concept       Modularize Development With                   Use Forward Declarations to solve      The DETERMINISTIC Clause with             List the PL/SQL Compile Time
   Describe the Human Resources (HR)            Use SQL Cursor Attributes to Obtain        PL/SQL Blocks                                 Illegal Procedure Reference           Functions                                  Warning Messages Categories
       Schema                                     Feedback on DML                       Understand the PL/SQL Execution               Implement Package Functions in SQL     Usage of Bulk Binding to Improve          Setting the Warning Messages
   PL/SQL development environments              Save and Discard Transactions              Environment                                   and Restrictions                      Performance                                Levels: Using SQL Developer,
       available in this course                                                         List the benefits of using PL/SQL             Persistent State of Packages                                                        PLSQL_WARNINGS Initialization
   Introduction to SQL Developer                Control Structures                         Subprograms                                Persistent State of a Package Cursor   Triggers                                     Parameter, and the
                                                Conditional processing using IF         List the differences between                  Control side effects of PL/SQL         Describe Triggers                            DBMS_WARNING Package
   Introduction to PL/SQL                         Statements                               Anonymous Blocks and                          Subprograms                         Identify the Trigger Event Types and         Subprograms
   Overview of PL/SQL                           Conditional processing using CASE          Subprograms                                Invoke PL/SQL Tables of Records in        Body                                   View Compiler Warnings: Using SQL
   Identify the benefits of PL/SQL                Statements                            Create, Call, and Remove Stored                  Packages                            Business Application Scenarios for           Developer, SQL*Plus, or the Data
      Subprograms                               Describe simple Loop Statement             Procedures                                                                           Implementing Triggers                     Dictionary Views
   Overview of the types of PL/SQL              Describe While Loop Statement           Implement Procedures Parameters               Implement Oracle-                      Create DML Triggers using the
      blocks                                    Describe For Loop Statement                and Parameters Modes                       Supplied Packages in                      CREATE TRIGGER Statement               Manage PL/SQL Code
   Create a Simple Anonymous Block              Use the Continue Statement              View Procedure Information                    Application Development                   and SQL Developer                      What Is Conditional Compilation?
   How to generate output from a                                                                                                      What are Oracle-Supplied Packages?     Identify the Trigger Event Types,         Implement Selection Directives
      PL/SQL Block?                             Composite Data Types                    Stored Functions and                          Examples of some of the Oracle-           Body, and Firing (Timing)              Invoke Predefined and User-Defined
                                                Use PL/SQL Records                      Debugging Subprograms                            Supplied Packages                   Differences between Statement Level          Inquiry Directives
   Declare PL/SQL Identifiers                   The %ROWTYPE Attribute                  Create, Call, and Remove a Stored             How does the DBMS_OUTPUT                  Triggers and Row Level Triggers        The PLSQL_CCFLAGS Parameter
   List the different Types of Identifiers in   Insert and Update with PL/SQL              Function                                      Package work?                       Create Instead of and Disabled               and the Inquiry Directive
      a PL/SQL subprogram                          Records                              Identify the advantages of using              Use the UTL_FILE Package to               Triggers                               Conditional Compilation Error
   Usage of the Declarative Section to          INDEX BY Tables                            Stored Functions                              Interact with Operating System      How to Manage, Test and Remove               Directives to Raise User-Defined
      Define Identifiers                        Examine INDEX BY Table Methods          Identify the steps to create a stored            Files                                  Triggers?                                 Errors
   Use variables to store data                  Use INDEX BY Table of Records              function                                   Invoke the UTL_MAIL Package                                                      The DBMS_DB_VERSION Package
   Identify Scalar Data Types                                                           Invoke User-Defined Functions in              Write UTL_MAIL Subprograms             Creating Compound, DDL,                   Write DBMS_PREPROCESSOR
   The %TYPE Attribute                          Explicit Cursors                           SQL Statements                                                                    and Event Database                           Procedures to Print or Retrieve
   What are Bind Variables?                     What are Explicit Cursors?              Restrictions when calling Functions           Dynamic SQL                            Triggers                                     Source Text
   Sequences in PL/SQL Expressions              Declare the Cursor                      Control side effects when calling             The Execution Flow of SQL              What are Compound Triggers?               Obfuscation and Wrapping PL/SQL
                                                Open the Cursor                            Functions                                  What is Dynamic SQL?                   Identify the Timing-Point Sections of a      Code
   Write Executable                             Fetch data from the Cursor              View Functions Information                    Declare Cursor Variables                  Table Compound Trigger
   Statements                                   Close the Cursor                        How to debug Functions and                    Dynamically Executing a PL/SQL         Understand the Compound Trigger           Manage Dependencies
   Describe Basic PL/SQL Block Syntax           Cursor FOR loop                            Procedures?                                  Block                                   Structure for Tables and Views         Overview of Schema Object
      Guidelines                                The %NOTFOUND and                                                                     Configure Native Dynamic SQL to        Implement a Compound Trigger to              Dependencies
   Learn to Comment the Code                       %ROWCOUNT Attributes                 Packages                                        Compile PL/SQL Code                     Resolve the Mutating Table Error       Query Direct Object Dependencies
   Deployment of SQL Functions in               Describe the FOR UPDATE Clause          Listing the advantages of Packages            How to invoke DBMS_SQL Package?        Comparison of Database Triggers to           using the USER_DEPENDENCIES
      PL/SQL                                       and WHERE CURRENT Clause             Describe Packages                             Implement DBMS_SQL with a                 Stored Procedures                         View
   How to convert Data Types?                                                           What are the components of a                    Parameterized DML Statement          Create Triggers on DDL Statements         Query an Object’s Status
   Describe Nested Blocks                       Exception Handling                         Package?                                   Dynamic SQL Functional                 Create Database-Event and System-         Invalidation of Dependent Objects
   Identify the Operators in PL/SQL             Understand Exceptions                   Develop a Package                               Completeness                            Events Triggers                        Display the Direct and Indirect
                                                Handle Exceptions with PL/SQL           How to enable visibility of a Package’s                                              System Privileges Required to                Dependencies
   Interaction with the Oracle                  Trap Predefined Oracle Server Errors       Components?                                Design Considerations for                 Manage Triggers                        Fine-Grained Dependency
   Server                                       Trap Non-Predefined Oracle Server       Create the Package Specification and          PL/SQL Code                                                                         Management in Oracle Database
   Invoke SELECT Statements in                     Errors                                  Body using the SQL CREATE                  Standardize Constants and              PL/SQL Compiler                              11g
      PL/SQL                                    Trap User-Defined Exceptions               Statement and SQL Developer                   Exceptions                          What is the PL/SQL Compiler?              Understand Remote Dependencies
   Retrieve Data in PL/SQL                      Propagate Exceptions                    Invoke the Package Constructs                 Understand Local Subprograms           Describe the Initialization Parameters    Recompile a PL/SQL Program Unit
   SQL Cursor concept                           RAISE_APPLICATION_ERROR                 View the PL/SQL Source Code using             Write Autonomous Transactions             for PL/SQL Compilation
   Avoid Errors by using Naming                    Procedure                               the Data Dictionary                        Implement the NOCOPY Compiler          List the new PL/SQL Compile Time
      Conventions when using Retrieval                                                                                                   Hint                                   Warnings
      and DML Statements                        Stored Procedures                       Deploying Packages                            Invoke the PARALLEL_ENABLE Hint        Overview of PL/SQL Compile Time                                                                                                        3                                            Phone: 410-290-8383 / Fax: 410-290-9427
                                                                                                                                                                                                                              Course Length

                                                                Oracle Database 11g: Introduction to SQL (ekit)                                                                                                                       5 Days

    Course Description: 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.

    Who Should Attend: This course is for Forms Developers, Dataand PL/SQL Administrators, Business Analysts, Developers,
                       System Analysts, Application Developers,            Developers.

    Prerequisites:                                 Students must have familiarity with data processing concepts and techniques and data processing.

    Benefits of Attendance: Upon completion of this course, students will be able to:
   • Retrieve row and column data from tables with the SELECT                                                            • Manage schema objects
     statement                                                                                                           • Manage objects with data dictionary views
   • Create reports of sorted and restricted data                                                                        • Write multiple-column sub-queries
   • Employ SQL functions to generate and retrieve customized data                                                       • Use scalar and correlated sub-queries
   • Display data from multiple tables using the ANSI SQL 99 JOIN                                                        • Use the regular expression support in SQL
     syntax                                                                                                              • Retrieve row and column data from tables with the SELECT
   • Identify the major structural components of the Oracle Database                                                       statement
     11g                                                                                                                 • Create reports of sorted and restricted data
   • Create reports of aggregated data                                                                                   • Employ SQL functions to generate and retrieve customized data
   • Write SELECT statements that include queries                                                                        • Display data from multiple tables using the ANSI SQL 99 JOIN
   • Run data manipulation statements (DML) to update data in the                                                          syntax
     Oracle Database 11g                                                                                                 • Identify the major structural components of the Oracle Database
   • Create tables to store data                                                                                           11g
   • Utilize views to display and retrieve data                                                                          • Create reports of aggregated data
   • Control database access to specific objects                                                                         • Write SELECT statements that include queries
    Course Outline:
   Introducing Oracle Database                                                                                                                        Retrieve data from views                            time
   11g                                               Using Single-Row Functions to                   Using Sub-queries to Solve                       Create, maintain, and use sequences
   List the features of Oracle Database 11g          Customize Output                                Queries                                          Create and maintain indexes                      Managing Data in Different Time
   Discuss the basic design, theoretical and         Describe the differences between single row     Describe the types of problem that sub-queries   Create private and public synonyms               Zones
      physical aspects of a relational database        and multiple row functions                       can solve                                                                                      Use data types similar to DATE that store
   Categorize the different types of SQL             Manipulate strings with character function in   Define sub-queries                               Controlling User Access                             fractional seconds and track time zones
      statements                                       the SELECT and WHERE clauses                  List the types of sub-queries                    Differentiate system privileges from object      Use data types that store the difference
   Describe the data set used by the course          Manipulate numbers with the ROUND, TRUNC        Write single-row and multiple-row sub-queries       privileges                                       between two date-time values
   Log onto the database using the SQL                 and MOD functions                                                                              Grant privileges on tables                       Practice using the multiple data-time functions
      Developer environment                          Perform arithmetic with date data               Using the SET Operators                          View privileges in the data dictionary              for globalize applications
   Save queries to files and use script files in     Manipulate dates with the date functions        Describe the SET operators                       Grant roles
      SQL Developer                                                                                  Use a SET operator to combine multiple           Distinguish between privileges and roles         Retrieving Data Using Sub-
                                                     Using Conversion Functions                        queries into a single query                                                                     queries
   Retrieving Data Using the SQL                     and Conditional Expressions                     Control the order of rows returned when using    Managing Schema Objects                          Write a multiple-column sub-query
   SELECT Statement                                  Describe implicit and explicit data type          the SET operators                              Add constraints                                  Use scalar sub-queries in SQL
   List the capabilities of SQL SELECT                 conversion                                                                                     Create indexes                                   Solve problems with correlated sub-queries
      statements                                     Use the TO_CHAR, TO_NUMBER, and                 Manipulating Data                                Create indexes using the CREATE TABLE            Update and delete rows using correlated sub-
   Generate a report of data from the output of a      TO_DATE conversion functions                  Describe each DML statement                         statement                                       queries
      basic SELECT statement                         Nest multiple functions                         Insert rows into a table with the INSERT         Create function-based indexes                    Use the EXISTS and NOT EXISTS operators
   Select All Columns                                Apply the NVL, NULLIF, and COALESCE                statement                                     Drop columns and set column UNUSED               Use the WITH clause
   Select Specific Columns                             functions to data                             Use the UPDATE statement to change rows in       Perform FLASHBACK operations
   Use Column Heading Defaults                       Use conditional IF THEN ELSE logic in a            a table                                       Create and use external tables                   Regular Expression Support
   Use Arithmetic Operators                            SELECT statement                              Delete rows from a table with the DELETE                                                          List the benefits of using regular expressions
   Understand Operator Precedence                                                                       statement                                     Managing Objects with Data                       Use regular expressions to search for, match,
   Learn the DESCRIBE command to display the         Reporting Aggregated Data                       Save and discard changes with the COMMIT         Dictionary Views                                    and replace strings
      table structure                                Using the Group Functions                          and ROLLBACK statements                       Explain the data dictionary
                                                     Use the aggregation functions in SELECT         Explain read consistency                         Find table information
   Restricting and Sorting Data                         statements to produce meaningful reports                                                      Report on column information
   Write queries that contain a WHERE clause to      Create queries that divide the data in groups   Using DDL Statements to Create                   View constraint information
      limit the output retrieved                        by using the GROUP BY clause                 and Manage Tables                                Find view information
   List the comparison operators and logical         Create queries that exclude groups of date by   Categorize the main database objects             Verify sequence information
      operators that are used in a WHERE clause         using the HAVING clause                      Review the table structure                       Understand synonyms
   Describe the rules of precedence for                                                              List the data types available for columns        Add comments
      comparison and logical operators               Displaying Data From Multiple                   Create a simple table
   Use character string literals in the WHERE        Tables                                          Decipher how constraints can be created at       Manipulating Large Data Sets
      clause                                         Write SELECT statements to access data from        table creation                                Manipulate data using sub-queries
   Write queries that contain an ORDER BY               more than one table                          Describe how schema objects work                 Describe the features of multi-table inserts
      clause sort the output of a SELECT             View data that generally does not meet a join                                                    Use the different types of multi-table inserts
      statement                                         condition by using outer joins               Creating Other Schema Objects                    Merge rows in a table
   Sort output in descending and ascending order     Join a table by using a self join               Create a simple and complex view                 Track the changes to data over a period of                                                                                                4                                               Phone: 410-290-8383 / Fax: 410-290-9427
                                                                                                                                                Course Length

                                              Oracle Database 11g: SQL Tuning Workshop (ekit)                                                      3 Days

    Course Description: 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.

    Who Should Attend: This course is for Application Developers, Data Warehouse Developers, Technical Consultants, and
                       Support Engineers.

    Prerequisites:                   Students must have taken Oracle Database: Introduction to SQL.

    Benefits of Attendance: Upon completion of this course, students will be able to:
   • Identify problem SQL statements          • Understand how the Query Optimizer                          • Use optimizer hints effectively
   • Modify a SQL statement to perform at its   makes decisions about how to access                         • Generate a load test
     best                                       data
   • Trace an application                     • Interpret execution plans
    Course Outline:
   Exploring the Oracle Database Architecture                                   Star Transformation
   Oracle Database Server Architecture: Overview                                Bitmap Join Indexes
   Oracle Database Memory Structures: Overview
   Background Process Roles                                                     Optimizer Statistics
   Automatic Shared Memory Management                                           Optimizer Statistics & Types of Optimizer Statistics
   Automated SQL Execution Memory Management                                    Multicolumn Statistics: Overview
   Automatic Memory Management                                                  Expression Statistics: Overview
   Database Storage Architecture                                                Gathering System Statistics
   Logical and Physical Database Structures                                     Statistic Preferences: Overview
                                                                                Optimizer Dynamic Sampling: Overview
   Introduction to SQL Tuning                                                   Locking Statistics
   Reasons for Inefficient SQL Performance
   Performance Monitoring Solutions                                             Using Bind Variables
   Monitoring and Tuning Tools: Overview                                        Cursor Sharing and Different Literal Values
   EM Performance Pages for Reactive Tuning                                     Cursor Sharing and Bind Variables
   CPU and Wait Time Tuning Dimensions                                          Bind Variables in SQL*Plus & Enterprise Manager
   Scalability with Application Design, Implementation, and Configuration       Cursor Sharing Enhancements
   Common Mistakes on Customer Systems                                          Adaptive Cursor Sharing: Overview
   Proactive Tuning Methodology                                                 Interacting with Adaptive Cursor Sharing

   Introduction to the Optimizer                                                Using Optimizer Hints
   Structured Query Language                                                    Optimizer Hints: Overview
   SQL Statement Representation, Implementation & Processing: Overview          Types of Hints
   SQL Statement Parsing: Overview                                              Specifying Hints
   Why Do You Need an Optimizer?                                                Rules for Hints
   Optimization During Hard Parse Operation                                     Hint Recommendations
   Cost-Based Optimizer                                                         Hint Categories
   Controlling the Behavior of the Optimizer                                    Optimization Goals and Approaches
   Optimizer Features and Oracle Database Releases                              Additional Hints

   Optimizer Operators                                                          Application Tracing
   Row Source Operations                                                        End-to-End Application Tracing Challenge
   Main Structures and Access Paths                                             Location for Diagnostic Traces
   Full Table Scan                                                              What Is a Service?
   Indexes: Overview                                                            Use Services with Client Applications
   Using Indexes: Considering Nullable Columns                                  Trace Your Own Session
   Bitmap Indexes, Composite Indexes &Invisible Index                           SQL Trace File Contents
   Guidelines for Managing Indexes                                              Formatting SQL Trace Files: Overview
   Clusters                                                                     Invoking the tkprof Utility

   Interpreting Execution Plans                                                 Automating SQL Tuning
   Execution Plan                                                               Tuning SQL Statements Automatically
   Links Between Important Dynamic Performance Views                            Application Tuning Challenges
   Automatic Workload Repository (AWR)                                          SQL Tuning Advisor: Overview
   Generating SQL Reports from AWR Data                                         Stale or Missing Object Statistics
   SQL Monitoring: Overview                                                     SQL Statement Profiling
   Reading More Complex Execution Plans                                         Plan Tuning Flow and SQL Profile Creation
   Reviewing the Execution Plan                                                 Database Control and SQL Tuning Advisor
   Looking Beyond Execution Plans                                               Implementing Recommendations

   Case Study: Star Transformation
   The Star & Snowflake Schema Model
   Execution Plan Without Star Transformation
   Retrieving Fact Rows from One Dimension All Dimensions
   Joining the Intermediate Result Set with Dimensions
   Using Bitmap Join Indexes                                                  5                                     Phone: 410-290-8383 / Fax: 410-290-9427
                                                                                                                                                                       Course Length

                                        Oracle Database 11g: Administration Workshop I (ekit)                                                                                5 Days

    Course Description: 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.

    Who Should Attend: This Database for Database Administrators, Support Engineers, Developers, Technical Administrators,
                            course is
                       and            Designers.
                                    Students must have working knowledge of SQL. It is also recommended that students have taken
    Prerequisites:                  Oracle Database 11g: Introduction to SQL.

    Benefits of Attendance: Upon completion of this course, students will be able to:
   • Describe Oracle Database Architecture                 • Create and administer user accounts                           • Monitor and administer undo data
   • Install and configure Oracle Database                 • Perform basic backup and recovery of a                        • Backup and recover a database
     11g                                                     database                                                      • Monitor performance
   • Configure Oracle Net services                         • Manage users and schemas                                      • Use the database diagnostic monitor
   • Manage the database storage structures                • Manage data and concurrency
    Course Outline:
   Exploring the Oracle Database               When Not to Use a Shared Server                  Implementing Oracle Database                  Monitoring the Flash Recovery Area
   Architecture                                                                                 Security
   Oracle Database Architecture Overview       Managing Database Storage                        Industry Security Requirements                Performing Database Recovery
   Interacting with an Oracle Database         Structures                                       Principle of Least Privilege                  Opening a Database
   Process Architecture                        Storage Structures                               Monitoring for Compliance                     Data Recovery Advisor
   Database Storage Architecture               How Table Data Is Stored                         Value-Based Auditing                          Loss of a Control File
   Logical and Physical Database Structures    Anatomy of a Database Block                      Fine-Grained Auditing                         Loss of a Redo Log File
   Tablespaces and Data Files                  Space Management in Tablespaces                  DBA Auditing                                  Data Recovery Advisor
   SYSTEM and SYSAUX Tablespaces               Tablespaces in the Preconfigured Database        Security Updates                              Data Failures
   Segments, Extents, and Blocks               Actions with Tablespaces                         Applying Security Patches                     Listing Data Failures
                                               Oracle Managed Files (OMF)                                                                     Data Recovery Advisor Views
   Preparing the Database                      ASM: Concepts                                    Database Maintenance
   Environment                                                                                  Introducing Terminology                       Moving Data
   Tasks of an Oracle Database Administrator   Administering User Security                      Optimizer Statistics                          Moving Data: General Architecture
   Tools Used to Administer an Oracle          Database User Accounts                           Automatic Workload Repository (AWR)           Directory Object: Overview
     Database                                  Predefined Accounts: SYS and SYSTEM              Automatic Database Diagnostic Monitor         SQL*Loader: Overview
   Installation: System Requirements           Administrator Authentication                        (ADDM)                                     Data Pump: Overview
   Optimal Flexible Architecture (OFA)         Benefits of Roles                                Advisory Framework                            Performance Initialization Parameters
   Setting Environment Variables               Predefined Roles                                 Automated Maintenance Tasks                   Using Enterprise Manager to Monitor Data
   Oracle Universal Installer (OUI)            Implementing Password Security Features          Server-Generated Alerts                         Pump Jobs
   Database Configuration Options              Assigning Quota to Users                         Reacting to Alerts                            Data Dictionary
   Advanced Installation Options               Managing Schema Objects                          Performance Management                        Enhancing Database
   Creating an Oracle Database                 What Is a Schema?                                Performance Monitoring                        Capabilities
   Planning the Database                       Accessing Schema Objects                         Managing Memory Components                    Using EM Support Workbench
   Configuring the Listener                    Specifying Data Types in Tables                  Enabling Automatic Memory Management          Create a Service Request
   Using the DBCA to Create a Database         Creating and Modifying Tables                      (AMM)                                       Package and upload diagnostic data to
   Password Management                         Understanding Data Integrity                     Automatic Shared Memory Advisor                 Oracle Support
   Creating a Database Design Template         Indexes & Views                                  Using Memory Advisors                         Track the SR and Implement Repairs
   Using the DBCA to Delete a Database         Sequences                                        Dynamic Performance Statistics                Incident Packaging Configuration
   Using DBCA For Additional Tasks             Temporary Tables                                 Troubleshooting and Tuning Views              Working with Oracle Support
                                                                                                Invalid and Unusable Objects                  MetaLink Integration
   Managing the Oracle Instance                Managing Data and                                                                              Managing Patches
   Management Framework                        Concurrency                                      Backup and Recovery
   Oracle Enterprise Manager                   Manipulating Data Through SQL                    Concepts
   Initialization Parameter                    PL/SQL                                           Part of Your Job
   Database Startup and Shutdown               Administering PL/SQL Objects                     Statement Failure
   Shutdown Modes                              Functions, Procedures, Packages & Triggers       User Error
   Viewing the Alert History                   Data Concurrency                                 Understanding Instance Recovery
   Using Trace Files                           Enqueue Mechanism                                Phases of Instance Recovery
   Data Dictionary: Overview                   Resolving Lock Conflicts Using SQL               Using the MTTR Advisor
                                               Deadlocks                                        Media Failure
   Configuring the Oracle                                                                       Archive Log Files
   Network Environment                         Managing Undo Data
   Oracle Net Services & Listener              Data Manipulation                                Performing Database Backups
   Establishing Net Connections                Transactions and Undo Data                       Backup Solutions: Overview
   Tools for Configuring and Managing the      Undo Data Versus Redo Data                       Oracle Secure Backup
     Oracle Network                            Configuring Undo Retention                       User-Managed Backup
   Net Services Administration Pages           Guaranteeing Undo Retention                      Terminology
   Naming Methods                              Using the Undo Advisor                           Recovery Manager (RMAN)
   Directory Naming                            Viewing System Activity                          Configuring Backup Settings
   SGA and PGA                                                                                  Backing Up the Control File to a Trace File                                                                  6                                    Phone: 410-290-8383 / Fax: 410-290-9427
                                                                                                                                                                                           Course Length

                                                        Oracle Database 11g: Administration Workshop II (ekit)                                                                                5 Days

    Course Description: 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.

    Who Should Attend: This course is for Database Administrators, Support Engineers, Data Warehouse Administrators, and
                       Technical Consultants.

    Prerequisites:                                 Students should have taken Oracle Database 11g: Administration Workshop I.

    Benefits of Attendance: Upon completion of this course, students will be able to:
   • Back up and recover a database                                                                          • Use an RMAN backup to duplicate a database
   • Configure Oracle Database for optimal recovery                                                          • Automating Tasks with the Scheduler
   • Administer ASM disk groups
    Course Outline:
   Database Architecture and ASM                                          Cloning a Running Database                                 Using the Segment Advisor
   Oracle Database Architecture Overview                                                                                             Space Management: Overview
   ASM General Architecture                                               Performing Tablespace Point-in-time Recovery               Proactive Tablespace Monitoring
   Creating an ASM Instance                                               Tablespace Point-in-Time Recovery (TSPITR) Concepts        Thresholds and Resolving Space Problems
   Using Enterprise Manager to Manage ASM Users                           Tablespace Point-in-Time Recovery: Architecture            Monitoring Tablespace Space Usage
   ASM Storage Concepts                                                   Understanding When to Use TSPITR                           Shrinking Segments
   The ASMCMD Utility                                                     Determining the Tablespaces for the Recovery Set           Space Reclamation with ASSM
   ASM Scalability and Performance                                        Using Enterprise Manager to Perform TSPITR                 Automatic Segment Advisor
                                                                          Understanding TSPITR Processing                            Minimum Compatibility Level
   Configuring for Recoverability                                         Troubleshooting RMAN TSPITR
   Purpose of Backup and Recovery Functionality                                                                                      Managing Resources
   Typical Backup and Recovery Tasks                                      Monitoring and Tuning RMAN                                 Database Resource Manager: Overview
   Oracle Backup and Recovery Solutions                                   Parallelization of Backup Sets                             Database Resource Manager Concepts
   Using Recovery Manager (RMAN)                                          Monitoring RMAN Sessions                                   Accessing Resource Plans
   Using a Flash Recovery Area                                            Interpreting RMAN Message Output                           Default Maintenance Resource Manager Plan
   Flash Recovery Area Space Management                                   Using the DEBUG Option                                     Creating Consumer Groups
                                                                          Tuning RMAN                                                Resource Allocation Methods for Resource Plans
   Using the RMAN Recovery Catalog                                        RMAN Multiplexing                                          Resource Allocation Methods for Resource Plans
   RMAN Repository Data Storage: Comparison of Options                    Comparing Synchronous and Asynchronous I/O                 Monitoring the Resource Manager
   Storing Information in the Recovery Catalog                            Tape Subsystem Performance Rules
   Registering a Database in the Recovery Catalog                                                                                    Automating Tasks with the Scheduler
   Recovery Catalog Resynchronization: Concepts                           Using Flashback Technology                                 Simplifying Management Tasks
   Using RMAN Stored Scripts                                              Flashback Technology                                       Key Components and Steps
   Backing Up and Recovering the Recovery Catalog                         Transactions and Undo                                      Creating an Event-Based Schedule
   Using a Virtual Private Catalog                                        Guaranteeing Undo Retention                                Creating Complex Schedules
                                                                          Preparing Your Database for Flashback                      Creating Job Chains
   Configuring Backup Specifications                                      Flashback Drop and the Recycle Bin                         Creating Job Chains
   Using RMAN to Create Backups                                           Using Flashback Technology to Query Data
   Configuring Persistent Settings for RMAN                               Possible Workflow                                          Administering the Scheduler
   Using Enterprise Manager to Configure RMAN Settings                    Flashback Transaction Wizard                               Advanced Scheduler Concepts
   Control File Auto-backups                                                                                                         Job Classes
   Managing Persistent Settings                                           Using Flashback Database                                   Windows
   Configuring Devices for Backup                                         Flashback Table                                            Prioritizing Jobs Within a Window
   Configuring and Allocating Channels for Use in Backups                 Enabling Row Movement on a Table                           Remote Jobs
   Configuring Backup Optimization                                        Enabling Row Movement on a Table                           Installing the Scheduler Agent
                                                                          Flashback Database Architecture                            Dictionary Views Supporting Remote Jobs
   Creating Backups                                                       Configuring Flashback Database
   Creating an Oracle-Suggested Backup                                    Performing Flashback Database Using EM                     Globalization
   Creating Backup Sets & Image Copies                                    Flashback Database Considerations                          Globalization Support Features
   Creating a Whole Database Backup                                       Flashback Data Archive                                     What Every DBA Needs to Know
   RMAN Backup Types                                                                                                                 Understanding Unicode
   Monitoring Block Change Tracking                                       Diagnosing the Database                                    Database Character Sets and National Character Sets
   Creating Duplex Backup Sets                                            Automatic Diagnostic Workflow & Repository                 Language- and Territory-Dependent Parameters
   Archival Backups: Concepts                                             Location for Diagnostic Traces                             Linguistic Searching and Sorting
   Encrypting Backups                                                     Viewing the Alert Log Using Enterprise Manager             Case- and Accent-Insensitive Search and Sort
                                                                          The Support Workbench and Oracle Configuration Manager     NLS Data Conversion with Oracle Utilities
   Performing User-Managed Backup and Recovery                            Create a Service Request
   Restoring and Recovering                                               Package and upload diagnostic data to Oracle Support
   Causes of File Loss                                                    Incident Packaging Configuration
   Critical Versus Non-critical                                           Health Monitor Overview & Data Recovery Advisor
   Recovering from a TEMPFILE Loss
   Re-creating Indexes                                                    Managing Memory
   Recovering from a Lost Index Tablespace                                Oracle Memory Structures
   Authentication Methods for Database Administrators                     Automatic Memory Management Overview
   Recovering a Read-Only Tablespace                                      Oracle Database Memory Parameters
                                                                          Auto Memory Parameter Dependency
   Using RMAN to Perform Recovery                                         Automatic Shared Memory Management: Overview
   Using RMAN RESTORE and RECOVER Commands                                Automatic PGA Memory Management
   Performing Recovery Using Enterprise Manager                           Using the Memory Advisor to Size the SGA
   Recovery Using Incrementally Updated Backups                           Memory Tuning Guidelines for the Library Cache
   Perform a Fast Switch to Image Copies
   Restoring and Recovering the Database on a New Host                    Managing Database Performance
   Performing Disaster Recovery                                           Tuning Activities
                                                                          Performance Planning & Performance Tuning Methodology
   Using RMAN to Duplicate a Database                                     Instance Tuning
   Using RMAN to Create a Duplicate Database                              Troubleshooting and Tuning Views
   Creating a Duplicate Database                                          Automatic Workload Repository
   Creating an Initialization Parameter File for the Auxiliary Instance   SQL Tuning & SQL Advisors
   Allocating Auxiliary Channels                                          Using the SQL Tuning Advisor
   Understanding the RMAN Duplication Operation                           SQL Access Advisor: Overview
   Using EM to Clone a Database                                                                                    7                        Phone: 410-290-8383 / Fax: 410-290-9427
                                                                                                                                                              Course Length
                                              Oracle Database 11g: New Features for                                                                                  5 Days
                                                       Administrators (ekit)                                                                                  TE1963_20080611

    Course Description: 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.

    Who Should Attend: This course is for Data Warehouse Administrators, Technical Consultants, Support Engineers, and
                       Database Administrators.
                         Students must thoroughly understand Oracle Database 10g concepts and have taken Oracle Database
    Prerequisites:       10g: New Features for Administrators Release 2 and Oracle Database 10g: Administration Workshop II
   Release 2 courses or have equivalent knowledge.

    Benefits of Attendance: Upon completion of this course, students will be able to:
   • Use the SQL Performance Analyzer       • Use the automatic database diagnostic                               • Manage a flashback data archive
   • Upgrade your database to 11g Release 1 monitor                                                               • Use the data recovery advisor
   • Record and replay workloads            • Explore advanced RMAN capabilities                                  • Setup and use ASM
    Course Outline:
   Installation and Upgrade Enhancements                 DBA Controls                                                Ease Diagnosis: Automatic Diagnostic Workflow
   Oracle Database 11g Installation: Changes             Automatic SQL Tuning Task                                   Automatic Diagnostic Repository
   Oracle Database 11g: Software Installation            Automatic SQL Tuning: Fine Tune                             Location for Diagnostic Traces
   Oracle Database Upgrade Enhancements                  Automatic SQL Tuning Considerations                         Incident Packaging Service (IPS)
   Upgrade Performance Enhancement                                                                                   EM Support Workbench: Overview
   Upgrade Process                                       Intelligent Infrastructure Enhancements                     Health Monitor: Overview
   Oracle Database 11g Release 1: Upgrade Paths          Automatic Workload Repository Baselines                     Data Recovery Advisor
   Database Upgrade Assistant (DBUA)                     Performance Monitoring and Baselines
   Hot Patching: Overview                                Automated Maintenance Tasks                                 Using the Data Recovery Advisor
                                                         Resource Manager: New EM Interface                          Repairing Data Failures
   Storage Enhancements                                                                                              Data Recovery Advisor
   ASM Fast Mirror Resync: Overview                      Performance Enhancements                                    Data Recovery Advisor RMAN Command-Line Interface
   ASM Preferred Mirror Read: Overview                   ADDM Enhancements in Oracle Database 11g                    Best Practice: Proactive Checks
   ASM Scalability and Performance Enhancements          Oracle Database 11g: Automatic Database Diagnostic          Setting Parameters to Detect Corruption
   ASM Scalability in Oracle Database 11g                  Monitor for RAC
   ASM Disk Group Compatibility                          New ADDM Views                                              Security: New Features
   ASMCMD Extensions                                     Automatic Memory Management: Overview                       Secure Password Support
                                                         Oracle Database 11g Memory Parameters                       Automatic Secure Configuration
   Change Management Unit Overview                       Automatic Memory Parameter Dependency                       Managing Default Audits
   Change Management in Oracle Database 11g              Monitoring Automatic Memory Management                      Setting Database Administrator Authentication
   Challenges Faced by DBAs When Performing Changes                                                                  Transparent Data Encryption
   Lifecycle of Change Management                        Partitioning and Storage-Related                            Hardware Security Module
   Setting Up a Test Environment by Using the Snapshot   Enhancements                                                Using RMAN Security Enhancements
      Standby Database                                   Oracle Partitioning
   SQL Performance Analyzer: Overview                    Partitioning Enhancements                                   Oracle SecureFiles
   Capturing the SQL Workload                            Interval Partitioning                                       Managing Enterprise Information
   SQL Performance Analyzer: Data Dictionary Views       System Partitioning                                         Problems with Existing LOB Implementation
                                                         Virtual Column–Based Partitioning                           Oracle SecureFiles
   SQL Plan Management                                   Reference Partitioning                                      Shared I/O Pool
   SQL Plan Management: Overview                         Table Compression: Overview                                 Altering SecureFiles
   SQL Plan Baseline: Architecture                       SQL Access Advisor: Overview                                Accessing SecureFiles Metadata
   Evolving SQL Plan Baselines                                                                                       Migrating to SecureFiles
   SQL Plan Selection                                    Using RMAN Enhancements                                     SecureFiles Monitoring
   Possible SQL Plan Manageability Scenarios             RMAN: New Features
   SQL Performance Analyzer and SQL Plan Baseline        Optimized Backups                                           Miscellaneous New Features
     Scenario                                            Parallel Backup and Restore for Very Large Files            Foreground Statistics
   Loading a SQL Plan Baseline Automatically             Using RMAN Multisection Backups                             Online Redefinition Enhancements
   Purging SQL Management Base Policy                    Duplicating a Database                                      Minimizing Dependent Recompilations
                                                         Managing Recovery Catalogs                                  Locking Enhancements
   Database Replay                                       Creating and Using Virtual Private Catalogs                 Invisible Index: Overview
   System Architecture: Capture                          Using RMAN Virtual Private Catalogs                         SQL Query Result Cache: Overview
   System Architecture: Processing the Workload                                                                      Adaptive Cursor Sharing: Overview
   System Architecture: Replay                           Using Flashback and LogMiner                                Temporary Tablespace Shrink
   Pre-Change Production System                          New and Enhanced Features for Flashback and LogMiner
   Supported Workloads                                   Flashback Data Archive Overview: “Oracle Total Recall”
   Database Replay Workflow in Enterprise Manager        Flashback Data Archive: Architecture
   Using the Capture Wizard                              Flashback Data Archive: Workflow
   Packages and Procedures                               Guidelines and Usage Tips
                                                         Flashback Transaction Backout
   Automatic SQL Tuning                                  Flashback Transaction Wizard
   Automatic SQL Tuning in Oracle Database 11g           Using LogMiner
   Selecting Potential SQL Statements for Tuning
   Maintenance Window Timeline                           Diagnosability Enhancements
   Automatic Tuning Process                              Oracle Database 11g R1 Fault Management                                                           8                                Phone: 410-290-8383 / Fax: 410-290-9427
                                                                                                                                          Course Length

                                        Oracle Database 11g: Performance Tuning (ekit)                                                          5 Days

    Course Description: 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.

    Who Should Attend: This course is for Database Administrators, Support Engineers, and Technical Consultants.

                                 Students should have taken Oracle Database 11g: Administration Workshop I and Oracle Database
    Prerequisites:               11g: Administration Workshop II.

    Benefits of Attendance: Upon completion of this course, students will be able to:
   • Use Database Statistics and Metrics to      • Identify and eliminate performance        • Identify problem SQL statements
     identify a performance problem                issues                                    • Influence the optimizer
   • Interpret Tuning diagnostics                • Set tuning priorities and strategies
    Course Outline:
   Introduction                                   Using AWR Based Tools                         Performance Tuning: Summary
   Tuning Questions                               Automatic Maintenance Tasks                   Important Initialization Parameters with Performance Impact
   Who tunes                                      Using ADDM                                    Database High Availability: Best Practices
   What to tune                                   Using Active Session History                  Tablespace: Best Practices
   How to tune                                    Historical Data View                          Statistics Gathering
   Monitoring With Basic Tools                    Monitoring an Application (Using              Using Statspack
   Monitoring tools overview                      Services)                                     Introduction to Statspack
   Enterprise Manager                             Service Overview                              Capturing Statspack Snapshots
   V$ views, Statistics and Metrics               Managing Service                              Reporting with Statspack
   Wait Events                                    Service Aggregation and Tracing               Statspack considerations
   Time Model: Overview                           Tracing Your Session                          Statspack and AWR
   Using Automatic Workload Repository            Baselines
   Automatic Workload Repository: Overview        Working with Metric Baselines
   Automatic Workload Repository Data             Setting Adaptive Alert Thresholds
   Database Control and AWR                       Configuring Normalization Metrics
   Generating AWR Reports in SQL*Plus
                                                  Tuning the Shared Pool
   Identifying the Problem                        Shared Pool Operation
   Tuning Life Cycle Phases                       Mutex
   Identify a Tuning Issue                        Statspack/AWR Indicators
   Remedy one problem                             Library Cache Activity
                                                  Diagnostic Tools
   Identifying Problem SQL Statements             UGA and Oracle Shared Server
   Characteristics of a bad SQL statement         Large Pool
   Role of the Optimizer
   Generate explain plan                          Tuning the Buffer Cache
   Access Paths Choices                           Architecture
   Trace the execution                            Tuning Goals and Techniques
   Influencing the Optimizer                      Solutions
   Manage Optimizer Statistics
   Calibrate I/O                                  Tuning PGA and Temporary Space
   Optimizer Cost                                 Monitoring SQL Memory Usage
   Changing Optimizer Behavior                    Temporary Tablespace Management
   SQL Plan Management                            Automatic Memory Management
   Automatic Maintenance Tasks                    Automatic Memory Management Architecture
   SQL Profiles                                   Dynamic SGA Feature
   SQL Access Advisor                             Managing Automatic Memory Management
   SQL Outlines
   SQL Plan Baselines                             Tuning Block Space Usage
                                                  Space Management
   Change Management                              Extent Management
   Types of changes                               Anatomy of a Database Block
   SQL Performance Analyzer                       Block Space Management
   DB Replay
   Server-Generated Alerts                        Tuning I/O
                                                  I/O Architecture
   Using Metrics and Alerts                       Striping and Mirroring
   Benefits of Metrics                            Using RAID
   Database Control Usage Model                   I/O Diagnostics
   User-Defined SQL Metrics                       Using Automatic Storage Management                                                    9                  Phone: 410-290-8383 / Fax: 410-290-9427
                                                                                                                                              Course Length

                                               Oracle Database 11g: Backup & Recovery (ekit)                                                     5 Days

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

    Who Should Attend: This course is for students interested in safeguarding Oracle 11g databases.

                                   Students should have taken Oracle Database 11g: Administration Workshop I and Oracle Database
    Prerequisites:                 11g: Introduction to SQL or have equivalent real-world experience.

    Benefits of Attendance: Upon completion of this course, students will be able to:
   • Use Oracle flashback technology to recover from user errors and from database failures, including flashback data archive and
     flashback transaction backout along with the Total Recall capability.
   • Use advanced Enterprise Manager wizards and tools, including the integrated LogMiner, Flashback Transaction Backout wizard,
     database Recovery Wizard, Recovery Advisor interface, and others.
   • Setup database instance recovery, tuning checkpoints, the Redo Log File Size Advisor, and the MTTR Advisor.
   • Implement User-managed recovery scenarios, including recovery from temporary, read-only, and index tablespaces.
   • Implement automatically managed backup strategies and database recovery operations using RMAN and other database facilities.
   • Build upon basic RMAN capabilities with a centralized recovery catalog.
   • Deploy standardized and consistent backup and recovery procedures throughout the enterprise by means of dynamic stored scripts
     and variable substitution.
   • Optimize backups for faster performance and parallelization of operations, employing compression algorithms and other strategies for
   • Set up data preservation through archival backups.
   • Implement security through transparent and explicit encryption features.
   • Duplicate databases for regulatory compliance, Real Application Testing database replay, test configuration, and other purposes.
    Course Outline:
   Recovery Concepts                                  Performing Incremental Backups               Enhancing Parallelism With Section Sizes
   About The Backup & Recovery Structures             Establishing A Backup Retention Policy       Archival Backups
   Managing Redo Data                                 Generate Reports                             Backup Set Encryption
   Managing Archived Redo Data                        Report Unrecoverable                         Copying Files Between Databases
   Creating A Foundation For Sound Recovery           Report Need Backup
                                                      List Incarnation                             Transporting Tablespaces
   Oracle Flashback Technology                                                                     About Tablespace Transportation
   About Flashback Technology                         RMAN Management With EM                      Read-Only Tablespace Transportation
   Flashback Query                                    Monitoring The Flash Recovery Area           Read-Write Tablespace Transportation
   Select...As Of Timestamp                           The EM Interface To RMAN                     Transport Tablespaces Using EM
   Select...As Of SCN                                 Scheduling RMAN Backups
   Configuring Undo Management For Flashback          Using The Oracle-Suggested Backup Strategy   Recovering From Corruption With Data
   Undo_Retention                                     Manage Current Backups                       Recovery Advisor
   Flashback Table                                    Backup Reports                               How Does Corruption Occur?
   Flashback Drop                                     Manage Restore Points                        Detecting Corruption
   Flashback Versions Query                                                                        Analyze
   Flashback Transaction Query                        User-Managed Recovery Operations             V$Database_Block_Corruption View
   Flashback Transaction Backout                      Recovery Concepts                            Db_Block_Checking
                                                      Recover Temporary Tablespaces                Db_Block_Checksum
   Flashback Database                                 Recover Read-Only Tablespaces                Db_Lost_Write_Protect
   About Flashback Database                           Recover Index Tablespaces                    Db_Ultra_Safe
   Configuring The Flash Recovery Area                Recover Redo Log Group Member                Recovery Using The Data Recovery Advisor
   Performing Database Flashback                      Recreate The Password File                   Block Media Recovery
   Monitoring Flashback Performance                                                                Isolating Corruption With Dbms_Repair()
   Flashback Database Considerations                  Recovery With RMAN
   Configure Flashback Data Archive                   Complete Media Recovery                      Conclusion
                                                      Incomplete Media Recovery
   Instance Recovery                                  Recovery Using EM
   About Instance Recovery
   Instance Recovery Parallelism                      Using The RMAN Recovery Catalog
   Mttr Advisor & Tuning Checkpoints                  Understanding Catalog Concepts
   Log_Checkpoints_To_Alert                           Create The Recovery Catalog
   Redo Logfile Size Advisor                          Manage Virtual Private Catalogs
   Fast-Start On-Demand Parallelism                   Data Protection Of The Recovery Catalog
                                                      Using RMAN Scripts
   Configuring RMAN
   RMAN Architecture                                  Database Duplication & Cloning
   Launch & Use RMAN                                  Why Perform Database Duplication?
   Configure RMAN Settings                            RMAN Duplicate Database
   Allocate RMAN Channels                             RMAN Duplicate
                                                      Database Cloning
   Backup With RMAN
   About Backup File Types                            Advanced RMAN Capabilities
   Performing Full Backups                            Backup Optimization                                                       10                 Phone: 410-290-8383 / Fax: 410-290-9427
                                                                                                                                                                        Course Length

                                                    Oracle Database 11g: Security (ekit)                                                                                      5 Days

    Course Description: 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.

    Who Should Attend: This course is for Security Compliance Professionals, Database Administrators, Security
                       Administrators, and Security Compliance Auditors.

    Prerequisites:                    Students must have taken Oracle Database 11g: Administration Workshop I.

    Benefits of Attendance: Upon completion of this course, students will be able to:
   • Use database security features          • Manage secure application roles                                              • Use Transparent Data Encryption
   • Secure the database and its listener    • Implement fine-grain access control
   • Manage users using proxy authentication • Implement fine-grain auditing
    Course Outline:
   Security Requirements                           User Identified by a Password                 Implementing Virtual Private               Transparent Data Encryption overview
   Data Security Concerns                          User Identified Externally                    Database                                   Components of Data Encryption
   Fundamental Data Security Requirements          Protecting Passwords                          Understanding Fine Grain Access Control    Using Data Encryption
   Components for enforcing security               Encrypted Database Link Passwords             Virtual Private Database                   Using Hardware Security Modules
   Security Risks: Internal, External, Sabotage,   Audit with Database Links                     Implementing VPD Policies                  Tablespace Encryption
     Recovery                                                                                    Manage VPD Policies
   Principle of Least Privilege                    Using Strong Authentication                   Policy Performance                         Use File Encryption
   Defining a Security policy                      Strong User Authentication                    Checking for Policies Applied to SQL       RMAN Encrypted Backups
   Implementing a Security Policy                  Single Sign-On                                  Statements                               Oracle Secure Backup Encryption
                                                   How to Use Certificates for Authentication                                               Using Transparent Mode Encryption
   Choosing Security Solutions                     Configuring SSL                               Oracle Label Security                      Using Password Mode Encryption
   Maintaining data integrity                      orapki Utility                                Concepts                                   Using Dual Mode Encryption
   Controlling data access                         How to Use Kerberos for Authentication        Access Control: Overview                   Restoring encrypted backups
   Data Protection                                 RADIUS Authentication: Overview               Discretionary Access Control
   Database Vault overview                         External Secure Password Store                Oracle Label Security                      Oracle Net Services Security
   Audit Vault overview                                                                          Comparing Oracle Label Security and the    Checklist
   Combining Optional Security Features            Enterprise User Security                        VPD                                      Security Checklists Overview
   Compliance Scanner                              Setting up Enterprise User Security                                                      Client Checklist
   Database Control: Policy Trend                  Oracle Identity Management Infrastructure:    Implementing Oracle Label                  Network Security Checklist
                                                     Default Deployment                          Security                                   Restricting Network IP Addresses
   Basic Database Security                         Oracle Database: Enterprise User Security     Policy Enforcement Options                 Restricting Open Ports
   Database Security Checklist                       Architecture                                Managing levels, groups, compartments      Encrypting Network Traffic
   Installing only what is required                Authenticating Enterprise Users               Administering Labels                       Configure Checksumming
   Applying Security Patches                       User Migration Utility                        Trusted Stored Package Units               Oracle Net Services Log Files
   11g Default security settings                   Enterprise-User Auditing                      Performance tips
   Enforcing Password Management                                                                                                            Securing the Listener
   System and Object Privileges                    Proxy Authentication                          Using the Data Masking Pack                Listener Security Checklist
   Restricting the Directories Accessible by the   Security Challenges of Three-Tier             Understanding Data Masking                 Restricting the Privileges of the Listener
     User                                            Computing                                   Identifying Sensitive Data for Masking     Password Protect the Listener
   Separation of Responsibilities                  Common Implementations of Authentication      Implementing Data Masking                  Administering the Listener Using TCP/IP
                                                   Restrict the Privileges of the Middle Tier    Data Masking Impact Report                   with SSL
   Database Auditing                               Using Proxy Authentication for Database                                                  Analyzing Listener Log Files
   Standard Database Auditing                        Users                                       Encryption Concepts
   Monitoring for Suspicious Activity              Using Proxy Authentication for Enterprise     Understanding encryption
   Audit Log Location Options                        Users                                       Cost of encryption
   Viewing Auditing Results                        Revoking Proxy Authentication                 Encryption is not Access Control
   Configure Auditing to syslog                    Data Dictionary Views for Proxy               Data Encryption Challenges
   Value-Based Auditing                              Authentication                              Encryption Key Management
   Triggers and Autonomous Transactions                                                          Solutions and examples
                                                   Authorization Methods
   Auditing DML Statements                         Authorization                                 Using Application Based
   (Fine-Grained Auditing)                         Assigning Privileges                          Encryption
   Fine-Grained Auditing (FGA)                     Using Enterprise roles                        Overview
   Fine-Grained Auditing Policy                    Implementing a Secure Application Role        The DBMS_CRYPTO Package
   Triggering Audit Events                                                                       Generate Keys Using RANDOMBYTES
   Data Dictionary Views                           Using Application Context                     Using ENCRYPT and DECRYPT
   Enabling and Disabling an FGA Policy            Application Context Overview                  Enhanced Security Using the Cipher Block
   FGA Policy Guidelines                           Implementing a Local Context                    Modes
   Maintaining the Audit Trail                     Application Context Accessed Globally         Hash and Message Authentication Code
   Basic User Authentication                                                                     Applying Transparent Data
   User Authentication                                                                           Encryption                                                                      11                                  Phone: 410-290-8383 / Fax: 410-290-9427
                                                                                                                                    Course Length

                                                 Introduction to MySQL/PHP                                                              5 Days

    Course Description: 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.

    Who Should Attend: This course developing using a three tier architecture (Client, Middle, and Database).GUI and want to
                                   is designed for individuals who have been developing web pages with a
                       progress to

    Prerequisites:             Students should have a firm understanding of HTML/XHTML tags and a programming background.

    Benefits of Attendance: Upon completion of this course, students will be able to:
   • develop three tier applications utilizing: a web browser to display HTML/XHTML code at the Client tier for input and output; PHP
     scripting language for the Middle tier to tie together the application, and SQL and MySQL for the Database tier. This skills set moves
     a company's web page from simple display and data gathering to a more personalized, structured, and automated application.
    Course Outline:
   Discussion of Three Tier Architecture
   Client tier
   Middle tier
   Database tier
   Overview of the Case Study - The Winestore
   Populating Web pages from a database
   User-driven queries/browse
   Data Entry and Validation
   User Authentication and Management
   Learning PHP
   PHP Basics
   Conditions and Branches
   Variables and Arrays
   MySQL databases
   Database Basics
   Loading a Database
   MySQL command Interpreter
   Creating a database
   Modifying a database
   Administering a database
   Developing an application using PHP and MySQL
   The Winestore
   MySQL functions in PHP
   Querying a database
   User-Driven Querying
   Previous and Next Browsing
   Inserts, Updates, and Deletes
   User Authentication and Management
   Ordering and Shipping                                               12                          Phone: 410-290-8383 / Fax: 410-290-9427
                                                                                                                                 Course Length
                                            Building and Securing Web Applications                                                   5 Days
                                                     Using MySQL and PHP                                                         TE6103_20081030

    Course Description: 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.

    Who Should Attend: Thiscontent is designed for the Web developer who is ready to take theirpersonal and a notch. By tying
                            course                                                              web page up
                       the         of the page to a database, the user experiences a more                   richly rewarding
   interaction, and the developer knows their data is secure during this interaction.

    Prerequisites:                   Students should have taken Introduction to PHP Programming.

    Benefits of Attendance: Upon completion of this course, students will be able to:
   • Design dynamic web pages linked to a database.                      • Troubleshoot the design process.
   • Process and evaluate PHP error messages.                            • Secure their system.
    Course Outline:
   Creating a User Interface                                               Using a Named Session
   Determine the purpose of your page                                      Cleaning up after a Session
   Knowing your user
   Design and layout
   What tools you will use
   Helping users
   Database Access with PHP
   Connecting to a database
   Creating a database query
   Displaying data
   Inserting, Deleting, and updating data
   Using transactions
   Closing database connections
   Error Handling and Debugging
   Sources of errors
   How errors are output
   PHP error codes
   Working with errors
   Php.ini settings for Error handling
   Exception error handling
   Debugging techniques
   Designing for security
   Identifying threats
   Securing PHP source code
   Securing SQL on input
   Securing server access
   Data validation
   PHP string cleaning functions
   Validation with Regular Expressions
   Accessing files and directories
   Opening files
   Reading files
   Writing to files
   Closing files
   Changing permissions
   Reading directory contents
   Security considerations
   Uploading/Downloading files
   How uploading works
   Configuring PHP for uploading
   Modifying Forms to allow uploading
   Error codes for file uploads
   Limiting upload file size
   Security considerations
   Cookies and Session Management
   How cookies work
   How Sessions work
   Controlling a Session                                               13                              Phone: 410-290-8383 / Fax: 410-290-9427
                                                                                                                                               Course Length
                                           High Performance MySQL: Optimization,                                                                  5 Days
                                                  Backups, and Replication                                                                     TE6104_20120305

    Course Description: 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.

    Who Should Attend: This applications, new for experienced usersare familiar with the well-tuned MySQL-based applications
                            course is for     users of MySQL who                         server and are ready to write their first
                       real               and                       who already have
   but need to get "a little more" out of them.

    Prerequisites:                    Students should have previous experience writing MySQL-based applications.

    Benefits of Attendance: Upon completion of this course, students will be able to:
   • Utilize advanced techniques to bring out MySQL's full power
   • Design schemas, indexes, queries and advanced MySQL features for maximum performance
   • Tune MySQL servers, operating systems, and hardware to their fullest potential
   • Scale applications with replication, load balancing, high availability, and failover in a practical, safe, high-performance way
    Course Outline:
   MySQL Architecture                                                                                        Account Basics
   MySQL's Logical Architecture                         Operating System and Hardware                        Operating System Security
   Concurrency Control                                  Optimization                                         Network Security
   Transactions                                         What Limits MySQL's Performance?                     Data Encryption
   Multiversion Concurrency Control                     How to Select CPUs for MySQL                         MySQL in a chrooted Environment
   MySQL's Storage Engines                              Balancing Memory and Disk Resources
                                                        Choosing Hardware for a Slave                        MySQL Server Status
   Finding Bottlenecks: Benchmarking and                RAID Performance Optimization                        System Variables
   Profiling                                            Storage Area Networks and Network-Attached Storage   SHOW STATUS
   Why Benchmark?                                       Using Multiple Disk Volumes                          SHOW INNODB STATUS
   Benchmarking Strategies                              Network Configuration                                SHOW PROCESSLIST
   Benchmarking Tactics                                 Choosing an Operating System                         SHOW MUTEX STATUS
   Benchmarking Tools                                   Choosing a Filesystem                                Replication Status
   Benchmarking Examples                                Threading                                            INFORMATION_SCHEMA
   Profiling                                            Swapping
   Operating System Profiling                           Operating System Status                              Tools for High Performance
                                                                                                             Interface Tools
   Schema Optimization and Indexing                     Replication                                          Monitoring Tools
   Choosing Optimal Data Types                          Replication Overview                                 Analysis Tools
   Indexing Basics                                      Setting Up Replication                               MySQL Utilities
   Indexing Strategies for High Performance             Replication Under the Hood                           Sources of Further Information
   An Indexing Case Study                               Replication Topologies
   Index and Table Maintenance                          Replication and Capacity Planning                    Appendix A. Transferring Large Files
   Normalization and Denormalization                    Replication Administration and Maintenance           Copying Files
   Speeding Up ALTER TABLE                              Replication Problems and Solutions                   File Copy Benchmarks
   Notes on Storage Engines                             How Fast Is Replication?                             Appendix B. Using EXPLAIN
                                                        The Future of MySQL Replication
   Query Performance Optimization                                                                            Invoking EXPLAIN
   Slow Query Basics: Optimize Data Access              Scaling and High Availability                        The Columns in EXPLAIN
   Ways to Restructure Queries                          Terminology                                          Visual EXPLAIN
   Query Execution Basics                               Scaling MySQL                                        Appendix C. Using Sphinx with MySQL
   Limitations of the MySQL Query Optimizer             Load Balancing                                       Overview: A Typical Sphinx Search
   Optimizing Specific Types of Queries                 High Availability                                    Why Use Sphinx?
   Query Optimizer Hints
                                                        Application-Level Optimization                       Architectural Overview
   User-Defined Variables
                                                        Application Performance Overview                     Special Features
   Advanced MySQL Features                              Web Server Issues                                    Practical Implementation Examples
   The MySQL Query Cache                                Caching                                              Conclusion
   Storing Code Inside MySQL                            Extending MySQL                                      Appendix D. Debugging Locks
   Cursors                                              Alternatives to MySQL                                Lock Waits at the Server Level
   Prepared Statements
                                                        Backup and Recovery                                  Lock Waits in Storage Engines
   User-Defined Functions
   Views                                                Overview
   Character Sets and Collations                        Considerations and Tradeoffs
   Full-Text Searching                                  Managing and Backing Up Binary Logs
                                                        Backing Up Data
   Optimizing Server Settings                           Recovering from a Backup
   Configuration Basics                                 Backup and Recovery Speed
   General Tuning                                       Backup Tools
   Tuning MySQL's I/O Behavior                          Scripting Backups
   Tuning MySQL Concurrency
   Workload-Based Tuning                                Security
   Tuning Per-Connection Settings                       Terminology                                                         14                         Phone: 410-290-8383 / Fax: 410-290-9427
                                                                                                                               Course Length

                                           SQLite 3 with PHP Essential Training                                                       5 Days

    Course Description: 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.

    Who Should Attend: This course is for developers who wish to learn SQLite.

    Prerequisites:                 Students should be experienced developers.

    Benefits of Attendance: Upon completion of this course, students will be able to:
   • Maintain localized storage in a single file that requires no      • Work with SQLite using a scripting language or a C-based
     configuration                                                       language such as C# or Objective-C
   • Build a personalized SQLite library or use a precompiled          • Understand the basics of database design, and learn how to
     distribution in applications                                        transfer what you already know to SQLite
   • Use several language functions and extensions                     • Take advantage of virtual tables and modules
    Course Outline:
   What is SQLite?
   Self-Contained, No Server Required
   Single File Database
   Zero Configuration
   Embedded Devivce Support
   Unique Features
   Compatible License
   Highly Reliable
   Uses of SQLite
   Building and Installing SQLite
   The SQL Language
   The SELECT Command
   Database Design
   C Programming Interface
   Additional Features and APIs
   SQL Functions and Extensions
   Virtual Tables and Modules                                             15                        Phone: 410-290-8383 / Fax: 410-290-9427

To top