Catalogue Search | MBRL
Are you sure you want to remove the book from the shelf?
{{itemTitle}}
126,944
result(s) for
"Database management"
Sort by:
Advanced Database Systems
This book provides an in-depth study of the advanced concepts and technologies in database systems. It covers topics such as distributed databases, object-oriented databases, data mining, and big data analytics. The book is written for students and professionals in the field of computer science who want to enhance their knowledge and skills in advanced database technologies. This book will provide you with a solid understanding of the latest developments in database systems and their applications.
eBook
High Performance PostgreSQL for Rails: Reliable, Scalable, Maintainable Database Applications
Build faster, more reliable Rails apps by taking the best advanced PostgreSQL and Active Record capabilities, and using them to solve your application scale and growth challenges. Gain the skills needed to comfortably work with multi-terabyte databases, and with complex Active Record, SQL, and specialized Indexes. Develop your skills with PostgreSQL on your laptop, then take them into production, while keeping everything in sync. Make slow queries fast, perform any schema or data migration without errors, use scaling techniques like read/write splitting, partitioning, and sharding, to meet demanding workload requirements from Internet scale consumer apps to enterprise SaaS.Deepen your firsthand knowledge of high-scale PostgreSQL databases and Ruby on Rails applications with dozens of practical and hands-on exercises. Unlock the mysteries surrounding complex Active Record. Make any schema or data migration change confidently, without downtime. Grow your experience with modern and exclusive PostgreSQL features like SQL Merge, Returning, and Exclusion constraints. Put advanced capabilities like Full Text Search and Publish Subscribe mechanisms built into PostgreSQL to work in your Rails apps. Improve the quality of the data in your database, using the advanced and extensible system of types and constraints to reduce and eliminate application bugs. Tackle complex topics like how to improve query performance using specialized indexes. Discover how to effectively use built-in database functions and write your own, administer replication, and make the most of partitioning and foreign data wrappers. Use more than 40 well-supported open source tools to extend and enhance PostgreSQL and Ruby on Rails. Gain invaluable insights into database administration by conducting advanced optimizations - including high-impact database maintenance - all while solving real-world operational challenges. Take your new skills into production today and then take your PostgreSQL and Rails applications to a whole new level of reliability and performance.What You Need:A computer running macOS, Linux, or Windows and WSL2PostgreSQL version 16, installed by package manager, compiled, or running with DockerAn Internet connection
eBook
PostgreSQL 10 Administration Cookbook
A practical guide to administer, monitor and replicate your PostgreSQL 10 database Key Features * Get to grips with the capabilities of PostgreSQL 10 to administer your database more efficiently * Monitor, tune, secure and protect your database for optimal performance * A step-by-step, recipe-based guide to help you tackle any problem in PostgreSQL 10 administration with ease Book Description PostgreSQL is a powerful, open source database management system with an enviable reputation for high performance and stability. With many new features in its arsenal, PostgreSQL 10 allows users to scale up their PostgreSQL infrastructure. This book takes a step-by-step, recipe-based approach to effective PostgreSQL administration. Throughout this book, you will be introduced to these new features such as logical replication, native table partitioning, additional query parallelism, and much more. You will learn how to tackle a variety of problems that are basically the pain points for any database administrator - from creating tables to managing views, from improving performance to securing your database. More importantly, the book pays special attention to topics such as monitoring roles, backup, and recovery of your PostgreSQL 10 database, ensuring high availability, concurrency, and replication. By the end of this book, you will know everything you need to know to be the go-to PostgreSQL expert in your organization. What you will learn * Get to grips with the newly released PostgreSQL 10 features to improve database performance and reliability * Manage open source PostgreSQL versions 10 on various platforms. * Explore best practices for planning and designing live databases * Select and implement robust backup and recovery techniques in PostgreSQL 10 * Explore concise and clear guidance on replication and high availability * Discover advanced technical tips for experienced users Who this book is for This book is for database administrators, data architects, developers, or anyone with an interest in planning for, or running, live production databases using PostgreSQL. It is most suited to those looking for hands-on solutions to any problem associated with PostgreSQL administration.
eBook
Oracle database 12c release 2 multitenant
\"Govern a scalable, extensible, and highly available enterprise database environment using the practical information contained in this Oracle Press guide. Written by a team of Oracle Masters, Oracle Database 12c Release 2 Multitenant shows, step-by-step, how to deploy and manage multitenant configurations across IT frameworks of all types and sizes. Find out how to create databases, work with PDBs and CDBs, administer Oracle Net Services, and automate administrative tasks. Backup and recovery, security, and advanced multitenant options are covered in complete detail. Learn how to: - Build high-performance multitenant Oracle databases - Create single-tenant, multitenant, and application containers - Establish network connections and manage services - Handle security using authentication, authorization, and encryption - Back up and restore your mission-critical data - Work with point-in-time recovery and Oracle Flashback - Move data and replicate and clone databases - Work with Oracle's Resource Manager and Data Guard\"-- Provided by publisher.
Book
Ultimate SQL Server and Azure SQL for Data Management and Modernization
SQL Server 2022 marks a major advancement in data management technology, offering features that empower organizations to harness their data like never before. Ultimate SQL Server 2022 Data Management and Modernization is your comprehensive guide to mastering this powerful tool. You will explore SQL Server 2022's latest features, including support for Linux, containerization, and Kubernetes deployments--skills essential in today's evolving data landscape. As you navigate these innovations, you will examine critical areas like security, business continuity, performance tuning, and optimization. Each chapter is crafted to illustrate practical applications in both on-premises and cloud environments, ensuring you grasp their significance. Building on this foundation, you will uncover best practices and modernization techniques tailored for Windows and Linux systems. The book also includes insights from the authors' extensive experience with the Microsoft SQL Server support team, equipping you with effective troubleshooting methods to address performance challenges directly. By the end of this book, you will have a thorough understanding of SQL Server deployments, empowering you to make strategic decisions and maximize its capabilities.
eBook
Professional Azure SQL Database Administration
Discover how you can migrate a traditional on-premise SQL server database to a cloud-based solution with Microsoft Azure. Built with database administrators in mind, this book emulates different scenarios you might come across while working with large, complex SQL database migrations and provides solutions for effectively managing the migrated databases. Key Features * Implement backup, restore, and recovery of Azure SQL databases * Create shards and elastic pools to scale Azure SQL databases * Automate common management tasks with PowerShell * Implement over 40 practical activities and exercises across 24 topics to reinforce your learning Book Description As the cloud version of SQL Server, Azure SQL Database differs in key ways when it comes to management, maintenance, and administration. It's important to know how to administer SQL Database to fully benefit from all of the features and functionality that it provides. This book addresses important aspects of an Azure SQL Database instance such as migration, backup restorations, pricing policies, security, scalability, monitoring, performance optimization, high availability, and disaster recovery. It is a complete guide for database administrators, and ideal for those who are planning to migrate from on premise SQL Server database to an Azure SQL Server database. What you will learn * Learn how to provision a new database or migrate an existing on-premise solution * Understand how to backup, restore, secure, and scale your own Azure SQL Database * Optimize the performance by monitoring and tuning your cloud-based SQL instance * Implement high availability and disaster recovery procedures with SQL Database * Develop a roadmap for your own scalable cloud solution with Azure SQL Database Who this book is for This book is ideal for database administrators, database developers, or application developers who are interested in developing or migrating existing applications with Azure SQL Database. Prior experience of working with an on-premise SQL Server deployment and brief knowledge of PowerShell and C# are recommended prerequisites.
eBook