DAMA-DMBOK...Data Management Body of Knowledge: 2nd Edition

Brief

Book

Today's organizations recognize that managing data is central to their success. They recognize data has value and they want to leverage that value. As our ability and desire to create and exploit data has increased, so too has the need for reliable data management practices. The second edition  updates and augments the highly successful DMBOK1. An accessible, authoritative reference book written by leading thinkers in the field and extensively reviewed by DAMA members, DMBOK2 brings together materials that comprehensively describe the challenges of data management and how to meet them by: Defining a set of guiding principles for data management and describing how these principles can be applied within data management functional areas.  Providing a functional framework for the implementation of enterprise data management practices; including widely adopted practices, methods and techniques, functions, roles, deliverables and metrics.  Establishing a common vocabulary for data management concepts and serving as the basis for best practices for data management professionals.

Developer-Enabled Threat Modeling...Owning Your Role in Risk-Averse Design

Book

Brief

Threat modeling is one of the most essential—and most misunderstood—parts of the development lifecycle. Whether you’re a security practitioner or application developer, this book will help you gain a better understanding of core concepts and how to apply them to your practice to protect your systems from threats. The authors walk you through the myriad ways to approach and execute threat modeling. Contrary to popular belief, the process takes neither incredibly advanced security knowledge nor an unmanageable amount of effort. But it’s critical for spotting and addressing potential concerns in a cost-effective way before the code’s written and it’s too late to find a solution. Find out why threat modeling is important and how it can make you and your team better, more well-rounded architects and developers  Learn the most effective ways to integrate threat modeling into your development lifecycle  Use the results of a threat modeling exercise on other aspects of the system lifecycle

Database Design for Mere Mortals

Brief

Book

Step by step, this book shows you how to design databases that are soundly structured, reliable, and flexible, even in modern web applications. The author guides you through everything from database planning to defining tables, fields, keys, table relationships, business rules, and views. You’ll learn practical ways to improve data integrity, how to avoid common mistakes, and when to break the rules. This edition has been updated to reflect the current landscape for databases and their prevalent uses in the world. Coverage includes Understanding database types, models, and design terminology  Discovering what good database design can do for you—and why bad design can make your life miserable  Setting objectives for your database, and transforming those objectives into real designs  Analyzing a current database so you can identify ways to improve it  Establishing table structures and relationships, assigning primary keys, setting field specifications, and setting up views  Ensuring the appropriate level of data integrity for each application Identifying and establishing business rules

Mastering Kafka Streams and ksqlDB... Building Real-Time Data Systems

Brief

Book

With Kafka Streams and ksqlDB, building stream processing applications is easy and fun. This practical guide explores the world of real-time data systems through the lens of these popular technologies and explains important stream processing concepts against a backdrop of interesting business problems. The author introduces you to both Kafka Streams and ksqlDB so that you can choose the best tool for each unique stream processing project. In this book, you’ll learn: Basic and advanced uses of Kafka Streams and ksqlDB  How to transform, enrich, and process event streams  How to build both stateless and stateful stream processing applications  The different notions of time and the role it plays in stream processing  How to to build event-driven microservices on top of continuous event streams  Features, operational characteristics, deployment patterns, and configuration tips for both technologies

SQL QuickStart Guide...

Brief

Book

The ubiquity of big data means that now more than ever there is a burning need to warehouse, access, and understand the contents of massive databases quickly and efficiently. That’s where SQL comes in. SQL is the workhorse programming language that forms the backbone of modern data management and interpretation. Any database management professional will tell you that despite trendy data management languages that come and go, SQL remains the most widely used and most reliable to date, with no signs of stopping. In this comprehensive guide, experienced mentor and SQL expert Walter Shields draws on his considerable knowledge to make the topic of relational database management accessible, easy to understand, and highly actionable. This book  is ideal for those seeking to increase their job prospects and enhance their careers, for developers looking to expand their programming capabilities, or for anyone who wants to take advantage of our inevitably data-driven future—even with no prior coding experience!

Learning SQL... Generate, Manipulate, and Retrieve Data

Brief

Book

As data floods into your company, you need to put it to work right away—and SQL is the best tool for the job. With the latest edition of this introductory guide, author Alan Beaulieu helps developers get up to speed with SQL fundamentals for writing database applications, performing administrative tasks, and generating reports. You’ll find new chapters on SQL and big data, analytic functions, and working with very large databases. Each chapter presents a self-contained lesson on a key SQL concept or technique using numerous illustrations and annotated examples. Exercises let you practice the skills you learn. Knowledge of SQL is a must for interacting with data. With Learning SQL, you’ll quickly discover how to put the power and flexibility of this language to work. Move quickly through SQL basics and several advanced features Use SQL data statements to generate, manipulate, and retrieve data  Create database objects, such as tables, indexes, and constraints with SQL schema statements  Learn how datasets interact with queries; understand the importance of subqueries  Convert and manipulate data with SQL’s built-in functions and use conditional logic in data statements