Oracle Database 11g: Program With PL/SQL - 1Z0-144

Oracle Database 11g: Program with PL/SQL satisfies one of the two exams required in order to become an Oracle PL/SQL Developer Certified Associate. This exam is primarily targeted at entry-level developers. The exam assesses candidates for their knowledge in database-centric applications. The exam covers PL/SQL fundamentals, Declaration of Variables, Creating Functions, Procedures, Triggers, and Working with Packages.

uCertify courses include

Expert Instructor-Led Training

uCertify uses the content from the finest publishers and only the IT industry’s finest instructors. They have a minimum of 15 years real-world experience and are subject matter experts in their fields. Unlike a live class, you can study at your own pace. This creates a personal learning experience and gives you all the benefit of hands-on training with the flexibility of doing it around your schedule 24/7.

Interactive Exercises

Our courseware includes include real world, interactive exercises. uCertify always focuses on real world scenarios and skill-set development.

Exercises, Quizzes & Flashcards

uCertify’s exercises, quizzes and flashcards prepare you for your exams differently and more effectively than the traditional exam preps on the market. You will have practice quizzes, flashcards and exercises after each module to ensure you are confident on the topic you have completed before proceeding. This will allow you to gauge your effectiveness before moving to the next module in your course.

Practice Test Sets

uCertify courses also include full length practice test sets designed to test your knowledge under real exam conditions. Each course has a number of test sets consisting of hundreds of items to ensure you are 100% prepared before taking your certification exam.

Exam Simulators

Online labs to supplement your training. uCertify labs are inexpensive and way safe to explore and learn. uCertify labs are versatile - labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training.

State of the Art Educator Tools

uCertify knows the importance of instructors and provide tools to help them do their job effectively. Instructors are able to clone and customize course. Do ability grouping. Create sections. Design grade scale and grade formula. Create and schedule assignments. Educators can also move a student from self-paced to mentor-guided to instructor-led mode in three clicks.

Award Winning Learning Platform (LMS)

uCertify has developed an award winning, highly interactive yet simple to use platform. uCertify understands that it is critical to help student focus on learning the subject and not learning the LMS. uCertify helps student retain and recall the knowledge by teaching students using interactive exercises. Features such as actionable analytics and study planner help in keeping students focused.

Skills Measured

• Introduction of PL/SQL
• Creation of functions, Procedures, and triggers
• Interaction with the Oracle Database Server
• Declaration of Variables, Functions and Triggers
• Packages
• Use of Dynamic SQL
• Managing Dependencies
• Handling Exceptions

Related Certifications

• Oracle Database SQL Expert
• Oracle Database 11g: SQL Fundamentals I - OCA
• Oracle Program With PL/SQL
• Oracle Database 11g: Advanced PL/SQL

Syllabus

• Chapter 1: Introduction to PL/SQL
  • Explain the need for PL/SQL
  • Explain the benefits of PL/SQL
  • Identify the different types of PL/SQL blocks
  • Output messages in PL/SQL
• Chapter 2: Declaring PL/SQL Variables
  • Recognize valid and invalid identifiers
  • List the uses of variables, declare and initialize variables, use bind variables
  • List and describe various data types using the %TYPE attribute
• Chapter 3: Writing Executable Statements
  • Identify lexical units in a PL/SQL block
  • Use built-in SQL functions in PL/SQL and sequences in PL/SQL expressions
  • Describe when implicit conversions take place and when explicit conversions have to be dealt with
  • Write nested blocks and qualify variables with labels
  • Write readable code with appropriate indentation
• Chapter 4: Interacting with the Oracle Database Server
  • Create PL/SQL executable blocks using DML and transaction control statements
  • Make use of the INTO clause to hold the values returned by a SQL statement
• Chapter 5: Writing Control Structures
  • Identify the uses and types of control structures
  • Construct and identify loop statements
  • Apply guidelines when using conditional control structures
  • Working with Composite Data Types
• Chapter 6: Create user-defined PL/SQL records
  • Create a record with the %ROWTYPE attribute
  • Create an INDEX BY table and INDEX BY table of records
  • Describe the differences among records, tables, and tables of records
• Chapter 7: Using Explicit Cursors
  • Distinguish between usage of implicit and explicit cursors, use SQL cursor attributes
  • Declare and control explicit cursors, use simple loops and cursor FOR loops to fetch data
  • Declare and use cursors with parameters
  • Lock rows with the FOR UPDATE clause and reference the current row with the WHERE CURRENT OF clause
• Chapter 8: Handling Exceptions
  • Define PL/SQL exceptions
  • Recognize unhandled exceptions
  • Handle different types of exceptions
  • Propagate exceptions in nested blocks and call applications
• Chapter 9: Creating Stored Procedures and Functions
  • Differentiate between anonymous blocks and subprograms
  • Create a simple procedure and invoke it from an anonymous block
  • Create a simple function
  • Create a simple function that accepts a parameter
  • Differentiate between procedures and functions
• Chapter 10: Creating Procedures
  • Differentiate between anonymous blocks and subprograms
  • Create a simple procedure and invoke it from an anonymous block
  • Work with procedures
  • Handle exceptions in procedures, remove a procedure, and display a procedure's information
• Chapter 11: Creating Functions
  • Differentiate between a procedure and a function
  • Describe the uses of functions
  • Work with functions (create, invoke, and remove functions)
• Chapter 12: Creating Packages
  • Identify the benefits and the components of packages
  • Work with packages
• Chapter 13: Working with Packages
  • Overload package subprograms, use forward declarations
  • Create an initialization block in a package body
  • Manage persistent package data states
• Chapter 14: Using Oracle-Supplied Packages in Application Development
  • Describe how the DBMS_OUTPUT package works
  • Use UTL_FILE to direct output to operating system files
  • Describe the main features of UTL_MAIL
• Chapter 15: Using Dynamic SQL
  • Describe the execution flow of SQL statements
  • Use Native Dynamic SQL (NDS)
  • Use the DBMS_SQL package
• Chapter 16: Design Considerations for PL/SQL Code
  • Create standard constants and exceptions
  • Write and call local subprograms
  • Control the run-time privileges of a subprogram
  • Perform autonomous transactions
  • Use NOCOPY hint, PARALLEL ENABLE hint, and DETERMINISTIC clause
  • Use bulk binding and the RETURNING clause with DML
• Chapter 17: Creating Triggers
  • Describe different types of triggers and their uses
  • Create database triggers
  • Manage triggers
• Chapter 18: Creating Compound, DDL, and Event Database Triggers
  • Create triggers on DDL statements
  • Create triggers on system events
  
  
• Chapter 19: Using the PL/SQL Compiler
  • Describe the new PL/SQL compiler and features
  • Use the new PL/SQL compiler initialization parameters
  • Use the new PL/SQL compile time warnings
• Chapter 20: Managing PL/SQL Code
  • Describe and use conditional compilation
  • Hide PL/SQL source code using dynamic obfuscation and the Wrap utility
• Chapter 21: Managing Dependencies
  • Track and manage procedural dependencies

Currently there are no Q&As for this course. Be the first to ask a question.