Mariadb Cookbook Book in PDF, ePub and Kindle version is available to download in english. Read online anytime anywhere directly from your device. Click on the download button below to get a free pdf file of Mariadb Cookbook book. This book definitely worth reading, it is an incredibly well-written.
A practical cookbook, filled with advanced recipes, and plenty of code and commands used for illustration, which will make your learning curve easy and quick. This book is for anyone who wants to learn more about databases in general or MariaDB in particular. Some familiarity with SQL databases is assumed, but the recipes are approachable to almost anyone with basic database skills.
Infrastructure as Code (IAC) Cookbook by Stephane Jourdan,Pierre Pomes Pdf
Over 90 practical, actionable recipes to automate, test, and manage your infrastructure quickly and effectively About This Book Bring down your delivery timeline from days to hours by treating your server configurations and VMs as code, just like you would with software code. Take your existing knowledge and skill set with your existing tools (Puppet, Chef, or Docker) to the next level and solve IT infrastructure challenges. Use practical recipes to use code to provision and deploy servers and applications and have greater control of your infrastructure. Who This Book Is For This book is for DevOps engineers and developers working in cross-functional teams or operations and would now switch to IAC to manage complex infrastructures. What You Will Learn Provision local and remote development environments with Vagrant Automate production infrastructures with Terraform, Ansible and Cloud-init on AWS, OpenStack, Google Cloud, Digital Ocean, and more Manage and test automated systems using Chef and Puppet Build, ship, and debug optimized Docker containers Explore the best practices to automate and test everything from cloud infrastructures to operating system configuration In Detail Infrastructure as Code (IAC) is a key aspect of the DevOps movement, and this book will show you how to transform the way you work with your infrastructure—by treating it as software. This book is dedicated to helping you discover the essentials of infrastructure automation and its related practices; the over 90 organized practical solutions will demonstrate how to work with some of the very best tools and cloud solutions. You will learn how to deploy repeatable infrastructures and services on AWS, OpenStack, Google Cloud, and Digital Ocean. You will see both Ansible and Terraform in action, manipulate the best bits from cloud-init to easily bootstrap instances, and simulate consistent environments locally or remotely using Vagrant. You will discover how to automate and test a range of system tasks using Chef or Puppet. You will also build, test, and debug various Docker containers having developers' interests in mind. This book will help you to use the right tools, techniques, and approaches to deliver working solutions for today's modern infrastructure challenges. Style and approach This is a recipe-based book that allows you to venture into some of the most cutting-edge practices and techniques about IAC and solve immediate problems when trying to implement them.
Zabbix 6 IT Infrastructure Monitoring Cookbook by Nathan Liefting,Brian van Baekel Pdf
Discover practical recipes to help you efficiently monitor enterprise IT infrastructure for Microsoft Windows, Linux, networking, and more Key FeaturesFind out how you can leverage some of the most exciting features of Zabbix 6Perform professional IT infrastructure and application monitoring on multiple platformsDiscover easy-to-follow, practical solutions to problems in network monitoring with ZabbixBook Description This updated second edition of the Zabbix 6 IT Infrastructure Monitoring Cookbook brings you new recipes, updated with Zabbix 6 functionality. You'll learn how to set up Zabbix with built-in high availability, use the improved Business Service Monitoring, set up automatic reporting, and create advanced triggers. Zabbix offers useful insights into your infrastructure performance and issues and enables you to enhance your monitoring setup with its powerful features. This book covers hands-on, easy-to-follow recipes for using Zabbix 6 to monitor effectively the performance of devices and applications over the network. You'll start by working your way through the installation and most prominent features of Zabbix and make the right design choices for building a scalable and easily manageable environment. This Zabbix book contains recipes for building items and triggers for different types of monitoring, building templates, and using Zabbix proxies. Next, you'll use the Zabbix API for customization and manage your Zabbix server and database efficiently. Finally, you'll find quick solutions to the common and not-so-common problems that you may encounter in your Zabbix monitoring work. By the end of this book, you'll be able to use Zabbix for all your monitoring needs and build a solid Zabbix setup by leveraging its key functionalities. What you will learnImplement your high-availability Zabbix setupBuild templates and explore the different types of monitoring available in Zabbix 6Use Zabbix proxies to scale your environment effectivelyWork with custom integrations and the Zabbix APISet up advanced triggers and effective alertingMaintain your Zabbix setup for scaling, backups, and upgradesDiscover how to perform advanced Zabbix database managementMonitor cloud-based products such as Amazon Web Services (AWS), Azure, and DockerWho this book is for This book is for IT engineers who want to get started with Zabbix and anyone with an intermediate-level understanding of Zabbix looking to extend their knowledge. Although not necessary, prior experience with Zabbix will help you to make the most of this book.
Zabbix 5 IT Infrastructure Monitoring Cookbook by Nathan Liefting,Brian van Baekel Pdf
Discover practical recipes to help you efficiently monitor enterprise IT infrastructure for Windows, Linux, and networking Key FeaturesFind out how you can leverage some of the most exciting features of Zabbix 5Perform professional IT infrastructure and application monitoring on multiple platformsDiscover easy-to-follow, practical solutions to problems in network monitoring with ZabbixBook Description Zabbix offers useful insights into your infrastructure performance and issues and enables you to enhance your monitoring setup with its variety of powerful features. This book covers hands-on, easy-to-follow recipes for using Zabbix 5 for effectively monitoring the performance of devices and applications over networks. The book starts by guiding you through the installation of Zabbix and using the Zabbix frontend. You'll then work your way through the most prominent features of Zabbix and make the right design choices for building a scalable and easily manageable environment. The book contains recipes for building items and triggers for different types of monitoring, building templates, and using Zabbix proxies. As you advance, you'll learn how to use the Zabbix API for customization and manage your Zabbix server and database efficiently. Finally, you'll find quick solutions to the common and not-so-common problems that you may encounter in your everyday Zabbix monitoring work. By the end of this Zabbix book, you'll have learned how to use Zabbix for all your monitoring needs and be able to build a solid Zabbix setup by leveraging its key functionalities. What you will learnExplore the different types of monitoring available in Zabbix 5Find out how to build your own Zabbix templatesUse Zabbix proxies for effective load balancing/scalingWork with custom integrations and the Zabbix APISet up triggers and alerting with Zabbix 5Maintain your Zabbix setup for scaling, backups, and upgradesDiscover how to perform advanced Zabbix database managementMonitor cloud-based products such as Amazon Web Services (AWS), Azure, and DockerWho this book is for This book is for IT engineers who want to get started with Zabbix and anyone with an intermediate understanding of Zabbix looking to extend their knowledge. Although not necessary, prior experience with Zabbix will help you to make the most of this book.
OpenStack Cloud Computing Cookbook by Kevin Jackson,Cody Bunch,Egle Sigler Pdf
Over 110 effective recipes to help you build and operate OpenStack cloud computing, storage, networking, and automation About This Book Explore many new features of OpenStack's Juno and Kilo releases Install, configure, and administer core projects with the help of OpenStack Object Storage, Block Storage, and Neutron Networking services Harness the abilities of experienced OpenStack administrators and architects, and run your own private cloud successfully Practical, real-world examples of each service and an accompanying Vagrant environment that helps you learn quickly In Detail OpenStack Open Source software is one of the most used cloud infrastructures to support software development and big data analysis. It is developed by a thriving community of individual developers from around the globe and backed by most of the leading players in the cloud space today. It is simple to implement, massively scalable, and can store a large pool of data and networking resources. OpenStack has a strong ecosystem that helps you provision your cloud storage needs. Add OpenStack's enterprise features to reduce the cost of your business. This book will show you the steps to build up a private cloud environment. At the beginning, you'll discover the uses of cloud services such as the identity service, image service, and compute service. You'll dive into Neutron, the OpenStack Networking service, and get your hands dirty with configuring ML2, networks, routers, and Distributed Virtual Routers. You'll then gather more expert knowledge on OpenStack cloud computing by managing your cloud's security and migration. After that, we delve in to OpenStack Object storage and how to manage servers and work with objects, cluster, and storage functionalities. Also, as you go deeper into the realm of OpenStack, you'll learn practical examples of Block storage, LBaaS, and FWaaS: installation and configuration covered ground up. Finally, you will learn OpenStack dashboard, Ansible and Foreman, Keystone, and other interesting topics. What You Will Learn Understand, install, configure, and manage Nova—the OpenStack Cloud Compute resource Configure ML2, networks, routers, and Distributed Virtual Routers with Neutron Use and secure Keystone, the OpenStack Authentication service Install and set up Swift and Container Replication between datacenters Gain hands-on experience and familiarity with Horizon, the OpenStack Dashboard user interface Automate complete solutions with our recipes on Heat, the OpenStack Orchestration service Use Ansible and Foreman to automate OpenStack installations successfully Follow practical advice and examples to run OpenStack in production Who This Book Is For This book is aimed at cloud system engineers, system administrators, and technical architects who are moving from a virtualized environment to cloud environments. This book assumes that you are familiar with cloud computing platforms, and have knowledge of virtualization, networking, and managing Linux environments. Style and approach Clear, step-by-step instructions coupled with practical and applicable recipes that'll enable you to use and implement the latest features of OpenStack.
Learn How to Implement Key System Administration Tasks in Linux KEY FEATURES ● Configure and use Linux network commands to analyze, maintain, and troubleshoot the network. ● Get familiar with the most commonly used advanced commands required for administrating the Linux Server. ● Explore new and trending services in the system administration domain. DESCRIPTION Linux is the most popular operating system in the IT industry due to its security and performance. In this book, you will get familiar with the most important and advanced concepts of Linux server administration. The book begins by showing you how to install a Linux distribution and the different possibilities available depending on the end usage of it. After installation, the book shows how to manage your system, administrate users, and permissions, and how to install new software and configure the services. The book provides a review of the most common and useful CLI commands and will provide knowledge on how to manage files, directories, and processes. It explains how to install and administer advanced services like databases and file sharing. The book will then guide you through new technologies related to automation, containers, and continuous integration/delivery pipelines. Lastly, it will help you explore concepts such as Infrastructure as Code and Infrastructure as a Service and the usage of Linux on Public and Private clouds in detail with multiple examples. By the end of the book, you will be able to use different open-source tools available on Linux to perform tasks. WHAT YOU WILL LEARN ● Learn how to install a Linux distribution. ● Explore advanced Network Configuration in Linux. ● Configure firewall and network security in the Linux server. ● Learn how to automate your system administration tasks. ● Automate Linux Server Deployments with Terraform. WHO THIS BOOK IS FOR This book is best suited for System administrators, Linux administrators, IT managers, Network engineers, Network administrators, and Security professionals. TABLE OF CONTENTS 1. Introduction to Linux 2. Linux Installation 3. Using the Command Line Interface 4. User Administration and Software Management 5. Managing Files, Directories, and Processes 6. Monitoring System Resources 7. Network Configuration 8. Security 9. Network Services 10. File Sharing 11. Databases 12. Automation 13. Containers and CI/CD 14. Backup and Restore 15. Multi Cloud Management 16. Infrastructure as a Service
CentOS 7 Linux Server Cookbook by Oliver Pelz,Jonathan Hobson Pdf
Over 80 recipes to get up and running with CentOS 7 Linux server About This Book A practical guide to install, configure, administer and maintain CentOS 7 servers An in-depth guide to the CentOS 7 operating system, exploring its various new features and changes in server administration Presents tricks and solutions to tackle common server issues with the help of practical examples and real-life scenarios Who This Book Is For This book is targeted at beginner and more experienced system administrators alike who want to use CentOS as their server solution. Readers do not need much pre-knowledge or experience at all to work with this book. What You Will Learn Install and configure CentOS 7 Linux server system from scratch using normal and advanced methods Maintain a performance-based and secure server solution by deploying expert configuration advice and managing software packages Monitor, manage and develop your server's file system to maintain a stable performance Gain best practice methods on sharing files and resources through a network Install and configure common standard services such as web, mail, FTP, database and domain name server technologies Introduce you to the world of operating-system-level virtualization using the Docker platform. Understand the fundamentals of the Security-Enhanced Linux access control architecture Monitor your IT infrastructure using Nagios In Detail This book will provide you with a comprehensive series of starting points that will give you direct access to the inner workings of the latest CentOS version 7 and help you trim the learning curve to master your server. You will begin with the installation and basic configuration of CentOS 7, followed by learning how to manage your system, services and software packages. You will then gain an understanding of how to administer the file system, secure access to your server and configure various resource sharing services such as file, printer and DHCP servers across your network. Further on, we cover advanced topics such as FTP services, building your own DNS server, running database servers, and providing mail and web services. Finally, you will get a deep understanding of SELinux and you will learn how to work with Docker operating-system virtualization and how to monitor your IT infrastructure with Nagios. By the end of this book, you will have a fair understanding of all the aspects of configuring, implementing and administering CentOS 7 Linux server and how to put it in control. Style and approach This book is a practical reference guide with hands-on examples and solutions to real-world administration problems. It covers in-depth and comprehensive information on CentOS 7 and its new features.
Getting Started with MariaDB by Daniel Bartholomew Pdf
MariaDB is a database that has become very popular in the few short years that it has been around. It does not require a big server or expensive support contract. It is also powerful enough to be the database of choice for some of the biggest and most popular websites in the world, taking full advantage of the latest computing hardware available. From installing and configuring through basic usage and maintenance, each chapter in this revised and expanded guide leads on sequentially and logically from the one before it, introducing topics in their natural order so you learn what you need, when you need it. The book is based on the latest release of MariaDB and covers all the latest features and functions. By the end of this beginner-friendly book, not only will you have a running installation of MariaDB, but you will have practical, hands-on experience in the basics of how to install, configure, administer, use, and maintain it.
MariaDB and MySQL Common Table Expressions and Window Functions Revealed by Daniel Bartholomew Pdf
Walk away from old-fashioned and cumbersome query approaches and answer your business intelligence questions through simple and powerful queries built on common table expressions (CTEs) and window functions. These new features in MariaDB and MySQL help you to write queries without having to wade through a quagmire of brittle self-joins and other crazy techniques from the past. Your queries will generate correct results, be more readable and less brittle in the face of unexpected data, and you’ll be able to adapt them quickly in the face of changing business requirements. MariaDB and MySQL Common Table Expressions and Window Functions Revealed introduces and explains CTEs and window functions, newly available in MariaDB 10.2 and MySQL 8.0, and helps you understand why and how every MariaDB and MySQL database programmer should learn and apply these features in their daily work. CTEs and especially window functions enable easy solutions to many query challenges that in prior releases have been difficult and sometimes impossible to surmount. Mastering these features opens the door to query solutions that are more robust, execute faster, and are easier to maintain over time than prior solutions using older techniques. The book: Takes you step-by-step through the workings of common table expressions and window functions Provides easy-to-follow examples of the new syntax Helps you answer business questions faster and easier than ever What You'll Learn Answer business questions using simple queries that don’t break in the face of unexpected data Avoid writing queries that are a difficult-to-maintain quagmire of self-joins and nested subqueries Recognize situations that call for window functions, and learn when to use these features Reduce the need for performance-robbing self-joins Simplify and speed the execution of analytical queries Create queries that finish in seconds instead of hours Who This Book Is For Database administrators and application developers who want to quickly get up to speed on important features in MariaDB and MySQL for writing business intelligence queries. Any developer writing SQL against MariaDB and MySQL databases will benefit tremendously from the knowledge and techniques this book provides.
Write custom plugins for Puppet, including facts, providers, and functions Key Features Grasp recipes that work with centralized and decentralized deployments Explore language differences and enhancements anticipated in Puppet version 5.x Gain expert understanding of Puppet's latest and most advanced features Book Description Puppet is a configuration management system that automates all your IT configurations, giving you control of managing each node. Puppet 5 Cookbook will take you through Puppet's latest and most advanced features, including Docker containers, Hiera, and AWS Cloud Orchestration. Updated with the latest advancements and best practices, this book delves into various aspects of writing good Puppet code, which includes using Puppet community style, checking your manifests with puppet-lint, and learning community best practices with an emphasis on real-world implementation. You will learn to set up, install, and create your first manifests with version control, and also learn about various sysadmin tasks, including managing configuration files, using Augeas, and generating files from snippets and templates. As the book progresses, you'll explore virtual resources and use Puppet's resource scheduling and auditing features. In the concluding chapters, you'll walk through managing applications and writing your own resource types, providers, and external node classifiers. By the end of this book, you will have learned to report, log, and debug your system. What you will learn Discover the latest and most advanced features of Puppet Master techniques to deal with centralized and decentralized Puppet deployments Use exported resources and forge modules to configure and deploy applications Create efficient manifests to streamline your deployments Automate deployment of puppet environment using git-hooks Deploy AWS instances and Docker containers with Puppet Make Puppet reliable, performant, and scalable Who this book is for Puppet 5 Cookbook is for anyone who builds and administers servers, especially in a web operations context. You’ll need some experience of Linux systems administration, including familiarity with the command line, filesystem, and text editing. No prior programming experience is required.
Over 100 recipes to get up and running with the modern Linux administration ecosystem Key FeaturesUnderstand and implement the core system administration tasks in LinuxDiscover tools and techniques to troubleshoot your Linux systemMaintain a healthy system with good security and backup practicesBook Description Linux is one of the most widely used operating systems among system administrators,and even modern application and server development is heavily reliant on the Linux platform. The Linux Administration Cookbook is your go-to guide to get started on your Linux journey. It will help you understand what that strange little server is doing in the corner of your office, what the mysterious virtual machine languishing in Azure is crunching through, what that circuit-board-like thing is doing under your office TV, and why the LEDs on it are blinking rapidly. This book will get you started with administering Linux, giving you the knowledge and tools you need to troubleshoot day-to-day problems, ranging from a Raspberry Pi to a server in Azure, while giving you a good understanding of the fundamentals of how GNU/Linux works. Through the course of the book, you’ll install and configure a system, while the author regales you with errors and anecdotes from his vast experience as a data center hardware engineer, systems administrator, and DevOps consultant. By the end of the book, you will have gained practical knowledge of Linux, which will serve as a bedrock for learning Linux administration and aid you in your Linux journey. What you will learnInstall and manage a Linux server, both locally and in the cloudUnderstand how to perform administration across all Linux distrosWork through evolving concepts such as IaaS versus PaaS, containers, and automationExplore security and configuration best practicesTroubleshoot your system if something goes wrongDiscover and mitigate hardware issues, such as faulty memory and failing drivesWho this book is for If you are a system engineer or system administrator with basic experience of working with Linux, this book is for you.
Google Cloud Platform Cookbook by Legorie Rajan PS Pdf
Practical recipes to implement cost-effective and scalable cloud solutions for your organization Key Features Implement Google Cloud services in your organization Leverage Google Cloud components to secure your organization’s data A recipe-based guide that promises hands-on experience in deploying a highly scalable and available environment Book Description Google Cloud Platform is a cloud computing platform that offers products and services to host applications using state-of-the art infrastructure and technology. You can build and host applications and websites, store data, and analyze data on Google's scalable infrastructure. This book follows a recipe-based approach, giving you hands-on experience to make the most of Google Cloud services. This book starts with practical recipes that explain how to utilize Google Cloud's common services. Then, you'll see how to make full use of Google Cloud components such as networking, security, management, and developer tools. Next, we'll deep dive into implementing core Google Cloud services into your organization, with practical recipes on App Engine, Compute Engine microservices with Cloud Functions, virtual networks, and Cloud Storage. Later, we'll provide recipes on implementing authentication and security, Cloud APIs, command-line management, deployment management, and the Cloud SDK. Finally, we'll cover administration troubleshooting tasks with the Compute and Container Engines and we'll show how to monitor your organization's efficiency with best practices. By the end of this book, you'll have a complete understanding of how to implement Google Cloud services in your organization with ease. What you will learn Host a Python application on Google Compute Engine Host an application using Google Cloud Functions Migrate a MySQL DB to Cloud Spanner Configure a network for a highly available application on GCP Learn simple image processing using Storage and Cloud Functions Automate security checks using Policy Scanner Understand tools for monitoring a production environment in GCP Learn to manage multiple projects using service accounts Who this book is for This book is for IT professionals, engineers, and developers looking at implementing Google Cloud in their organizations. Administrators and architects planning to make their organization more efficient with Google Cloud will also find this book useful. Basic understanding of Cloud services and the Google Cloud platform is necessary.
Drupal 10 Development Cookbook by Matt Glaman,Kevin Quillen Pdf
Build your expertise in developing dynamic web experiences by leveraging all-new capabilities of Drupal 10 Purchase of the print or Kindle book includes a free PDF eBook Key Features Design your digital experience platform with robust content management and editorial workflows Write custom modules to extend Drupal to meet your requirements by creating customized plugins, entity types, and pages Enhance your Drupal site using modern frontend development build tools Book DescriptionThis new and improved third edition cookbook is packed with the latest Drupal 10 features such as a new, flexible default frontend theme - Olivero, and improved administrative experience with a new theme - Claro. This comprehensive recipe book provides updated content on the WYSIWYG (What You See Is What You Get) editing experience, improved core code performance, and code cleanup. Drupal 10 Development Cookbook begins by helping you create and manage a Drupal site. Next, you’ll get acquainted with configuring the content structure and editing content. You’ll also get to grips with all new updates of this edition, such as creating custom pages, accessing and working with entities, running and writing tests with Drupal, migrating external data into Drupal, and turning Drupal into an API platform. As you advance, you’ll learn how to customize Drupal’s features with out-of-the-box modules, contribute extensions, and write custom code to extend Drupal. By the end of this book, you’ll be able to create and manage Drupal sites, customize them to your requirements, and build custom code to deliver your projects.What you will learn Create and manage a Drupal site’s codebase Design tailored content creator experiences Leverage Drupal by creating customized pages and plugins Turn Drupal into an API platform for exposing content to consumers Import data into Drupal using the data migration APIs Advance your Drupal site with modern frontend tools using Laravel Mix Who this book is forIf you are a beginner or an intermediate Drupal developer, looking to jumpstart your journey in application building, then this book is for you. Basic knowledge of web development is required.
Docker Cookbook by Ken Cochrane,Jeeva S. Chelladhurai,Neependra K Khare Pdf
Leverage Docker to deploying software at scale Key Features Leverage practical examples to manage containers efficiently Integrate with orchestration tools such as Kubernetes for controlled deployments Learn to implement best practices on improving efficiency and security of containers Book Description Docker is an open source platform for building, shipping, managing, and securing containers. Docker has become the tool of choice for people willing to work with containers. Since the market is moving toward containerization, Docker will definitely have a big role to play in the future tech market. This book starts with setting up Docker in different environment, and helps you learn how to work with Docker images. Then, you will take a deep dive into network and data management for containers. The book explores the RESTful APIs provided by Docker to perform different actions, such as image/container operations. The book then explores logs and troubleshooting Docker to solve issues and bottlenecks. You will gain an understanding of Docker use cases, orchestration, security, ecosystems, and hosting platforms to make your applications easy to deploy, build, and collaborate on. The book covers the new features of Docker 18.xx (or later), such as working with AWS and Azure, Docker Engine, Docker Swarm, Docker Compose, and so on. By the end of this book, you will have gained hands-on experience of finding quick solutions to different problems encountered while working with Docker. What you will learn Install Docker on various platforms Work with Docker images and containers Container networking and data sharing Docker APIs and language bindings Various PaaS solutions for Docker Implement container orchestration using Docker Swarm and Kubernetes Container security Docker on various clouds Who this book is for Book is targeted towards developers, system administrators, and DevOps engineers who want to use Docker in his/her development, QA, or production environments. It is expected that the reader has basic Linux/Unix skills such as installing packages, editing files, managing services, and so on. Any experience in virtualization technologies such as KVM, XEN, and VMware will be an added advantage
PostgreSQL 15 Cookbook by Mohammad Samsad Hussain Pdf
Level up database administration with PostgreSQL 15 recipes for mastery KEY FEATURES ● Explore PostgreSQL 15 through 100 plus practical recipes, gaining expertise in monitoring, logging, and migration. ● Master cloud setup, scaling, and PostgreSQL 15 resource management in the cloud. ● Enhance database efficiency, streamline backup, and recovery for administration. DESCRIPTION PostgreSQL 15 is a powerful, open-source database system known for its reliability, flexibility, and advanced features. It stores and manages data efficiently, making it ideal for everything from personal projects to large-scale applications. Get started with installation, configuration, and user management. Learn the basics of tables, views, and functions. Deploy your database securely on AWS, migrate seamlessly from other systems, and explore replication for high availability. Write efficient SQL queries, optimize performance, and safeguard your information with backups and recovery techniques. Control user access, implement robust security measures, and monitor your database health for proactive troubleshooting. Solve common errors and optimize performance, Practical tips and real-world scenarios provide a hands-on learning experience, making it easy to apply new knowledge. By the end of this book, you will have the confidence and skills to manage data like a pro, tackle challenges with ease, and unleash the full potential of PostgreSQL 15. WHAT YOU WILL LEARN ● To setup, configure, and manage users with expertise. ● Scale your database to the cloud securely and migrate seamlessly. ● Protect your data, recover from unexpected events. ● Control access, implement robust security measures, and monitor your database's health. ● Troubleshooting, problem-solving, and fixing common errors. WHO THIS BOOK IS FOR This book is for aspiring students, IT professionals, database administrators, and solution architects looking to enhance their database management skills. TABLE OF CONTENTS 1. Up and running with PostgreSQL 15 2. Database Hierarchy 3. Cloud Provisioning 4. Migration 5. Transaction Log 6. Partitioning and Sharding 7. Replication and High Availability 8. Leveraging SQL 9. Server Controls and Auditing 10. Backup 11. Recovery 12. Monitoring and Diagnosis 13. Troubleshooting