Online Oracle Server eLearning Training

Oracle9i Database Admin Set Up Oracle Net Services ...eps required for a client to establish a connection to an Oracle server. • Match the client and server network components required to perform specific tasks on a Web application client implementation. • Identify the features of automatic instance registration. • Configure a local net service name by using the Oracle Net Configuration Assistant. • Identify the tasks more...

Oracle9i Database Admin Perform Database Backups ...m with an operating system utility. • Match the key Oracle server file structures with their uses. • Differentiate between the user and server processes for user interaction with a database. • Match the key Oracle memory structures with their functions. • Match the functions of the key background processes with their functions. • Place a log member from two log more...

Oracle9i SQL DML and DDL ...ables. Learn To: o Identify the data structures in an Oracle server. o Identify the rules for naming tables in a database. o Identify the DML and transaction control statements. o Insert rows in a table by using the INSERT statement. o Add a column to a table in an Oracle database. o Change the table structure by modifying the characteristics of an existing column. o Identify more...

Oracle9i SQL Basic SELECT Statements ...tify the tools and languages used to communicate with the Oracle server. o Match the services provided by Oracle9iAS with their functions. o Match the tools in Oracle9iDS with their functions. o Identify the features of Oracle9i. o Identify the features of Oracle9i Database. o Match the components of Oracle Internet Platform with their features. o Identify the benefits of the Entity more...

Oracle8i Backup and Recovery Strategies Backups ...background processes with their functions. Match the key Oracle server file structures with their uses. Unit 2: Database Archiving Duration: 1 - 2 Hour(s) Identify the implications of operating an Oracle database in NOARCHIVELOG mode. Identify the implications of operating an Oracle database in ARCHIVELOG mode. Sequence the steps to change the archive mode of an Oracle database. more...

Oracle8i Database Admin Manage Storage Structures ...mation that they provide. Sequence the steps used by the Oracle Server to manage data within a block. Retrieve the information to check the current number of extents and blocks allocated to a segment by using Oracle SQL*Plus Worksheet. Retrieve the information to view the extents for a given segment by using Oracle SQL*Plus Worksheet. Write a query to check the extents for a given segment more...

Oracle Form Builder R6 Including Reusable Oracle Components Course Overview This course is the sixth in a six-part Oracle Developer series that is based on Oracle Developer Release 6. This course will enable learners to implement methods to use additional data sources, to work with Oracle8 objects, and to integrate charts, reports, and timers in form modules. In addition, the course covers the procedures to reuse components, objects, and code and to more...

Oracle8 Database Administration - Manage Data ... with their features. Identify the procedure followed by Oracle Server to implement unique and primary keys. Identify the factors to be considered while performing DDL on the tables referenced by a foreign key. Identify the factors to be considered while performing DML on the FK-PK related tables. Identify the various types of triggers with the situations under which they are executed. more...

Oracle8 Database Administration - Manage Storage Structures ...mation that they provide. Sequence the steps used by the Oracle Server to manage data within a block. Retrieve the information to check the current number of extents and blocks allocated to a segment by using Oracle SQL Worksheet. Retrieve the information to view the extents for a given segment by using Oracle SQL Worksheet. Write a query to check the extents for a given segment by using more...

Oracle Form Builder Including Reusable Oracle Components ...reuse components, objects, and code. Implement the new Oracle Server error handling features accessible to Form Builder. C ontent Emphasis Skills-Based A udience Application developers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or more...

Oracle SQL Tuning Tuning SQL and the Optimizer ...f a shared SQL area. Sequence the steps performed in the Oracle Server for processing a SQL statement. Identify the benefits of sharing cursors. Identify whether or not the given pair of statements will share cursors. Identify the guidelines for coding SQL in order to share cursors. Match the columns of the V$LIBRARYCACHE view with the information that they contain. Match the columns of more...

SQL and PL SQL PL SQL Basics ...r acquire the expertise to design, develop, and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming. Numerous easy-to-understand examples ensure that the concepts are amply illustrated. L earn To: Identify the features and benefits of PL/SQL and understand more...

SQL and PL SQL Basic SELECT ...l technology. Define the tools used to interact with the Oracle server. Identify the types of SQL statements. Unit 2: Writing Basic SQL Duration: 1 - 2 Hour(s) List capabilities of SQL SELECT statements. Identify the mandatory elements of a SELECT statement. Identify methods for executing SELECT statements. Write a SELECT statement that displays all columns and rows of a table. more...

Oracle 11i e-Business Suite Essentials for Implementers Part 2 ...constructs with their descriptions. Match components of Oracle Server with their descriptions. Identify options used to respond to a notification. Identify features of Application Server components. Identify features of the End-User Client components. Monitor a workflow. Identify key concepts related to system integration with Workflow. Identify key implementation considerations more...

Oracle SQL for End Users--Part 1 ...identifies relational database properties, introduces the Oracle server, and indicates how SQL and SQL*Plus are used in the Oracle product set. In this course, the learner creates basic SQL SELECT statements and customizes these queries to restrict and sort the results. In addition, the learner writes statements that contain a variety of single-row functions. L earn To: Identify more...