From the course: Complete Guide to Generative AI for Data Analysis and Data Science
Unlock the full course today
Join today to access over 24,800 courses taught by industry experts.
NoSQL databases
From the course: Complete Guide to Generative AI for Data Analysis and Data Science
NoSQL databases
- [Instructor] NoSQL databases are an alternative to relational databases when we're working in data analytics. Now, some key characteristics of NoSQL databases are that they employ flexible schemas with a variety of data models. So now with relational databases, we define the structure of what the tables will look like, what tables will we have, and what columns they will have, and a number of other characteristics of tables. We define those before we put data into the database. With NoSQL database, we can figure out the structure of the data as the data is coming in. So we have this ability to be flexible. Now, another feature of NoSQL databases is that they are horizontally scalable. Now what that means is we can create a relational database and implement it on a cluster or a set of servers that all work together. And if we need more sort of horsepower, we can add more servers to our cluster. So what we're doing is just adding more servers to the set of servers that are doing the…
Contents
-
-
-
-
-
-
-
-
-
-
-
-
-
Relational databases15m 15s
-
(Locked)
NoSQL databases10m 21s
-
(Locked)
Extraction, transformation, and loading data into databases5m 46s
-
(Locked)
Introduction to SQL5m 45s
-
(Locked)
Creating tables and inserting data8m 2s
-
(Locked)
Querying data with SQL10m 28s
-
(Locked)
Joining data with SQL6m 57s
-
(Locked)
Descriptiive statistics in SQL4m 55s
-
(Locked)
Generating synthetic data sets for a relational database7m 12s
-
(Locked)
Generating a star schema, synthetic data, and queries3m 41s
-
(Locked)
Challenge: Generate a relational data model1m 12s
-
(Locked)
Solution: Generate a relational data model4m 32s
-
-
-
-
-
-
-
-
-