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.

Become well versed with all of ShardingSphere's features for every data management need with this comprehensive guide put together by ShardingSphere's founder and core contributors Key Features Understand the core concepts and efficiently set up Apache ShardingSphere Enhance existing databases with sharding, elastic scaling, encryption, governance features, and more Import and customize the ecosystem's core features for various application scenarios Book DescriptionApache ShardingSphere is a new open source ecosystem for distributed data infrastructures based on pluggability and cloud-native principles that helps enhance your database. This book begins with a quick overview of the main challenges faced by database management systems (DBMSs) in production environments, followed by a brief introduction to the software's kernel concept. After that, using real-world examples of distributed database solutions, elastic scaling, DistSQL, synthetic monitoring, database gateways, and SQL authority and user authentication, you'll fully understand ShardingSphere's architectural components, how they're configured and can be plugged into your existing infrastructure, and how to manage your data and applications. You'll also explore ShardingSphere-JDBC and ShardingSphere-Proxy, the ecosystem's clients, and how they can work either concurrently or independently to address your needs. You'll then learn how to customize the plugin platform to define personalized user strategies and manage multiple configurations seamlessly. Finally, the book enables you to get up and running with functional and performance tests for all scenarios. By the end of this book, you'll be able to build and deploy a customized version of ShardingSphere, addressing the key pain points encountered in your data management infrastructure. What you will learn Assemble a custom solution using the software's pluggable architecture Discover how to use Database Plus features effectively Understand the difference between ShardingSphere-JDBC and ShardingSphere-Proxy Get to grips with ShardingSphere's pluggability mechanism Explore mainstream test models for databases and distributed databases Perform migrations from an on-premise database to a cloud-based database Reconfigure your data infrastructure and eliminate switching costs Who this book is forThis book is for database administrators working with distributed database solutions who are looking to explore the capabilities of Apache ShardingSphere. DBAs looking for more capable, flexible, and cost-effective alternatives to the solutions they're currently utilizing will also find this book helpful. To get started with this book, a basic understanding of, or even an interest in, databases, relational databases, SQL languages, cloud computing, and data management in general is needed.

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.

A hands-on implementation guide to application development in Node.js using the powerful Sequelize ORM Key Features Use the highly powerful JavaScript library to map your database to objects easily Build an application from scratch with easy-to-follow steps and examples Discover industry best practices, tips, and techniques on Sequelize to manage your database with ease Book DescriptionContinuous changes in business requirements can make it difficult for programmers to organize business logic into database models, which turns out to be an expensive operation as changes to the database may result in errors and incongruity within applications. Supercharging Node.js Applications with Sequelize helps you get to grips with Sequelize, a reliable ORM that enables you to alleviate these issues in your database and applications. With Sequelize, you'll no longer need to store information in flat files or memory. This book takes a hands-on approach to implementation and associated methodologies for your database that will have you up and running in no time. You'll learn how to configure Sequelize for your Node.js application properly, develop a better sense of understanding of how this ORM works, and find out how to manage your database from Node.js using Sequelize. Finally, you'll be able to use Sequelize as the database driver for building your application from scratch. By the end of this Node.js book, you'll be able to configure, build, store, retrieve, validate, and associate your data from a database to a Node.js application. What you will learn Configure and optimize Sequelize for your application Validate your database and hydrate it with data Add life cycle events (or hooks) to your application for business logic Organize and ensure the integrity of your data even on preexisting databases Scaffold a database using built-in Sequelize features and tools Discover industry-based best practices, tips, and techniques to simplify your application development Who this book is forThis book is for beginner- to intermediate-level Node.js developers looking to upgrade their skills and use Sequelize as their ORM of choice. Basic knowledge of and prior experience with JavaScript and SQL are needed to make the most out of this book.

This report illustrates why Southeast Asian countries need big data for recovery from COVID-19 to radically transform the delivery of key services such as health care, social protection, and education. The final of a four-part series, it looks at the impact of the pandemic on Cambodia, Thailand, Indonesia, Myanmar, and the Philippines to determine how big data can help governments analyze the challenges they face. It outlines policy reforms and recommendations to help capture the benefits of big data, including drawing up digital roadmaps, improving technical infrastructure, and ramping up training to create a skilled workforce to lead the digital transformation.

This edition provides analysis of tax systems and their administration in 38 economies across the region as a resource for revenue bodies seeking to boost fiscal capacity weakened by the pandemic. Topics covered include features of an effective tax reform strategy, the use of innovative technologies, taxing the digital economy, and international cooperation to help crack down on tax loopholes. The publication enables revenue bodies to benchmark their administration against similar economies in the region to help improve performance. The comparable data and analysis are based largely on the 2020 round of the International Survey on Revenue Administration.

This report identifies and examines six key technologies that are transforming fundamental financial market infrastructure and will serve as a springboard for the technological advancement of financial market infrastructure in the region. This report ascertains the most current status of technology adoption by Cross-Border Settlement Infrastructure Forum member organizations. They include central securities depositories and central banks in the Association of Southeast Asian Nations (ASEAN) plus the People's Republic of China, Japan, and the Republic of Korea (collectively known as ASEAN+3) region.

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.

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.

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.

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.