Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 8 images

Oracle PL/SQL: The Complete Video Course Multimedia CD – December, 2000

3.6 out of 5 stars 5 customer reviews

See all formats and editions Hide other formats and editions
New from Used from
Multimedia CD, December, 2000
"Please retry"

Top 20 lists in Books
Top 20 lists in Books
View the top 20 best sellers of all time, the most reviewed books of all time and some of our editors' favorite picks. Learn more

Editorial Reviews

From the Back Cover

Fully Integrated Book/QuickTime Video Package—Expert Training at an Incredible Value!!

CD-ROM contains 31/2 hours of QuickTime video instruction PLUS the Oracle PL/SQL Interactive Workbook!

Covers syntax, program control, exceptions, cursors, procedures, functions, packages, stored code, triggers, PL/SQL tables, and more.

Features 31/2 hours of expert QuickTime video instruction by Columbia University instructor Elena Silvestrova.


See it, hear it, do it! There's never been a faster, more effective way to master Oracle PL/SQL. Based upon courses at Columbia University's prestigious "Database Application Development and Design" program, this book/video package uses real-world labs, exercises, projects, and insight to explore every aspect of Oracle PL/SQL development.

  • First, watch QuickTime video lectures as your personal instructor walks through every key concept
  • Line-by-line code analysis shows you exactly how it's done, step by step!
  • Then, work through hundreds of hands-on labs and exercises
  • Next, read related sections in the book for more detailed coverage
  • Finally, do your "homework"-real-world "Test Your Thinking" projects
Video Lectures Lecture 1 Programming Concepts Lecture 2 PL/SQL Concepts Lecture 3 General Programming Language Fundamentals Lecture 4 SQL in PL/SQL Lecture 5 Conditional Control Lecture 6 Exception Handling and Built-In Exceptions Lecture 7 Iterative Control Lecture 8 Introduction to Cursors Lecture 9 Exceptions Lecture 10 Exceptions: Advanced Concepts Lecture 11 Procedures Lecture 12 Functions Lecture 13 Packages Lecture 14 Stored Code Lecture 15 Triggers Lecture 16 PL/SQL Tables Key Topics

Covers every Oracle PL/SQL technique and concept you need to master:

  • PL/SQL syntax, structured programming, and iterative control
  • Scoping and anchored datatypes
  • Exception handling-in depth
  • Scoping, cursors, packaged code, and triggers
  • Advanced topics: stored code, package and parameter passing, and much more!
  • All beginning database programmers
  • Web developers building database-enabled applications with Oracle
  • Familiarity with SQL in Oracle 7, 8, or 8i database
TOTAL RUNNING TIME 3 HOURS 34 MINUTES SYSTEM REQUIREMENTS For Windows 300 MHz processor or higher Windows 95/98/NT 4.0x For Macintosh PowerPC 300 MHz processor or higher System 8.0 or above HARDWARE REQUIREMENTS 32 MB disk space/64 MB RAM 12x CD-ROM drive and sound card support Netscape 4.08 (included) QuickTime 4.1 (included) Adobe Acrobat Reader 4.0 (included)

Includes the best-selling Oracle PL/SQL Interactive Workbook. This innovative workbook teaches all of the Oracle PL/SQL skills you need- without the endless, boring discussions of most books. Integrated with the book's tutorials are hands-on practical exercises, self-review questions, and real-world labs. "Test Your Thinking" projects guarantee that you'll go beyond rote knowledge to really master the subject.

RAVE REVIEW! "This book is perfect for someone new to PL/SQL. The workbook holds your hand and walks you through PL/SQL programming, every step of the way."

About the Author

ELENA SILVESTROVA, BENJAMIN ROSENZWEIG and Series Technical Advisor DOUGLAS SCHERER are instructors at the Columbia University School of Continuing Education, specializing in database development and management.


Product Details

  • Series: Complete Video Courses
  • CD-ROM
  • Publisher: Prentice Hall PTR; 1st edition (December 2000)
  • Language: English
  • ISBN-10: 0130321257
  • ISBN-13: 978-0130321251
  • Product Dimensions: 9.7 x 7.3 x 2.7 inches
  • Shipping Weight: 2.5 pounds
  • Average Customer Review: 3.6 out of 5 stars  See all reviews (5 customer reviews)
  • Amazon Best Sellers Rank: #6,198,246 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

