Instructor Led 10g Training in Canada

Oracle 10g Administration ...DBA will perform to create, maintain and manage an Oracle 10g Database such as security, creating and managing users, creating and managing database objects (tablespaces, tables, indexes, etc.), running utilities, configuring Oracle networking, and simple backup and recovery techniques. Provides an overview of the Oracle Data Dictionary and Oracle 10g architecture; Administrative Users;  more...

Oracle 10g 11g PL SQL Programming This class will teach you how to write efficient and scalable PL/ SQL programs to create database-intensive PL/ SQL applications. Learning how to create efficient, scalable PL/ SQL programs is an important objective of this course. To meet that objective, the course includes instruction on such things as the proper use of bind variables, bulk processing, pipelining, benchmarking different  more...

Oracle 10g 11g Advanced SQL ..., using partition outer join to "densify" data, the Oracle10g MODEL clause ("spreadsheet-like capability directly from the database"), Oracle10g regular expressions for pattern matching, using the extended aggregate functions CUBE and ROLLUP, CONNECT BY (hierarchical queries), coding SET operations such as INTERSECT, and more. An overview Oracle10g SQL-related new features is also  more...

Oracle 10g 11g Introduction to SQL This course is designed for developers who are new to relational database and need to know how to query, update and create basic objects in Oracle databases. Students receive a comprehensive introduction to Oracle's implementation of the SQL language and the common query tools, SQL*Plus and iSQL*Plus. The course includes a lesson on basic relational database concepts. LEARNING  more...

Oracle Database 10g Administration I Technical This course Oracle Database 10g Administration will address critical skills needed by Oracle Database 10g administrators and prepare students for the Oracle Database 10g Administration I 1Z1-042 exam.  more...