Description
The book has been written to provide students an excellent grounding in database concepts and systems. The book has several illustrative examples, which have a logical link between them. Each set of examples helps build skills that will take the reader to the next set of examples, which in turn leads upwards until a strong programming foundation using ANSI SQL, the natural language of an RDBMS, has been established.
Topics covered in the book the purpose of database System: Basic database concepts entity relationships modeling: E. R. database schemas the relational model: relational algebra, tuple relational calculus structured query language: table fundamentals, ansi Sql statements (Ddl, Dml, Dql, Dcl), data constraints, the set operations, views sql transactions: reversing transactions, cursors-implicit and explicit concurrency controls: locking protocol, deadlock handling, locks query optimization: query executed, explain plan command relational database design: decomposition and normalizations other relevant advanced topics and applications Oracle forms: creating a data entry form via the forms builder Oracle reports: creating a report via the reports builder.
Author: IVAN BAYROSS
Publisher: IVAN BAYROSS
ISBN-13: 9.78818E+12
Language: ENGLISH
Binding: PAPERBACK
No. Of Pages: 342
Country of Origin: India
Reviews
There are no reviews yet.