Online Data Dictionary eLearning Training
 online course |
 instructor led class |
 learn at home |
 group study |
 self directed training |
 cd based training |
 DVD video training |
 printed book |
 e-book digital book |
 workshop seminar |
 train the trainer |
 computer based learning |
 discount pricing |
 online tutorial |
From Serebra Learning Corporation
Database Structures in Oracle9i
To describe how to use an Oracle9i database data dictionary, the control files, and the redo log files Anyone wanting to learn about Oracle9i database administration
more...
To describe how to use an Oracle9i database data dictionary, the control files, and the redo log files Anyone wanting to learn about Oracle9i database administration
more...
ABAP Fundamentals
To recognize the basic features of ABAP, including the workbench and ABAP tools, and to learn how to create a domain, a data element, and a table. Project team members who will be involved at a programming level in customizing SAP implementations using SAP's ABAP programming language
more...
To recognize the basic features of ABAP, including the workbench and ABAP tools, and to learn how to create a domain, a data element, and a table. Project team members who will be involved at a programming level in customizing SAP implementations using SAP's ABAP programming language
more...
Oracle 8i PL/SQL - Adv SQL, SQL *Plus & Data Dictionary
In this course you will learn to create subqueries and queries using SET operators. The course describes the SQL *PLUS file commands and SET commands that are used to customize the SQL *PLUS environment. Furthermore the course discusses the SQL *Plus format commands and script files. The concept of data dictionary tables and views is also covered in the course. Related Exam: Oracle Exam #1Z0-001:
more...
In this course you will learn to create subqueries and queries using SET operators. The course describes the SQL *PLUS file commands and SET commands that are used to customize the SQL *PLUS environment. Furthermore the course discusses the SQL *Plus format commands and script files. The concept of data dictionary tables and views is also covered in the course. Related Exam: Oracle Exam #1Z0-001:
more...
Oracle 8i DBA - Oracle Instance, the Start-up and Shutdown Procedure
The course is aimed at familiarizing the learner with the Oracle instance. It teaches you the learner about the startup and shutdown processes and the different stages of startup and shutdown. The course also provides a list of data dictionary views that help in performing administrative tasks. The course initiates the learner into hands-on learning by helping you the learner type in the commands
more...
The course is aimed at familiarizing the learner with the Oracle instance. It teaches you the learner about the startup and shutdown processes and the different stages of startup and shutdown. The course also provides a list of data dictionary views that help in performing administrative tasks. The course initiates the learner into hands-on learning by helping you the learner type in the commands
more...
Oracle 8i DBA - Data Dictionary and Database Files
...The course is aimed at familiarizing the student with the Data Dictionary views and database files. The course enables the learner to manage log and control files. The uses and contents of control files will be discussed as well as obtaining information from control files. The planning use and troubleshooting of redo log files will also be explained. The course also provides a list of Data
more...
...The course is aimed at familiarizing the student with the Data Dictionary views and database files. The course enables the learner to manage log and control files. The uses and contents of control files will be discussed as well as obtaining information from control files. The planning use and troubleshooting of redo log files will also be explained. The course also provides a list of Data
more...
Oracle 8i DBA - Oracle Storage Architecture
This course is designed to give an Oracle DBA the necessary knowledge and skills to manage data storage. It will provide detailed information about logical structures such as tablespaces segments extents and Oracle data blocks. The creation and management of rollback segments will also be covered. The course also provides a list of data dictionary views that help in managing these logical
more...
This course is designed to give an Oracle DBA the necessary knowledge and skills to manage data storage. It will provide detailed information about logical structures such as tablespaces segments extents and Oracle data blocks. The creation and management of rollback segments will also be covered. The course also provides a list of data dictionary views that help in managing these logical
more...
Oracle8i DBA: Indexes and Constraints
In this course you will learn to create indexes and enforce various constraints. The course describes the reorganization of indexes managing indexes and maintaining constraints. You will also learn how to obtain information about indexes and constraints from the data dictionary. Related Exam: Oracle Exam #1Z0-023: Oracle 8i: Architecture and Administration.
more...
In this course you will learn to create indexes and enforce various constraints. The course describes the reorganization of indexes managing indexes and maintaining constraints. You will also learn how to obtain information about indexes and constraints from the data dictionary. Related Exam: Oracle Exam #1Z0-023: Oracle 8i: Architecture and Administration.
more...
Oracle 8i DBA - Managing Oracle Database Security
This course is aimed to familiarize the learner with the basic concepts of Oracle 8i administration of security user roles and resources. The course also provides a list of data dictionary views that help in performing administrative tasks. The course initiates the learner into hands-on learning by helping the learner to type-in the commands to perform administrative tasks. Related Exam: Oracle
more...
This course is aimed to familiarize the learner with the basic concepts of Oracle 8i administration of security user roles and resources. The course also provides a list of data dictionary views that help in performing administrative tasks. The course initiates the learner into hands-on learning by helping the learner to type-in the commands to perform administrative tasks. Related Exam: Oracle
more...
Advanced Oracle PL/SQL: Design Considerations and Object Types
This course introduces students to subtypes subprograms cursor variables and the NOCOPY parameter used in advanced function definitions and packages. Students also learn about object types data dictionary views and collections.
more...
This course introduces students to subtypes subprograms cursor variables and the NOCOPY parameter used in advanced function definitions and packages. Students also learn about object types data dictionary views and collections.
more...
From 123-CBT Computer Based Training
Oracle9i Peformance Tuning Managing Memory and Disk I O
This course introduces students to the importance of good initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database. Learn To: o Match the optimizer modes with their descriptions. o Match the
more...
This course introduces students to the importance of good initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database. Learn To: o Match the optimizer modes with their descriptions. o Match the
more...
Oracle9i Database Admin Manage Security
... • Display the tablespace quotas for users from the data dictionary using Oracle SQL*Plus Worksheet. • Display the account status of users from the data dictionary by using Oracle SQL*Plus Worksheet. Unit 2: Managing Resources and Password Security 1 - 2 hours • Identify the uses of profiles. • Create a user profile. • Assign a profile to an existing user by
more...
... • Display the tablespace quotas for users from the data dictionary using Oracle SQL*Plus Worksheet. • Display the account status of users from the data dictionary by using Oracle SQL*Plus Worksheet. Unit 2: Managing Resources and Password Security 1 - 2 hours • Identify the uses of profiles. • Create a user profile. • Assign a profile to an existing user by
more...
Oracle9i Database Admin Manage Data Storage
...rieve the table, extent and row location information from data dictionary. • Identify the features of index-organized tables and alter tables. • Identify the various types of database triggers and the methods to disable and enable the triggers. • Identify the guidelines for implementing constraints and create the two types of constraints. • Disable, enable and drop
more...
...rieve the table, extent and row location information from data dictionary. • Identify the features of index-organized tables and alter tables. • Identify the various types of database triggers and the methods to disable and enable the triggers. • Identify the guidelines for implementing constraints and create the two types of constraints. • Disable, enable and drop
more...
Oracle9i Database Admin Manage Storage Structures
.... • Retrieve rollback segment information from the data dictionary. • Describe the solutions to rollback segment problems. • Explain the concepts of automatic management of undo space. • Identify the purpose and the features of the various types of temporary segments. • Retrieve temporary segment information from the data dictionary. • Maintain indexes.
more...
.... • Retrieve rollback segment information from the data dictionary. • Describe the solutions to rollback segment problems. • Explain the concepts of automatic management of undo space. • Identify the purpose and the features of the various types of temporary segments. • Retrieve temporary segment information from the data dictionary. • Maintain indexes.
more...
Oracle9i Database Admin Create a Database
...nd online redo log files using OMF. • Describe the data dictionary structure, identify the data dictionary categories, and retrieve data dictionary information. • Execute catproc.sql and identify the uses of administrative scripts categories. • Identify the properties of stored procedures and packages, the benefits of using stored program units, and the functions of
more...
...nd online redo log files using OMF. • Describe the data dictionary structure, identify the data dictionary categories, and retrieve data dictionary information. • Execute catproc.sql and identify the uses of administrative scripts categories. • Identify the properties of stored procedures and packages, the benefits of using stored program units, and the functions of
more...
Oracle9i Database Admin Manage an Instance
...e way to control the sort sequence. • Retrieve the data dictionary information about the character sets and the NLS settings. Audience The intended audience for this course include Database administrators, System administrators, Network administrators, and Technical support professionals. Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data
more...
...e way to control the sort sequence. • Retrieve the data dictionary information about the character sets and the NLS settings. Audience The intended audience for this course include Database administrators, System administrators, Network administrators, and Technical support professionals. Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data
more...
Oracle PL SQL Database Programming
Course Overview This course is the third in a series of three titles, and discusses the features of stored subprograms and packages. This course explains how to create and execute stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. This course covers how to manage stored
more...
Course Overview This course is the third in a series of three titles, and discusses the features of stored subprograms and packages. This course explains how to create and execute stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. This course covers how to manage stored
more...
Oracle8i Backup and Recovery Strategies Backups
...by setting parameters in the init.ora file. Identify the data dictionary views used to obtain the archive log information. Unit 3: Oracle Recovery Manager Duration: 2 Hour(s) Select the features of Recovery Manager (RMAN). Start Recovery Manager by using the RMAN command. Identify the events that occur during the connection process after the RMAN command is executed. Select the
more...
...by setting parameters in the init.ora file. Identify the data dictionary views used to obtain the archive log information. Unit 3: Oracle Recovery Manager Duration: 2 Hour(s) Select the features of Recovery Manager (RMAN). Start Recovery Manager by using the RMAN command. Identify the events that occur during the connection process after the RMAN command is executed. Select the
more...
Oracle8i Performance Tuning Managing Memory Disk I O
...tents of the library cache. Identify the contents of the data dictionary cache. Select the functions of the Multithreaded Server Connection. Identify the goals for tuning the library cache. View the sizes of all SGA structures by using the V$SGASTAT view. Determine the percentage of parse calls that find a cursor to share by using the GETHITRATIO column of the V$LIBRARYCACHE view.
more...
...tents of the library cache. Identify the contents of the data dictionary cache. Select the functions of the Multithreaded Server Connection. Identify the goals for tuning the library cache. View the sizes of all SGA structures by using the V$SGASTAT view. Determine the percentage of parse calls that find a cursor to share by using the GETHITRATIO column of the V$LIBRARYCACHE view.
more...
Oracle8i Database Admin Manage Security
...anager. Display the tablespace quotas for users from the data dictionary by using Oracle SQL*Plus Worksheet. Display the account status of users from the data dictionary by using Oracle SQL*Plus Worksheet. Unit 2: Managing Resources and Password Security Duration: 1 Hour(s) Identify the uses of profiles. Create a user profile by using Oracle Security Manager. Assign a user
more...
...anager. Display the tablespace quotas for users from the data dictionary by using Oracle SQL*Plus Worksheet. Display the account status of users from the data dictionary by using Oracle SQL*Plus Worksheet. Unit 2: Managing Resources and Password Security Duration: 1 Hour(s) Identify the uses of profiles. Create a user profile by using Oracle Security Manager. Assign a user
more...
Oracle8i Database Admin Create Databases
... To: Identify and create a database. Identify the data dictionary views. Identify the data dictionary views to retrieve information. Identify the scripts to set up the PL/SQL environment. Identify control files Identify redo log files Identify tablespaces and data files. C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators,
more...
... To: Identify and create a database. Identify the data dictionary views. Identify the data dictionary views to retrieve information. Identify the scripts to set up the PL/SQL environment. Identify control files Identify redo log files Identify tablespaces and data files. C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators,
more...
Oracle8 Performance Tuning Managing Memory and Disk I O
...tions of the Library Cache.
Identify the function of the Data Dictionary Cache.
Identify the function of the User Global Area.
Match the diagnostic views of the Library Cache with their respective definitions.
Perform the steps to determine the percentage of parse calls that find a cursor to share using GETHITRATIO column of the V$LIBRARYCACHE view
Perform the steps to determine the
more...
...tions of the Library Cache.
Identify the function of the Data Dictionary Cache.
Identify the function of the User Global Area.
Match the diagnostic views of the Library Cache with their respective definitions.
Perform the steps to determine the percentage of parse calls that find a cursor to share using GETHITRATIO column of the V$LIBRARYCACHE view
Perform the steps to determine the
more...
Oracle8 Network Administration Net8 Configuration and Troubleshooting
...configuration parameters with their functions. Match the data dictionary views used to verify MTS setup with their contents. Sequence the steps involved in the Connection Pooling process. Identify the syntax of the init.ora parameter MTS_DISPATCHERS that needs to be configured to enable Connection Pooling. Unit 3: Connection Manager Duration: 2 Hour(s) Identify the benefits of the
more...
...configuration parameters with their functions. Match the data dictionary views used to verify MTS setup with their contents. Sequence the steps involved in the Connection Pooling process. Identify the syntax of the init.ora parameter MTS_DISPATCHERS that needs to be configured to enable Connection Pooling. Unit 3: Connection Manager Duration: 2 Hour(s) Identify the benefits of the
more...
Oracle8 Backup and Recovery - Strategies and Backups
...nds.
Display information from the recovery catalog using data dictionary views.
Identify data dictionary views used for extracting recovery catalog information.
Unit 4: Oracle Backup Methods
Duration: 2 Hour(s)
Sequence the steps to perform a closed database backup.
Perform an open database backup.
Identify the requirements to perform an open database backup.
Write the command
more...
...nds.
Display information from the recovery catalog using data dictionary views.
Identify data dictionary views used for extracting recovery catalog information.
Unit 4: Oracle Backup Methods
Duration: 2 Hour(s)
Sequence the steps to perform a closed database backup.
Perform an open database backup.
Identify the requirements to perform an open database backup.
Write the command
more...
Oracle8 Database Administration - Manage Security
...anager.
Display the tablespace 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
more...
...anager.
Display the tablespace 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
more...
Oracle8 Database Administration - Manage Data
...and manage tables.
Retrieve table information from the data dictionary.
Identify the characteristics and types of triggers and constraints.
Implement and maintain data integrity.
Retrieve information from the data dictionary.
Implement clusters and index-organized tables (IOTs).
Load and reorganize data in tables.
C ontent Emphasis
Skills-Based
A udience
more...
...and manage tables.
Retrieve table information from the data dictionary.
Identify the characteristics and types of triggers and constraints.
Implement and maintain data integrity.
Retrieve information from the data dictionary.
Implement clusters and index-organized tables (IOTs).
Load and reorganize data in tables.
C ontent Emphasis
Skills-Based
A udience
more...
Oracle8 Database Administration - Create Databases
... earn To:
Plan and create a database.
Create the data dictionary view.
Use the data dictionary view to retrieve information.
Identify the properties and benefits of using stored procedures and packages.
Plan for the creation of redo log files.
Plan for the maintenance of redo log groups.
Redo log members.
Control files.
Identify the process of log switches and
more...
... earn To:
Plan and create a database.
Create the data dictionary view.
Use the data dictionary view to retrieve information.
Identify the properties and benefits of using stored procedures and packages.
Plan for the creation of redo log files.
Plan for the maintenance of redo log groups.
Redo log members.
Control files.
Identify the process of log switches and
more...
Oracle Database 10g SQL Fundamentals I Part 2
...creating and dropping indexes.
Identify features of the data dictionary.
Identify the contents and usage of data dictionary views.
Unit 2: Objects and Data Management
Identify tasks to be performed for granting system privileges.
Identify tasks to be performed for granting object privileges.
Identify syntax for performing various tasks for maintaining columns.
Identify syntax
more...
...creating and dropping indexes.
Identify features of the data dictionary.
Identify the contents and usage of data dictionary views.
Unit 2: Objects and Data Management
Identify tasks to be performed for granting system privileges.
Identify tasks to be performed for granting object privileges.
Identify syntax for performing various tasks for maintaining columns.
Identify syntax
more...
Object Analysis Design Requirements Analysis
...f the system boundary.
Identify the purpose of using the Data Dictionary.
Identify the role of an Actor within Object Orientation.
Identify the purpose of Use Cases.
Identify the benefits of Use Case diagrams within Object Oriented Analysis.
Identify how complexity is managed within Use Cases.
Identify the use of Aggregation in Use Cases.
Identify the uses of Generalization.
Identify
more...
...f the system boundary.
Identify the purpose of using the Data Dictionary.
Identify the role of an Actor within Object Orientation.
Identify the purpose of Use Cases.
Identify the benefits of Use Case diagrams within Object Oriented Analysis.
Identify how complexity is managed within Use Cases.
Identify the use of Aggregation in Use Cases.
Identify the uses of Generalization.
Identify
more...
Oracle SQL Specifics Creating and Managing Database Objects
... to create a table from rows in another table.
Match the data dictionary views used to confirm tables and constraints with their purpose.
Identify the naming conventions to follow when naming tables and columns.
Identify the four most common datatypes used in the Oracle8 database.
Match the five Oracle8 data integrity constraints with their descriptions.
Identify the default constraint
more...
... to create a table from rows in another table.
Match the data dictionary views used to confirm tables and constraints with their purpose.
Identify the naming conventions to follow when naming tables and columns.
Identify the four most common datatypes used in the Oracle8 database.
Match the five Oracle8 data integrity constraints with their descriptions.
Identify the default constraint
more...
Oracle SQL and SQL Plus SQL Plus and Reporting
Course Overview
This is the second course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the fundamental concepts of SQL*Plus and queries using SQL*Plus runtime variables. In addition, this course explores saving customizations and enhancing query output.
L earn To:
Identify the fundamental concepts of SQL*Plus and write queries
more...
Course Overview
This is the second course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the fundamental concepts of SQL*Plus and queries using SQL*Plus runtime variables. In addition, this course explores saving customizations and enhancing query output.
L earn To:
Identify the fundamental concepts of SQL*Plus and write queries
more...
Oracle 9i New Features Database Administration
...nagement feature. Identify the new data dictionary enhancements that support the new memory management features. Identify the benefits of the dynamic SGA feature. Identify the characteristics of the dynamic SGA components. Match the database parameters with their buffer cache sizing attributes.
more...
...nagement feature. Identify the new data dictionary enhancements that support the new memory management features. Identify the benefits of the dynamic SGA feature. Identify the characteristics of the dynamic SGA components. Match the database parameters with their buffer cache sizing attributes.
more...
CIW Database Specialist Part 1 Introduction to Database Design
This is the first course in a four part series that teaches students about relational databases and database planning and design. It introduces relational databases, Codd's rules, relational data structure and the ER model. It also covers the various phases in the design life cycle and database design methodology, including the creation of ER models. Learn To: o Identify features of a
more...
This is the first course in a four part series that teaches students about relational databases and database planning and design. It introduces relational databases, Codd's rules, relational data structure and the ER model. It also covers the various phases in the design life cycle and database design methodology, including the creation of ER models. Learn To: o Identify features of a
more...
Oracle Database 10g PL SQL Fundamentals Part 2
This course introduces learners to PL/SQL and helps them understand the benefits of this programming language. Students learn to create anonymous PL/SQL blocks. They learn to declare variables and trapping exceptions, develop stored procedures, functions, packages and database triggers.
Learn To:
Identify features of PL/SQL blocks within a subprogram.
Match types of PL/SQL named blocks
more...
This course introduces learners to PL/SQL and helps them understand the benefits of this programming language. Students learn to create anonymous PL/SQL blocks. They learn to declare variables and trapping exceptions, develop stored procedures, functions, packages and database triggers.
Learn To:
Identify features of PL/SQL blocks within a subprogram.
Match types of PL/SQL named blocks
more...
From Teach Me IT
Basic PL/SQL Programming
...t will be able to:
Create views
Identify the different data dictionary views
Create and maintain sequences
Create synonyms
Identify the different kinds of PL/SQL blocks
Describe the Lexical units of a PL/SQL block
Declare variables
Identify the uses and types of control structure
Construct different types of loop statements
Create a PL/SQL Record
Create a PL/SQL Table
Identify the
more...
...t will be able to:
Create views
Identify the different data dictionary views
Create and maintain sequences
Create synonyms
Identify the different kinds of PL/SQL blocks
Describe the Lexical units of a PL/SQL block
Declare variables
Identify the uses and types of control structure
Construct different types of loop statements
Create a PL/SQL Record
Create a PL/SQL Table
Identify the
more...
From Skillspride Online Training
Microsoft Visual FoxPro 6 Introduction
The course is designed to introduce readers to the interactive and programming language of MS Visual FoxPro. The course readers will cover: how to use the interactive features of Visual FoxPro; understand the class and object structure of Visual FoxPro; be able to build a data dictionary with validation and security; design data input forms; create and use new classes; create and use new objects.
more...
The course is designed to introduce readers to the interactive and programming language of MS Visual FoxPro. The course readers will cover: how to use the interactive features of Visual FoxPro; understand the class and object structure of Visual FoxPro; be able to build a data dictionary with validation and security; design data input forms; create and use new classes; create and use new objects.
more...
online course |
instructor led class |
learn at home |
group study |
self directed training |
cd based training |
DVD video training |
printed book |
e-book digital book |
workshop seminar |
train the trainer |
computer based learning |
discount pricing |
online tutorial |
