Beginning Database Design Solutions: Understanding and Implementing Database Design Concepts for the Cloud and Beyond, Second Edition

  • 13h 36m
  • Rod Stephens
  • John Wiley & Sons (US)
  • 2023

A concise introduction to database design concepts, methods, and techniques in and out of the cloud

In the newly revised second edition of Beginning Database Design Solutions: Understanding and Implementing Database Design Concepts for the Cloud and Beyond, Second Edition, award-winning programming instructor and mathematician Rod Stephens delivers an easy-to-understand guide to designing and implementing databases both in and out of the cloud. Without assuming any prior database design knowledge, the author walks you through the steps you’ll need to take to understand, analyze, design, and build databases.

In the book, you’ll find clear coverage of foundational database concepts along with hands-on examples that help you practice important techniques so you can apply them to your own database designs, as well as:

  • Downloadable source code that illustrates the concepts discussed in the book
  • Best practices for reliable, platform-agnostic database design
  • Strategies for digital transformation driven by universally accessible database design

An essential resource for database administrators, data management specialists, and database developers seeking expertise in relational, NoSQL, and hybrid database design both in and out of the cloud, Beginning Database Design Solutions is a hands-on guide ideal for students and practicing professionals alike.

About the Author

ROD STEPHENS is a professional programmer, sought-after technical speaker, instructor, and author. He’s written 37 books and over 250 magazine articles on C#, Java, and other programming languages. He runs the popular C# Helper and VB Helper websites which have helped millions of programmers with tips, tricks, and useful example code.

In this Book

  • Introduction
  • Database Design Goals
  • Relational Overview
  • NoSQL Overview
  • Understanding User Needs
  • Translating User Needs into Data Models
  • Extracting Business Rules
  • Normalizing Data
  • Designing Databases to Support Software
  • Using Common Design Patterns
  • Avoiding Common Design Pitfalls
  • Defining User Needs and Requirements
  • Building a Data Model
  • Extracting Business Rules
  • Normalizing and Refining
  • Example Overview
  • MariaDB in Python
  • MariaDB in C#
  • PostgreSQL in Python
  • PostgreSQL in C#
  • Neo4j AuraDB in Python
  • Neo4j AuraDB in C#
  • MongoDB Atlas in Python
  • MongoDB Atlas in C#
  • Apache Ignite in Python
  • Apache Ignite in C#
  • Introduction to SQL
  • Building Databases with SQL Scripts
  • Database Maintenance
  • Database Security
  • Glossary
SHOW MORE
FREE ACCESS