Description
The database in now the underlying framework of the information system, and has fundamentally changed the way many organizations operate. In particular, the developments in this technology over the last few years have produced systems that are more powerful and more intuitive to use. this has resulted in database systems becoming increasingly available to a winder variety of users. the objectives of this book, therefore, are to provide a textbook that introduces the theory behind database as clearly as possible and, in particular, to provide a methodology for database design that can be used by IT professionals, such as systems analysts or designers, application programmers, systems programmers, database practitioners, and for for independent self-teachers.
Table of Contents
Chapter 1: Database Concepts
Chapter 2: Data Models
Chapter 3: Entity Relationship Model
Chapter 4: Relational Database Model
Chapter 5: Relational Algebra And Calculus
Chapter 6: Normalization
Chapter 7: Transaction Processing
Chapter 8: Concurrency Control
Chapter 9: Database Recovery
Chapter 10: Database Security And Integrity
Chapter 11: Distributed Databases
Chapter 12: Oodbms and Kbms
UNIT-I
Chapter 1: Introduction To Oracle
Chapter 2: Introduction To Sql
Chapter 3: More On Sql
Chapter 4: Sql Performance Tuning
UNIT-2
Chapter 1: Introduction To Pl/Sql
Chapter 2: Pl/Sql Datatypes
Chapter 3: Pl/Sql Control Statements
Chapter 4: Pl/Sql Transactions And Concurrency Control
Chapter 5: Pl/Sql Cursors
Chapter 6: Pl/Sql Subprograms
Chapter 7: Pl/Sql Database Triggers
Chapter 8: Handling Pl/Sql Errors
Author
Ikvinderpal Singh
Ikvinderpal Singh, is Lecturer of P.G. Deptt. Of Computer Science & Applications, Khalsa College, Amritsar which is a premier institute in North India. He obtained his MCA with distinction from Guru Nanak Dev University, Amritsar. He has always been excellence right from his student carrer. He has written five books. He brought name for himself when he topped the college in B.Sc. His other areas of interest include Fuzzy systems, digital electronics and java programming.
Reviews
There are no reviews yet.