Duration: 3 Days Instructor-Led

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 as proactive 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 students 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 learnat 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.

This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator Certification. Only instructor-led in-class or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-ROM and Knowledge Center courses DO NOT meet the Hands-on Requirement.

Target Audience

• PL/SQL Developer
• Technical Consultant
• Reports Developer
• Business Intelligence Developer
• Java Developer
• Forms Developer

Required Prerequisite
Oracle Database 10g: SQL Fundamentals I

Suggested Prerequisite
Oracle Database 10g: PL/SQL Fundamentals

Course Objectives

• Describe the basic steps in processing SQL statements
• Describe the causes of performance problems
• Understand where SQL tuning fits in an overall tuning methodology
• Describe Automatic SQL Tuning
• Use the diagnostic tools to gather information about SQL statement processing
• Understand Optimizer behavior
• Influence the optimizer behavior
• Influence the physical data model so as to avoid performance problems

Course Outline

• Database Architecture overview
• Following a Tuning Methodology
• Designing Applications for performance
• Introducing the optimizer
• Optimizer Operations
• Displaying Execution plans
• Gathering Statistics
• Application Tracing
• Identifying High Load SQL
• Automatic SQL Tuning
• Introduction to Indexes
• Advanced Indexes
• Optimizer Hints and Plan Stability
• Materialized Views and Temporary Tables

 Print this page

Duration: 3 Days Instructor-Led

Practical introduction to fundamental Oracle concepts. Students learn how to create a data model, and how to implement it as a database.

Target Audience
Database administrators, programmers and system administrators who want an introduction to Oracle and its use, and an introduction to SQL.

Prerequisites
Computing background, preferably with some database or programming experience.

Course Outline

• Database Concepts
• Data Normalization
• Data Modelling and Design
• Introduction to SQL
• PL/SQL
• Database Objects
• Oracle Architecture

Practical Skills Gained

• Create a basic data model
• Implement model as functioning Oracle database
• Write SQL queries
• Create and modify tables
• Manage user privileges
• Understand Oracle architecture

 Print this page

Duration: 5 Days Instructor-Led

This five-day, instructor-led course provides students with the knowledge and skills to implement, manage, and maintain a Microsoft Windows Server™ 2003 network infrastructure. The course is intended for systems administrator and systems engineer candidates who are responsible for implementing, managing, and maintaining server networking technologies. These tasks include implementing routing; implementing, managing, and maintaining Dynamic Host Configuration Protocol (DHCP), Domain Name System (DNS), and Windows Internet Name Service (WINS); securing Internet Protocol (IP) traffic with Internet Protocol security (IPSec) and certificates; implementing a network access infrastructure by configuring the connections for remote access clients; and managing and monitoring network access.
This is the fourth course in the Systems Administrator and Systems Engineer track for Windows Server 2003, and it is the final course in the Systems Administrator track.

Audience
This course is intended for individuals who are employed as or seeking employment as a systems administrator or systems engineer.

Prerequisites
Before attending this course, students must have completed:
Course 2276: Implementing a Microsoft Windows Server 2003 Network Infrastructure: Network Hosts, or have equivalent knowledge and skills.

Course Outline
Module 1: Configuring Routing by Using Routing and Remote Access
Module 2: Allocating IP Addressing by Using Dynamic Host Configuration Protocol (DHCP)
Module 3: Managing and Monitoring Dynamic Host Configuration Protocol (DHCP)
Module 4: Resolving Names
Module 5: Resolving Host Names by Using Domain Name System (DNS)
Module 6: Managing and Monitoring Domain Name System (DNS)
Module 7: Resolving NetBIOS Names by Using Windows Internet Name Service (WINS)
Module 8: Securing Network Traffic by Using IPSec and Certificates
Module 9: Configuring Network Access
Module 10: Managing and Monitoring Network Access

After completing this course, students will be able to:

• Configure routing by using the Routing and Remote Access service
• Allocate IP addressing by using DHCP
• Manage and monitor DHCP
• Resolve names
• Resolve host names by using DNS
• Manage and monitor DNS
• Resolve network basic input/output system (NetBIOS) names by using WINS
• Secure network traffic by using IPSec and certificates
• Configure network access
• Manage and monitor network access

 Print this page

Duration: 5 Days

This course combines five days of instructor-led training with additional e-Learning content, to provide students with the knowledge and skills required to manage accounts and resources, maintain server resources, monitor server performance, and safeguard data in a Microsoft Windows Server™ 2003 environment. This is the first course in the Systems Administrator and Systems Engineer tracks for Windows Server 2003 and serves as the entry point for other courses in the Windows Server 2003 curriculum.

