Loading...

Data Analytics

332 learners

Mastering SQL Functions and Clauses with PostgreSQL

Take your SQL skills further by exploring PostgreSQL’s powerful functions and rich features. This course is ideal for those who know SQL basics and are ready to enhance data analysis and reporting. Learn to count, summarize, and identify unique data with PostgreSQL’s advanced capabilities.

PostgreSQL

See path

5 lessons

25 practices

2 hours

Data Analysis for Insights

Course details

Using the COUNT Function for Quantitative Analysis

Preview

Counting Rows in a Table

Counting Marvel Movies by Phase

Count Characters for a Specific Movie

Counting Popular Characters

Counting Marvel Characters by Actor

Previous Course

Next Course: Advanced Query Techniques and Conditional Logic in PostgreSQL

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.