To give you the best possible experience, this site uses cookies. Using your site means your agree to our use of cookies. We have published a new cookies policy, which you should need to find out more about the cookies we use. View Cookies Policy.
Vision Publications, Pune, Educational books, SPPU
  • -10%
  • New
Review  (0)
₹189.00₹210.00
Vision Publications, Pune, Educational books, SPPU
  • -10%
  • New
Review  (0)
₹333.00₹370.00
Vision Publications, Pune, Educational Book, BCom Computer Application
  • -10%
  • New
Review  (0)
₹292.50₹325.00
Vision Publications, Pune, Educational Book, BCom Computer Application
  • -10%
  • New
Review  (0)
₹144.00₹160.00
Vision Publications, Pune, Educational Book, BCom Computer Application
  • -10%
  • New
Review  (0)
₹126.00₹140.00
Vision Publications, Pune, Educational Book, BCom Computer Application
  • -10%
  • New
Review  (0)
₹148.50₹165.00
  • New
  • -10%
    Relational Database Management System
    Relational Database Management System

    Relational Database Management System

    Review  (0)
    ₹207.00
    ₹230.00
    Save 10%
    In Stock

    As per NEP w.e.f. 2024-25

    B.B.A. (Computer Application)

    Semesters-II

    Author: Gautam A. Kudale, Mahesh D. Pawar

    ISBN: 978-93-94022-76-8

    Book ID: 2136

    Quantity :
    In Stock 25 Available items
    Write your review

    EU3234363840424446USXX5XSSMLXLXXLXXLArm Length6161,56262,56363,56464,5Bust Circumference8084889296101106111Waist Girth6165697377828792Hip Circumference87919599103108113118

    • Security policySecurity policy(edit with the Customer Reassurance module)
    • Delivery policyDelivery policy(edit with the Customer Reassurance module)
    • Return policyReturn policy(edit with the Customer Reassurance module)

    Contents

    1. Introduction to RDBMS and PL-SQL

    1. Introduction

    2. Introduction to Popular RDBMS Product and their Features

    2.1 Difference between DBMS and RDBMS

    2.2 Advantages and Disadvantages of RDBMS

    3. Overview of PL/SQL

    3.1 Data Types

    3.2 PL/SQL Block

    4. Operators, Functions, Comparison, Numeric, Character, Date

    5. Control Statement

    5.1 Conditional Control

    5.2 Iterative Control

    5.3 Sequential Control

    6. Exceptional Handling

    7. Functions, Procedures

    8. Cursor

    8.1 What is a Cursor?

    8.2 Types of Cursors

    8.3 Cursor Declaration

    8.4 Cursor For Loops

    8.5 Parameterized Cursors

    9. Database Triggers

    9.1 Types of Triggers

    10. Oracle Packages

    10.1 Components of an Oracle package

    2. Transaction Management

    1. Transaction Concept

    1.1 Transaction Properties

    1.2 Transaction States

    2. Concurrent Execution

    3. Schedule

    4. Serializability

    4.1 Conflict Serializability

    4.2 Testing for Conflict Serializability

    3. Concurrency Control and Recovery System

    1. Concurrency Control

    2. Lock Based Protocols

    2.1 Locks

    2.2 Granting of Locks

    2.3 Two-Phase Locking Protocol

    3. Timestamp-Based Protocols 

    3.1 Timestamp

    3.2 Timestamp-Ordering Protocol

    3.3 Thomas Write Rule

    4. Validation-Based Protocols

    5. Deadlock Handling

    5.1 Deadlock Prevention

    5.2 Deadlock Detection

    5.3 Deadlock Recovery

    6. Recovery System

    7. Failure Classification

    7.1 Transaction Failure

    7.2 System Crash

    7.3 Disk Failure

    8. Storage Structure

    8.1 Storage Types

    8.2 Data Access

    9. Recovery and Atomicity

    9.1 Log-Based Recovery

    9.2 Deferred Database Modification

    9.3 Immediate Database Modification

    9.4 Checkpoints

    10. Recovery with Concurrent Transactions

    10.1 Interaction with Concurrency Control

    10.2 Transaction Rollback

    10.3 Restart Recovery

    11. Remote Backup Systems

    B.B.A.
    2136
    25 Items

    No customer reviews for the moment.

    Write your review
    Relational Database Management System
    Vision Publications, Pune, Educational Book, BBA Computer Application

    Relational Database Management System

    ₹207.00
    ₹230.00
    Save 10%