Introduction to No-SQL Databases
- Created By raju2006
- Last Updated December 26th, 2023
- Overview
- Prerequisites
- Audience
- Audience
- Curriculum
Description:
This course helps you understand and appreciate the evolution of data storage systems and growth of data. Then, it builds on that to describe the various types of non-relational databases that have emerged within the last decade. You get to match real-life usage patterns with No-SQL database types.
Long Description:
This course helps you understand and appreciate the evolution of data storage systems and the growth of data. Then, it builds on that to describe the various types of non-relational databases that have emerged within the last decade. You get to match real life usage patterns with No-SQL database types.
This Introduction to No-SQL Databases course helps in the understanding and success of distributed architecture and options of various non-relational databases. Along the way, you’ll get a background and a secret sauce that makes distributed architecture the way ahead. Demystify the difference between relational and non-relational databases along with usage patterns. You will expand your vocabulary in the No-SQL world to understand types like Document Stores, Graph Database, Column-Oriented Database, Key-value. Finally, we will do several hands-on labs to illustrate capability and patterns such as when to use which type of Datastores.
Course Code/Duration:
BDT57A / 1 Day
Learning Objectives:
After this course, you will be able to:
- Understand the history and evolution of Data Storage systems
- Understand distributed architecture benefits
- Discuss how to identify which kinds of technique to be applied for specific use case
- Hadoop and HDFS
- Compare SQL and No-SQL Databases
- Why No-SQL Databases emerged?
- Understand No-SQL Databases types
- Understand Cloud-Based Data Storage options
- Identify usage patterns for various No-SQL Databases types
- Perform hands-on labs for various No-SQL Databases types
- Basic knowledge of programming preferably Python, Java or Scala
- Basic understanding of Databases
- This course is designed for Software Architects, Developers, Data Engineer, Analyst, Database Administrators, and DevOps teams.
- This course is designed for Software Architects, Developers, Data Engineer, Analyst, Database Administrators, and DevOps teams.
Course Outline:
Course Introduction
Need of Elasticity
- Horizontal versus Vertical scalability
- Parallel Execution
- Fault tolerance
- Economic impact
Cluster and Cloud option
- Cluster
- Cloud options
- AWS, GCP, and Microsoft Azure
Non-relational databases
Evolution of Data Storage
- History of data stores
- OLTP versus OLAP
- Data warehousing concepts
- Data growth and usage patterns
- 5Vs of Big Data
- Hadoop and HDFS
Relational versus non-relational databases
- CAP Theorem
- Comparison of Relational and Non-relational databases
- No-SQL Databases
- No-SQL Databases types
- Document Stores
- Graph Database
- Column-Oriented Database
- Key-value
- Search
Document Stores
- Overview
- Pros and Cons
- Usage patterns
- Examples – MongoDb
- Hands-on Labs
Graph Database
- Overview
- Pros and Cons
- Usage patterns
- Examples – Neo4J
- Hands-on Labs
Key-value Data store
- Overview
- Pros and Cons
- Usage patterns
- Examples – Redis, Dynamo
- Hands-on Labs
Column-Oriented Database
- Overview
- Pros and Cons
- Usage patterns
- Examples – Hbase
- Hands-on Labs
Search
- Overview
- Pros and Cons
- Usage patterns
- Examples – Solr, ELK Stack
- Hands-on Labs
Cloud Data store
- Overview
- Pros and Cons
- Usage patterns
- Examples – S3, AWS Dynamo, Google Cloud SQL, Azure Cosmos Db, Snowflake
- Hands-on Labs
- References and Next steps
Structured Activity/Exercises/Case Studies:
- No-SQL Databases Hands-on
Training material provided:
Yes (Digital format)
