Course Outline for Oracle PL/SQL
OL 101: Introduction to Oracle
Goal:
This
course is designed to aim at imparting a basic level Oracle database. After
completing the course the incumbent is able to the write, execute and
understand sql statement and basic PL/SQL programming.
Pre-requisites:
Student should have basic knowledge of programming.
Prepares for:
Oracle database and PL/SQL programming
Audience:
IT professionals or B.Tech / MCA students etc.
Duration:
1.5 Months (30 hours)
Course Outline:
Overview of Oracle:
- Overview of Oracle Database and architecture
- Overview of Transactions
- Commit and Undo Transactions
- Savepoints
- Overview of Oracle SQL
Overview of SQL:
- Use of DDL Statements to Create and Manage Tables
- Overview of Datatypes
- Overview of Data Integrity, Integrity Constraints & Keys
- Data Manipulation Statements
- DCL - Data Control Language. Some examples:
- TCL - Transaction Control:
- Retrieve Data using the SQL SELECT Statement
- Learn to Restrict and Sort Data
- Usage of Single-Row Functions to Customize Output
- Invoke Conversion Functions and Conditional Expressions
- Aggregate Data Using the Group Functions
- Display Data From Multiple Tables Using Joins
- Use Sub-queries to Solve Queries
- The SET Operators
- Function
- Expressions
- Other Schema Objects
- Pseudocolumns
Overview of PL/SQL:
- Understanding the basic Features of PL/SQL
- Block Structure
- Variables, Assignment and Operators
- Writing Control Structures
- Cursors
- Cursor FOR Loops
- Cursor Variables Attributes
- Procedures
- Functions
- Packages
- Triggers
- Error Handling
OL 102: Advance Oracle
Goal:
This
course is designed to aim at imparting advance level Oracle database. After
completing the course the incumbent is able to do Advance level oracle database
handling and PL/SQL programming.
Pre-requisites:
Student should have basic knowledge of oracle (OL 101)
Prepares for:
Advance level Oracle PL/SQL Programming
Audience:
IT professionals or B.Tech / MCA students etc.
Duration:
1.5 Months (30 hours)
Course Outline:
- Advance on Oracle:
- Advance
on Oracle architecture
- Physical Database Structures
- Logical
Database Structures
- Schemas and
Common Schema Objects
- System
Global Area
- Program
Global Area
- Oracle
Background Processes
- Overview
of Datawarehousing with oracle
- How
to Write Tuned Queries
- Advance
on Indexes
- Concepts
of View/Materialized view
- Concepts
of Table partitioning
- Database
Security
Advance on PL/SQL:
PL/SQL
Architecture
OOP
with PL/SQL
Different
types of Cursors and their attributes
IF
Vs. CASE
Working
with Collections
Concept
of BULK
Use
of built-in oracle packages.
Use
of advance features of packages
Use
of Dynamic SQL
Tuning
PL/SQL Application
Concepts
on creating flat files.
|
+91-9999-283-283/9540-283-283
info@sisoft.in