GROUP BY and HAVING - DataEng Lab

Skip to content

Learn
Labs
Certificate
Blog
Community
Blog
Discover insights, tutorials & practical tips
Forum
Ask questions, share ideas, grow together
Contribute
Publish content and give back to the community

Learn
Labs
Certificate
Blog
Community
Blog
Discover insights, tutorials & practical tips
Forum
Ask questions, share ideas, grow together
Contribute
Publish content and give back to the community

Basic SQL for Data Engineers GROUP BY and HAVING

Basic SQL for Data Engineers

0% Completed

SQL Fundamentals & Data Types

What is a relational database: tables, rows, PKs, FKs, NULLs

Data types: text, numeric, boolean, date/time

SELECT statement

Basic arithmetic, string functions

CRUD & Data Modification

SQL Queries Types

CREATE TABLE, DROP, and ALTER

INSERT new data into tables

UPDATE and DELETE with safe filtering

Transactions: BEGIN, COMMIT, ROLLBACK

Constraints: NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY

Filtering & Sorting

WHERE conditions: IN, BETWEEN, LIKE, IS NULL

Logical operators: AND, OR, NOT

ORDER BY, LIMIT, OFFSET

Dealing with NULLs in filters

Aggregations & Grouping

Aggregate functions: COUNT, SUM, AVG, MIN, MAX

GROUP BY and HAVING

Combining aggregates with filters

NULLs and GROUP BY edge cases

Multi-Table Queries & Joins

INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN

Self-joins and CROSS JOIN

Anti-joins / semi-joins: NOT EXISTS, EXISTS

Best practices for multi-table queries

Window Functions & Analytics

PARTITION BY and ORDER BY in window context

ROW_NUMBER, RANK, DENSE_RANK, NTILE

LAG, LEAD, FIRST_VALUE, LAST_VALUE

Running totals and moving averages

Mini Project

Wrap-Up

SQL Best Practices for Data Engineers

What’s Next? (Advanced SQL, Data Warehouses, dbt)

Announcements Reviews Course Info

About

About DataEng Lab

Legal & Accessibility

Support

FAQs
Support

Linkedin Github

© 2026 DataEng Lab

Manage Consent

To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.

Functional Functional Always active

The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.

Preferences Preferences

The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.

Statistics Statistics

The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.

Marketing Marketing

The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.

Manage options
Manage services
Manage {vendor_count} vendors
Read more about these purposes

View preferences

{title}
{title}
{title}