Oracle Database and PL/SQL Programming

DATABASE CONCEPTS

Database Fundamentals, Introduction to Database Management Systems, Different Models, Three Layer Architecture, Data Independence, , DDL, DML, DCL, Functions of DBA, DBM , Introduction to ORACLE technology stack, SQL Language, Introduction & Using SQL*Plus, SQL History and Standards, SQL Basics, SQL Data Types, Introduction to Structured Query Language - SQL, Writing Basic SQL statements, Creating and Managing Tables, Insert, Update, Delete commands, Alter, Drop commands, Select Command, SQL Operators and Functions, Single row functions, Aggregating data using group functions, Group By clause, Set Operators, Joins, Creating Views, Subquery, Nested Queries, Co-related Sub-queries, Constraints, Creating Indexes, Controlling user access, Grant and Revoke Statements, Optimization and Performance Tips, SQL Tuning, ER Model, Assignments on E-R Model, E-R to Relational Mapping, Assignments on E-R to Relational Mapping, Normalization, Assignments on Normalization , Using simple modeling Tool, Buidling model for Simple Applications, Simple Fund Mangement example, Simple Inventory example, Simple Security example

PL/SQL Programming Language

PL/SQL Variables and Constants, Using %TYPE and %ROWTYPE Attributes, PL/SQL Variable Scope, Creating Anonymous PL/SQL Block, Using DBMS_OUTPUT.PUT_LINE, PL/SQL Control Structures and Variables, Writing Interactive PL/SQL program, Embedding SELECT Statement inside PL/SQL Block, Embedding DML Statements inside PL/SQL Block, Cursors - Definition Cursor, Using Implicit and Explicit Cursors, Cursor Attributes, Cursor FOR loops, Parameterized Cursors, FOR UPDATE and WHERE CURRENT OF with Explicit Cursors, Exception Definition, Handling user defined, Oracle predefined and non-predefined exceptions., Propogating exceptions, Procedures, functions and Packages and Trigggers, Procedures and Functions, Creating Stored Procedures and functions, Invoking stored procedures, Parmeter Modes – IN, OUT and IN OUT, Calling Stored Functions, Packages - Definition Packages, Advantages of using Packages, Components of a Package, Creating and using Package, Triggers - Definition Triggers, Database Triggers , Difference between Stored Procedure and Database Triggers, Trigger Components and types, Creating and using Database Triggers, Objects In database , Objects Types and Using Object Table, Creating and Using Collection Types, Dynamic SQL, Native Dynamic SQL, Using Packages like DBMS_OUTPUT, DBMS_PIPE, UTL_FILE, DBMS_SQL, Bulk statements in PL/SQL

Oracle Administration and Tools

ADMINISTRATION


Introduction to ORACLE technology stack, ORACLE Database Administrator - jobs & responsibilities, Introduction to ORACLE Architecture, Oracle Installation, Creating Database, Instance Management, Configuration, Oracle *Net configuration, Database storage structure, Users and Privilege Management, Managing data concurrency, Managing Undo data, Database maintenance, Backup & Recovery concepts, Database maintenance, Backup & Recovery, Configuring for Recoverability

TOOLS

Core Concepts and Tools of the Oracle Database, Oracle DBA utilities, RMAN recovery catalog, Configuring backup settings, Creating backups with RMAN, Restore & recovery tasks, Using RMAN to perform recovery, Monitoring & tuning RMAN, Diagnosing the database, Managing memory, Performance management, Tracing SQL Execution, SQL Execution Internals, SQL tuning, Database Task scheduler, DB space management, Database cloning - manual, Database cloning - RMAN, Managing ASM Instance, Oracle High Availability Tools