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,100 courses taught by industry experts.
Introduction to SQL
From the course: Complete Guide to Generative AI for Data Analysis and Data Science
Introduction to SQL
- [Instructor] We're going to look at SQL and how we use SQL in data analytics. So basically SQL is a language for manipulating data and structures in relational databases. This is going to be our core tool when we're working with relational databases. Now, I should say SQL is part of relational databases. So if you're working with a relational database, you're going to have access to SQL. SQL has also grown outside of relational databases in the sense that non relational databases may also use SQL. And actually maybe what I should say is non relational data stores. So there are data stores that use object storage in the cloud, which is a different type of mechanism. It doesn't have all of the properties of relational databases like asset transactions and things like that. But there are times where you can use SQL to manipulate data or query data in these different types of data stores. So if you're working with a relational database, you will have access to SQL. If you're working…
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
-
-
-
-
-
-
-
-
-