Newsgroups: comp.databases.oracle.server Path: newssvr20.news.prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!prodigy.com!news.glorb.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newspeer.radix.net!news.er.usgs.gov!news From: Brian Peasland Subject: Re: Oracle9i: Program with PL/SQL Course Advise X-Nntp-Posting-Host: edcxpw014.cr.usgs.gov Content-Type: text/plain; charset=us-ascii Message-ID: <4076C9DA.6974DAB2@remove_spam.peasland.com> Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739) Content-Transfer-Encoding: 7bit Organization: U.S. Geological Survey, Reston VA X-Accept-Language: en References: <306fadc.0404090752.5c0c179b@posting.google.com> Mime-Version: 1.0 Date: Fri, 9 Apr 2004 16:05:46 GMT X-Mailer: Mozilla 4.78 [en] (Windows NT 5.0; U) Lines: 35 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:259270 Joe I wrote: > > I have to learn PL/SQL and would like to take the "Oracle9i: Program > 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. 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"