UNIX, Linux, & vi
 
Home

Maximum Availability Series
Automated Storage Management (ASM)
Data Guard
Dynamic Reconfiguration
Flashback
Grid Control
Online Redefinition
Real Application Clusters (RAC)
Resumable Transactions

DBA Series
11g New features for DBAs
Audit Vault
Disaster Prevention and RMAN
Managing Terabyte Databases
Oracle Security Workshop
Sarbanes-Oxley & HIPAA Compliance

Developer Series
11g New Features for Developers
Advanced Queuing and Streams
Array Processing and Bulk Binding
Exception Handling
Procedures, Functions, & Packages
Security and Fine Grained Access Control
SQL and PL/SQL Tuning
SwingBench Installation & Configuration
Triggers

Applications Series
E-Business Suite

Fusion Middleware Series
Oracle Application Server
Oracle Identity Management

Independent Classes
Interviewing and Hiring Oracle Pros
Oracle for DB2/UDB DBAs & Developers
Oracle for Informix DBAs & Developers
Oracle for SQL Server DBAs & Developers
Oracle for Sybase DBAs & Developers
UNIX, Linux and vi

Evening Workshops
Constraints
Exception Handling
Functions & Pipelined Table Functions
Interviewing
Linux and UNIX Skills
Loops Cursors and Array Processing
Materialized Views
Sarbanes-Oxley - HIPAA Compliance
Triggers
Tuning SQL and PL/SQL
Writing PL/SQL Packages
Writing Stored Procedures
Oracle Unbreakable Linux
The purpose of our Linux and Unix class is:
  • Make the user community comfortable working with a real operating system
  • Teach the skills necessary to install Oracle products
  • Teach the skills necessary to manage Oracle installations
The PSOUG's *NIX class is a stand-alone class intended to help those whose experience with computer operating systems is primarily, or only, Windows learn to work with a real operating system. This one day class is priced at only $450/student. This class is taught using Oracle Unbreakable Linux 4.
 
2007-2008 Calendar
Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct
 
Syllabus
8:30-9:00am Registration Join us for coffee and pastries while you register.
9:00-10:00am Discussion *NIX Concepts and Architecture
This discussion covers some of the history of the *NIX operating system and its variants, the concepts, layout, file system, and the 'man' help system.
10:00-10:30am Lab 1  Navigation
Students explore the root, bin, boot, dev, etc, home, lib, mnt, opt, sbin, tmp, usr, and var directories. Learn to navigate using cd and environment variables.
10:30-10:45am Lab 2 Users and Groups
We use groupadd, useradd, and the GUI to create groups and users. This lab also includes the assignment and changing of passwords. Students also learn to manage resources with ulimit.
10:45-11:30am Lab 3 Managing Files
In this lab we use touch, cp, mv, and vi to create files, change file ownership with chown, file permissions with chmod, delete files with rm, and use mkdir, rmdir, and rm to create and remove directories.
11:30-12:00pm Lab 4 Backup and Restore
Students work with tar balls, zip files, and cpio.
12:00-1:00pm Lunch
1:00-2:00pm Lab 5 Applications
The *NIX operating system contains a large number of tools that are used to empower the user. Among them: cat, df, echo, find, grep, iostat, more, mpstat, ps, sar, tee, top, vmstat, and which. Students have an opportunity to work with these and how to pipe the output from one as an input to another.
2:00-2:15pm Lab 6 /etc files
From an Oracle standpoint there are a number of files in /etc that are modified during pre-installation of application servers and the database.
2:15-3:30pm Lab 7 vi
There is no skill more important than that of learning to use vi. This lab is designed to give students mastery of basic vi commands.
3:30-4:00pm Lab 8 Cron Job 101
Students create a cron job that performs a basic Oracle maintenance function.
4:00-4:30pm Lab 9 Shell Programming with Oracle
Students write a small shell program that performs DML.
 
Instructors
Dan Morgan is an Oracle Ace Director, a 10g and 11g Beta tester for Oracle, and the instructor of the Oracle program at the University of Washington since its inception in 1999. He 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 about when version 6 hit the 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.
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).
 
This is site maintained by the Puget Sound Oracle Users Group. Last Updated: