Our Latest Offers

Oracle 11g DBA


About Oracle 11g DBA

Oracle 11g is a new version of database management system. The Oracle Database 11g is a relational database management system (RDBMS) produced and marketed by Oracle Corporation. The specialty of this new version is the inclusion of grid computing capability, represented by `g` in the name 11g. The term 10g DBA is often used for 11g Database Administrator, which represents a person or a group of people responsible for creation and maintenance of an Oracle 10g Database. Oracle Corporation offers a certification programme for DBAs under which a DBA can appear for an examination to test his DBA skills.

Oracle 11g Database provides efficient, reliable, secure data management for high-end applications such as high-volumeon-line transaction processing (OLTP) environments, query-intensive data warehouses, and demanding Internet applications. Our faculty provide how the student will learn and how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques.

This course is designed to give you a firm foundation in basic database administration and advances your success as an Oracle professional in the area of database administration. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. The lesson topics are reinforced with structured hands-on practices. This course is designed to prepare you for the corresponding oracle Certified Associate exam. Oracle continues to dominate the database industry. Several versions of Oracle are being used in the industry. Oracle is usually conducted on Microsoft Window Server platform. If you prefer, you can opt for Oracle on Linux/Ubuntu.

Before you continue, you should have a basic understanding of the following:

1. Knowledge of SQL.
2. Knowledge of Basic understanding of database.

Benefits of Courses:

1. Oracle Developer.
2. Oracle Developer.
3. Oracle Discoverer Services Developer.

Projects

1. We will provide real time project training with code explanation and implementation.
2. Our training modules are completely designed according to current IT market.
3. After completion of 75% of course, student will go through Major Project Training, Live Project Training, Interview Preparation and
     Recruitment process in IT Industry.
4. Student will go through the training of HTML, CSS and JavaScript as a complimentary package before starting of SQL Server.
5. We offer regular, fast track and weekend training in SQL Server course.
6. Study material is provided with the course which consist of concepts, examples and real time examples.

Oracle 11g Foundations - SQL and SQL*Plus
In the Beginning. Database Management System Overview Introduction to Entity Relationship Modeling Fundamentals of Relational Database Management Systems
1. What is a Database? 1. What is a Data Model? 1. What is an RDBMS?
2. Types of DBMSs 2. Why Use an Entity Relationship Model? 2. History of SQL
  3. Input and Components of an Entity Relationship Model 3. Physical Data Storage
  4. Reading the Entity Relationship Model 4. Relationships between Tables
  5. Guidelines for a Model Review 5. Domains - Data Integrity Constraint
SQL Basics and SQL*Plus Using SQL Developer The WHERE and ORDER BY Clause
1. Difference Between SQL, SQL*Plus, and PL/SQL 1. SQL Developer Environment and Commands 1. WHERE, ORDER BY Clause
2. Invoking and Leaving SQL*Plus   2. Using the Data Dictionary
3. Entering and Executing Commands   3. Hierarchical Queries
4. The SQL Buffer, SQL*Plus Default Output    
5. LOGIN.SQL    
6. The SELECT Command and Mandatory Clauses    
Single Row Functions Joining Data from Multiple Tables in Queries Group Functions and the GROUP BY Clause
1. Single Row vs. Group Functions 1. The JOIN Condition/The Cartesian Product 1. Group Functions
2. Date and Numeric Format Models 2. Outer JOINs 2. Distinct Operator in Group Functions
3. Data Conversion 3. SET Operators 3. GROUP BY, WITH Clause, ROLLUP, CUBE
4. Control Statements 4. ANSI SQL99 Joins 4. GROUPING SETS
5. Regular Expressions    
Using Subqueries and CASE Clauses Analytic Functions (Optional) SQL*Plus Reporting
1. Single-Row, Multi-Row, and Multi-Column Subqueries 1. Single-Row Analytic Functions 1. SQL*Plus Report Writing Commands
2. Subqueries in a WHERE Clause 2. Aggregating Analytic Functions 2. COLUMN Command/Titles, System Variables
3. Subqueries in the FROM Clause - In-Line Views 3. PIVOT/UNPIVOT 3. Master-Detail Report with TITLE and COLUMN Commands
4. Subqueries in the SELECT Clause - Scalar Subqueries   4. Control Breaks, Computing Aggregate Amounts
5. Correlated Subqueries   5. Using SET Variables in SQL*Plus, SQL to Generate SQL
6. CASE Clause    
Data Manipulation Language (DML) Commands Data Definition Language (DDL) Commands Security
1. INSERT, UPDATE, DELETE, MERGE Command 1. DDL Commands, Object Naming, Dropping Objects 1. Users, Privileges, Roles, Changing Passwords
2. Use of Subqueries 2. TRUNCATE, COMMENT, RENAME Command Getting Data In And Out Of Oracle
3. Transaction Control Commands/Read Consistency/Locking 3. Creating Tables/Integrity Constraints 1. SQL*Loader Basics
4. The MERGE Command 4. CREATE TABLE, ALTER TABLE Command 2. Importing Oracle Data Into Excel
5. Flashback Queries 5. Datatypes, Types of Declarative Constraints 3. Direct Database Queries Using ODBC
  6. Default Values  
  7. Creating, Deferrable, Dropping, Disabling/Enabling Constraints/Displaying Constraint Information  
  8. Handling Exceptions  
  9. Views, Synonyms, Sequences, Indexes, Virtual Columns  
  10. Temporary Tables, External Tables  
