Database management systems : a business-oriented approach to ORACLE, MySQL and MS Access /
Zygiaris, Sotirios,
Database management systems : a business-oriented approach to ORACLE, MySQL and MS Access / Sotirios Zygiaris. - First edition. - 1 online resource (299 pages) : illustrations
Includes bibliographical references and index.
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.
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.
9781787566958 (electronic book) 1787566951 (electronic book) 9781787566972 1787566978 (hardcover) (hardcover)
9781787566972 Emerald Publishing
GBB8E9694 bnb
019011738 Uk
Microsoft Access.
MySQL (Electronic resource)
Oracle (Computer file)
Microsoft Access.
MySQL (Electronic resource)
Oracle (Computer file)
Database management.
Management information systems.
Bases de données--Gestion.
Systèmes d'information de gestion.
COMPUTERS--Databases--General.
Database management.
Management information systems.
Electronic books.
QA76.9.D3
005.74
Database management systems : a business-oriented approach to ORACLE, MySQL and MS Access / Sotirios Zygiaris. - First edition. - 1 online resource (299 pages) : illustrations
Includes bibliographical references and index.
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.
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.
9781787566958 (electronic book) 1787566951 (electronic book) 9781787566972 1787566978 (hardcover) (hardcover)
9781787566972 Emerald Publishing
GBB8E9694 bnb
019011738 Uk
Microsoft Access.
MySQL (Electronic resource)
Oracle (Computer file)
Microsoft Access.
MySQL (Electronic resource)
Oracle (Computer file)
Database management.
Management information systems.
Bases de données--Gestion.
Systèmes d'information de gestion.
COMPUTERS--Databases--General.
Database management.
Management information systems.
Electronic books.
QA76.9.D3
005.74