Oracle9i Training and Seminars

Oracle Database 9i 2 day DBA Full 2 days DBA courseware of Oracle 9i database Installing Oracle Creating database Managing users Managing controlfile Managing tablespace, tables, indexes Managing security Managing redo log files Configuration of server with listener Configuration of client with tns names Managing networking of Oracle User Managed cold backup User managed hot backup Recovery principal Tuning of  more...

Oracle9i SQL: Basic SELECT Statements This course covers relational database principles and Oracle concepts; writing basic SQL statements; restricting and sorting data; and using single-row functions. Additionally this course provides an introduction to relational database concepts and the use of SQL for storing retrieving and manipulating data in a relational database.  more...

Oracle9i SQL: Data Retrieval Techniques This course covers joins group functions subqueries and the iSQL*Plus report variables. Additionally this course shows students how to access data from multiple table using joins aggregate data using group functions create subqueries and use iSQL*Plus commands to create customized queries.  more...

Oracle9i SQL: DML and DDL The Oracle SQL DML and DDL course is the third in a three-part series covering the Data Manipulation and Data Definition language statements supported by Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create update and delete the database objects. The participants also learn to add rows update and delete existing rows from a table.  more...

Oracle 9iAS: Discoverer Plus for End Users This course introduces students to the querying and analytical capabilities of Oracle Discoverer4i Plus. Students learn how to create modify run and refine ad hoc queries using multidimensional data. Students also learn how to create edit and customize graphs to analyze data.  more...

Oracle9i New Features: Database Administration This course introduces learners to the Oracle9i enhancements in server-side manageability Oracle Enterprise Manager and globalization.  more...

Oracle9i Database Administration: Manage an Instance ...Oracle9i Database Administration: Manage An Instance course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle9i. This course introduces the participants to the concepts and procedures associated with Oracle architectural components. The participants learn the various tasks of a database administrator that are performed by using  more...

Oracle9i Database Administration: Create a Database ...Oracle9i Database Administration: Create a Database course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle9i. Participants learn about the concepts associated with storage structure components management of rollback segments temporary segments and indexes. In addition this course discusses how to create and maintain  more...

Oracle9i Database Administration: Manage Storage Structures The Oracle 9i Database Administration: Manage Storage Structures course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course participants learn the concepts associated with storage structure components. In addition this course teaches users the procedures for managing segment free space undo space temporary segments  more...

Oracle9i Database Administration: Manage Data Storage This course is the fourth in the series covering the database administration strategies and procedures provided in Oracle9. This course covers the concepts associated with tables maintaining data integrity clusters and index-organized tables and methods for loading and reorganizing data.  more...

Oracle9i Database Administration: Manage Security This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course you will learn the concepts and methods associated with implementing security and resource consumption in an Oracle9i database.  more...

Oracle9i Database Administration: Strategies and Backups ...Oracle9i database administration. The backup concepts covered by this course include backup strategies and requirements Oracle Architecture archiving data backup methods and working with a standby database. Students perform backup procedures using operating system utilities Oracle9i utilities such as RMAN standard SQL*Plus commands and the Oracle Enterprise Manager Console. Students assess the  more...

Oracle9i Database Administration: Recover Databases ...Oracle9i database recovery concepts. The recovery concepts course includes recovery with and without archiving recovery of offline and online databases recovery with missing data files and incomplete recovery with and without archiving. Additional concepts covered by this course include time-based recovery cancel-based recovery recovery manager components recovery manager commands export and  more...

Oracle9i Database Administration: Set Up Oracle Net Services This course covers the architecture and configuration of Oracle Net Services. It details client-server and web implementations in addition to additional features such as Dynamic Service Registration and the use of the Oracle Names Server as an LDAP Proxy. This course also discusses the configuration of the Oracle Shared Server and Oracle Names Server.  more...

Oracle9i SQL: Basic SELECT Statements This course covers relational database principles and Oracle concepts; writing basic SQL statements; restricting and sorting data; and using single-row functions. Additionally, this course provides an introduction to relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database.  more...

Oracle9i SQL: Data Retrieval Techniques This course covers joins, group functions, subqueries, and the iSQL*Plus report variables. Additionally, this course shows students how to access data from multiple table using joins, aggregate data using group functions, create subqueries, and use iSQL*Plus commands to create customized queries.  more...

Oracle9i SQL: DML and DDL The Oracle SQL DML and DDL course is the third in a three-part series covering the Data Manipulation and Data Definition language statements supported by Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create, update, and delete the database objects. The participants also learn to add rows, update, and delete existing rows from a table.  more...

Oracle9i Database Administration: Manage an Instance ...Oracle9i Database Administration: Manage An Instance course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle9i. This course introduces the participants to the concepts and procedures associated with Oracle architectural components. The participants learn the various tasks of a database administrator that are performed by using  more...

Oracle9i Database Administration: Create a Database ...Oracle9i Database Administration: Create a Database course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle9i. Participants learn about the concepts associated with storage structure components, management of rollback segments, temporary segments, and indexes. In addition, this course discusses how to create and maintain  more...

Oracle9i Database Administration: Manage Storage Structures The Oracle 9i Database Administration: Manage Storage Structures course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course, participants learn the concepts associated with storage structure components. In addition, this course teaches users the procedures for managing segment free space, undo space, temporary  more...

Oracle9i Database Administration: Manage Data Storage This course is the fourth in the series covering the database administration strategies and procedures provided in Oracle9. This course covers the concepts associated with tables, maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data.  more...

Oracle9i Database Administration: Manage Security This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course you will learn the concepts and methods associated with implementing security and resource consumption in an Oracle9i database.  more...

Oracle9i Database Administration: Strategies and Backups ...Oracle9i database administration. The backup concepts covered by this course include backup strategies and requirements, Oracle Architecture, archiving data, backup methods, and working with a standby database. Students perform backup procedures using operating system utilities, Oracle9i utilities such as RMAN, standard SQL*Plus commands, and the Oracle Enterprise Manager Console. Students  more...

Oracle9i Database Administration: Recover Databases ...Oracle9i database recovery concepts. The recovery concepts course includes recovery with and without archiving, recovery of offline and online databases, recovery with missing data files, and incomplete recovery with and without archiving. Additional concepts covered by this course include time-based recovery, cancel-based recovery, recovery manager components, recovery manager commands, export  more...

Oracle9i Database Administration: Set Up Oracle Net Services This course covers the architecture and configuration of Oracle Net Services. It details client-server and web implementations, in addition to additional features such as Dynamic Service Registration and the use of the Oracle Names Server as an LDAP Proxy. This course also discusses the configuration of the Oracle Shared Server and Oracle Names Server.  more...