SQL 101 Crash Course is a comprehensive beginner's guide that takes you through the world of SQL, right from understanding databases to mastering complex queries. This book is designed to provide you with a solid foundation in SQL, along with practical examples and real-world scenarios to reinforce your learning.

In this book, you'll explore the key concepts of databases and their structure while getting started with SQLite Studio, a versatile SQL tool. You'll dive deep into the fundamentals of SQL queries, turning raw data into meaningful information, and working with tables, multiple tables, and their relationships.

You'll also learn how to harness the power of SQL functions and subqueries to optimize your queries and retrieve data more efficiently. As you progress, you'll delve into the world of views, joins, and advanced SQL topics such as transactions, stored procedures, and performance tuning. The book concludes with two sample databases, where you'll put your newfound knowledge to the test and gain hands-on experience.

This book promises a smooth learning journey for aspiring SQL developers, enabling them to build robust and efficient databases. The book's step-by-step approach ensures that even complete beginners can grasp complex concepts with ease. By the end of this book, you'll emerge as a smart SQL developer, equipped with the skills and knowledge to tackle real-world database challenges.

Key Learnings

• Master SQL fundamentals and best practices.
• Learn to create, modify, and optimize tables.
• Understand and implement table relationships.
• Execute complex queries with ease and confidence.
• Leverage SQL functions for powerful data manipulation.
• Utilize subqueries and derived tables effectively.
• Create and manage views for enhanced data access.
• Apply advanced SQL techniques for optimized performance.
• Hands-on experience with real-world sample databases.
• Begin your journey as a skilled SQL developer.

Table of Content

1. Introduction to Databases and SQL
2. Setting Up Your SQL Environment
3. SQL Queries Basics
4. Turning Data into Information
5. Working with Tables
6. Multiple Tables and Joins
7. SQL Functions
8. Subqueries and Derived Tables
9. Views and Materialized Views
10. Advanced SQL Topics
11. Sample Programs & Executing SQL

Audience

This book requires no prior knowledge to get started, making it an ideal read for those looking to pursue careers in database administration, business analytics, or business intelligence. Its accessibility ensures that an unwavering passion for learning SQL is all you need to effortlessly progress through the book's content.

This book is for DBAs and devs who are eager to dive into the world of modern database operations with MySQL 9. With clear-cut instructions and step-by-step demonstrations, you'll be up and running in no time. You'll learn to install MySQL 9 on Linux, upgrade existing systems, and even migrate data from other platforms like PostgreSQL.

Every chapter covers a key part of database administration, like deploying and scaling instances, setting up replication for high availability, and optimizing query performance through smart indexing, buffer tuning, and performance analysis using tools like MySQL Workbench. It's got real-life scenarios to help you understand how to manage transactions, balance isolation levels, and resolve conflicts so your data stays accurate and reliable, even under heavy loads. It also shows you how to secure your MySQL environment through strong authentication, role-based access control, and encryption techniques.

On top of that, you'll learn how to maintain your database through automated workflows, scheduled events, and integration with external tools like Google Spreadsheets and AWS S3. Overall, this book builds strong confidence and competency to deploy, manage, and optimize your MySQL environment for future heavy-data demanding applications.

Key Learnings

• Learn ins and outs of setting up MySQL 9 with step-by-step instructions.
• Prepare for MySQL 9 with ease by upgrading and migrating legacy databases.
• Set up high availability with multiple master-slave configurations, replication, and failover to make it resilient.
• Use efficient indexing, CTEs, window functions, and query profiling techniques to optimize query performance.
• Exact adjustments to isolation levels, savepoints, rollbacks, and commits for careful transaction management.
• Implement strong authentication, role-based access control, and use advanced encryption methods.
• Create partitioning, normalization, and efficient data integrity constraints schemas for scalability.
• Use shell scripts, scheduled events, and third-party integration to automate routine tasks.
• Perform ongoing system performance monitoring with MySQL Workbench and Performance Schema.
• Quickly fix issues with configuration and replication to keep database running smoothly.

Table of Content

1. Getting Started with MySQL 9
2. Upgrade and Modernize Environment
3. Migrate from Other Systems
4. Deploy and Scale MySQL Instances
5. Secure the Application
6. Establish High Availability and Replication
7. Queries Performance and Optimization
8. Master Data Management and Routine Maintenance
9. Leverage Advanced SQL and Transaction Control
10. Troubleshoot and Improve Continuously
11. Automate Database Workflows

PostgreSQL 17 QuickStart Pro is the definitive hands-on, practical book for professionals at every level, from entry-level administrators to seasoned experts. It provides rapid learning and practical implementation of PostgreSQL 17, focusing on the latest features and best practices to effectively manage, configure, and optimize PostgreSQL databases—and it does so effectively.

The book begins by using the Titanic dataset to illustrate practical examples of upgrade strategies, post-upgrade validation, and database configuration. Next, it covers cluster administration, configuration settings, and performance tracking. You will master the management of permissions and roles through intricate role hierarchies, authentication methods, and security settings. Next, we'll optimize server performance, plan queries, and manage resources based on real performance data.

The next section dives deep into complicated data types, bulk data operations, advanced indexing methods, and the creation of triggers and functions, all with an emphasis on effective data management. Next, you will learn about table partitioning strategies, performing physical and logical backups, database restoration, and process automation using BART. We then move on to streaming replication, where we will configure, administer, and monitor replication to ensure optimal uptime. Finally, we will explore point-in-time recovery (PITR), which allows us to restore databases to specific points in time by replaying WAL logs. In short, this book will equip database administrators with the knowledge and skills to confidently handle PostgreSQL 17 databases.

Key Learnings

• Upgrade and configure PostgreSQL 17, including post-upgrade validation and configuration.
• Learn PostgreSQL architecture, memory models, and cluster management.
• Use hierarchical permissions, authentication, and security for advanced role management.
• Tune server performance with query planning, resource management, and configuration tuning.
• Effectively use PostgreSQL extensions, JSONB, and arrays.
• Optimize queries with GIN, GiST, and BRIN indexing.
• Master table partitioning for large dataset performance and scalability.
• Automate physical and logical backups and confidently restore databases.
• Manage PostgreSQL streaming replication for high availability and automatic failover.
• Restore data using WAL logs and Point-in-Time Recovery.

Table of Content

1. Upgrading and Setting up PostgreSQL 17
2. Expert Database Cluster Administration
3. Advanced Database and Role Management
4. Configuration and Performance Tuning
5. Effective Data Management
6. Table Partitioning Strategies
7. Backup and Recovery Best Practices
8. Streaming Replication and High Availability
9. Point-in-Time Recovery