-
Beginning Database Design Solutions, 2nd Edition
Author Rod Stephens
A concise introduction to database design concepts, methods, and techniques in and out of the cloudIn 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 i....
Release Date 2023/04 -
Author Thomas LaRock , Enrico van de Laar
Use this practical guide to analyze and troubleshoot SQL Server performance using wait statistics. You'll learn to identify precisely why your queries are running slowly. And you'll know how to measure the amount of time consumed by each bottleneck so you can focus attention on making the largest ....
Release Date 2023/01 -
Pro SQL Server 2022 Administration: A Guide for the Modern DBA
Author Peter A. Carter
Get your daily work done efficiently using this comprehensive guide for SQL Server DBAs that covers all that a practicing database administrator needs to know. Updated for SQL Server 2022, this edition includes coverage of new features, such as Ledger, which provides an immutable record of table his....
Release Date 2022/11 -
SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Author Grant Fritchey
Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pressure to provide more speed. This new edition has been redesigned and rewritten from scratch based on the last 15 years of learning, knowledge, and experience accumu....
Release Date 2022/11 -
SQL Server 2022 Revealed: A Hybrid Data Platform Powered by Security, Performance, and Availability
Author Bob Ward
Know how to use the new capabilities and cloud integrations in SQL Server 2022. This book covers the many innovative integrations with the Azure Cloud that make SQL Server 2022 the most cloud-connected edition ever. The book covers cutting-edge features such as the blockchain-based Ledger for creati....
Release Date 2022/11 -
Introducing RavenDB: The Database for Modern Data Persistence
Author Dejan Miličić
Simplify your first steps with the RavenDB NoSQL Document Database. This book takes a task-oriented approach by showing common problems, potential solutions, brief explanations of how those solutions work, and the mechanisms used. Based on real-world examples, the recipes in this book will show you ....
Release Date 2022/11 -
Author Josephine Bush
Know how to track changes and key events in your SQL Server databases in support of application troubleshooting, regulatory compliance, and governance. This book shows how to use key features in SQL Server ,such as SQL Server Audit and Extended Events, to track schema changes, permission changes, an....
Release Date 2022/09 -
Author Michael Bunting , Carl Lemieux
Learn the secrets to self-awareness, life-changing growth and happy, high-performing teams—from the bestselling author of The Mindful LeaderGreat leaders and teams don’t know everything, and they don’t get it right every time. What sets them apart is their commitment to continual learning and vertic....
Release Date 2022/08 -
Learn dbatools in a Month of Lunches
Author Rob Sewell , Jess Pomfret , Chrissy LeMaire , Cláudio Silva
If you work with SQL Server, dbatools is a lifesaver. This book will show you how to use this free and open source PowerShell module to automate just about every SQL server task you can imagine—all in just one month! In Learn dbatools in a Month of Lunches you will learn how to: Perform instance....
Release Date 2022/07 -
SQL Server Advanced Troubleshooting and Performance Tuning
This practical book provides a comprehensive overview of troubleshooting and performance tuning best practices for Microsoft SQL Server. Database engineers, including database developers and administrators, will learn how to identify performance issues, troubleshoot the system in a holistic fashion,.... -
Author Thomas Pettit , Scott Cosentino
Learning MySQL just got a whole lot easier, thanks to this hands-on workshop, complete with simple explanations, engaging examples, and realistic exercises that focus on helping you to build and maintain databases effectivelyKey FeaturesLearn how to set up and maintain a MySQL databaseRun SQL querie....
Release Date 2022/04 -
Databases Illuminated, 4th Edition
Author Catherine M. Ricardo , Susan D. Urban , Karen C. Davis
Databases Illuminated, Fourth Edition is designed to help students integrate theoretical material with practical knowledge, using an approach that applies theory to practical database implementation.
Release Date 2022/03 -
PostgreSQL 14 Administration Cookbook
Author Simon Riggs , Gianni Ciolli
Administer, monitor, and replicate your PostgreSQL 14 database for efficient database management and maintenanceKey FeaturesTroubleshoot and tackle any administration and management problems in PostgreSQL 14Find expert techniques for monitoring, fine-tuning, and securing your databaseAdopt efficient....
Release Date 2022/03 -
Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads
Author Edward Pollack
Meet the challenge of storing and accessing analytic data in SQL Server in a fast and performant manner. This book illustrates how columnstore indexes can provide an ideal solution for storing analytic data that leads to faster performing analytic queries and the ability to ask and answer business i....
Release Date 2022/02 -
High Performance MySQL, 4th Edition
How can you realize MySQL's full power? With High Performance MySQL, you'll learn advanced techniques for everything from choosing the right abstraction layer for databases to designing schemas, indexes, and queries to tuning your server, operating system, and hardware to achieve their full potent.... -
Author Alice Zhao
If you use SQL in your day-to-day work as a data analyst, data scientist, or data engineer, this popular pocket guide is the ideal on-the-job reference. You'll find many examples that address the language's complexities, along with key aspects of SQL used in Microsoft S....
Release Date 2021/12 -
Author Vinicius M. Grippa , Sergey Kuzmichev
Get a comprehensive overview on how to set up and design an effective database with MySQL. This thoroughly updated edition covers MySQL’s latest version, including its most important aspects. Whether you’re deploying an environment, troubleshooting an issue, or engaging i....
Release Date 2021/10 -
Foundation Db2 and Python: Access Db2 with Module-Based API Examples Using Python
Work with Db2 to write SQL and access databases using optimized code for the fastest response. This book will give you complete documentation on DB2 via Python for the IBM_db module and provide a number of examples for the usage of each module API.Begin by getting your free version of Db2 for .... -
Advanced Analytics with Transact-SQL: Exploring Hidden Patterns and Rules in Your Data
Learn about business intelligence (BI) features in T-SQL and how they can help you with data science and analytics efforts without the need to bring in other languages such as R and Python. This book shows you how to compute statistical measures using your existing skills in T-SQL. You will le.... -
Learning PHP, MySQL & JavaScript, 6th Edition
Build interactive, data-driven websites with the potent combination of open source technologies and web standards, even if you have only basic HTML knowledge. With the latest edition of this popular hands-on guide, you'll tackle dynamic web programming using the most recent versions of today's cor.... -
Database-Driven Web Development: Learn to Operate at a Professional Level with PERL and MySQL
Learn to operate at a professional level with HTML, CSS, DOM, JavaScript, PERL and the MySQL database. With plain language explanations and step-by-step examples, you will understand the key facets of web development that today’s employers are looking for. Encapsulating knowledge that is usually fou.... -
PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries
Write optimized queries. This book helps you write queries that perform fast and deliver results on time. You will learn that query optimization is not a dark art practiced by a small, secretive cabal of sorcerers. Any motivated professional can learn to write efficient queries from the get-go and c.... -
R2DBC Revealed: Reactive Relational Database Connectivity for Java and JVM Programmers
Understand the newest trend in database programming for developers working in Java, Kotlin, Clojure, and other JVM-based languages. This book introduces Reactive Relational Database Connectivity (R2DBC), a modern way of connecting to and querying relational databases from Java and other JVM language.... -
IBM Integrated Synchronization: Incremental Updates Unleashed
The IBM® Db2® Analytics Accelerator (Accelerator) is a logical extension of Db2 for IBM z/OS® that provides a high-speed query engine that efficiently and cost-effectively runs analytics workloads. The Accelerator is an integrated back-end component of Db2 for z/OS. Together, they provide a hybrid w.... -
High Performance SQL Server: Consistent Response for Mission-Critical Applications
Design and configure SQL Server instances and databases in support of high-throughput, mission-critical applications providing consistent response times in the face of variations in numbers of users and query volumes. In this new edition, with over 100 pages of additional content, every original cha.... -
MySQL Concurrency: Locking and Transactions for MySQL Developers and DBAs
Know how locks work in MySQL and how they relate to transactions. This book explains the major role that locks play in database systems, showing how locks are essential in allowing high-concurrency workloads. You will learn about lock access levels and lock granularities from the user level as well .... -
Author Sergio Guerrero
Get started building custom Fiori applications for your enterprise. This book teaches you how to design, build, and deploy enterprise-ready, custom Fiori applications in SAP HANA. Tips and tricks collected from projects using Fiori applications (built consuming OData mode....
Release Date 2020/12