Intermediate Microsoft SQL Database

Gain hands-on experience with Oracle’s PL/SQL programming language, with expert assistance from an IT veteran. PL/SQL is Oracle’s procedural language extension to Structured Query Language (SQL).

This course will give you the skills you need to write powerful and flexible programs using that language. You’ll learn the building blocks and core features of PL/SQL, including expressions, various iterations, and built-in functions. Then, you’ll begin building fully functional PL/SQL programs with procedures, packages, debugging routines, database structures, triggers, and cursor processing. By the time you finish this course, you will be able to store PL/SQL programs in a database and execute them.

Duration: 3 Months

  • Details
    • Learn the building blocks and core features of PL/SQL
    • Begin building fully functional PL/SQL programs
    • Understand procedures, packages, debugging routines, database structures, triggers, and cursor processing
    • Learn how to store PL/SQL programs in a database and execute them
  • Course Outline

    Introduction to PL/SQL
    Datatypes and Block Structure
    Operators, Expressions, and Datatype Conversions
    PL/SQL Functions, IF Statements, and Looping Statements
    GOTO Statement, Statement Labels, and Loop Constructs
    Oracle’s Built-In Functions
    Procedures and Packages
    Errors and Exceptions
    Types of SQL Statements, Declaring Variables in PL/SQL, and Transaction Management
    Using Cursors
    Database Triggers, Advanced Cursor Concepts, and Managing PL/SQL Code
    Debugging Your Code

  • Requirements

    Prerequisites:

    Completion of Cindy Delia’s Introduction to Oracle course (or equivalent experience).

    Requirements:

    Hardware Requirements:

    • This course can be taken on either a PC or Mac.

    Software Requirements:

    • PC: Windows XP or later.
    • Mac: OS X Snow Leopard 10.6 or later.
    • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
    • Oracle’s Database Software. The Database Software is available for downloading from Oracle’s website (www.oracle.com). Download the Oracle Database that supports your operating system. This course provides post-installation instruction on Oracle. Installation support will not be provided in the course. Installation support is provided from Oracle’s website.
    • Adobe Flash Player. Click here to download the Flash Player.
    • Adobe Acrobat Reader. Click here to download the Acrobat Reader.
    • Software must be installed and fully operational before the course begins.

    Other:

    • Email capabilities and access to a personal email account.

Course Fee: USD 120Now available at Afghanistan, Bangladesh, Bhutan, India, Maldives, Nepal, Pakstan and Sri Lanka

Post An Inquiry Register Now