|
Book details / order |
DATABASE CONCEPTS AND SYSTEMS FOR STUDENTS, 3RD 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.
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
Publication : Spd
Isbn : 9788184046694
Store book number : 104
NRS 480.00
|
|
|
|
|
|
|
|
|
|