Oracle 11g Foundations - Program with PL/SQL
Introduction to PL/SQL Declaring PL/SQL Identifiers Writing Executable Statements
1. PL/SQL Overview 1. Different Types of Identifiers in a PL/SQL subprogram 1. Describing Basic PL/SQL Block Syntax Guidelines
2. Benefits of PL/SQL Subprograms 2. Using the Declarative Section to Define Identifiers 2. Commenting Code
3. Overview of the Types of PL/SQL blocks 3. Storing Data in Variables 3. SQL Functions in PL/SQL
4. Creating and Executing a Simple Anonymous Block 4. Scalar Data Types 4. Data Type Conversion
5. Generating Output from a PL/SQL Block 5. %TYPE Attribute 5. Nested Blocks
  6. Bind Variables 6. Operators in PL/SQL
  7. Using Sequences in PL/SQL Expressions  
Interacting with the Oracle Server Writing Control Structures Working with Composite Data Types
1. Including SELECT Statements in PL/SQL to Retrieve data 1. Conditional processing Using IF Statements 1. Using PL/SQL Records
2. Manipulating Data in the Server Using PL/SQL 2. Conditional processing Using CASE Statements 2. Using the %ROWTYPE Attribute
3. The SQL Cursor concept 3. Simple Loop Statement 3. Inserting and Updating with PL/SQL Records
4. Using SQL Cursor Attributes to Obtain Feedback on DML 4. While Loop Statement 4. INDEX BY Tables
5. Saving and Discarding Transactions 5. For Loop Statement 5. INDEX BY Table Methods
  6. The Continue Statement 6. INDEX BY Table of Records
Using Explicit Cursors Handling Exceptions Creating Stored Procedures
1. Understanding Explicit Cursors 1. Understanding Exceptions 1. Creating a Modularize and Layered Subprogram Design
2. Declaring the Cursor 2. Handling Exceptions with PL/SQL 2. Modularizing Development With PL/SQL Blocks
3. Opening the Cursor 3. Trapping Predefined Oracle Server Errors 3. Understanding the PL/SQL Execution Environment
4. Fetching data from the Cursor 4. Trapping Non-Predefined Oracle Server Errors 4. The Benefits of Using PL/SQL Subprograms
5. Closing the Cursor 5. Trapping User-Defined Exceptions 5. The Differences Between Anonymous Blocks and Subprograms
6. Cursor FOR loop 6. Propagate Exceptions 6. Creating, Calling, and Removing Stored Procedures Using the CREATE Command and SQL Developer
7. Explicit Cursor Attributes 7. RAISE_APPLICATION_ERROR Procedure 7. Using Procedures Parameters and Parameters Modes
    8. Viewing Procedures Information Using the Data Dictionary Views and SQL Developer
