Oracle Database 10g: SQL Tuning Workshop

ExitCertified - Canada
Ottawa, Toronto, Vancouver, Calgary, Edmonton, Winnipeg, Canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course is designed to give the experienced SQL Developer or DBA a firm foundation in SQL tuning techniques. The participant learns the necessary knowledge and skills to effectively tune SQL in the Oracle Database 10g. They learn about tuning methodology as well proactive tuning and reactive tuning methods. Students are introduced to the benefits of the new automatic tuning mechanisms available in Oracle Database 10g. On completion of the course they are able to compare and contrast the steps involved to tune manually as in prior releases as well as use the automatic SQL tuning features provided in the current release. Students gain a thorough conceptual understanding of the Oracle Optimizer, and reinforce instructor-led learning with structured hands-on practices. The course uses a series of challenge-level workshops, allowing students to "play, discover, and learn" at their own level and pace. The students learn to use the Oracle diagnostic tools and facilities: Automatic SQL Tuning components, EXPLAIN, SQL Trace and TKPROF, SQL*Plus AUTOTRACE. Students also learn to influence the behavior of the Optimizer by changing the physical schema and modifying SQL statement syntax. ...''

Phone:1.866.328.EXIT (3948)

School Address:

Ottawa, Ontario
ExitCertified Head Office
85 Albert Street, Suite 1200
Ottawa, Ontario, Canada
K1P 6A4

Toronto, Ontario
40 Eglinton Ave E., Suite 305
Toronto, Ontario, Canada
M4P 3A2

Montréal, Quebec
Sun Life Building
1155 Metcalfe Street, Suite 2120
Montréal, Québec, Canada
H3B 2V6

Québec City, Quebec
Holiday Inn Select
Centre-Ville
395, de la Couronne
Québec City, Québec, Canada
G1K 7X4

Vancouver, British Columbia
700 West Pender Street
Suite 610, Pender Place I
Vancouver, British Columbia, Canada
V6C 1G8

Calgary, Alberta
Suite 204
2333 - 18th Avenue NE
Calgary, Alberta, Canada
T2E 8T6

Edmonton, Alberta
10060 Jasper Ave.
Suite 810, Scotia Place
Edmonton, Alberta, Canada
T5J 3R8

Winnipeg, Manitoba
723 Portage Ave.
Winnipeg, Manitoba, Canada
R3G 0M8


Jobs & Resumes: Ottawa, Toronto, Vancouver, Calgary, Edmonton, Winnipeg
Houses & Roommates: Ottawa, Toronto, Vancouver, Calgary, Edmonton, Winnipeg

Oracle Database 10g: PL/SQL
Oracle Database 10g: Data Guard Administration
Managing Oracle on Linux
Oracle Application Server 10g R2: Administration
Oracle Application Server 10g R3: Administration
OracleAS Portal 10g: Build Portlets with Java
OracleAS 10g R3: Java Programming
OracleAS Portal 10g: Build Portlets with PL/SQL
Oracle BPEL Process Manager: Services Orchestration
Data Modeling and Relational Database
Oracle Forms & Reports Developer 10g: Move to the Web
Oracle 10g: XML
Object-Oriented Analysis and Design using the Unified Modeling Language (UML)
Oracle HTML DB 2.0: Develop Web Applications
Oracle SOA Suite 10g: SOA Essentials
Data Warehousing Fundamentals
Data Warehouse Database
OracleBI Discoverer Administrator 10g: Develop an EUL
OracleBI Discoverer Plus 10g: Analyze Relational and OLAP Data

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.