2015
Lynda
Lynn Langit
3:26
English

NoSQL databases can store non-relational data on a super large scale, and can solve problems regular databases can't handle: indexing the entire Internet, predicting subscriber behavior, or targeting ads on a platform as large as Facebook. But with over 150 NoSQL database types, it can be hard for a SQL professional to know where to start. In this course, Lynn Langit breaks these types down into five main categories and shows how to get your own NoSQL database up and running with easy-to-configure cloud solutions. You'll learn how to add and query data and also examine case studies where NoSQL was used to solve real-world data storage management issues. The final chapter contains tips just for startup businesses that are considering their first NoSQL solution.

Introduction
Welcome
Using the exercise files
1. Why Change?
The changing landscape of data
Big data changes
RDBMS challenges
What is a NoSQL database?
2. Is Hadoop NoSQL?
What is Hadoop?
How to get started with Hadoop
Exploring the Cloudera Live environment
Introducing MapReduce
Choosing Hadoop over NoSQL
3. Understanding NoSQL Databases
Understanding NoSQL
The 5 categories of NoSQL databases
Understanding key-value stores
Exploring Redis
Understanding wide-column stores
Exploring HBase
Understanding document databases
Understanding graph databases
Exploring Neo4j
4. NoSQL Options in Microsoft SQL Server 2014
Exploring NoSQL features in SQL Server
Using columnstore indexes
Cloud RDBMS
Exploring a cloud-hosted RDBMS
5. Exploring Cloud-Based NoSQL Databases
Cloud-based files
Exploring cloud-based file storage
Cloud-based Hadoop
Exploring cloud-based Hadoop on Amazon Web Services
Key-value databases, Redis, and DynamoDB
Exploring DynamoDB on Amazon Web Services
Wide-column datastores
Exploring Google's wide-column datastore
Document databases in MongoDB
Exploring MongoDB Labs
Hosted graph databases
Exploring hosted Neo4j
Scaling RDBMS systems in the cloud
Exploring Aurora on Amazon Web Services
MemSQL and BigQuery
Exploring Google BigQuery
Summarizing cloud data offerings
6. Case Studies and Scenarios
Applying NoSQL choices via business scenarios
Working with hardware log files
Storing customer or donor information
Tracking social gaming purchases
Linking museum data
Working with health data
7. Important Tips for Startups
Database selection tips for startups
Considering how data will be input (ingested)
Considering how data will be output (queried)
Exploring tools, community, and support
Conclusion
Next steps

http://www.lynda.com/

Download File Size:488.45 MB

---