Loading...

Data Analytics

785 learners

Mastering SQL Functions and Clauses

Take your SQL expertise to the next level by harnessing the power of SQL functions. Using data from an online shopping platform, this course delves into advanced SQL functions and clauses, helping you summarize, count, and differentiate data to gain deeper insights into shopping datasets.

MySQL

See path

5 lessons

25 practices

2 hours

Data Analysis for Insights

Course details

Mastering the COUNT Function

Preview

Counting Rows in SQL

Counting Conditioned Rows in Orders Table

Fix the SQL Query

Counting Rows in a Table

Counting Selected Customer Orders

Previous Course

Next Course: Advanced Query Techniques and Conditional Logic in SQL

Meet Cosmo:

The smartest AI guide in the universe

Our built-in AI guide and tutor, Cosmo, prompts you with challenges that are built just for you and unblocks you when you get stuck.

From our community

Hear what our customers have to say about CodeSignal Learn

I'm impressed by the quality and can't stop recommending it. It's also a lot of fun!

Francisco Aguilar Meléndez

Data Scientist

+11

I love that it's personalized. When I'm stuck, I don't have to hope my Google searches come out successful. The AI mentor Cosmo knows exactly what I need.

Faith Yim

Software Engineer

+14

It's an amazing product and exceeded my expectations, helping me prepare for my job interviews. Hands-on learning requires you to actually know what you are doing.