About The Book
The book has been written to provide students an excellent grounding in Database Concepts and Systems. The book has several illustrative examples, which...
Read more
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 BookThe Purpose Of Database System: Basic Database ConceptsEntity Relationships Modeling: E. R. Database SchemasThe Relational Model: Relational Algebra, Tuple Relational CalculusStructured Query Language: Table Fundamentals, Ansi Sql Statements (Ddl, Dml, Dql, Dcl), Data Constraints, The Set Operations, ViewsSQL Transactions: Reversing Transactions, Cursors-Implicit And ExplicitConcurrency Controls: Locking Protocol, Deadlock Handling, LocksQuery Optimization: Query Executed, Explain Plan CommandRelational Database Design: Decomposition And NormalizationsOther Relevant Advanced Topics And ApplicationsOracle Forms: Creating A Data Entry Form Via The Forms BuilderOracle Reports: Creating A Report Via The Reports Builder
Hide more