Common Functions in PostgreSQL

Table of contents

1. 1. Intro Quiz

   0/7

   How much do you know about SQL?

   List of exercises Start now
   1. Intro Quiz
      1. Introduction
      2. Exercise 1
      3. Exercise 2
      4. Exercise 3
      5. Exercise 4
      6. Exercise 5
      7. Congratulations

2. 2. String Functions

   0/24

   Find out how to manipulate texts in your database.

   List of exercises Start now
   1. Introduction
      1. Introduction
      2. The copywriter table
      3. The slogan table
   2. Concatenation
      1. The concatenation || operator
      2. The CONCAT() function
      3. The || operator vs the CONCAT() function
   3. Simple text functions
      1. The LENGTH() function
      2. Practicing LENGTH()
      3. The LOWER() and UPPER() functions
      4. The INITCAP() function
      5. The LTRIM() and RTRIM() functions
      6. The TRIM() function
   4. Modifying strings
      1. The SUBSTRING() function
      2. The LEFT() and RIGHT() functions
      3. The POSITION() function
      4. The REVERSE() function
      5. The REPLACE() function
      6. The TRANSLATE() function
      7. The REPEAT() function
   5. Summary
      1. Summary
      2. Exercise 1
      3. Exercise 2
      4. Exercise 3
      5. Congratulations!

3. 3. Numeric Functions

   0/27

   Numbers can cause a headache. You need to fight them back!

   List of exercises Buy course
   1. Review
      1. Introduction
      2. The table player
      3. Get to know the character table
      4. First, a quick review
      5. Numeric functions: concatenation
   2. So you think you can count?
      1. Problems with subtraction
      2. Binary arithmetic is not exact
      3. Problems with division
      4. Integer division
      5. Casting values to other types
      6. Division by zero, part one
      7. Division by zero, part two
      8. Getting rid of division by zero
      9. The modulo operator (%)
   3. Rounding functions and more
      1. The ROUND() function
      2. Precision in ROUND()
      3. ROUND() in PostgreSQL – explanation
      4. Rounding up
      5. Rounding down
      6. The TRUNC() function
      7. The ABS() function
   4. Review and practice
      1. Summary
      2. Exercise 1
      3. Exercise 2
      4. Exercise 3
      5. Exercise 4
      6. Congratulations

4. 4. Date and time functions

   0/54

   Learn how to work with date and time data in PostgreSQL

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. The route table
      3. The aircraft table
      4. The flight table
   2. Dealing with dates
      1. Dates in PostgreSQL
      2. The DATE data type
      3. Using comparison operators with dates
      4. Using BETWEEN with dates
      5. Dates with ORDER BY
      6. Dates – exercise
   3. Working with time
      1. Time in SQL
      2. The TIME data type
      3. Using BETWEEN with time data
      4. Comparing dates and times using operators
      5. Sorting by TIME columns
      6. Practice time!
   4. Date and time data types in PostgreSQL
      1. Date and time
      2. Date and time data types in PostgreSQL
      3. Using date and time with constant values
      4. Using operators to compare timestamps
      5. Sorting timestamp data
      6. Practice time!
   5. Extracting dates and times
      1. The DATE_PART() function
      2. DATE_PART() – example
      3. DATE_PART() with the wrong data type
      4. DATE_PART() with the wrong data type – continued
      5. The EXTRACT() function
      6. The DATE_TRUNC() function
      7. The DATE_TRUNC() function – continued
   6. Intervals
      1. Difference between timestamps
      2. Intervals in PostgreSQL
      3. INTERVAL with multiple fields
      4. INTERVAL with constant values
      5. INTERVAL with constant values – continued
      6. Filtering with INTERVALs
      7. Filtering with INTERVALs – practice
      8. The OVERLAPS operator
      9. The AGE() function
      10. The AGE() function – continued
   7. Timezone conversion
      1. AT TIME ZONE
      2. AT TIME ZONE – additional practice
   8. Format date and time
      1. The TO_CHAR() function
      2. The TO_CHAR() function – additional practice
   9. Current date and time data
      1. The CURRENT_TIMESTAMP and NOW() functions
      2. The CURRENT_DATE and CURRENT_TIME functions
      3. Current date and time with intervals – additional practice
   10. Summary
       1. Summary
       2. Exercise 1
       3. Exercise 2
       4. Exercise 3
       5. Exercise 4
       6. Exercise 5
       7. Exercise 6
       8. Congratulations

5. 5. Other Functions

   0/18

   Learn how to successfully work with NULLs.

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. The product table
      3. A quick review of NULLs
   2. The COALESCE() function
      1. The COALESCE() function
      2. Data types in COALESCE()
      3. Using COALESCE() with other functions
      4. Using COALESCE() in calculations
      5. Using COALESCE() with multiple parameters
   3. The GREATEST() & LEAST() functions
      1. The GREATEST() function
      2. The LEAST() function
      3. The GREATEST() and the LEAST() with NULL
   4. The NULLIF() function
      1. The NULLIF() function
      2. Practice NULLIF() – 1
      3. Practice NULLIF() – 2
   5. Summary
      1. Summary
      2. Exercise 1
      3. Exercise 2
      4. Congratulations

6. 6. Final Quiz

   0/13

   Find out how well you remember the contents of this course

   List of exercises Buy course
   1. Final Quiz
      1. Introduction
      2. The person table
      3. Exercise 1
      4. Exercise 2
      5. Exercise 3
      6. Exercise 4
      7. Exercise 5
      8. Exercise 6
      9. Exercise 7
      10. Exercise 8
      11. Exercise 9
      12. Exercise 10
      13. Congratulations

Get the Certificate of Competency in SQL

This certificate will confirm your practical SQL problem-solving skills

Obtain the Certificate Learn more