Oracle DBA school training courses in Albuquerque, NM (public, in-house or online)

This course introduces Oracle9i and Oracle Database 10g users to PL/SQL and helps them understand the benefits of this powerful programming language. Learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Create anonymous PL/SQL blocks, stored procedures, and functions, and learn about declaring variables and trapping exceptions. Develop stored procedures, functions, packages and database triggers. Manage PL/SQL program ...

Full archival course description>>

Oracle DBAs manage the industry’s most advanced information systems and command some of the highest salaries. This course is designed to provide a firm foundation in basic database administration. In this class, students learn how to install and maintain an Oracle database. Students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students will also learn how to create an operational database and properly man...

Full archival course description>>

Students study the internal structure and organization of an Oracle database environment. The course presents a structured approach to planning, building, tuning, and monitoring an Oracle 11g database. Students create an Oracle database, tablespaces, user accounts, views, indices, and other objects necessary to support an application. We also examine some of the issues involved when running a large number of databases within an environment and with running large databases.

PL/SQL is Oracle’s extension language for standard SQL.

In this PL/SQL training class, students who already know SQL, learn to use PL/SQL to write sophisticated queries against an Oracle database.

Class Goals
•Understand the PL/SQL Development Environment.
•Learn the basics of the PL/SQL language.
•Learn to declare and work with variables.
•Learn to use conditionals and loops in PL/SQL.
•Learn to handle and create user-defined exceptions.
•Learn to ...

Full archival course description>>

This Oracle Database Administration Training will develop the key fundamental skills necessary to be an Oracle DBA. Students will design and create a server using the Optimal Flexible Architecture (OFA), configure logical and physical structures, set up database and user security, add and administer users, and monitor and tune main server areas. Each student will create a toolkit of administration scripts for database management and tuning by the end of this class.

The course is inteded f...

Full archival course description>>