Common PostgreSQL Functions | Online Course

What you get?

Fully interactive online courses. Just you, SQL, Python, R and the web browser.

Instant access to lessons. You decide when and how long you want to learn.

Hundreds of SQL, Python, R exercises to master Your skills.

Course completion certificate to show the world that you really can!

Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Good job! You've learned how to handle NULLs and more!

In the next part, you're going to review everything you've learned as it will be The Final Quiz!

Next exercise

18/18 Congratulations

1. Introduction

2. The product table

3. A quick review of NULLs

4. The COALESCE() function

5. Data types in COALESCE()

6. Using COALESCE() with other functions

7. Using COALESCE() in calculations

8. Using COALESCE() with multiple parameters

9. The GREATEST() function

10. The LEAST() function

11. The GREATEST() and the LEAST() with NULL

12. The NULLIF() function

13. Practice NULLIF() – 1

14. Practice NULLIF() – 2

Wow, excellent work! That was a piece of cake for you 🙂

You've learned some useful new PostgreSQL functions. We hope you enjoyed working with Mr. Adams and his company. See you in the next part!

Click Next exercise to finish this part.

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.

Instruction

Exercise

Need assistance?

login:
password:
Remember me on this computer

Recipient's Name:
Recipient's Email:
Your Message (Optional):

Create a free accountand start learning now!

What you get?

Sign upand join a company account!

Log in

Your registration has been successfully finished

Wrap course as a gift

Common Functions in PostgreSQL

Great job!

Instruction

Exercise

Need assistance?