A deft and knowledgeable hand who ably presents lean and well thought out material, Ms. Silvestrova avoids the trap of spending too much time attempting to create a glossy and slick presentation, and quickly gets down to the business of teaching PL/SQL. Her slight accent was melodious, and served to inject freshness into the teaching of a technical subject.
I found this course not only highly satisfying, but also very effective in making PL/SQL an easily approachable subject. The emphasis obviously is placed on teaching a technical subject in a down to earth fashion, not on entertaining the audience with a glitzy set and air brushed actors. If the latter is what you want, better wait for the Walt Disney version (or buy one of the slickly produced competing PL/SQL videos on the market - this is experience speaking here). However, if you are a serious student, who seeks a sound introductory foundation and a solid immersion into the heart of intermediate PL/SQL, delivered by an apparently seasoned professional, then look no further. A+
Comment 2 of 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
One star is way to high of a rating for this book!! I bought this set hoping that I would get in-depth knowledge of the PL/SQL programming language. I was greatly disappointed. First of all, I have no clue how the author, Elena Silvestrova, got her job with Columbia University. The presentation material was read directly out of the book. She did not elaborate on any examples at all. Isn't that the point of a video course??? Many times she would read an example incorrectly and then move to the next slide then catch her mistake and go back to the previous slide to correct her mistake! The video was very unorganized and not edited well at all. You could pick the book up and literally read the entire video course with her. Elena Silvestrova has a very heavy accent and it's quite hard to make out what she is reading. Her presentation skills are very poor and she stumbles through sentences. You would be better off to just to skip this one as I have put mine back in box. I stopped this course after chapter four and had to come to this site and leave my comments.
Comment 3 of 4 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
By A Customer on December 10, 2001
I bought the video expecting a better speaker. The woman who is the lecturer has a very heavy Russian accent, pauses often in mid sentence, blinks a lot and lacks dynamic presentation skills. The content seems ok, but a better presenter would improve the video greatly. Also, I can't understand why the cameraman doesn't center the camera.
Comment 3 of 4 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
With over twenty years in large scale IT development using Java/C++/C/Assembly languages on HP-UX/Solaris/AIX/Windows 2000/NT platforms, but a neophyte with PL/SQL, I needed a PL/SQL package that would assume no background knowledge in PL/SQL, get me up to speed fast, and at the same time be comprehensive. In other words, I wanted everything. This package no only satisfied this need, but opened up new avenues of thought concerning approaches to database programming. The book is simply matchless (it should get 6 stars--an extra star for the terrific exercises that incorporate hidden pearls of IT wisdom), and yes I have perused others on the market. Ms. Silvestrova demonstrates that she is a consummate professional. The flow of the book, depth of the hands-on exercises, and scope of material is an inimitable combination. This so far may sound over-glowing, but a workman is worthy of her hire. I would recommend this package to any introductory or middle level PL/SQL student. If you desire to be a competent PL/SQL professional, look no further. If you desire to have a guide that provides you with a solid answer to specific types of PL/SQL problems, look no further. However, if you seek a slick product that spoon feeds you programming palaver (under the guise of teaching), fly you fool: you have many under-performing options available. The video is as effective as any video can be on a Sequential Non-Event Oriented and Non-GUI programming language. It provides a visual venue that reinforces and compliments what the student should have accomplished in the workbook. Let's avoid any petulance or semantic superciliousness: Yes, Ms. Silvestrova has a slight accent, but no more than how someone from Alabama would sound to a New Yorker or vice-versa. She is easy to listen to, and more importantly, easy to learn from.
Buy it, try it, apply it!!!
Comment 2 of 3 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Both this book and the similiar Oracle DBA book are magnificent. Each in their subject area is the most effective training books I've ever used, and I've had to read WAY too many in my career. The PL/SQL book gives superb examples- each example is a complete runnable block, not an excerpted fragment. So you don't have to flip all over the place to understand how the statements work together ot to test it out yourself. The book's diagrams are also very good. The explanation text is lucid and well organized. I really dont see how the books could be much better unless they could do a Vulcan Mind Meld!
The video on the other hand is quite disappointing, really almost useless. I had real difficulty understanding the instructor. The pronunciation and mangling of english constructs results in a presentation that is very difficult to follow - especially considering you are trying to learn a difficult and complex technical subject. Buy the book (seperately), and you will have the best tool for learning PL/SQL short of a personal tutor. Makes the Complete Reference series seem like random monkey typing!
Comment 2 of 3 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse