|
||||
|
||
|
||
| Introduction to RDBMS and SQL *Plus | ||
| Functions, Tables, and Groups | ||
| Advanced SQL, SQL*Plus & Data Dictionary | ||
| DML and DDL Statements | ||
| Database Objects and Security | ||
| Oracle PL/SQL Basic Operations | ||
|
||
| Introducing Procedure Builder | ||
| Oracle Server and Database Architecture | ||
| Oracle Instance, the Start-up and Shutdown Procedure | ||
| Data Dictionary and Database Files | ||
| Oracle Storage Architecture | ||
| Understanding Storage Allocation | ||
| Indexes and Constraints | ||
| Managing Oracle Database Security | ||
| SQL*Loader, Oracle Export and Import, and NLS | ||
| VIEW DEMO To view a demo please visit our website link. To view a demo you need to visit our website and click the link. If you do not have a shockwave player it will ask you to download it. You only need the shockwave player for the online demos only, although they are the same as the product for web purposes we have configured them to play in shockwave. Shockwave is similar to a flash player and can be downloaded free from Macromedia shockwave.com | ||
The course aims to familiarize you with the basic concepts of database design. The course also provides a brief overview of relational database model since the Oracle database is based on this model. The course familiarizes you with the use of SQL and SQL *PLUS commands. The course will enable you to construct queries using SELECT statement with clauses, such as, WHERE, ORDER BY, and DISTINCT. You would also be able to retrieve data from a database using arithmetic, logical, comparison, and SQL operators.
Intro to RDBMS and SQL *Plus training covers such topics as:
RDBMS and SQL
Basics of SQL
Controlling Selected Rows
Operators
Oracle 8i PL/SQL - Functions, Tables, and Groups
This course covers the concepts of single row functions that enable the manipulation of data. The course essentially focuses on three single row functions: character functions, number functions, and date functions. The course also covers the concept of conversion that enables the conversion of a value from one datatype to another. The concept of retrieving data from, more than one table by using join statements is also covered. Additionally, the course discusses group functions that operate on sets of rows to give one result. Related Exam: Oracle Exam #1Z0-001: Introduction to Oracle: SQL and PL/SQL.
Functions, Tables, and Groups training covers such topics as:
Single Row Functions
Conversion Functions
Display Data From Multiple Tables
Working With Groups
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. The course discusses the SQL *Plus format commands and script files and the concept of data dictionary tables and views.
Adv SQL, SQL *Plus & Data Dictionary training covers such topics as:
Subqueries
SQL *Plus Commands
Creating Reports
Data Dictionary
The course addresses the training needs of IT Professionals who use Oracle 8i. This course also addresses the needs of IT professionals who want to become certified under the Oracle8i Certified Database Administrator (DBA) Track.