Relational Database Management Systems (RDBMS)

₹185.00
1841

Specific References

According to New CBCS (CHOICE BASE CREDIT SYSTEM) Syllabus w.e.f. 2019-20

A Text Book of

Relational Database Management Systems (RDBMS) (CS 202)

Author: Dr. Reena Bharathi, Vandana Bhat

ISBN: 978-93-5016-489-1

Price: 185/-

Quantity
In Stock

Contents

1.Relational Database Design Using PLSQL  

1. Introduction to PL/SQL 

2. PL/PgSQL    

3. Controlling the Program Flow, Conditional Statements, Loops 

4. Stored Procedures

5. Stored Functions 

6. Handling Errors and Exceptions   

7. Cursors

8. Triggers    

2. Transaction Concepts and Concurrency Control

1. Introduction

2. Describe a Transaction, Properties of Transaction, State of the Transaction 

3. Executing Transactions Concurrently Associated Problem in Concurrent Execution    

4. Schedules, Types of Schedules, Concept of Serializability, Precedence Graph of Serializability

5. Ensuring Serializability by Locks, Different Lock Modes,2PL and its Variations

6. Basic Timestamp Method for Concurrency, Thomas Write Rule   

7. Locks with Multiple Granularity, Dynamic Database Concurrency (Phantom Problem)    

8. Timestamps Versus Locking   

9. Deadlock and Deadlock Handling-Deadlock Avoidance (wait-die, wound-wait)

10.Deadlock Avoidance (Wound-Wait, Wait-die)   

11.Deadlock Detection and Recovery (Wait For Graph) 

 3. Database Integrity and Security Concepts    

1. Introduction

2. Domain Constraints 2

3. Referential Integrity  

4. Introduction to Database Security Concepts  

5. Methods of Database Security

6. Use of Views in Security Enforcement   

7. Overview of Encryption Technique for Database    

8. Statistical Database Security    

4. Crash Recovery   

1. Introduction 2

2. Failure Classification 

3. Recovery Concepts

4. Log Based Recovery Techniques (Deferred and Immediate Update)    

5. Checkpoints, Relationship between Database Manager and Buffer Cache. Aries recovery Algorithm  

6. Recovery with Concurrent Transactions (Rollback, Checkpoints, Commit)  

7. Database Backup and Recovery from Catastrophic Failures

5. Other Databases  

1. Introduction to Parallel and Distributed Databases

2. Introduction to Object Based Databases 

3. XML databases    

4. NoSQL Databases  

5. Multimedia Databases   

6. Big Data Databases

Related Products

Advanced C Programming
0 Review(s)
In Stock
Price ₹130.00

According to New CBCS (CHOICE BASE CREDIT SYSTEM) Syllabus w.e.f. 2019-20

A Text Book of

Advanced C Programming (CS 201)

Author: Dr. Poonam Ponde

ISBN: 978-93-5016-485-3

Price: 130/-

Instrumentation Systems
0 Review(s)
In Stock
Price ₹105.00

According to New CBCS (CHOICE BASE CREDIT SYSTEM) Syllabus w.e.f. 2019-20

A Text Book of

Instrumentation Systems (ELC 121)

Author: Dr. Deepa V. Ramane

Price: 105/-

Basics of Computer...
0 Review(s)
In Stock
Price ₹100.00

According to New CBCS (CHOICE BASE CREDIT SYSTEM) Syllabus w.e.f. 2019-20

A Text Book of

Basics of Computer Organisation (ELC 122)

Author: H.R. Arvind

ISBN: 978-93-5016-483-0

Price: 100/-

Linear Algebra
0 Review(s)
In Stock
Price ₹245.00

According to New CBCS (CHOICE BASE CREDIT SYSTEM) Syllabus w.e.f. 2019-20

A Text Book of

Linear Algebra (MTC 121)

Author: Arun Pandhari

Price: 245/-

Graph Theory
0 Review(s)
In Stock
Price ₹210.00

According to New CBCS (CHOICE BASE CREDIT SYSTEM) Syllabus w.e.f. 2019-20

A Text Book of

Graph Theory (MTC 122)

Author: Parshuram Ahire

ISBN: 978-93-5016-487-7

Price: 210/-

Methods of Applied Statistics
0 Review(s)
In Stock
Price ₹125.00

According to New CBCS (CHOICE BASE CREDIT SYSTEM) Syllabus w.e.f. 2019-20

A Text Book of

Methods of Applied Statistics (CSST 121)

Author: Surekha Deshmukh

ISBN: 978-93-5016-490-7

Price: 125/-

Continuous Probability...
0 Review(s)
In Stock
Price ₹160.00

According to New CBCS (CHOICE BASE CREDIT SYSTEM) Syllabus w.e.f. 2019-20

A Text Book of

Continuous Probability Distribution and Testing of Hypothesis (CSST 122)

Author: Surekha Deshmukh

ISBN: 978-93-5016-488-4

Price: 160/-