|
Oracle 9i Database Administrator Certified Associate
(3228504) |
|
Return to Search Results | Request More Information | View Comments | Recommend this Course | Purchase Course |
 |
Summary:
This set is comprised of 3 courses:
Introduction to Oracle9i
Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus
Oracle9i: Database Fundamentals I |
|
Course Offered By:
Element K
500 Canal View Boulevard
Rochester, New York 14623
Phone: 585-240-7500
Courses by this Learning Provider |
|
 | | Over the past 25 years, Element K has been committed to helping the world's most prestigious companies improve their business with learning and development. |
|
|
|
Course Cost:
$370.00 (Purchase Course)
|
Promotions:
We offer 15% discount to Dice Learning members. Please add coupon code DICESPECIAL15 to your checkout on this site.
Purchase any Element K web-based course and get one month FREE Dice Advantage service with your first purchase. A $29 value! Contact us for details.
|
Course Duration:
44 Hours, 58 Minutes
|
Course Type:
Self Paced
|
|
|
Description:
The following 3 courses are included:
Introduction to Oracle9i
Description:
In this course, you will examine the basic Oracle concepts and how they relate to database administrators and developers, identify and apply the techniques of logical database design to design a basic entity-relationship diagram, examine the purpose of denormalization, identify the advantages and disadvantages of iSQL*Plus, write SQL statements to retrieve and manipulate data, create and execute a simple PL/SQL program, list the purpose and syntax of packages, procedures, triggers, and functions, list the objects in an Oracle database, and examine the overall architecture of the Oracle Relational Database Management System (RDBMS).
Objectives:
After completing this course, you will be able to list the users of Oracle, trace the history of databases, list the phases in the development life cycle for Oracle systems, distinguish between data modeling techniques, create entities, add attributes and relationships, use SQL*Plus, examine the purpose of denormalization, identify the advantages and disadvantages of iSQL*Plus, query with the SELECT statement, work with set operators, subqueries, joins, ANSI SQL: 1999-compliant joins, and grouping functions, work with tables, insert and update data in tables using the MERGE statement, commit and rollback changes to data, control a transaction with savepoints, grant and manage privileges to users. You will also be able to identify variables and constants, describe anonymous blocks, conditional logic flow, and cursors, list the purpose and syntax of packages, procedures, triggers, and functions, list the contents of a datablock, manage datablocks, describe the architecture of Oracle9i, and the overall operation of a Relational Database Management System (RDBMS).
Duration: 10 Hours, 24 Minutes
Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus
Description:
In this course, you will examine the use of SQL, PL/SQL, and SQL*Plus, filter and sort data, use built-in SQL functions, create and modify tables and constraints, create and use database objects, use PL/SQL control structures, process cursors in PL/SQL, develop procedures and functions with runtime exceptions, develop Oracle packages, create Oracle triggers, and work with collections of data.
Objectives:
After completing this course, you will be able to use SQL, PL/SQL, and SQL*Plus, use SQL*Plus commands to filter and sort data, use built-in SQL functions, work with multiple tables, create and modify tables and constraints, create and use other database objects, build PL/SQL blocks, use PL/SQL control structures, process cursors in PL/SQL, handle runtime exceptions, develop procedures and functions, develop Oracle packages, create Oracle triggers, and work with collections of data.
Duration: 17 Hours, 20 Minutes
Oracle9i: Database Fundamentals I
Description:
The Oracle9i Database Fundamentals I course will enable you to describe the basic Oracle9i architecture and how objects are stored in the database. This course will also enable you to manage several aspects such as an Oracle instance, datafiles, tables, and users. Your can maintain the online redo log and the control files. You will also be able to describe globalization support.
Objectives:
In this course, you will be introduced to the responsibilities of an Oracle database administrator (DBA). You will explore the underlying architecture of the Oracle database server and the essential tasks required to manage database installations such as how to start up and shut down an Oracle instance. You will also explore the components that comprise a database, practice creating a database, manage database objects, reorganize data, and implement security measures. Finally, you will explore how to troubleshoot real-life scenarios that could occur.
Duration: 17 Hours, 14 Minutes
|
|
Applicable Vendor Technologies:
Oracle
|
|
Associated Disciplines:
Databases
|
|
RECOMMEND THIS COURSE
You must be logged in as a Candidate to recommend courses
|
|
|
|
|
|
|
