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
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
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 20s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 8m 43s
    During this video, you will learn how to upload data from a file to MySQL. FREE ACCESS
  • Locked
    3.  Using ChatGPT to Filter Rows Using the WHERE Clause
    9m 39s
    In this video, find out how to filter rows using the WHERE clause. FREE ACCESS
  • Locked
    4.  Using Different Conditional Clauses for Filtering
    12m 21s
    Discover how to use different conditional clauses. FREE ACCESS
  • Locked
    5.  Using the LIKE and IN Keywords for Filtering
    10m 50s
    Learn how to filter data with the LIKE and IN keywords. FREE ACCESS
  • Locked
    6.  Using Prompt Engineering for Subquery Operations
    10m 30s
    During this video, discover how to view data with subqueries. FREE ACCESS
  • Locked
    7.  Configuring Foreign Key Constraints
    9m 20s
    In this video, you will learn how to work with foreign key constraints. FREE ACCESS
  • Locked
    8.  Setting up ON DELETE CASCADE with ChatGPT's Help
    8m 36s
    Find out how to set up foreign keys with cascading deletes. FREE ACCESS
  • Locked
    9.  Using Bard to Perform Numeric Aggregations on Data
    10m 47s
    In this video, discover how to perform numeric aggregations. FREE ACCESS
  • Locked
    10.  Executing String Functions and Math Operations
    7m 17s
    During this video, you will learn how to use NOT NULL constraints in structured query language (SQL). FREE ACCESS
  • Locked
    11.  Computing Aggregations on Grouped Data
    10m 10s
    In this video, find out how to group data and perform aggregations. FREE ACCESS
  • Locked
    12.  Using the HAVING Clause to Filter Grouped Results
    11m 29s
    Discover how to filter grouped results using the HAVING clause. FREE ACCESS
  • Locked
    13.  Writing Complex Grouping and Aggregation Queries Using Bard
    9m 55s
    During this video, you will learn how to perform complex groupby and aggregation operations. FREE ACCESS
  • Locked
    14.  Course Summary
    2m 32s
    In 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.

YOU MIGHT ALSO LIKE

Course Querying SQL Databases: Learning SQL Using Prompt Engineering
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Course CompTIA Data+: Query Optimization
Rating 5.0 of 4 users Rating 5.0 of 4 users (4)
Book Querying MySQL: Make your MySQL Database Analytics Accessible with SQL Operations, Data extraction, and Custom Queries

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Querying SQL Databases: Prompt Engineering to Work with Advanced SQL Operations
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)
Course Leading in the Age of Generative AI
Rating 4.8 of 27 users Rating 4.8 of 27 users (27)
Course Getting Started with Power Query in Power BI
Rating 4.6 of 14 users Rating 4.6 of 14 users (14)