Oracle 12c Developer

This Oracle Database: PL/SQL Fundamentals training introduces you to PL/SQL. It helps you understand the benefits of this powerful programming language, while teaching you real-world scenarios where these lessons can be applied.

In this course, you’ll learn from expert Oracle instructors, then engage in demonstrations and hands-on practice to reinforce the fundamental concepts. You’ll use Oracle SQL Developer to develop these program units. SQL*Plus is introduced as optional tools.

Oracle Database 12c: SQL Workshop I

  • Introduction
  • Retrieving Data using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data From Multiple Tables Using Joins
  • Using Subqueries to Solve Queries
  • Managing Tables using DML statements
  • Introduction to Data Definition Language

Oracle Database: SQL Workshop II

  • Introduction
  • Introduction to Data Dictionary Views
  • Creating Sequences, Synonyms, Indexes
  • Creating Views
  • Managing Schema Objects
  • Retrieving Data by Using Subqueries
  • Manipulating Data by Using Subqueries
  • Controlling User Access
  • Manipulating Data
  • Managing Data in Different Time Zones

Oracle Database 12c: PL/SQL Fundamentals

  • Introduction
  • Introduction to PL/SQL
  • Declaring PL/SQL Variables
  • Writing Executable Statements
  • Using SQL Statements within a PL/SQL Block
  • Writing Control Structures
  • Working with Composite Data Types
  • Using Explicit Cursors
  • Handling Exceptions
  • Creating Stored Procedures and Functions

Oracle Database: Develop PL/SQL Program Units

  • Introduction
  • Creating Stored Procedures
  • Creating Functions and Debugging Subprograms
  • Creating Packages
  • Working With Packages
  • Using Oracle-Supplied Packages in Application Development
  • Using Dynamic SQL
  • Design Considerations for PL/SQL Code
  • Creating Triggers
  • Creating Compound, DDL, and Event Database Triggers
  • Using PL/SQL compiler
  • Managing Dependencies

Oracle Database SQL 1Z0-071

Oracle Database 12c Advanced PL/SQL 1Z0-148

Coming soon.

We are looking forward to hear from you


Name:
Phone:
Email:
Experience:
Current Location:
Preferred Location:
Course Interested in:
Comments:

Enter this code here

You can also reach us directly:


Chennai
Ms. Praveena
Phone: +91 98942 66663
Email: praveena.m@mazenetsolution.com


Services