Applied Database Management -U North GA

Product Details
Author(s): Michael A Fudge
ISBN: 9781684782642
Edition: 1
Copyright: 2023
Available Formats
Format: GRLContent (online access)

$84.00

Overview of
Applied Database Management -U North GA

Discovery

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

About the Author
Michael A Fudge

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.

Table of Contents

  • 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