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 effectively Key Features Learn how to set up and maintain a MySQL database Run SQL queries to create, retrieve, and manipulate data Use MySQL effectively with common business applications such as Excel and MS Access Book DescriptionDo you want to learn how to create and maintain databases effectively? Are you looking for simple answers to basic MySQL questions as well as straightforward examples that you can use at work? If so, this workshop is the right choice for you. Designed to build your confidence through hands-on practice, this book uses a simple approach that focuses on the practical, so you can get straight down to business without having to wade through pages and pages of dull, dry theory. As you work through bite-sized exercises and activities, you'll learn how to use different MySQL tools to create a database and manage the data within it. You'll see how to transfer data between a MySQL database and other sources, and use real-world datasets to gain valuable experience of manipulating and gaining insights from data. As you progress, you'll discover how to protect your database by managing user permissions and performing logical backups and restores. If you've already tried to teach yourself SQL, but haven't been able to make the leap from understanding simple queries to working on live projects with a real database management system, The MySQL Workshop will get you on the right track. By the end of this MySQL book, you'll have the knowledge, skills, and confidence to advance your career and tackle your own ambitious projects with MySQL. What you will learn Understand the concepts of relational databases and document stores Use SQL queries, stored procedures, views, functions, and transactions Connect to and manipulate data using MS Access, MS Excel, and Visual Basic for Applications (VBA) Read and write data in the CSV or JSON format using MySQL Manage data while running MySQL Shell in JavaScript mode Use X DevAPI to access a NoSQL interface for MySQL Manage user roles, credentials, and privileges to keep data secure Perform a logical database backup with mysqldump and mysqlpump Who this book is forThis book is for anyone who wants to learn how to use MySQL in a productive, efficient way. If you're totally new to MySQL, it'll help you get started or if you've used MySQL before, it'll fill in any gaps, consolidate key concepts, and offer valuable hands-on practice. Prior knowledge of simple SQL or basic programming techniques will help you in quickly grasping the concepts covered, but is not necessary.

This report reviews the impact of trade facilitation initiatives in Asia and the Pacific since the coronavirus disease (COVID-19) pandemic began and discusses how to increase supply chain resilience. Supply chain disruptions caused by the pandemic have underscored the need for digital and paperless trade procedures. A special chapter examines the pandemic's impact on the supply chains of critical goods such as vaccines, personal protective equipment, and food, and provides policy suggestions for enhancing supply chain resilience and trade facilitation. This is the third biennial progress report on trade facilitation implementation in Asia and the Pacific jointly prepared by the Asian Development Bank and the United Nations Economic and Social Commission for Asia and the Pacific.

Administer, monitor, and replicate your PostgreSQL 14 database for efficient database management and maintenance Key Features Troubleshoot and tackle any administration and management problems in PostgreSQL 14 Find expert techniques for monitoring, fine-tuning, and securing your database Adopt efficient replication for high availability with PostgreSQL 14 Book DescriptionPostgreSQL 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 14 allows you to scale up your PostgreSQL infrastructure. With this book, you'll take a step-by-step, recipe-based approach to effective PostgreSQL administration. This book will get you up and running with all the latest features of PostgreSQL 14 while helping you explore the entire database ecosystem. You'll learn how to tackle a variety of problems and pain points you may face as a database administrator such as creating tables, managing views, improving performance, and securing your database. As you make progress, the book will draw attention to important topics such as monitoring roles, validating backups, regular maintenance, and recovery of your PostgreSQL 14 database. This will help you understand roles, ensuring high availability, concurrency, and replication. Along with updated recipes, this book touches upon important areas like using generated columns, TOAST compression, PostgreSQL on the cloud, and much more. By the end of this PostgreSQL book, you'll have gained the knowledge you need to manage your PostgreSQL 14 database efficiently, both in the cloud and on-premise. What you will learn Plan, manage, and maintain PostgreSQL databases in production Work with the newly introduced features of PostgreSQL 14 Use pgAdmin or OmniDB to perform database administrator (DBA) tasks Use psql to write accurate and repeatable scripts Understand how to tackle real-world data issues with the help of examples Select and implement robust backup and recovery techniques in PostgreSQL 14 Deploy best practices for planning and designing live databases Who this book is forThis Postgres 14 book is for database administrators, data architects, database developers, and anyone with an interest in planning and running live production databases using PostgreSQL 14. Those looking for hands-on solutions to any problem associated with PostgreSQL 14 administration will also find this book useful. Some experience with handling PostgreSQL databases will help you to make the most out of this book, however, it is a useful resource even if you are just beginning your Postgres journey.

