Online Oracle Sql Worksheet eLearning - Training Resources

Oracle9i Database Admin Manage Security Course Overview 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. Learn To • Define and maintain the five components of the security domain of a user in a given  more...

Oracle9i Database Admin Manage Data Storage Course Overview 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. Learn To • Identify the row storage method used by the various tables and the  more...

Oracle9i Database Admin Manage Storage Structures Course Overview 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  more...

Oracle8i Database Admin Manage Security Course Overview This course is the last 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 tasks associated with managing security. L earn To: Define and maintain the security domains for users in a given environment. Define and maintain a named set of resources and  more...

Oracle8i Database Admin Manage Data Storage Course Overview This course is the fourth in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts associated with tables. In addition, this course will teach users about maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data. L  more...

Oracle8i Database Admin Manage Storage Structures Course Overview This course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn the concepts associated with storage structure components. In addition, this course will teach users how to create and maintain rollback segments, temporary segments and indexes. L earn To: Identify  more...

Oracle8i Database Admin Create Databases Course Overview This course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts associated with storage structure components, managing rollback segments, temporary segments, and indexes. In addition, creating and maintaining databases will be covered. L earn 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...

Oracle8 Database Administration - Manage Security ...espace quotas for users from the data dictionary by using Oracle SQL Worksheet. Display the account status of users from the data dictionary by using Oracle SQL Worksheet. Unit 2: Managing Profiles Duration: 1.5 - 2 Hour(s) Identify the uses of profiles. Identify the implications of exceeding each type of profile limit. Identify the level at which the limit of a given resource is  more...

Oracle8 Database Administration - Manage Data ...racle Schema Manager. Manually allocate extents by using Oracle SQL Worksheet. Identify the characteristics of the high water mark. Validate a table structure by using Oracle SQL Worksheet. Execute the command used to detect row migration in a table by using Oracle SQL Worksheet. De-allocate the unused space in a table by using Oracle SQL Worksheet. Truncate a table by using Oracle SQL  more...

Oracle8 Database Administration - Manage Storage Structures ...ber 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 Oracle SQL Worksheet. Unit 2: Managing Rollback Segments Duration: 1 - 2 Hour(s) Identify the purposes of rollback segments. Identify the  more...

Oracle8 Database Administration - Create Databases ... Start a specified instance in the NOMOUNT mode by using Oracle SQL Worksheet. Identify the functionality of the CREATE DATABASE command options. Create a database with specified parameter values by using the CREATE DATABASE command. Identify the commonly encountered situations in which the CREATE DATABASE command fails. Identify the contents of a database after its creation. Unit 2 -  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...