Oracle

Oracle Training Institute in Bangalore With Live Projects

Minimum Eligibility

Graduate/ B.E/ B.Tech/ BCA/ MCA

 Promotional Discount

Internship Salary

Upto 15 % off

Rs 2000/-

COURSE FEES  RS.14,000/-

SKMTECHNOSOLZ provides in-depth knowledge of building database applications using the advanced features of PL/SQL. With the help of real-time examples, you will explore how to create stored procedures, packages, functions, database triggers, cursors, collections, etc. You will also get an opportunity to work on hands-on projects, and this will enable you to become a certified Oracle PL SQL developer.

Benefits of learning Oracle training course in Bangalore @ SKMTECHNOSOLZ

  • Leading Drupal training institute in Bangalore
  • State of the art infrastructure
  • Industry Experienced and skilled teachers
  • Facility to work on “Live” Projects
  • Certificate on completion of the Course
  • 100% Job Assistance Guaranteed!

ORACLE Course Content

Module 1 Oracle Syllabus

Writing Basic SQL SELECT Statements
    •  Basic SELECT Statement
    • Selecting All Columns
    • Selecting Specific Columns
    • Writing SQL Statements
    • Column Heading Defaults
    • Arithmetic Expressions
    • Using Arithmetic Operators
    • Operator Precedence
    • Using Parentheses
    • Defining a Null Value
    • Null Values in Arithmetic Expressions
    • Defining a Column Alias
    • Using Column Aliases
    • Concatenation Operator
    • Using the Concatenation Operator
    • Literal Character Strings
    • Using Literal Character Strings
    • Duplicate Rows
    • Eliminating Duplicate Rows
    • Limiting Rows Using a Selection
    • Limiting the Rows Selected
    • Using the WHERE Clause
    • Character Strings and Dates
    • Comparison Conditions
    • Using Comparison Conditions
    • Other Comparison Conditions
    • Using the BETWEEN Condition
    • Using the IN Condition
    • Using the LIKE Condition
    • Using the NULL Conditions
    • Logical Conditions
    • Using the AND Operator
    • Using the OR Operator
    • Using the NOT Operator
    • Rules of Precedence
    • ORDER BY Clause
    • Sorting in Descending Order
    • Sorting by Column Alias
    • Sorting by Multiple Columns
    • SQL Function
    • Two Types of SQL Functions
    • Single-Row Functions
    • Single-Row Functions
    • Character Functions
    • Character Functions
    • Case Manipulation Functions
    • Using Case Manipulation Functions
    • Character-Manipulation Functions
    • Using the Character-Manipulation Functions
    • Number Functions
    • Using the ROUND Function
    • Using the TRUNC Function
    • Using the MOD Function
    • Working with Dates
    • Arithmetic with Dates
    • Using Arithmetic Operators with Dates
    • Date Functions
    • Using Date Functions
    • Practice 3, Part One:
    • Conversion Functions
    • Implicit Data Type Conversion
    • Explicit Data Type Conversion
    • Using the TO_CHAR Function with Dates
    • Elements of the Date Format Model
    • Using the TO_CHAR Function with Dates
    • Using the TO_CHAR Function with Numbers
    • Using the TO_NUMBER and TO_DATE Functions
    • RR Date Format
    • Example of RR Date Format
    • Nesting Functions
    • General Functions
    • NVL Function
    • Using the NVL Function
    • Using the NVL2 Function
    • Using the NULLIF Function
    • Using the COALESCE Function
    • Conditional Expressions
    • The CASE Expression
    • Using the CASE Expression
    • The DECODE Function
    • Using the DECODE Function
    • Displaying Data from Multiple Tables
    • Obtaining Data from Multiple Tables
    • Cartesian Products
    • Generating a Cartesian Product
    • Types of Joins
    • Joining Tables Using Oracle Syntax
    • What is an Equijoin?
    • Retrieving Records with Equijoins
    • Additional Search Conditions Using the AND Operator
    • Qualifying Ambiguous Column Names
    • Using Table Aliases
    • Joining More than Two Tables
    • Non-Equijoins
    • Retrieving Records with Non-Equijoins
    • Outer Joins Outer Joins Syntax
    • Using Outer Joins
    • Self Joins
    • Joining a Table to Itself
    • Joining Tables Using SQL: 1999 Syntax
    • Creating Cross Joins
    • Creating Natural Joins
    • Retrieving Records with Natural Joins
    • Creating Joins with the USING Clause
    • Retrieving Records with the USING Clause
    • Creating Joins with the ON Clause
    • Retrieving Records with the ON Clause
    • Creating Three-Way Joins with the ON Clause
    • INNER Versus OUTER Joins
    • LEFT OUTER JOIN
    • RIGHT OUTER JOIN
    • FULL OUTER JOIN
    • Additional Conditions
    • Aggregating Data Using Group Functions
    • What Are Group Functions?
    • Types of Group Functions
    • Group Functions Syntax
    • Using the AVG and SUM Functions
    • Using the MIN and MAX Functions
    • Using the COUNT Function
    • Using the DISTINCT Keyword
    • Group Functions and Null Values
    • Using the NVL Function with Group Functions
    • Creating Groups of Data
    • Creating Groups of Data: The GROUP BY Clause Syntax
    • Using the GROUP BY Clause
    • Grouping by More Than One Column
    • Using the GROUP BY Clause on Multiple Columns
    • Illegal Queries Using Group Functions
    • Excluding Group Results
    • Excluding Group Results: The HAVING Clause
    • Using the HAVING Clause
    • Nesting Group Functions
    • Subqueries
    • Objectives
    • Using a Subquery to Solve a Problem
    • Subquery Syntax
    • Using a Subquery
    • Guidelines for Using Subqueries
    • Types of Subqueries
    • Single-Row Subqueries
    • Executing Single-Row Subqueries
    • Using Group Functions in a Subquery
    • The HAVING Clause with Subqueries
    • What is Wrong with this Statement?
    • Will this Statement Return Rows?
    • Multiple-Row Subqueries
    • Using the ANY Operator in Multiple-Row Subqueries
    • Using the ALL Operator in Multiple-Row Subqueries
    • Null Values in a Subquery
    • Manipulating Data
    • Data Manipulation Language
    • Adding a New Row to a Table
    • The INSERT Statement Syntax 8-5
    • Inserting New Rows
    • Inserting Rows with Null Values
    • Inserting Special Values
    • Inserting Specific Date Values
    • Creating a Script
    • Copying Rows from Another Table
    • Changing Data in a Table
    • The UPDATE Statement Syntax
    • Updating Rows in a Table
    • Updating Two Columns with a Subquery
    • Updating Rows Based on Another Table
    • Updating Rows: Integrity Constraint Error
    • Removing a Row from a Table

