Search

Become well-versed with database modeling and SQL optimization, and gain a deep understanding of transactional systems through practical examples and exercisesKey FeaturesGet to grips with fundamental-to-advanced database design and modeling concepts with PostgreSQL and MySQLExplore database integration with web apps, emerging trends, and real-world case studiesLeverage practical examples and hands-on exercises to reinforce learningPurchase of the print or Kindle book includes a free PDF eBookBook DescriptionDatabase Design and Modeling with PostgreSQL and MySQL will equip you with the knowledge and skills you need to architect, build, and optimize efficient databases using two of the most popular open-source platforms. As you progress through the chapters, you'll gain a deep understanding of data modeling, normalization, and query optimization, supported by hands-on exercises and real-world case studies that will reinforce your learning. You'll explore topics like concurrency control, backup and recovery strategies, and seamless integration with web and mobile applications. These advanced topics will empower you to tackle complex database challenges confidently and effectively. Additionally, you'll explore emerging trends, such as NoSQL databases and cloud-based solutions, ensuring you're well-versed in the latest developments shaping the database landscape. By embracing these cutting-edge technologies, you'll be prepared to adapt and innovate in today's ever-evolving digital world. By the end of this book, you'll be able to understand the technologies that exist to design a modern and scalable database for developing web applications using MySQL and PostgreSQL open-source databases.What you will learnDesign a schema, create ERDs, and apply normalization techniquesGain knowledge of installing, configuring, and managing MySQL and PostgreSQLExplore topics such as denormalization, index optimization, transaction management, and concurrency controlScale databases with sharding, replication, and load balancing, as well as implement backup and recovery strategiesIntegrate databases with web apps, use SQL, and implement best practicesExplore emerging trends, including NoSQL databases and cloud databases, while understanding the impact of AI and MLWho this book is forThis book is for a wide range of professionals interested in expanding their knowledge and skills in database design and modeling with PostgreSQL and MySQL. This includes software developers, database administrators, data analysts, IT professionals, and students. While prior knowledge of MySQL and PostgreSQL is not necessary, some familiarity with at least one relational database management system (RDBMS) will help you get the most out of this book.

Analyze and transform data efficiently with DuckDB, a versatile, modern, in-process SQL databaseKey FeaturesUse DuckDB to rapidly load, transform, and query data across a range of sources and formatsGain practical experience using SQL, Python, and R to effectively analyze dataLearn how open source tools and cloud services in the broader data ecosystem complement DuckDB's versatile capabilitiesPurchase of the print or Kindle book includes a free PDF eBookBook DescriptionDuckDB is a fast in-process analytical database. Getting Started with DuckDB offers a practical overview of its usage. You'll learn to load, transform, and query various data formats, including CSV, JSON, and Parquet. The book covers DuckDB's optimizations, SQL enhancements, and extensions for specialized applications. Working with examples in SQL, Python, and R, you'll explore analyzing public datasets and discover tools enhancing DuckDB workflows. This guide suits both experienced and new data practitioners, quickly equipping you to apply DuckDB's capabilities in analytical projects. You'll gain proficiency in using DuckDB for diverse tasks, enabling effective integration into your data workflows.What you will learnUnderstand the properties and applications of a columnar in-process databaseUse SQL to load, transform, and query a range of data formatsDiscover DuckDB's rich extensions and learn how to apply themUse nested data types to model semi-structured data and extract and model JSON dataIntegrate DuckDB into your Python and R analytical workflowsEffectively leverage DuckDB's convenient SQL enhancementsExplore the wider ecosystem and pathways for building DuckDB-powered data applicationsWho this book is forIf you're interested in expanding your analytical toolkit, this book is for you. It will be particularly valuable for data analysts wanting to rapidly explore and query complex data, data and software engineers looking for a lean and versatile data processing tool, along with data scientists needing a scalable data manipulation library that integrates seamlessly with Python and R. You will get the most from this book if you have some familiarity with SQL and foundational database concepts, as well as exposure to a programming language such as Python or R.

Get hands-on with deploying and managing your database services to provide scalable and high-speed data access on CockroachDBKey FeaturesGain insights into CockroachDB and build highly reliable cloud-native applicationsExplore the power of a scalable and highly available cloud-native SQL database to distribute data and workloads automaticallyBuild high-speed database services using CockroachDB and troubleshoot performance issuesBook DescriptionGetting Started with CockroachDB will introduce you to the inner workings of CockroachDB and help you to understand how it provides faster access to distributed data through a SQL interface. The book will also uncover how you can use the database to provide solutions where the data is highly available.Starting with CockroachDB's installation, setup, and configuration, this SQL book will familiarize you with the database architecture and database design principles. You'll then discover several options that CockroachDB provides to store multiple copies of your data to ensure fast data access. The book covers the internals of CockroachDB, how to deploy and manage it on the cloud, performance tuning to get the best out of CockroachDB, and how to scale data across continents and serve it locally. In addition to this, you'll get to grips with fault tolerance and auto-rebalancing, how indexes work, and the CockroachDB Admin UI. The book will guide you in building scalable cloud services on top of CockroachDB, covering administrative and security aspects and tips for troubleshooting, performance enhancements, and a brief guideline on migrating from traditional databases.By the end of this book, you'll have gained sufficient knowledge to manage your data on CockroachDB and interact with it from your application layer.What you will learnBecome well-versed with the overall architecture and design concepts of CockroachDBUnderstand how auto-rebalancing of data can avoid performance bottlenecksGet to know how CockroachDB achieves atomicity, consistency, isolation, and durabilityPartition your data across multiple geolocations to ensure very low latency when serving dataFind out how indexes are stored and the optimizations used to serve query results fasterDiscover the key concepts of deploying and managing CockroachDB clustersWho this book is forSoftware engineers, database developers, database administrators, and anyone who wishes to learn about the features of CockroachDB and how to build database solutions that are fast, highly available, and cater to business-critical applications, will find this book useful. Although no prior exposure to CockroachDB is required, familiarity with database concepts will help you to get the most out of this book.