NEWSLETTER

Advanced RDBMS using Oracle

BI 1444

New

According to New Revised Syllabus w.e.f. 2012 PUNE, Maharashtra (INDIA)

Advanced RDBMS using Oracle

MCM Sem-II

Author : Himanshu Dabir, Dipali Meher

Book ID : 1444

ISBN : 978-93-5016-150-0

Edition : 2nd 2014

Solved Question Papers upto 2013 October

More details

Rs.176

Rs.195

-10%

Warning: Last items in stock!

Contents

1. Introduction To Oracle Architecture

1. Introduction

2. Databases

3. Instances

4. Memory Structures of an Instance

5. Background Processes

6. External Structures

7. Data Blocks, Extents and Segments

2. Data Type

1. Introduction

2. Variables

3. Constants

4. Data Types

3. Queries

1. Introduction of SQL

2. Select Command

3. Operators

Solved Programs

4. SQL Functions

1. Introduction

2. Types of Functions

3. The Dual Table

4. Nested Functions

5. Date Formats

5. Joins

1. Introduction

2. Types of Joins

3. Operators

6. Subqueries and Correlated Query

1. Introduction

2. Using a Subquery to Select Data

3. Subquery Search Conditions

4. Correlated Subqueries

7. DML and TCL Statements

1. Introduction

2. TCL Commands

8. Locks in Oracle

1. Introduction

2. Locking

3. Types of Locks

4. Deadlocks

9. DDL Statements and Users

1. The Data Definition Language

2. Assigning Privileges

3. Creating Users

10. Table

1. Introduction

2. Creating a Table

3. Constraints   

Solved Programs

11. Oracle Objects

1. Introduction

2. Indexes

3. Views

4. Sequences

5. Synonyms

12. Cursor

1. What is a Cursor?

2. Types of Cursor

3. Cursor Attributes

4. Cursor for Loop

5. Parameterized Cursors

6. Cursor Variables

Solved Programs

13. PL/SQL

1. Introduction to PL/SQL

2. Advantages of PL/SQL

3. PL/SQL Character Set

4. Executing PL/SQL

5. The DBMS Output Package

6. PL/SQL Blocks

7. Attribute

8. Operators  

9. Control Structures

10. Error Handling   

11. Composite Data Types

Solved Programs

14. Database Triggers

1. Introduction

2. Creating Triggers

3. Types of Triggers

4. Enabling and Disabling

5. Trigger Predicates

Solved Programs

15. Procedures and Functions

1. Introduction

2. Creating Procedures and Functions

3. Subprogram Parameters

4. Information on Stored Procedures

5. Procedure Overloading

6. Recursive Procedure

7. Dropping Procedures and Functions

8. Procedures Vs. Functions

Solved Programs

16. Packages

1. Introduction

2. Package Specification

3. Package Body

4. Package and Scope

5. Package Initialization

6. Recompiling the Package

7. Deleting a Package

8. Advantages of a Package

Solved Programs

17. Creating an Oracle Database

1. Introduction

2. Creating an Oracle Database

3. Managing the Oracle Instance

18. Performing Database Backup and Recovery

1. Introduction

2. Performing Database Backup

3. Performing Database Recovery

19. Moving Data

1. Introduction

2. Describe the General Architecture of Data Pump

3. Use Data Pump Export and Import to Move the Data between Oracle Databases

4. Load Data with SQL Loader

5. Use External Tables to Move Data

No customer comments for the moment.

Write a review

Write a review

3 other products in the same category:

Customers who bought this product also bought: