Re: Intro to Oracle:SQL & PL/SQL class -HELP

[Quoted] I wish you were in my classes. (I teach Oracle 8i Basics, Advanced PL/SQL, and Oracle DBA classes at the University of Washington) as your perceptions are correct.

My curriculum, which is very aggressive and targeted toward people already in the business. It covers creation of basic database objects (tables, indexes, constraints, sequences), the data dictionary, and some SQL and PL/SQL in SQL*Plus in 30 hours (10 x 3 hours). The Advanced PL/SQL class (stored procedures, functions, packages, triggers, error handling, and a few of the most useful built-in packages) in 30 hours. And a DBA class oriented toward developers (not for serious full-time DBAs) also 30 hours. To attempt to do this with novices is wholly unrealistic.

Daniel A. Morgan

> I would like some input from a teacher on the subject.
> I am taking an Oracle class now from a large corp that specializes
> in teaching. The Oracle DBA is over 11 weeks, with PL/SQL taking
> three of those eleven weeks. The class is once a week for 8 hours.
> Can you adequately take a beginner from zilch to a good understanding
> in 24 ( 3 X 8 ) hours.
>
> The first three weeks have gone by and I feel comfortable with about HALF the
> material. We are using ORACLE textbooks. In my eyes, they are written poorly,
> not descriptive at all, and leave a student wanting ' where's the beef ' mode.
>
> I have yet to find a good tutor on the web for SQL \ PL/SQL \ SQL Plus
> which the first exam is based on. Could you direct me to one ??
>
> bruce w
>
> steveee_ca_at_my-deja.com wrote:
>
> > Hi,
> >
> > I've taught this class many times..I'm looking at the Oracle Education
> > book for SQL, Chapter 9 and it refers to a lab9_1 script.It's just a
> > script to create a table called MY_EMPLOYEE as described in the book..
> >
> > Her you go:
> >
> > SQL> CREATE TABLE MY_EMPLOYEE
> > 2 (ID NUMBER(4) PRIMARY KEY,
> > 3 LAST_NAME VARCHAR2(25),
> > 4 FIRST_NAME VARCHAR2(25),
> > 5 USERID VARCHAR2(8),
> > 6 SALARY NUMBER(9,2));
> >
> > Have fun!
> >
> > Steve
> >
> > In article <cdua6.5057$1m.272574_at_bgtnsc04-news.ops.worldnet.att.net>,
> > "Jolo" <temple_at_techie.com> wrote:
> > > Has anyone here has taken the Into to Oracle SQL & PL/SQL class ?
> > >
> > > I'm doing the labs in chapter 9 on my computer and lo and behold, it
> > > mentions about running a script called lab9_1.sql. But I don't have it
> > > although I have all of the other test databases (login as scott,
 password =
> > > tiger).
> > >
> > > If anyone has that script so I can continue and finish the practices
 in
> > > chapter 9 (Manipulating Data) PLEASE E-MAIL THE SCRIPT TO ME !!!
> > >
> > > Thanks,
> > >
> > > Jon Temple
> > > temples_at_att.net
> > >
> > >
> >
> > Sent via Deja.com
> > http://www.deja.com/
Received on Tue Feb 13 2001 - 06:31:33 CET