Audience
This course is intended for individuals who are employed as or seeking employment as a systems administrator or systems engineer.

Prerequisites
Before attending this course, students must have:

• CompTIA A+ certification, or equivalent knowledge and skills.
• CompTIA Network+ certification, or equivalent knowledge and skills.

Course Outline
Part 1: Managing a Microsoft Windows Server 2003 Environment
Module 1: Introduction to Administering Accounts and Resources
Module 2: Managing User and Computer Accounts
Module 3: Managing Groups
Module 4: Managing Access to Resources
Module 5: Implementing Printing
Module 6: Managing Printing
Module 7: Managing Access to Objects in Organizational Units
Module 8: Implementing Group Policy
Module 9: Managing the User Environment by Using Group Policy
Module 10: Introduction to Security in Windows Server 2003

Part 2: Maintaining a Microsoft Windows Server 2003 Environment
Module 1: Preparing to Administer a Server
Module 2: Preparing to Monitor Server Performance
Module 3: Monitoring Server Performance
Module 4: Maintaining Device Drivers
Module 5: Managing Disks
Module 6: Managing Data Storage
Module 7: Managing Disaster Recovery
Module 8: Maintaining Software by Using Software Update Services

After completing this course, students will be able to:

• Create and populate organizational units with user and computer accounts
• Manage user and computer accounts
• Create and manage groups
• Manage access to resources
• Implement printing
• Manage printing
• Manage access to objects in organizational units
• Implement Group Policy
• Manage the user and computer environment by using Group Policy
• Audit accounts and resources
• Prepare to administer server resources
• Configure a server to monitor system performance
• Monitor system performance
• Manage device drivers by configuring device driver signing and restoring a device driver
• Manage hard disks
• Manage data storage
• Manage disaster recovery
• Maintain software by using Microsoft Software Update Services

 Print this page

JUICI PATTIES
7 Trinidad Terrace, Kingston 5
Tel: 876-920-5660
Fax: 876-968-4188

TASTEE PATTIES
11A Knutsford Boulevard, Kingston 5
Tel: 876-929-0754

ISLAND GRILL
59 Knutsford Blvd, Kingston 5
Tel: 876-926-3826 / 920-8887

CHELSEA JERK CENTRE
7 Chelsea Avenue, Kingston 5
Tel: 876-926-6322

PIZZA HUT
57 Knutsford Boulevard, Kingston 5
Tel: 876-960-9162

BURGER KING
61 Knutsford Boulevard, Kingston 5
Tel: 876-920-7752

WENDY’S
73 Knutsford Boulevard, Kingston 5
Tel: 876-906-9256

KENTUCKY FRIED CHICKEN
15 Dominica Drive, Kingston 5
Tel: 876-968-8441

LE MERIDIEN JAMAICA PEGASUS
www.jamaicapegasus.com
81 Knutsford Boulevard, Kingston 5, Jamaica, West Indies
Tel: 876-926-3690
Fax: 876-929-5855

HILTON NEW KINGSTON
www.hiltoncaribbean.com/kingston/
77 Knutsford Boulevard, Kingston 5, Jamaica, West Indies
Tel: 876-926-5430
Fax: 876-929-7439

THE COURTLEIGH HOTEL AND SUITES
http://www.courtleigh.com
85 Knutsford Boulevard, Kingston 5, Jamaica, West Indies
Tel: 876-929-9000
Fax: 876-926-7744
Email: courtleigh@cwjamaica.com

THE KNUTSFORD COURT HOTEL
http://www.knutsfordcourt.com
16 Chelsea Avenue, Kingston 5, Jamaica, West Indies
Tel:876-929-1000
Fax:876-960-7373
Email: sales@knutsfordcourt.com

ALTAMONT COURT HOTEL
http://www.altamontcourt.com
1-5 Altamont Terrace, Kingston 5, Jamaica, West Indies
Tel: 876-929-4497
International Phone: (876) 929 5931/929 4497 8
Fax:876-929-2118
Email: altamontsales@cwjamaica.com

HOTEL FOUR SEASONS
http://www.hotelfourseasonsja.com
18 Ruthven Road, Kingston 5, Jamaica, West Indies
Tel: 876-929-7655
Fax: 876-929-5964
Email: info@hotelfourseasonsja.com

INDIES HOTEL
5 Holborn Road, Kingston 5, Jamaica, West Indies
Tel: 876-926-2952
Fax: 876-926-2879
Email: indieshotel@hotmail.com

TERRA NOVA
http://www.terranovajamaica.com
17 Waterloo Road, Kingston 5, Jamaica, West Indies
Tel: 876-926-2211-2
Fax: 876-929-4933
Email: info@terranovajamaica.com