This report discusses the enhanced framework of the Asia-Pacific Regional Cooperation and Integration Index (ARCII) that now includes digital connectivity and environmental cooperation among other innovations for monitoring progress. The ARCII has been used for monitoring progress in various dimensions of regional cooperation and integration (RCI) in Asia and the Pacific since 2017. With these new features of the ARCII, the report explores the links between regional and global economic integration and sheds light on the application of the index to RCI analysis and policy strategies for Asia and Pacific economies.

Get up to speed with core PostgreSQL tasks such as database administration, application development, database performance monitoring, and database testing Key Features Build real-world enterprise database management systems using Postgres 12 features Explore the development, administrative and security aspects of PostgreSQL 12 Implement best practices from industry experts to build powerful database applications Book DescriptionPostgreSQL is an open-source object-relational database management system (DBMS) that provides enterprise-level services, including high performance and scalability. This book is a collection of unique projects providing you with a wealth of information relating to administering, monitoring, and testing PostgreSQL. The focus of each project is on both the development and the administrative aspects of PostgreSQL. Starting by exploring development aspects such as database design and its implementation, you'll then cover PostgreSQL administration by understanding PostgreSQL architecture, PostgreSQL performance, and high-availability clusters. Various PostgreSQL projects are explained through current technologies such as DevOps and cloud platforms using programming languages like Python and Node.js. Later, you'll get to grips with the well-known database API tool, PostgREST, before learning how to use popular PostgreSQL database testing frameworks. The book is also packed with essential tips and tricks and common patterns for working seamlessly in a production environment. All the chapters will be explained with the help of a real-world case study on a small banking application for managing ATM locations in a city. By the end of this DBMS book, you'll be proficient in building reliable database solutions as per your organization's needs. What you will learn Set up high availability PostgreSQL database clusters in the same containment, a cross-containment, and on the cloud Monitor the performance of a PostgreSQL database Create automated unit tests and implement test-driven development for a PostgreSQL database Develop PostgreSQL apps on cloud platforms using DevOps with Python and Node.js Write robust APIs for PostgreSQL databases using Python programming, Node.js, and PostgREST Create a geospatial database using PostGIS and PostgreSQL Implement automatic configuration by Ansible and Terraform for Postgres Who this book is forThis PostgreSQL book is for database developers, database administrators, data architects, or anyone who wants to build end-to-end database projects using Postgres. This book will also appeal to software engineers, IT technicians, computer science researchers, and university students who are interested in database development and administration. Some familiarity with PostgreSQL and Linux is required to grasp the concepts covered in the book effectively.

Master data management by effectively utilizing the features of Azure SQL database. Key Features Learn to automate common management tasks with PowerShell. Understand different methods to generate elastic pools and shards to scale Azure SQL databases. Learn to develop a scalable cloud solution through over 40 practical activities and exercises. Book DescriptionDespite being the cloud version of SQL Server, Azure SQL Database and Azure SQL Managed Instance stands out in various aspects when it comes to management, maintenance, and administration. Updated with the latest Azure features, Professional Azure SQL Managed Database Administration continues to be a comprehensive guide for becoming proficient in data management. The book begins by introducing you to the Azure SQL managed databases (Azure SQL Database and Azure SQL Managed Instance), explaining their architecture, and how they differ from an on-premises SQL server. You will then learn how to perform common tasks, such as migrating, backing up, and restoring a SQL Server database to an Azure database. As you progress, you will study how you can save costs and manage and scale multiple SQL databases using elastic pools. You will also implement a disaster recovery solution using standard and active geo-replication. Finally, you will explore the monitoring and tuning of databases, the key features of databases, and the phenomenon of app modernization. By the end of this book, you will have mastered the key aspects of an Azure SQL database and Azure SQL managed instance, including migration, backup restorations, performance optimization, high availability, and disaster recovery. What you will learn Understanding Azure SQL database configuration and pricing options Provisioning a new SQL database or migrating an existing on-premises SQL Server database to an Azure SQL database Backing up and restoring an Azure SQL database Securing and scaling an Azure SQL database Monitoring and tuning an Azure SQL database Implementing high availability and disaster recovery with an Azure SQL database Managing, maintaining, and securing managed instances Who this book is forThis book is designed to benefit database administrators, database developers, or application developers who are interested in developing new applications or migrating existing ones with Azure SQL database. Prior experience of working with an on-premise SQL Server or Azure SQL database along with a basic understanding of PowerShell scripts and C# code is necessary to grasp the concepts covered in this book.