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 carrier. 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.