Oracle9i: Program with PL/SQL Course Advise
Joe I
with PL/SQL" course. The prerequisites are "Working with iSQL*Plus"
and "Introduction to Oracle9i: SQL". I'm a programmer and have been
working with SQL for several years and I would like to believe that I
have a good working knowledge of it but I can't honesty say I know
everything covered in the Introduction to Oracle9i: SQL course. My
question is how much SQL do I really need to know for the Oracle9i:
Program with PL/SQL course ? This might be a tough question to answer
but any advise would be appreciated.
Brian Peasland
You really don't need that much SQL for the PL/SQL course. The SQL
course goes through nice things like SELECT, INSERT, UPDATE, DELETE, and
then things escalate from there. For the PL/SQL course, you pretty much
need a good understanding of SQL, but not everything about it. Your
PL/SQL work will involve some SQL statements. But if you understand
joins and aggregate functions, then you probably have enough to take the
course.
HTH,
Brian
--
===================================================================
Brian Peasland
dba@remove_spam.peasland.com
Remove the "remove_spam." from the email address to email me.
"I can give it to you cheap, quick, and good. Now pick two out of
the three"
Bob Jones
"Joe I" <ippol...@yahoo.com> wrote in message
news:306fadc.04040...@posting.google.com...
For PL/SQL classes, you probably won't need advanced SQL. The purpose is to
introduce you to Oracle's version of procedural language. If you know other
procedural languages, it will help greatly.
Richard Foote
Hi Joe,
Having taught these courses for many years, the amount of SQL knowledge
assumed for the first PL/SQL course is pretty trivial. A basic understanding
of SELECT, being able to restrict, sort and aggregate data, basic DML and
that's about it. Someone with several years of SQL would be more than
capable.
Good Luck
Richard