978-81-8487-503-4 Publication Year: 2016
Pages: 424 Binding: Paper Back
About the book
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.
Undergraduate and Postgraduate Students and Industry