Learn how to write your own functions in Postgres with this 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

12/15 Function testing

1. The log table

2. Create a logging function

3. Test the logging function

4. The dim_customer table

5. The stg_customer table

6. Implement the ETL process

7. Test the implementation

8. The newsletter table

9. The subscription table

10. Create a function

11. Function overloading

12. Function testing

13. Mailing list function

14. Executing mailing list function

15. Congratulations

Well done! Let's quickly test the new overloaded function opt_in_out().

Using the opt_in_out() functions:

Subscribe the customer with ID of 4 to all existing newsletters.
Subscribe the customer with ID of 6 to the newsletter with ID of 1.

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

Writing User-Defined Functions in PostgreSQL

Instruction

Exercise

Need assistance?