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 Database Administration: Create a Database The 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 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 This course introduces students to backup methods for 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... more...
Oracle9i Database Administration: Recover Databases This course introduces students to 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... 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... more...
Oracle9i Database Administration: Create a Database The 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 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 This course introduces students to backup methods for 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,... more...
Oracle9i Database Administration: Recover Databases This course introduces students to 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... more...
Sybase Replication Server DBA CHAPTER 1 Introduction to Replication Server
CHAPTER 2 Replication Server Technical Overview
CHAPTER 3 Managing Replication Server with Sybase Central
CHAPTER 4 Managing a Replication System
CHAPTER 5 Setting Up and Managing RepAgent
CHAPTER 6 Managing Routes
CHAPTER 7 Managing Database Connections
CHAPTER 8 Managing Replication Server Security
CHAPTER 9 Managing Replicated Tables
CHAPTER 10... more...