|
|
| Oracle Developer 11g/12g |
PROGRAMS |
PRE
REQUISITES |
MODULE WISE DETAILS |
COURSE
DURATION |
ORACLE 11g/12g Developers |
UG / PG / Diploma /BE/ Btech / ME / Mtech in any stream with/without Programming
Knowledge |
OCA Developer |
4 Days |
12 Days
|
a. SQL with Dumps |
2 Days |
b. PLSQL with Dumps |
2 Days |
| Advanced SQL& PLSQL with Performance Tuning |
2 Day |
UNIX Shell Scripting - Basics |
1 Day |
Projects , Real time scenarios,
Case Studies and Mock Interviews |
1 Day |
Course Content
Oracle SQL: SESSION I: UNIT I
Introducing Oracle
Course Contents Oracle SQL: SESSION I: UNIT I
Introducing Oracle Database 11g
List the features of Oracle Database 11g
Discuss the basic design, theoretical and physical aspects of a relational database
Categorize the different types of SQL statements
Describe the data set used by the course
Log onto the database using the SQL Developer environment
Save queries to files and use script files in SQL Developer
Retrieving Data Using the SQL SELECT Statement
List the capabilities of SQL SELECT statements
Generate a report of data from the output of a basic SELECT statement
Select All Columns
Select Specific Columns
Use Column Heading Defaults
Use Arithmetic Operators
Understand Operator Precedence
Learn the DESCRIBE command to display the table structure
Restricting and Sorting Data
Write queries that contain a WHERE clause to limit the output retrieved
List the comparison operators and logical operators that are used in a WHERE clause
Describe the rules of precedence for comparison and logical operators
Use character string literals in the WHERE clause
Write queries that contain an ORDER BY clause sort the output of a SELECT statement
Sort output in descending and ascending order
UNIT 2 Using Single-Row Functions to Customize Output
Describe the differences between single row and multiple row functions
Manipulate strings with character function in the SELECT and WHERE clauses
Manipulate numbers with the ROUND, TRUNC and MOD functions
Perform arithmetic with date data
Manipulate dates with the date functions
Using Conversion Functions and Conditional Expressions
Describe implicit and explicit data type conversion
Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Nest multiple functions
Apply the NVL, NULLIF, and COALESCE functions to data
Use conditional IF THEN ELSE logic in a SELECT statement
UNIT 3 Reporting Aggregated Data Using the Group Functions
Use the aggregation functions in SELECT statements to produce meaningful reports
Create queries that divide the data in groups by using the GROUP BY clause
Create queries that exclude groups of date by using the HAVING clause
Displaying Data from Multiple Tables
Write SELECT statements to access data from more than one table
View data that generally does not meet a join condition by using outer joins
Join a table by using a self join
SESSION II: UNIT 4 Using Sub-queries to Solve Queries
Describe the types of problem that sub-queries can solve
Define sub-queries
List the types of sub-queries
Write single-row and multiple-row sub-queries
Using the SET Operators
Describe the SET operators
Use a SET operator to combine multiple queries into a single query
Control the order of rows returned when using the SET operators
Manipulating Data
Describe each DML statement
Insert rows into a table with the INSERT statement
Use the UPDATE statement to change rows in a table
Delete rows from a table with the DELETE statement
Save and discard changes with the COMMIT and ROLLBACK statements
Explain read consistency
UNIT 5 Using DDL Statements to Create and Manage Tables
Categorize the main database objects
Review the table structure
List the data types available for columns
Create a simple table
Decipher how constraints can be created at table creation
Describe how schema objects work
Creating Other Schema Objects
Create a simple and complex view
Retrieve data from views
Create, maintain, and use sequences
Create and maintain indexes
Create private and public synonyms
SESSION III: UNIT 6 & 7 Discussions on DUMPS and Assignments ORACLE PLSQL: SESSION VI:
Introduction to PLSQL and 11g Features
Tools and Utilities Supported By Oracle
UNIT 8: PL/SQL Concepts
PL/SQL in Client/Server Architecture
Use PL/SQL Anonymous Blocks
Understand How PL/SQL Gets Executed
PL/SQL in SQL*Plus
Use Substitution Variables
Use the DBMS_OUTPUT.PUT_LINE Statement
Try It Yourself
UNIT 9: General Programming Languages Fundamentals
PL/SQL Programming Fundamentals
Make Use of PL/SQL Language Components
Make Use of PL/SQL Variables
Handle PL/SQL Reserved Words
Make Use of Identifiers in PL/SQL
Make Use of Anchored Data types
Declare and Initialize Variables
Understand the Scope of a Block, Nested Blocks, and Labels
Try It Yourself
UNIT 10: SQL in PL/SQL
Making Use of DML in PL/SQL
Use the Select INTO Syntax for Variable Initialization
Use DML in a PL/SQL Block
Make Use of a Sequence in a PL/SQL Block
Making Use of SAVEPOINT
Make Use of COMMIT, ROLLBACK, and SAVEPOINT in a PL/SQL Block
Try It Yourself
UNIT 11: Conditional Control: IF Statements
IF Statements
Use the IF-THEN Statement
Use the IF-THEN-ELSE Statement
ELSIF Statements
Use the ELSIF Statement
Nested IF Statements
Use Nested IF Statements
Try It Yourself
SESSION VII: UNIT 12: Conditional Controls: CASE Statements
CASE Statements
Use the CASE Statement
Use the Searched CASE Statement
CASE Expressions
Use the CASE Expression
NULLIF and COALESCE Functions
The NULLIF Function
Use the COALESCE Function
Try It Yourself
UNIT 13: Iterative Controls: Part I
Simple Loops
Use Simple Loops with EXIT Conditions
Use Simple Loops with EXIT WHEN Conditions
WHILE Loops
Use WHILE Loops
Numeric FOR Loops
Use Numeric FOR Loops with the IN Option
Use Numeric FOR Loops with the REVERSE Option
Try It Yourself
UNIT 14: Iterative Controls: Part II
The CONTINUE Statement
Use the CONTINUE Statement
Use the CONTINUE WHEN Condition
Nested Loops
Use Nested Loops
Try It Yourself
UNIT 15: Error Handling and Built-in Exceptions
Handling Errors
Understand the Importance of Error Handling
Built-in Exceptions
Use Built-in Exceptions
Try It Yourself
UNIT 16: Exceptions
Exception Scope
Understand the Scope of an Exception
User-Defined Exceptions
Use User-Defined Exceptions
Exception Propagation
Understand How Exceptions Propagate
Reraise Exceptions
Try It Yourself
SESSION VIII: UNIT 17: Exceptions: Advanced Concepts
RAISE APPLICATION ERROR
Use RAISE APPLICATION ERROR
EXCEPTION INIT Pragma
USE the EXCEPTION INIT Pragma
SQLCODE and SQLERRM
Use SQLCODE and SQLERRM
Try It Yourself
UNIT 18: Introductions to Cursors
Cursor Manipulations
Make Use of Record Types
Process an Explicit Cursor
Make Use of Cursor Attributes
Put It All Together
Using Cursor FOR Loops and Nested Cursors
Use a Cursor FOR Loop
Process Nested Cursors
Try It Yourself
UNIT 19: Advanced Cursors
Using Parameters with Cursors and Complex Nested Cursors
Use Parameters in a Cursor
Use Complex Nested Cursors
FOR UPDATE and WHERE CURRENT Cursors
For UPDATE and WHERE CURRENT Cursors
Try It Yourself
UNIT 20: Triggers
What Triggers Are
Understand What a Trigger Is
Use BEFORE and AFTER Triggers
Types of Triggers
Use Row and Statement Triggers
Use INSTEAD OF Triggers
Try It Yourself
SESSION IX: UNIT 21: Records & PLSQL Tables
Record Types
Use Table-Based and Cursor-Based Records
Use User-Defined Records
Nested Records
Use Nested Records
Collections of Records
Use Collections of Records
Try It Yourself
UNIT 22: Procedures
Creating Procedures
Create Procedures
Query the Data Dictionary for Information on Procedures
Passing Parameters into and out of Procedures
Use IN and OUT Parameters with Procedures
Try It Yourself
UNIT 23: Functions
Creating and Using Functions
Create Stored Functions
Make Use of Functions
Invoke Functions in SQL Statements
Write Complex Functions
Try It Yourself
UNIT 24: Native Dynamic SQL
EXECUTE IMMEDIATE Statements
Use the EXECUTE IMMEDIATE Statement
OPEN-FOR, FETCH, and CLOSE Statements
Use OPEN-FOR, FETCH, and CLOSE Statements
Try It Yourself
SESSION X: UNIT 25: Packages
The Benefits of Using Packages
Create Package Specifications
Create Package Bodies
Call Stored Packages
Create Private Objects
Create Package Variables and Cursors
Cursor Variables
Make Use of Cursor Variables
Extending the Package
Extend the Package
Try It Yourself
UNIT 26: Oracle Supplied Packages
Making Use of Oracle Supplied Packages to Profile PL/SQL, Access Files, and Schedule Jobs
Access Files with UTL_FILE
Schedule Jobs with DBMS_JOB
Submit Jobs
Making Use of Oracle-Supplied Packages to Generate an Explain
Plan and Create HTML Pages
Generate an Explain Plan with DBMS_XPLAN
Creating Web Pages with the Oracle Web Toolkit
Create an HTML Page with the Oracle Web Toolkit
Try It Yourself
UNIT 27: PL/SQL Compiler & Procedural Dependencies
Using the PL/SQL Compiler
Describe the new PL/SQL compiler and features
Use the new PL/SQL compiler initialization parameters
Use the new PL/SQL compile time warnings
Managing PL/SQL Code
Describe and use conditional compilation
Hide PL/SQL source code using dynamic obfuscation and the Wrap utility
Managing Dependencies
Track and manage procedural dependencies
UNIT 28: Discussions on Dumps & Assignments
|
|
|
|
|
