Description
Book SynopsisMore 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.
Trade ReviewThis guide is intended to be accessible to business managers and students in management who are not experts in information technology. The book shows how to design, implement, and manage databases in the business environment by combining three database management systems: Microsoft Access, Oracle Express, and Maria DB (MySQL). A book-length case study demonstrates results. B&w screen shots are included. Guidelines and code are linked to online videos with step-by-step tutorials. -- Annotation ©2018 * (protoview.com) *
Table of ContentsChapter 1. The Database Environment Chapter 2. Database Design Chapter 3. SQL Data Management Chapter 4. SQL Introducing Queries Chapter 5. SQL in Multiple Tables Chapter 6. SQL Grouping Data, Subqueries Chapter 7. SQL Views: Triggers and Functions
