NoSQL and SQL
Presentation
•
Computers
•
University
•
Practice Problem
•
Hard
Shiny Verghese
Used 22+ times
FREE Resource
12 Slides • 6 Questions
1
Closer Look at NoSQL
2
Multiple Choice
What does the Acronym NoSQL stand for?
NoSQL
There is no SQL
FInally! Thankfully, no SQL
Hmm..well, I just woke up, no I am not sure
Not SQL
Not Only SQL
3
Difference between SQL and NoSQL
SQL databases are well suited for structured data, complex relationships and transactional systems.
NoSQL databases are well suited for unstructured, big data and real-time analytics applications.
4
5
Multiple Choice
NoSQL database use a fixed table schema and rely on SQL to query the data.
True or False?
TRUE
FALSE
6
Relationships
How do NoSQL Databases handle data relationships?
Instead of using foreign keys, NoSQL databases use embedded documents or denormalized data.
<Show the video: Normalised and de-normalised data Lectures:Database:2023:videos>
7
Source: Datacamp.com
8
Multiple Select
Disadvantages of NoSQL
Data integrity
performance
limited querying capability
scalability
9
Multiple Select
Advantages of NoSQL
Scalability
flexibility
difficulty to handle complex relationships
No clue.
10
11
12
13
14
15
Multiple Choice
Advantage of graph database over a traditional relational database?
Better at handling unstructured data
Better at handling complex relationships between data
faster at performing complex queries
16
Source: Beginnersbook.com
17
Source: crocodillion.com
18
Multiple Choice
Explain the difference between JSON and BSON
JSON: Binary Format
BSON: text-based Format
BSON: Designed to store data in document-oriented database while JSON is not
JSON: data interchange format.
BSON: data storage format
BSON: more efficient format for storing data than JSON
Closer Look at NoSQL
Show answer
Auto Play
Slide 1 / 18
SLIDE
Similar Resources on Wayground
16 questions
Azure Cosmo DB
Presentation
•
University
14 questions
Jaringan Komputer
Presentation
•
12th Grade
13 questions
Communication Networks
Presentation
•
Professional Development
17 questions
Trend Technology
Presentation
•
University
17 questions
basis data
Presentation
•
University
13 questions
Tipos de instrucciones SQL
Presentation
•
Professional Development
17 questions
Las IA's y sus implicaciones en el Turismo
Presentation
•
KG - University
10 questions
Routing Algorithms
Presentation
•
University
Popular Resources on Wayground
24 questions
PBIS-HGMS Day 10
Quiz
•
6th - 8th Grade
10 questions
HCS SCI 03 Summer School Review 3
Quiz
•
3rd Grade
11 questions
Home Scope
Quiz
•
7th - 8th Grade
15 questions
HCS SCI 05 Summer School Assessment 3 Review
Quiz
•
5th Grade
35 questions
Lufkin Road Middle School Student Handbook & Policies Assessment
Quiz
•
7th Grade
18 questions
Geo 11.3 Area of Circles and Sectors
Quiz
•
9th - 11th Grade