The Database section covers how to design, query and run databases, relational and NoSQL alike. The guides explain the ideas behind a schema as well as the SQL that uses it, with examples for MySQL, PostgreSQL and SQL Server.
Designing a schema? Begin with constraints and validation rules, which keep bad data out of your tables. For NoSQL, data modelling for schema-less designs and consistency models explain the trade-offs that work differently from SQL. Other guides range from counting NULL and NOT NULL values in a column to what MySQL, PostgreSQL and SQL Server each offer, and from column-family stores to backups.
Preparing for an interview? SQL tricky interview questions works through the questions interviewers use to test SQL. Running a database in production? See backup and recovery strategies for relational databases before you need them.
Explore the concept of serverless databases and discover how they're transforming database management in the cloud. Learn about automatic scaling, pay-as-you-go pricing, and the advantages of this innovative approach to handling data.
Learn about the variety of managed database services offered by leading cloud providers such as AWS, Azure, and GCP. Understand the features, scalability, and flexibility of different solutions to choose the right service for your needs.
Dive into the essential security features and compliance considerations of cloud database solutions. Explore encryption, authentication, monitoring, regulatory requirements, and more to understand how to safeguard data and adhere to legal standards.
Explore the key concepts of scalability and elasticity in cloud databases. Understand how these attributes allow cloud databases to adapt to fluctuating demands, providing flexible and cost-effective solutions for diverse workloads.
Explore key strategies for migrating existing databases to the cloud, including assessment, planning, execution, and post-migration management. Learn how to ensure a successful and seamless transition to cloud databases.
Selecting the right cloud database for your application requires careful consideration. This guide outlines how to assess your needs and evaluate options, helping you choose the best cloud database service for your specific requirements.
Explore the essentials of cloud databases, including their types, benefits, and applications. Understand how cloud-based databases offer scalability, cost-effectiveness, security, and more.