Database Concepts and Systems, 2nd Edition

 
9788173669989: Database Concepts and Systems, 2nd Edition
View all copies of this ISBN edition:
 
 

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. The Topics Covered THE PURPOSE OF DATABASE SYSTEMS: Basic Database Concepts ENTITY RELATIONSHIPS MODELLING: 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 Normalization 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. Each topic is liberally sprinkled with examples that are mapped to applications, which fit in the real world. At the end of each chapter there is a material review section consisting of Fill in the blanks and True or False questions. This should help in providing a quick but accurate way of measuring how the material has been absorbed. Where applicable each chapter has several Hands-on exercises. These exercises will help reinforce the concepts studied. The solutions to these hands-on exercises have also been provided at the very end of the book.

"synopsis" may belong to another edition of this title.

About the Author:

The author Ivan Bayross is an M. Tech in DBMS from Manchester University UK. He has spent more than 27 years in the software industry. He rose from the ranks in the IT industry, where he started as a programmer, moved up to C.1.0, and is now the Chairman and Technology lead, in a software development house at Mumbai, India. He specializes in multi-tier, client/ server, application development.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Ivan Bayross
Published by Shroff Publishers & Distributors
ISBN 10: 8173669988 ISBN 13: 9788173669989
New Softcover Quantity Available: 1
Seller:
Ohmsoft LLC
(Lake Forest, IL, U.S.A.)
Rating
[?]

Book Description Shroff Publishers & Distributors. Condition: New. Paperback. Worldwide shipping. FREE fast shipping inside USA (express 2-3 day delivery also available). Tracking service included. Ships from United States of America. Seller Inventory # 8173669988

More information about this seller | Contact this seller

Buy New
US$ 54.34
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

2.

Ivan Bayross
Published by Shroff Publishers & Distributors (2005)
ISBN 10: 8173669988 ISBN 13: 9788173669989
New Softcover Quantity Available: 1
Seller:
Irish Booksellers
(Portland, ME, U.S.A.)
Rating
[?]

Book Description Shroff Publishers & Distributors, 2005. Condition: New. book. Seller Inventory # M8173669988

More information about this seller | Contact this seller

Buy New
US$ 63.72
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds