Understanding Databases
With chapters selected by David Clinton
  • September 2019
  • ISBN 9781617297663
  • 50 pages
Understanding Databases
With chapters selected by David Clinton
In this big data era—when businesses, healthcare organizations, the financial sector, social media, etc. are all taking advantage of the insights they gain from data—the volume of data being gathered is growing at an unprecedented rate. Managing all this data requires powerful databases, and choosing the right one is vital.
Table of Contents detailed table of contents

Managing databases

4.1 Configuring database options

4.2 Detaching and attaching databases

4.3 Assessing database storage

4.4 Identifying potential performance concerns in storage

4.4.1 Problems with file layout

4.4.2 Problems with file size

4.4.3 Filegroups

4.5 System databases

4.6 An overview of storage hardware

4.7 Hands-on lab

Databases on AWS

4.1 The database

4.2 Choosing the right database model

4.2.1 Relational databases

4.2.2 NoSQL databases

4.2.3 How to choose

4.3 Infrastructure design: where does your database belong?

4.4 Estimating costs

4.5 Migrating your database to RDS

4.5.1 Creating a MySQL dump

4.6 Building an Amazon RDS instance

4.7 Configuring security group settings

4.8 Populating the new database

4.9 Lab

NoSQL: It’s about making intelligent choices

1.1 What is NoSQL?

1.2 NoSQL business drivers

1.2.1 Volume

1.2.2 Velocity

1.2.3 Variability

1.2.4 Agility

1.3 NoSQL case studies

1.3.1 Case study: LiveJournal’s Memcache

1.3.2 Case study: Google’s MapReduce—​use commodity hardware to create search indexes

1.3.3 Case study: Google’s Bigtable—​a table with a billion rows and a million columns

1.3.4 Case study: Amazon’s Dynamo—​accept an order 24 hours a day, 7 days a week

1.3.5 Case study: MarkLogic

1.3.6 Applying your knowledge

Summary

About the book

To help you understand the capabilities and limitations of the different kinds of databases available, David Clinton—technology guru, teacher, and author—has chosen chapters from three Manning books to create this free mini ebook, Understanding Databases. In it, you’ll learn about database configuration, how to assess database storage, and how and why to move or copy your database. As you look at relational databases and infrastructure design, you’ll also discover the factors to consider when choosing your database architecture and explore illuminating real-world case studies that shine a light on NoSQL databases and the elements that drive NoSQL business solutions. This on-point guide is a great way to start learning about databases, how to use them, and how to choose the right one for your tasks.

What's inside

  • “Managing databases” from Learn SQL Server Administration in a Month of Lunches by Don Jones
  • “Databases on AWS” from Learn Amazon Web Services in a Month of Lunches by David Clinton
  • “NoSQL: It’s about making intelligent choices” from Making Sense of NoSQL by Daniel G. McCreary and Ann M. Kelly

About the author

David Clinton is a system administrator, teacher, and writer. He has administered, written about, and created training materials for many important technology subjects including Linux systems, cloud computing (AWS in particular), and container technologies like Docker. Many of his video training courses can be found on Pluralsight.com, and links to his other books (on Linux administration and server virtualization) can be found at https://bootstrap-it.com.

eBook $0.00 PDF only
Prices displayed in rupees will be charged in USD when you check out.

placing your order...

Don't refresh or navigate away from the page.

FREE domestic shipping on three or more pBooks