This technical study examines the state of e-commerce infrastructure among CAREC countries looking at internet payment systems, delivery, and logistics infrastructure. Digital trade promotion has been a long-standing priority for member countries of the Central Asia Regional Economic Cooperation (CAREC) Program to support their integration into global value chains and economic diversification. The study underscores the importance of enabling legislation, digital literacy, and creation of trust. Comprehensive strategy; adequate data for policy making; and support for e-commerce ecosystems, industry associations, and start-ups could nurture e-commerce markets. In addition, CAREC countries must leverage international and regional initiatives to expand domestic and cross-border e-commerce and promote digital trade.

Take your first steps to becoming a fully qualified data analyst by learning how to explore complex datasets Key Features Master each concept through practical exercises and activities Discover various statistical techniques to analyze your data Implement everything you've learned on a real-world case study to uncover valuable insights Book DescriptionEvery day, businesses operate around the clock, and a huge amount of data is generated at a rapid pace. This book helps you analyze this data and identify key patterns and behaviors that can help you and your business understand your customers at a deep, fundamental level. SQL for Data Analytics, Third Edition is a great way to get started with data analysis, showing how to effectively sort and process information from raw data, even without any prior experience. You will begin by learning how to form hypotheses and generate descriptive statistics that can provide key insights into your existing data. As you progress, you will learn how to write SQL queries to aggregate, calculate, and combine SQL data from sources outside of your current dataset. You will also discover how to work with advanced data types, like JSON. By exploring advanced techniques, such as geospatial analysis and text analysis, you will be able to understand your business at a deeper level. Finally, the book lets you in on the secret to getting information faster and more effectively by using advanced techniques like profiling and automation. By the end of this book, you will be proficient in the efficient application of SQL techniques in everyday business scenarios and looking at data with the critical eye of analytics professional. What you will learn Use SQL to clean, prepare, and combine different datasets Aggregate basic statistics using GROUP BY clauses Perform advanced statistical calculations using a WINDOW function Import data into a database to combine with other tables Export SQL query results into various sources Analyze special data types in SQL, including geospatial, date/time, and JSON data Optimize queries and automate tasks Think about data problems and find answers using SQL Who this book is forIf you're a database engineer looking to transition into analytics or a backend engineer who wants to develop a deeper understanding of production data and gain practical SQL knowledge, you will find this book useful. This book is also ideal for data scientists or business analysts who want to improve their data analytics skills using SQL. Basic familiarity with SQL (such as basic SELECT, WHERE, and GROUP BY clauses) as well as a good understanding of linear algebra, statistics, and PostgreSQL 14 are necessary to make the most of this SQL data analytics book.

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 critical skills needed to deploy and use Databricks SQL and elevate your BI from the warehouse to the lakehouse with confidence Key Features Learn about business intelligence on the lakehouse with features and functions of Databricks SQL Make the most of Databricks SQL by getting to grips with the enablers of its data warehousing capabilities A unique approach to teaching concepts and techniques with follow-along scenarios on real datasets Book DescriptionIn this new era of data platform system design, data lakes and data warehouses are giving way to the lakehouse - a new type of data platform system that aims to unify all data analytics into a single platform. Databricks, with its Databricks SQL product suite, is the hottest lakehouse platform out there, harnessing the power of Apache Spark (TM), Delta Lake, and other innovations to enable data warehousing capabilities on the lakehouse with data lake economics. This book is a comprehensive hands-on guide that helps you explore all the advanced features, use cases, and technology components of Databricks SQL. You'll start with the lakehouse architecture fundamentals and understand how Databricks SQL fits into it. The book then shows you how to use the platform, from exploring data, executing queries, building reports, and using dashboards through to learning the administrative aspects of the lakehouse - data security, governance, and management of the computational power of the lakehouse. You'll also delve into the core technology enablers of Databricks SQL - Delta Lake and Photon. Finally, you'll get hands-on with advanced SQL commands for ingesting data and maintaining the lakehouse. By the end of this book, you'll have mastered Databricks SQL and be able to deploy and deliver fast, scalable business intelligence on the lakehouse. What you will learn Understand how Databricks SQL fits into the Databricks Lakehouse Platform Perform everyday analytics with Databricks SQL Workbench and business intelligence tools Organize and catalog your data assets Program the data security model to protect and govern your data Tune SQL warehouses (computing clusters) for optimal query experience Tune the Delta Lake storage format for maximum query performance Deliver extreme performance with the Photon query execution engine Implement advanced data ingestion patterns with Databricks SQL Who this book is forThis book is for business intelligence practitioners, data warehouse administrators, and data engineers who are new to Databrick SQL and want to learn how to deliver high-quality insights unhindered by the scale of data or infrastructure. This book is also for anyone looking to study the advanced technologies that power Databricks SQL. Basic knowledge of data warehouses, SQL-based analytics, and ETL processes is recommended to effectively learn the concepts introduced in this book and appreciate the innovation behind the platform.

Get well-versed with ready-to-use techniques for creating high-performance queries and applications Key Features Speed up queries and dramatically improve application performance by both understanding query engine internals and practical query optimization Understand how the query optimizer works Learn about intelligent query processing and what is new in SQL Server 2022 Book DescriptionSQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications. This book starts by describing the inner workings of the query optimizer, and will enable you to use this knowledge to write better queries and provide the query engine with all the information it needs to produce efficient execution plans. As you progress, you'll get practical query optimization tips for troubleshooting underperforming queries. The book will also guide you through intelligent query processing and what is new in SQL Server 2022. Query performance topics such as the Query Store, In-Memory OLTP and columnstore indexes are covered as well. By the end of this book, you'll be able to get the best possible performance for your queries and applications. What you will learn Troubleshoot queries using methods including extended events, SQL Trace, and dynamic management views Understand how the execution engine and query operators work Speed up queries and improve app performance by creating the right indexes Detect and fix cardinality estimation errors by examining query optimizer statistics Monitor and promote both plan caching and plan reuse to improve app performance Troubleshoot and improve query performance by using the Query Store Improve the performance of data warehouse queries by using columnstore indexes Handle query processor limitations with hints and other methods Who this book is forThis book is for SQL Server developers who are struggling with slow query execution, database administrators who are tasked with troubleshooting slow application performance, and database architects who design SQL Server databases in support of line-of-business and data warehousing applications.

This report explores digital solutions that can support the core business processes of public health insurance operators in Asia and the Pacific. Examples from low- and middle-income countries in the region and beyond are drawn to demonstrate how digital solutions have improved health insurance management and administration. To support decision-making on potential investments, the report identifies key success factors for integrating new technologies into public health insurance schemes.

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.

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.

This publication outlines key blockchain use cases that demonstrate how digital solutions can be applied to facilitate domestic and cross-border trade in Maldives. The Asian Development Bank is helping Maldives implement a robust domestic and regional trade system under the South Asia Subregional Economic Cooperation program. This integrated trade network facilitates seamless movement of goods and documents, across organizational and national boundaries, and will vastly improve the business environment and overall economic activity. The feasibility study conducted from April to July 2019 established the use cases of blockchain technology that may be ideal in Maldives.

Thorough and updated coverage of database design and SQL for DB2 are the focus of this guide for the relational database-management system used on IBM i computer systems. Suitable for classroom instruction or self-study, this book explains the most widely used database language and the way that language is implemented on a variety of computer platforms. Topics covered include database concepts, SQL inquiries, web applications, and database security, and the material is reinforced by numerous illustrations, examples, and exercises.