Description

Database Systems: Introduction to Databases and Data Warehouses covers the design and use of both operational and analytical database systems in detail. A solid theoretical foundation and meaningful hands-on experiences are provided. This understanding prepares students to apply their knowledge in today's business environments.

Edition 3.0 includes more coverage of SQL. Additionally, ERDPlus (free web-based software) now allows students to run SQL queries on the preloaded datasets from the book. To that end, a third running review example has been added for additional and varied practice opportunities.

FEATURES:

Experience logical step-by-step coverage

Clear and straightforward coverage of topics that successively build on each other.

Solidify knowledge with examples, mini cases, and exercises

Numerous easy-to-understand examples, mini-cases, and hands-on exercises cement understanding of each topic introduced.

Save time with running examples

The ZAGI Retail Company Sales Department Database Example is used to illustrate the main concepts for both operational databases and data warehouses. Use of a running example enables quick and straightforward coverage, because students are already familiar with the details of the case.

Free software

Access ERDPlus, a free, easy-to-use, web-based, data modeling suite designed for use in conjunction with this textbook.

Introduce material with online videos

As more classes are being offered remotely, the need for online resources has been increasing. A series of videos that introduce each chapter are available for the book.

Optionally cover advanced topics

Appendices provided cover additional topics including stored procedures, functions, and blockchain.

An eTextbook version is available at VitalSource.com for $65.80 USD. ISBN: 978-1-958303-28-3.