Database Concepts and Systems for Students, 3rd Edition - Softcover

Ivan Bayross

Softcover

ISBN 10: 8184046693 ISBN 13: 9788184046694

Verlag: Shroff Publishers and Distributors Pvt. Ltd., 2009

Inhaltsangabe

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

Details zur Ausgabe

• Verlag: Shroff Publishers and Distributors Pvt. Ltd.
• Erscheinungsdatum: 2009
• Sprache: Englisch
• ISBN 10: 8184046693
• ISBN 13: 9788184046694
• Einband: Taschenbuch
• Auflage: 3
• Anzahl der Seiten: 428
• Kontakt zum Hersteller: Nicht verfügbar
• Verantwortliche Person: Nicht verfügbar