Grokking Relational Database Design

В этом материале разберём тему: database.

Grokking Relational Database Design makes the principles of designing relational databases approachable and engaging. Everything in this book is reinforced by hands-on exercises and examples.

In Grokking Relational Database Design you’ll learn the basics of relational database design including how to name fields and tables, which data to store where, how to eliminate repetition, good practices for data collection and hygiene, and much more. In Grokking Relational Database Design, you’ll learn how to:Query and create databases using Structured Query Language (SQL)Design databases from scratchImplement and optimize database designsTake advantage of generative AI when designing databasesA well-constructed database is easy to understand, query, manage, and scale when your app needs to grow. You won’t need a computer science degree or in-depth knowledge of programming—the book’s practical examples and down-to-earth definitions are beginner-friendly.

Whether you’re a software developer, an analyst creating reports and dashboards, or a business user just trying to pull the latest numbers, it pays to understand how a relational database operates. About the technologyAlmost every business uses a relational database system. This friendly, easy-to-follow book guides you from square one through the basics of relational database design.

The clear explanations, intuitive illustrations, and hands-on projects make database theory come to life, even if you can’t tell a primary key from an inner join. About the bookGrokking Relational Database Design introduces the core skills you need to assemble and query tables using SQL. As you go, you’ll design, implement, and optimize a database for an e-commerce application and explore how generative AI simplifies the mundane tasks of database designs.

What's insideDefine entities and their relationshipsMinimize anomalies and redundancyUse SQL to implement your designsSecurity, scalability, and performanceAbout the readerFor self-taught programmers, software engineers, data scientists, and business data users. No previous experience with relational databases assumed.

Если материал оказался полезен — сохраните страницу.