Applied Database Management

  • Author(s): Fudge, Michael A
  • ISBN: 9781644965900
  • Edition: 1
  • Copyright: 2021
  • Pages:
Contact GRL Request Review Copy
AVAILABLE FORMATS  
GRLContent ISBN: 9781644965900 $105.88 Purchase

The most important asset of every organization is its data. Data are created through our everyday activities and help us to make more informed decisions. The key to deriving value from data is understanding how to store, manage and access it in an organized manner. In this book, you will learn how to do just that through database design and programming in SQL (Structured Query Language).

 

The text is divided into 13 units. We begin by addressing the question, “What is a database?” and introducing important concepts for understanding databases in the first two units. The next four units, 3 through 6, address SQL, which we use to build databases and more importantly query the data within.  Units 7, 8 and 9 turn our focus to the question, “How do I create a database application to address the needs of my users?” In the final units 10 through 13 address important topics such as programming, transactions/concurrency, performance and normalization.

 

What does it mean to take a hands-on approach in this course? The text, and accompanying labs and videos are part of a method of learning where the concepts are introduced, explained through practical examples, and then eventually applied through activities and labs. Every unit is hands-on; you will not only learn the concepts but see them applied and ultimately learn to apply them yourself! This will help you form a deeper understanding of the course material and provide an enriched learning experience.  Learn more at https://applieddatabasemanagement.com/

Fudge, Michael A

Michael Fudge is a Professor of Practice with the School of Information Studies at Syracuse University. With 25 years of relevant industry experience, and 20 years of teaching experience, Michael brings a wealth of knowledge and expertise to the subjects he teaches. He actively explores methods to improve his teaching and student learning, especially among the more technical subjects which he teaches.  Through his title, Applied Database Management, Michael is excited to share his knowledge and passion for with you.


Unit 01: Introduction to Databases

Unit 02: The Relational Model

Unit 03: Introduction to SQL

Unit 04: SQL SELECT Statement Part 1

Unit 05: SQL SELECT Statement Part 2

Unit 06: Advanced SQL Query Patterns

Unit 07: Conceptual Data Modeling

Unit 08: Logical Data Modeling

Unit 09: Database Applications

Unit 10: Database Programming

Unit 11: Transactions and Concurrency Control

Unit 12: Performance and Indexing

Unit 13: Data Normalization