Online Application Dba eLearning

Oracle 11i Profile Options DBA Duties and Printer Management Oracle 11i: Profile Options, DBA Duties, and Printer Management Oracle To set and view profile options, perform some Application-DBA tasks, define printers, and print with the pasta.cfg file  more...

Oracle Database 11g R2 Application Performance Enhancements Oracle Database 11g R2: Application Performance Enhancements Oracle Oracle Database 11g Release 2 offers improved and new features to provide better application performance. It offers online table redefinition, which allows tables to be modified without affecting the availability of the table to users and does not affect any of its dependencies. This allows for easier application changes and  more...

Oracle 11i10 System Administration Curriculum The Oracle 11i10 System Administration Curriculum includes the following courses: Oracle 11i10 System Admin.: Application, Function & Data Security Oracle 11i10 System Admin.: User Management & Resource Auditing Oracle 11i10 System Admin.: Concurrent Management & Profile Options Oracle 11i10 System Admin.: Printer Management & Form Personalization Oracle 11i10 System Admin.:  more...

Oracle 11i10 System Admin DBA Activities ...ations. The tasks and duties discussed in this course are Application DBA duties, folder administration, custom program addition, help customization, and document sequencing. Learn To: Identify the steps for assigning resource consumer groups. Identify features of cost-based optimization (CBO). Identify the components of the Network Test window that you use to evaluate  more...

Oracle SQL Specifics Creating and Managing Database Objects Course Overview This course is the second in a two-part series on Oracle SQL Specifics that will teach participants how to use commands, functions, and operators supported by Oracle as extensions to standard SQL. Users will learn how to create and manage tables, build integrity constraints, and use the COMMIT and ROLLBACK statements to control transactions. Learners will create and maintain  more...

Oracle8 Database Administration - Manage an Instance Course Overview This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support. L earn To:  more...

Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention Course Overview This course is the third in a three-part Oracle8 Performance Tuning series. This course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately. The student  more...

Oracle8i Performance Tuning Managing Memory Disk I O Course Overview This course is the second in a three-part Oracle8i Performance Tuning series. This course introduces the learner to the application tuning issues that will impact database performance. In addition, participants will be introduced to tuning components and functions of the shared pool and the buffer cache. Students will learn how to monitor the contents and usage of the Redo Log  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. Learn To: o Identify the components of the relational  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. Learn To: o Identify the four Oracle join types used to display data from more than one table. o  more...

Oracle e-Business 11i System Admin Fundamentals 3 This is the third course of five that teaches 11i System Administrators the concepts and fundamentals of their role. This course focuses on the management of printers and various DBA miscellaneous duties such as application-related duties, incorporating custom Help files, and managing folders and document sequences. Learn To: Identify fundamental features of printers in an Oracle  more...

Oracle8 Backup and Recovery - Troubleshooting and Recovery Course Overview This course is the second course in a two-part series that introduces participants to the critical task of planning and implementing database recovery strategies. This course will identify ways of handling different types of failures, diagnosing errors and detecting corruption. Additionally, users will be introduced to the different types of Oracle recovery methods and how to  more...

Oracle8i Database Admin Manage an Instance Course Overview This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support. L earn To:  more...