Database management systems : a business-oriented approach to ORACLE, MySQL and MS Access / Sotirios Zygiaris.

By:

Zygiaris, Sotirios [author.]

Material type: Text

text

Media type:

computer

Carrier type:

online resource

ISBN:

9781787566958
1787566951

Subject(s):

Genre/Form:

Electronic books.

Additional physical formats: Print version:: Database management systems.DDC classification:

005.74 22

LOC classification:

QA76.9.D3

Online resources:

EBSCOhost

Contents:

1. The database environment -- 2. Database design -- 3. Structured query language (SQL) : data management -- 4. Structured query language (SQL) : introducing queries -- 5. Structured query language (SQL) : in multiple tables -- 6. Structured query language (SQL) : grouping data and subqueries -- 7. Structured query language (SQL) : views, triggers, and functions -- 8. Database : administration and security -- 9. Building web database applications -- 10. Databases in the business world -- 11. Distributed databases and concurrency control.

Summary: More and more, the advance of enterprise computing and cloud technologies means that managers are responsible for retrieving data ad-hoc and constructing business reports for decision-making and storytelling. The technical competencies necessary for such tasks can be daunting, and most database teaching methods do little to mitigate the confusion. They tend to follow traditional computer science methods that expose all computational and matrix theory complexities as well as various design theories, and in so doing, they present an excess of information that unnecessarily complicates the learning process for business-minded readers. Zygiaris simplifies his teaching method in order to provide an accessible walkthrough of all technological advances of databases in the business environment. Readers learn how to design, develop, and use databases to provide business analytical reports with the three major database management systems: Microsoft Access, Oracle Express and MariaDB (formerly MySQL). This is all delivered through clearly structured, streamlined chapters, all of which link to online videos that demonstrate visually, in step-by-step tutorials, how to implement the processes outlined in the book. All of these features help the non-IT student or manager to understand the importance of databases in the business environment and to learn how to use those databases to solve real-world problems. This book is of particular interest to students of management and to business managers, and it is of keen interest to anyone who works with major business database systems.

Holdings ( 1 )
Title notes ( 5 )

Holdings
Item type	Current library	Collection	Call number	Status	Date due	Barcode	Item holds
eBook	e-Library	EBSCO Business		Available

Total holds: 0

Includes bibliographical references and index.

More and more, the advance of enterprise computing and cloud technologies means that managers are responsible for retrieving data ad-hoc and constructing business reports for decision-making and storytelling. The technical competencies necessary for such tasks can be daunting, and most database teaching methods do little to mitigate the confusion. They tend to follow traditional computer science methods that expose all computational and matrix theory complexities as well as various design theories, and in so doing, they present an excess of information that unnecessarily complicates the learning process for business-minded readers. Zygiaris simplifies his teaching method in order to provide an accessible walkthrough of all technological advances of databases in the business environment. Readers learn how to design, develop, and use databases to provide business analytical reports with the three major database management systems: Microsoft Access, Oracle Express and MariaDB (formerly MySQL). This is all delivered through clearly structured, streamlined chapters, all of which link to online videos that demonstrate visually, in step-by-step tutorials, how to implement the processes outlined in the book. All of these features help the non-IT student or manager to understand the importance of databases in the business environment and to learn how to use those databases to solve real-world problems. This book is of particular interest to students of management and to business managers, and it is of keen interest to anyone who works with major business database systems.

Print version record.

Master record variable field(s) change: 630, 650