Creating Stored Functions Creating Packages Working With Packages
1. Creating, Calling, and Removing a Stored Function Using the CREATE Command and SQL Developer 1. Listing the Advantages of Packages 1. Overloading Subprograms in PL/SQL
2. Identifying the Advantages of Using Stored Functions in SQL Statements 2. Describing Packages 2. Using the STANDARD Package
3. Identify the steps to create a stored function 3. The Components of a Package 3. Using Forward Declarations to Solve Illegal Procedure Reference
4. Using User-Defined Functions in SQL Statements 4. Developing a Package 4. Using Package Functions in SQL and Restrictions
5. Restrictions When Calling Functions from SQL statements 5. The Visibility of a Package's Components 5. Persistent State of Packages
6. Controlling Side Effects When Calling Functions from SQL Expressions 6. Creating the Package Specification and Body Using the SQL CREATE Statement and SQL Developer 6. Persistent State of a Package Cursor
7. Viewing Functions Information 7. Invoking the Package Constructs 7. Controlling Side Effects of PL/SQL Subprograms
  8. Viewing the PL/SQL Source Code Using the Data Dictionary 8. Using PL/SQL Tables of Records in Packages
Using Oracle-Supplied Packages in Application Development Using Dynamic SQL Design Considerations for PL/SQL Code
1. Using Oracle-Supplied Packages 1. The Execution Flow of SQL 1. Standardizing Constants and Exceptions
2. Examples of Some of the Oracle-Supplied Packages 2. What is Dynamic SQL? 2. Using Local Subprograms
3. How Does the DBMS_OUTPUT Package Work? 3. Declaring Cursor Variables 3. Using Autonomous Transactions
4. Using the UTL_FILE Package to Interact With Operating System Files 4. Dynamically Executing a PL/SQL Block 4. Using the NOCOPY Compiler Hint
5. Using the UTL_MAIL Package 5. Using Native Dynamic SQL to Compile PL/SQL Code 5. Using the PARALLEL_ENABLE Hint
6. Using the UTL_MAIL Subprograms 6. Using DBMS_SQL Package 6. Using the Cross-Session PL/SQL Function Result Cache
  7. Using DBMS_SQL with a Parameterized DML Statement 7. Using the DETERMINISTIC Clause with Functions
  8. Dynamic SQL Functional Completeness 8. Using Bulk Binding to Improve Performance
Creating Triggers Creating Compound, DDL, and Event Database Triggers Using the PL/SQL Compiler
1. Working With Triggers 1. Working With Compound Triggers 1. Using the PL/SQL Compiler
2. Identifying the Trigger Event Types and Body 2. Identifying the Timing-Point Sections of a Table Compound Trigger 2. Using the Initialization Parameters for PL/SQL Compilation
3. Business Application Scenarios for Implementing Triggers 3. Compound Trigger Structure for Tables and Views 3. Using the New PL/SQL Compile Time Warnings
4. Creating DML Triggers Using the CREATE TRIGGER Statement and SQL Developer 4. Using a Compound Trigger to Resolve the Mutating Table Error 4. Overview of PL/SQL Compile Time Warnings for Subprograms
5. Identifying the Trigger Event Types, Body, and Firing (Timing) 5. Comparing Database Triggers to Stored Procedures 5. The Benefits of Compiler Warnings
6. Statement Level Triggers Versus Row Level Triggers 6. Creating Triggers on DDL Statements 6. The PL/SQL Compile Time Warning Messages Categories
7. Creating Instead of and Disabled Triggers 7. Creating Database-Event and System-Events Triggers 7. Setting the Warning Messages Levels: Using SQL Developer, PLSQL_WARNINGS Initialization Parameter, and the DBMS_WARNING
8. Managing, Testing, and Removing Triggers 8. System Privileges Required to Manage Triggers 8. Package Subprograms
    9. Viewing the Compiler Warnings: Using SQL Developer, SQL*Plus, or the Data Dictionary Views
Managing Dependencies Managing PL/SQL Code  
1. Overview of Schema Object Dependencies 1. What Is Conditional Compilation and How Does it Work?  
2. Querying Direct Object Dependencies Using the USER_DEPENDENCIES View 2. Using Selection Directives  
3. Querying an Object's Status 3. Using Predefined and User-Defined Inquiry Directives  
4. Invalidation of Dependent Objects 4. The PLSQL_CCFLAGS Parameter and the Inquiry Directive  
5. Displaying Direct and Indirect Dependencies 5. Using Conditional Compilation Error Directives to Raise User-Defined Errors  
6. Fine-Grained Dependency Management in Oracle Database 11g 6. Using the DBMS_DB_VERSION Package  
7. Understanding Remote Dependencies 7. Using DBMS_PREPROCESSOR Procedures to Print or Retrieve Source Text  
8. Recompiling a PL/SQL Program Unit 8. Obfuscating and Wrapping PL/SQL Code