Database-SQL/PLSQL – Course Contents

Database-SQL/PLSQL – Course Contents

PLSQL Online Training from India

PLSQL Online Training from India

Course Duration: – 30 Sessions (Each session is 1Hr)
Objectives

At the end of Oracle Database – SQL and PL/SQL training course, the student will be able to :

  • Understand different types of SQL queries (DDL, DML, TCL)
  • Use built-in functions of Oracle database
  • Use single row and multi row functions
  • Develop the business logic in database server using PL/SQL
  • Define triggers, functions, procedures

Benefits to you:

  • 100% student satisfaction guaranteed, if NOT fee will be returned back to student
  • Hands-on practices
  • Teaching with real-time examples
  • Introduction of various tools to be used by PL/SQL developers/administrators

Course Contents

Introduction to SQL

  • Installation and configuration of Oracle Database Server
  • Types of SQL statements
    • DDL
    • DML
    • TCL
  • Sub queries
  • Types of Joins
  • Built-in functions of Oracle Database

Introduction to SQL and PL/SQL

  • PL/SQL Environment
  • Benefits of PL/SQL
  • Overview of the Types of PL/SQL blocks
  • Create and Execute a Simple Anonymous Block
  • Generate Output from a PL/SQL Block

Declaring PL/SQL Identifiers

  • Identify the Different Types of Identifiers in a PL/SQL subprogram
  • Use the Declarative Section to Define Idekntifiers
  • List the Uses for Variables
  • Store Data in Variables
  • Declare PL/SQL Variables

Writing Executable Statements

  • Describe Basic Block Syntax Guidelines
  • Use Literals in PL/SQL
  • Customize Identifier Assignments with SQL Functions
  • Use Nested Blocks as Statements
  • Reference an Identifier Value in a Nested Block
  • Qualify an Identifier with a Label
  • Use Operators in PL/SQL
  • Use Proper PL/SQL Block Syntax and Guidelines

Interacting with the Oracle Server

  • Identify the SQL Statements You Can Use in PL/SQL
  • Include SELECT Statements in PL/SQL
  • Retrieve Data in PL/SQL with the SELECT Statement
  • Avoid Errors by Using Naming Conventions When Using Retrieval and DML Statements
  • Manipulate Data in the Server Using PL/SQL
  • The SQL Cursor concept
  • Use SQL Cursor Attributes to Obtain Feedback on DML
  • Save and Discard Transactions

Writing Control Structures

  • Control PL/SQL Flow of Execution
  • Conditional processing Using IF Statements
  • Conditional Processing CASE Statements
  • Handle Nulls to Avoid Common Mistakes
  • Build Boolean Conditions with Logical Operators
  • Use Iterative Control with Looping Statements

Working with Composite Data Types

  • Learn the Composite Data Types of PL/SQL Records and Tables
  • Use PL/SQL Records to Hold Multiple Values of Different Types
  • Inserting and Updating with PL/SQL Records
  • Use INDEX BY Tables to Hold Multiple Values of the Same Data Type

Using Explicit Cursors

  • Cursor FOR Loops Using Sub-queries
  • Increase the Flexibility of Cursors By Using Parameters
  • Use the FOR UPDATE Clause to Lock Rows
  • Use the WHERE CURRENT Clause to Reference the Current Row
  • Use Explicit Cursors to Process Rows
  • Explicit Cursor Attributes
  • Cursors and Records

Handling Exceptions

  • Handling Exceptions with PL/SQL
  • Predefined Exceptions
  • Trapping Non-predefined Oracle Server Errors
  • Functions that Return Information on Encountered Exceptions
  • Trapping User-Defined Exceptions
  • Propagate Exceptions
  • Use The RAISE_APPLICATION_ERROR Procedure To Report Errors To Applications

Creating Stored Procedures and Functions    

  • Differences Between Anonymous Blocks and Subprograms
  • Creating and invoking Procedure
  • Creating and invoking Functions
  • Passing Parameter to the Function

Environment

  • Oracle Database Server

IDE: Oracle SQL Developer/ TOAD

 

 

PLSQL Online Training from India

Contact Us

5th Floor, T-Hub Building
IIIT Campus, Gachibowli Circle,
Hyderabad, Telangana 500032.
Phone: +91-9966465202 (India)
+1-415-935-5884 (USA) rajuonlinetraining@gmail.com
www.rajutechnologies.com
Skype: rajutechnologies

Raju Technologies

Raju Technologies is founded and operated by real-time EXPERTS. We'll assure that, training will be delivered with 100% quality. We always reachable after the training as well.