Instructor Led And 10g Training in Canada

Oracle 10g Administration Comprehensive, hands-on class focusing on the day-to-day tasks a 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  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 This course will give experienced Oracle technologists the advanced SQL skills necessary to design and code complex queries against Oracle databases. You will learn to use many advanced SQL coding techniques such as coding analytic functions for data warehouse and decision support queries, using partition outer join to "densify" data, the Oracle10g MODEL clause ("spreadsheet-like capability  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...