Querying SQL Databases: Using Generative AI Tools to Filter & Group Data
Prompt Engineering, SQL
| Intermediate
- 14 videos | 2h 4m 29s
- Includes Assessment
- Earns a Badge
In structured query language (SQL), filtering and grouping are fundamental operations that enable precise control and analysis of data. Begin this course by filtering your data using SQL queries. You will learn how to use the WHERE clause with comparison and logical operators to create predicates and how to use the LIKE and IN keywords for filtering. Then you will discover how to read data from a CSV file into a MySQL table using the MySQL workbench. Next, you will work with subqueries to help execute queries using data from multiple tables and you will explore foreign-key constraints to maintain referential integrity. You will examine grouping and aggregation of your data, including simple numeric aggregations like COUNT, SUM, and AVG. Finally, you will perform basic string manipulation and math operations on table columns, divide your data by categorical columns and perform aggregations for each category, and filter the results of grouped and aggregated tables.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in this course
Upload data from a file to mysql
Filter rows using the where clause
Use different conditional clauses
Filter data with the like and in keywords
View data with subqueries
Work with foreign key constraints -
Set up foreign keys with cascading deletes
Perform numeric aggregations
Use not null constraints in structured query language (sql)
Group data and perform aggregations
Filter grouped results using the having clause
Perform complex groupby and aggregation operations
Summarize the key concepts covered in this course
IN THIS COURSE
-
2m 20sIn this video, we will discover the key concepts covered in this course. FREE ACCESS
-
8m 43sDuring this video, you will learn how to upload data from a file to MySQL. FREE ACCESS
-
3. Using ChatGPT to Filter Rows Using the WHERE Clause9m 39sIn this video, find out how to filter rows using the WHERE clause. FREE ACCESS
-
4. Using Different Conditional Clauses for Filtering12m 21sDiscover how to use different conditional clauses. FREE ACCESS
-
5. Using the LIKE and IN Keywords for Filtering10m 50sLearn how to filter data with the LIKE and IN keywords. FREE ACCESS
-
6. Using Prompt Engineering for Subquery Operations10m 30sDuring this video, discover how to view data with subqueries. FREE ACCESS
-
7. Configuring Foreign Key Constraints9m 20sIn this video, you will learn how to work with foreign key constraints. FREE ACCESS
-
8. Setting up ON DELETE CASCADE with ChatGPT's Help8m 36sFind out how to set up foreign keys with cascading deletes. FREE ACCESS
-
9. Using Bard to Perform Numeric Aggregations on Data10m 47sIn this video, discover how to perform numeric aggregations. FREE ACCESS
-
10. Executing String Functions and Math Operations7m 17sDuring this video, you will learn how to use NOT NULL constraints in structured query language (SQL). FREE ACCESS
-
11. Computing Aggregations on Grouped Data10m 10sIn this video, find out how to group data and perform aggregations. FREE ACCESS
-
12. Using the HAVING Clause to Filter Grouped Results11m 29sDiscover how to filter grouped results using the HAVING clause. FREE ACCESS
-
13. Writing Complex Grouping and Aggregation Queries Using Bard9m 55sDuring this video, you will learn how to perform complex groupby and aggregation operations. FREE ACCESS
-
14. Course Summary2m 32sIn this video, we will summarize the key concepts covered in this course. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
