Basic SQL and PL/SQL

Duration : 2 Days

Introduction to SQL

• Oracle Datatypes
• Starting SQL* Plus
• Querying Database Tables
• Summarizing Data with Aggregate Functions
• Ordering the Result of a Query
• Aggregate Functions
• Grouping the Result of a Query

Querying Multiple Tables

• Collating Information
• Equi Joins
• Cartesian Joins
• Outer Joins
• Self Joins
• Set Operators
• Nested Queries

Data Manipulation and Control

• Data Defination Language
• Creating Tables
• Inserting Values in Table
• Updating Columns of a Table
• Deleting Rows in a Table
• Introduction to Views
• Manipulating the Basement through Views
• Rules for DML Statements of Join Views
• Dropping a View
• Database Security & Privileges
• GRANT Command
• REVOKE Command
• Application Privileges Management
• Enhancing Performance
• Sequences
• Maintaining Database Objects
• COMMIT and ROLLBACK

PL/SQL

• Introduction to PL/SQL
• The Advantage of PL/SQL
• PL/SQL Block Structure
• PL/SQL Architecture
• Fundamentals of PL/SQL
• PL/SQL Data Type

Variable and Constants

Assignments and Expressions

Built-in Functions

SQL within PL/SQL

Composite Datatypes

Cursor Management in PL/SQL

Cursor Manipulation

Implicit Cursor Attributes

Exception Handling in PL/SQL

Predefined Exceptions

User Defined Exceptions