Oracle SQL Training in Bangalore

Chapter 1 – Retrieving Data Using the SQL SELECT Statement

• • The SELECT Statement
  • The SELECT and FROM Clauses
  • Conditions and the WHERE Clause
  • Other Conditional Operators
  • Logical Operators

Chapter 2 – Restricting and Sorting Data

• • The ORDER BY Clause
  • Column Aliases
  • Arithmetic Expressions
  • Precedence of Operators

Chapter 3 – Using Single-Row Functions to Customize Output

• • Function Types
  • Using Table dual to try out Functions
  • Numeric Functions
  • Character Functions
  • String Concatenation
  • Date Arithmetic and Date Functions

Chapter 4 – Using Conversion Functions and Conditional Expressions

• • Conversion Functions
  • NVL and NVL2
  • DECODE
  • CASE Expressions
  • COALESCE and NULLIF

Chapter 5 – Reporting Aggregated Data Using the Group Functions

• • SUM()
  • COUNT()
  • MIN()
  • MAX()
  • AVG()

Chapter 6 – Displaying Data from Multiple Tables

• • Overview of Table Joins
  • Inner Joins
  • Table Aliases
  • Outer Joins
  • Self Joins
  • ANSI Standard Joins

Chapter 7 – Using Sub queries to Solve Queries

• • Overview of Subqueries
  • Simple Subqueries
  • Complex Subqueries
  • Subquery Rules
  • Using the ANY, ALL and IN Operators

       Chapter 8 – Using the Set Operators

• • UNION ,UNION ALL,INTERSECT and MINUS

       Chapter 9 – Manipulating Data

• • Inserting Rows
  • Updating Rows
  • Deleting Rows
  • Verifying Updates
  • Transaction Control
  • Commit and Rollback
  • Save points
  • Commits and Constraints
  • Amending Data in SQL Developer

Chapter 10 – Using DDL Statements to Create and Manage Tables

• • Creating Tables
  • Specifying Constraints
  • Altering Tables, Columns and Constraints
  • Dropping Tables, Columns and Constraints
  • Copying Tables
  • Data dictionary

Chapter 11 – Creating Other Schema Objects

• • Creating Indexes
  • Dropping Indexes
  • Listing Indexes
  • Creating and Using Views
  • Dropping Views
  • Listing Views
  • Create a Sequence
  • View Sequence Details
  • Create a Synonym
  • List Synonyms

Oracle 11g PL/SQL Course Content:

Introduction to PL/SQL

What is PL/SQL

PL/SQL Environment

Benefits of PL/SQL

Overview of the Types of PL/SQL blocks

Create and Execute a Simple Anonymous Block