| |
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
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.I.O, 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.isbn-9788184046694
|
| |
Pages : 428
|