Get our Monthly News & Offers

Get great offers and monthly Academy updates delivered straight to your inbox monthly, just a click away, Sign Up Now.

Oracle Database SQL/PLSQL

Oracle Database SQL/PLSQL

Categories: , ,

Description

Oracle Database technology is used by the world’s leading companies to manage critical business functions, systems and processes.

  • Oracle Database is the number one database in the world.
  • Over 305,000 top companies trust their critical systems to Oracle Database.
  • Oracle Database is the number one embedded database technology.

In fact, 97% of Global Fortune 500 companies use Oracle software. Well-trained, highly-skilled database professionals who can manage critical systems are in high demand.

The process of becoming Oracle Database certified broadens your knowledge and skills by exposing you to a wide array of important database features, functions and tasks. Oracle Database certification teaches you how to perform complex, hands-on activities through labs, study and practice.

Get brochure here.

Who Should Attend

  • Data Warehouse Administrator
  • PL/SQL Developer
  • Application Developers
  • System Analysts
  • Business Analysts
  • Forms Developer
  • Developer

What You Will Cover

• INTRODUCTION TO PL/SQL

• 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 FUNCTION

• DISPLAYING DATA FROM MULTIPLE TABLES USING JOIN

• USING SUBQUERIES TO SOLVE QUERIES

• USING THE SET OPERATOR

• MANAGING TABLES USING DML STATEMENTS

• CREATING SEQUENCES, SYNONYMS, INDEXES

• CREATING VIEWS

• MANAGING SCHEME OBJECY

• RETRIEVING DATA BY USING SUBQUERIES

• CONTROLLING USER ACCESS

• MANIPULATING DATA

• DECLARE PL/SQL VARIABLE

• WRITE ANONYMOUS PL/SQL BLOCKS

• CONTROL STRUCTURE

• COMPOSITE DATA TYPES

• EXPLICIT CURSORS

• EXCEPTION HANDLING

• STORED PROCEDURE

• STORED FUNCTIONS

• PACKAGES

• DYNAMIC SQL

• DESIGN CONSIDERATIONS FOR PL/SQL CODE

• TRIGGERS

Reviews

There are no reviews yet.

Be the first to review “Oracle Database SQL/PLSQL”

Your email address will not be published. Required fields are marked *

Riang@Work - Skilled & Secured

Attend Our Free Training

I want to Attend! Tell me more.