|
Home
| Seattle
- May 5 - May 9 |
 |
|
|
|
|
RAC - Data
Guard -
|
|
Maximum availability is not
something you can achieve by installing a single piece of
hardware or configuring a single initialization parameter.
Maximum availability is a convergence that comes from
deploying the right hardware, the right database, the
right options, and deploying specific pieces of the tech
stack correctly. This
PSOUG hands-on Boot Camp is convergence of the result of
merging some existing PSOUG classes with new materials to
bring together the pieces of the puzzle required to
implement maximum availability in your organization.
The following outline is
for a five day DBA Boot Camp being offered in Seattle
Washington, May, 5 to May 9, 2008. The class will be limited to a maximum
of 8 students.
If you are interested please contact the PSOUG
office at 206-547-1600. Only $2495.
|
|
Day 1 -
Real Application Cluster Installation
|
| 8:30-9:00am |
Registration |
Join us for coffee and pastries while you register. |
| 9:00-10:30am |
Session
1 |
Maximum
Availability Concepts and Architecture
The |
|
10:30-12:00pm |
Lab
1 |
Linux
Installation
Students will perform a hands-on installation of
Oracle Unbreakable Linux including kernel
configuration. |
| 1:30-2:30pm |
Lab 2 |
Clusterware
Installation
T |
| 2:30-3:30pm |
Lab
3 |
Database
Installation
St |
| 3:30-4:30pm |
Lab
4 |
RAC
Failover
The |
|
|
Day 2
- RAC Cluster Management |
| 9:00-10:30am |
Session
3 |
What
is a database
A discussion of the components of an Oracle
database that are both physical and logical
structures including datafiles, tempfiles,
tablespaces, tablespace groups, control files, log
files, pfiles, and spfiles. The discussion will
include storage best practices with the focus on
understanding how SAN, NAS, iSCSI, and other
storage solutions interact with the Oracle
database and how to optimize performance and
minimize cost. |
| 10:30-11:30pm |
Lab 3 |
Storage
Students, using the data dictionary, will explore
the default database files and then create new
tablespaces, data files, tempfiles, and learn how
to drop and create a new UNDO tablespace. |
| 11:30-12:00pm |
Session 4 |
Extent
Management
This instructor led discussion, with live demos,
will teach students the techniques for determining
space usage and predicting space requirements.
Also covered will be the UNDO advisor for properly
sizing the UNDO tablespace. |
| 1:00-2:30pm |
Lab 4 |
Extents Lab
Students, using the tools discussed in Session 5, will design a schema, use the DBMS_SPACE built-in
package to predict space requirements, and design the required infrastructure. They will also, using
DBMS_STATS examine space utilization of existing structures. |
| 2:30-3:30pm |
Session 5 |
Tables
This instructor led discussion, with live demos, will cover the different types of tables available
in Oracle including HEAP, CLUSTERS, COMPRESSED, EXTERNAL, GLOBAL TEMPORARY, INDEX ORGANIZED,
PARTITIONED, and XML. |
| 3:30-4:45pm |
Session 6 |
Indexes
This instructor led discussion, with live demos, will cover the different types of indexes
available in Oracle including B*TREE, BITMAP, BITMAP JOIN, COMPRESSED, DESCENDING,
FUNCTION BASED, INVISIBLE, NO SEGMENT, and REVERSE. |
| 4:45-5:00pm |
Review |
Review
The day's work will be reviewed and students will receive a homework assignment to prepare them for Day 3. |
|
|
Day 3 -
Automated Storage Management (ASM) |
| 9:00-10:30am |
Session 7 |
What is an Instance
A |
| 10:30-11:30am |
Lab 7A |
SPFILE Lab
St |
| 12:30-2:00pm |
Lab 7B |
Instance Management Lab
This lab wil |
| 2:00-3:30pm |
Session 8 |
Network Connectivity
Thi |
| 3:30-4:45pm |
Lab 8 |
Network Connectivity Lab
In th |
| 4:45-5:00pm |
Review |
Review
The day's |
|
| Day 4 -
Replication and Disaster Recovery |
| 9:00-10:30am |
Session
9 |
Users
An essential part of managing any Oracle database
installation is creating users, managing their
privileges, and providing an infrastructure that
meets requirements for governance and compliance.
This instructor led
session will teach students both the issues and
the solutions.
|
| 10:30-11:00am |
Lab
9A |
Data
Guard
This lab |
| 1:00-1:30pm |
Session
10 |
RMAN
System |
| 2:15-2:45pm |
Session
11 |
D
T |
| 3:30-4:00pm |
Session
12 |
D
T |
|
| Day
5 - Midterm |
| 9:00-9:30am |
Session
13 |
D
T |
| 1:00-4:00pm |
Lab
13
continued |
D
T |
|
|
Instructors |
Caleb Small is the primary instructor for the
Oracle Workforce Development program at Camosun College in
Victoria BC, and a private consultant with years of
experience implementing and teaching Oracle throughout
North America. He has over 30 years experience in the IT
industry in numerous business areas including both public
and private sectors.
Caleb is also active as a director of the Victoria and
Puget Sound Oracle User Groups, and has delivered numerous
lectures, presentations, live demos and articles to other
groups. He has authored and led many of the PSOUG
workshops including RAC, ASM, RMAN and Data Guard.
Caleb was one of the first people to build an 11g RAC
cluster and has been a primary consultant on RAC to
publicly held corporations including Areva T&D and
Montana Dakota Utilities (MDU).
Dan Morgan is an Oracle Ace Director, a
10g and 11g Beta tester for Oracle, and the author and
primary instructor of
the Oracle program at the University of Washington since
its inception in 1999. Morgan began his IT career in 1969 with
an IBM 370/145, punch cards, and Fortran IV, and though he
will vigorously deny it, wrote COBOL for a decade before
moving into Oracle when version 6 came to market.
In addition to Dan's work at the university he is the
Education Chair of the Puget Sound Oracle Users Group, a
member of UKOUG, and a member of the British-American
Chamber of Commerce in Seattle. He is also a frequent
lecturer at training events and at conferences and has
presented at Oracle OpenWorld on RAC (2005), at Seattle
OracleDay (2004-2007), at numerous government and
corporate training events including Apple Computer,
Argonne National Laboratory, Boeing Commercial Airplane
Group, Dow Jones & Company, Lawrence Livermore
National Laboratory, NASA, T-Mobile, US Navy at Pearl
Harbor, and Weyerhaeuser to name but a few and presented
on Streams and Change Data Capture at UKOUG in 2006.
Dan Morgan is the Morgan behind the "Morgan's
Library" website that contains the many demos he has
created for his University of Washington classes as well
as for his frequent lectures. He is the former publisher
of MacTech Journal, has presented Oracle technical
lectures in the US, Canada, Great Britain, and Japan.
Morgan is also the author of this course.
|
|