Module 2 Plsql syllabus

Part I: Programming in PL/SQL
    • Introduction to PL/SQL
    • What Is PL/SQL?
    • The Origins of PL/SQL
    • About PL/SQL Versions
    • Resources for PL/SQL Developers
    • Creating and Running PL/SQL Code
    • SQL*Plus
    • Performing Essential PL/SQL Tasks Calling PL/SQL from Other Languages
    • Language Fundamentals
    • PL/SQL Block Structure
    • The PL/SQL Character Set
    • Identifiers
    • Literals
    • The Semicolon Delimiter
    • Comments
    • The PRAGMA Keyword
    • Labels
    • Part II: PL/SQL Program Structure
    • Conditional and Sequential Control
    • IF Statements
    • CASE Statements and Expressions
    • The GOTO Statement
    • The NULL Statement
    • Iterative Processing with Loops
    • Loop Basics
    • The Simple Loop
    • The WHILE Loop
    • The Numeric FOR Loop The Cursor FOR Loop
    • Loop Labels
    • Tips for Iterative Processing
    • Exception Handlers
    • Exception-Handling Concepts and Terminology
    • Defining Exception Raising Exceptions
    • Handling Exceptions
    • Building an Effective Error Management Architecture
    • Making the Most of PL/SQL Error Management
    • Part III: PL/SQL Program Data
    • Working with Program Data
    • Naming Your Program Data
    • Overview of PL/SQL Datatypes
    • Declaring Program Data
    • Programmer-Defined Subtypes
    • Conversion Between Datatypes
    • Strings
    • String Datatypes
    • Working with Strings
    • String Function Quick Reference
    • Numbers
    • Numeric Datatypes
    • Number Conversions
    • Numeric Functions
    • Records
    • Records in PL/SQL
    • Collections
    • Collections Overview
    • Collection Methods (Built-Ins)
    • Working with Collections
    • Nested Table Multiset Operations
    • Maintaining Schema-Level Collections
    • Miscellaneous Datatypes
    • The BOOLEAN Datatype
    • The RAW Datatype
    • The UROWID and ROWID Datatypes
    • The LOB Datatypes
    • Working with LOBs
    • Predefined Object Types
    • Part IV: SQL in PL/SQL
    • DML and Transaction Management
    • DML in PL/SQL
    • Bulk DML with the FORALL Statement
    • Transaction Management
    • Autonomous Transactions
    • Data Retrieval
    • Cursor Basics
    • Working with Implicit Cursors
    • Working with Explicit Cursors
    • BULK COLLECT
    • SELECT … FOR UPDATE
    • Cursor Variables and REF CURSORs
    • Cursor Expressions
      Procedures, Functions, and Parameters
    • Procedures
    • Functions
    • Parameters
    • Local Modules
    • Module Overloading
    • Forward Declarations
    • Advanced Topics
    • Go Forth and Modularize!

       

 

Module 3 Oracle Forms

Oracle Forms Developer 10g: Build Internet Applications
  • Introducing Oracle Forms Developer and Forms Services
  • Grid Computing
  • Oracle 10g Products
  • Oracle Application Server 10g Architecture
  • Benefits and Components of Oracle Developer Suite 10g
  • Running a Forms Developer Application
  • Working in the Forms Developer Environment
  • Creating Forms Modules
  • Working with Data Blocks and Frames
  • Working with Input Items
  • Working with Non Input Items
  • Working with Windows and Canvases
  • Producing Triggers
  • Debugging Triggers
  • Adding Functionality to Items
  • Run-Time Messages and Alerts
  • Query Triggers
  • Validation
  • Navigation
  • Transaction Processing
  • Sharing Objects and Code
  • Using WebUtil to Interact with the Client
  • Introducing Multiple Form Applications

Send us your details & we will get back to you +917483811438