Querying SQL Databases: Using Generative AI Tools to Filter & Group Data

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. 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.