• This course has been retired. Users who have purchased the course will still have access to it, however it is no longer available for purchase.

Oracle PL/SQL Programming Part 1

What should I do if my video will not play?

There are many things that can affect the quality of your video so we have put together these instructions to help you review all the things that need to be tested in order to trouble-shoot video quality.

The first thing we want to assure you is that we have done everything possible to make sure that our videos will play well.  Our videos are hosted in the cloud by Akamai.  Akamai has servers around the world to make sure that your videos are sent from the server that is closest to you.  By hosting our videos with Akamai we make sure that you receive the highest video quality. If you are experiencing video buffering or freezing at home or at the office there are a number of things you can do to help us troubleshoot.

  • Popup Blockers: Please check to make sure that your pop-up blocker is turned off when you go to our website. This will prevent the video window from opening.
  • Your Connection Speed: Internet speed needs to be 2.0 Mbps upload and download to successfully watch the videos.  You will want to check and see if your connection speed is 2.0 Mbps or higher.  You can do this by clicking on this link and running a speed test.
  • Jitter and Packet Loss: Your Jitter rate lets us know if your connection speed is consistent while your Packet Loss rate lets us know if your internet connection could be losing pieces of the video.
    • Go to https://www.dotcom-tools.com/ping-test.aspx to determine if there is any Jitter or Packet Loss on your connection.
    • This is measured by a letter scale with A being the best.
      • If your Packet Loss is below a B, your connection is losing pieces of the video and causing the video to skip.
      • If your Jitter is below a B, your connection speed is very inconsistent and may be changing while you are watching the video which will result in buffering issues.
      • If either of these is the case you will need to contact your internet provider.
  • Shared Internet Connection: If you are on a shared internet connection, test playing videos during non-peak hours when usage by others on your network is low.
  • Reset Your Browser: If you've tried all the previous steps, your browser may be retaining data that needs to be deleted, and this requires a reset. If you are using Chrome, use the instructions in this link to reset your browser. If you are using Internet Explorer (IE) you may need to reset it. You can do this by clicking on the cog icon on the top right of your page. Then click on tools, internet options, advanced and reset. If you are using Firefox, use the instructions in this link to reset your browser.
  • Other things to check:
    • At home or at work, test using different browsers and computers to see if you get the same result.
      • Make sure you have the latest version of the browser you are using.
    • If you are using Internet Explorer (IE) you may need to reset it. You can do this by clicking on the cog icon on the top right of your page. Then click on tools, internet options, advanced and reset.
    • Try from a different location using a different network.
    • If you are on a wireless connection try a wired solution.
    • If you are on a home network:
      • Test playing the videos when you are the only user on the network.
      • Try by-passing your router to eliminate it as the point of failure. A direct plug from your ISP to your computer will take care of this and will make sure that neither your router nor other users are affecting your connection.
    • If you are running Firefox, you can check your plugins here: https://www.mozilla.org/en-US/plugincheck/
  • Make sure you do not have any other programs open. File sharing and peer to peer sharing programs, even when limited to low bandwidth, can make it almost impossible to stream properly.
  • Tracking Progress on Mobile Devices: The GogoTraining site is designed to use the native player found in your browser. If you are taking your course on a mobile device and want to make sure your progress is tracked, then you will need to play the videos from the native player that is in your browser. Do not download any third party apps to play the videos as they do not allow your progress to be recorded. If you have installed a third party app and want to receive a Course Completion Certificate, then you will need to uninstall the 3rd party app or see if the app has the ability for you to disable it for certain sites.
  • Submitting Debugging Information If you have tried everything else and still are having trouble viewing the videos, you can visit this page where you can help us debug your particular setup by following the instructions on the page and submit the debugging information to us.
Video Title
00: Oracle 11g PL/SQL Programming Part 1 Online Training - Course Introduction
6 min
01: PL/SQL Overview Part 1
22 min
02: PL/SQL Overview Part 2
30 min
03: I/O Within PL/SQL and Overview of Sample Environment
23 min
04: Datatypes and Scalar Variables
25 min
05: Composite Variables
22 min
06: Datatypes and Scalar Variables Exercise and Exercise Review
7 min
07: SQL Statements in PL/SQL
15 min
08: DML Commands and Transaction Processing
22 min
09: DML Commands and Transaction Processing Exercise and Exercise Review
6 min
10: IF and CASE Statements
22 min
11: Loops and Labels
29 min
12: Exception Handling
25 min
13: Pre-Defined Exceptions
18 min
14: Using SQL code, SQLERRM and User-defined Exceptions
15 min
15: User-Defined Exceptions Exercise and Exercise Review
12 min
16: Exception Propagation and Displaying Errors
16 min
17: Exception Propagation and Displaying Errors Exercise and Exercise Review
10 min
5 hrs 25 mins

Mary Gable

Mary Hunsaker Gable has been designing, administering, and developing applications, databases, and education solutions for the Oracle database for over twenty-three years beginning with version 5 of the database. With no choice but to use Pro*PL/1 and Pro*C, she was excited to take advantage of PL/SQL when it was initially released and used it along with Oracle’s Forms and Reports tools to develop her company’s custom accounting software. While watching PL/SQL grow into a robust (and sane) environment for Oracle development, Mary combined her passion for Oracle with her passion for teaching and created Preferred Training Solutions in 1993. In addition to PL/SQL, her favorite, she regularly teaches the full curriculum of Oracle database administration and application development courses worldwide for many Fortune 100 companies such as Hewlett-Packard, IBM, Fannie Mae, Northrop Grumman, various universities, and local, state, and federal government. Mary is active in the Oracle user group community and has authored and presented dozens of papers for various Oracle user groups. She founded the Hampton Roads Oracle User Group (HROUG) in 1993 and continues to serve the local user group community as a board member, frequent presenter, and IOUG representative.  She has been chosen by Steven Feuerstein to lead the PL/SQL Fundamentals track at OPP conferences OPP '07, OPP '08, and OPP '09 being held in Atlanta, Nov. 10-11, 2009.

System Requirements


  • RAM: 256 MB minimum: 512 MB recommended.  On windows Vista, the minimum requirement is 512 MB
  • Virtual memory is double the amount of RAM
  • Disk Space for basic installation is 2.04 GB, advanced installation is 1.94 GB
  • Video adapter: 256 colors
  • Processor: 550 MHz minimum. On windows Vista, the minimum requirement is 800 MHz
  • Oracle Database components include 32 MB hard disk to install java Runtime Environment (JRE) and Oracle Universal Installer on the partition where the operating system is installed


Detailed set up is provided in the Oracle Installation Guide. Select the appropriate version of the Oracle database to download.

Course Links

These links are activated when you purchase this course.

  • Course Survey
  • Oracle PL/SQL Enhancements


This course comes with a Transcript that tracks your progress. You can use your transcript to view and monitor your progress and when you complete the course, you can print or email the transcript.

Certificate of Completion

You will be awarded a Certificate of Completion when you finish this course. You will be able to print or email the certificate and share your accomplishment with everyone.

How to Take Your Exam

Oracle 10g/11g PL/SQL programming Part 1 is part of a two-course online training series that helps you to prepare for one of the following exams: 1Z0-147 Program with PL/SQL or 1Z0-144 Oracle Database 11g: Program with PL/SQL. When you pass one of these exams, you have completed a portion of the requirements towards the Oracle PL/SQL Developer Certified Associate certification.

For more information about certification, requirements and fees, click on the link found in Related Links.