ISBN: 978-81-8487-503-4 
Publication Year:   2016
Pages:   424
Binding:   Paper Back

DATABASE MANAGEMENT SYSTEMS has become necessary tool for managing and storing data. The book provides an up-to-date coverage of the database systems and explains the concepts in a simple, elegant and easy understandable format. Apart from theoretical explanations, the book provides a practical approach and includes many diagrammatic illustrations, database security, transaction management, embedded SQL, dynamic SQL, indexing, hashing, data warehousing and data mining. The book can act as a complete reference for Oracle on line examination.

• • Detailed description of the characteristics of the database approach • Details the context of relational data model and other data models • Relational algebra concepts • Worked out examples with screen shots for SQL queries • SQL concepts explained from fundamentals to advanced concepts • Security issues and need for constraints in database system • Study of relational database design with examples • Focus on transaction processing and concurrency control • Study on database recovery and storage • Retrieval of data from database and query processing • Explanation for data warehousing and data mining’ • Programming concept of PL/SQL.

Introduction / Data Models / The Relational Algebra / SQL-Fundamentals / Joint, Constraints and Advanced SQL / Relational Database Design / Transaction Processing / Concurrency Control / Database Recovery Techniques / Record Storage / Physical Database Design / Indexing and Hashing / Query Processing / PL/SQL / Data Mining & Data Warehousing / Index.