Back-To-School Deals - hours only!Up to 80% off on all courses and bundles.-Close

Introduce yourself to the standard SQL functions used in data processing. This course shows you how to use SQL to work with the following data types:

  • Text
  • Numeric
  • Date and time
  • And more
 

You’ll also learn about:

  • Dealing with NULLs in SQL functions
  • SQL aggregate functions
 

You’ll also examine the CASE WHEN expression – a powerful SQL construction that facilitates conditional computations. Finally, the SQL reporting exercises explain how to work with computing ratios and percentages.

Note: This course uses examples written in standard SQL, but not all databases comply with the SQL standard. Some minor modifications may be needed. If that’s the case, we’ll let you know in the exercise instructions. Also, many databases offer non-standard functions that do the same thing as these standard functions. We don’t cover non-standard syntax in this course; your database documentation is a good place to learn about any non-standard syntax.

What Do You Need to Take This Course?

  • A web browser and an Internet connection
  • Some understanding of SQL, such as the concepts presented in our SQL Basics course

This Course Will Teach You How To:

  • Utilize common SQL text functions
  • Identify and use standard SQL numeric functions
  • Select and implement SQL date and time functions
  • Work with NULLs in standard SQL functions
  • Understand SQL aggregate functions
 

Plus, you’ll get to practice your skills on 211 interactive exercises.

Who Should Take This Course?

  • Anyone who wants to learn about standard SQL functions
  • Beginning database analysts
  • Beginning developers
  • Students taking classes in relational databases
  • Business database users who want to improve their skills

 

The material in Standard SQL Functions is intended for intermediate users. To complete this course, you’ll need to know:

  • How to select from a single table, including writing complex WHERE conditions
  • How to JOIN tables
  • How GROUP BY and HAVING work

 

This course is not about user-defined functions. If you're looking for a course about user-defined functions, see the Writing User-Defined Functions in PostgreSQL course.

    Start for free
    Gift this course

    Bundle deals

    87%
    off

    Reg. price
    $1551

    One to Rule 'Em All

    Includes 41 courses Python Basics. Part 1, Python Basics. Part 2, Python Basics. Part 3, Python Data Structures in Practice, Built-in Algorithms in Python, Working with Strings in Python, SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Basic SQL Reports, Window Functions, Revenue Trend Analysis in SQL, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, Introduction to R, Tidyverse, Data Visualization 101, Statistics 101, SQL Basics in MS SQL Server, How to Insert, Update, or Delete Data in MS SQL Server, Common Functions in MS SQL Server, Revenue Trend Analysis in SQL Server, Creating Basic SQL Reports in SQL Server, Window Functions in MS SQL Server, Recursive Queries in MS SQL Server, GROUP BY Extensions in MS SQL Server, How to Read and Write CSV Files in Python, Introduction to Python for Data Science, How to Read and Write JSON Files in Python, Lists and Functions in R, Data Manipulation in R, Creating Basic SQL Reports in PostgreSQL, SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS

    Bundle price $199

    37 hours left at this price!

    73%
    off

    Reg. price
    $359

    SQL Complete Track

    Includes 9 courses SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Window Functions, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, PostGIS

    Bundle price $95

    37 hours left at this price!

    68%
    off

    Reg. price
    $143

    SQL Advanced Kit

    Includes 3 courses Standard SQL Functions, Window Functions, Recursive Queries

    Bundle price $45

    37 hours left at this price!

    66%
    off

    Reg. price
    $193

    SQL First Aid

    Includes 5 courses SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Tables in SQL

    Bundle price $65

    37 hours left at this price!

    Table of contents

    Progress: 0% completed 0 of 211 exercises done

    1. Intro Quiz

    In this course we assume that you know the basics of SQL: you know how to select information from a single table, you know how to join queries and group by query results. Take the test to find out if you know SQL well enough to follow the course.

    More details Less
    Start now

    0% completed 0 of 7 exercises done

    2. Pretty Printing

    Learn the basic SQL text functions to transform text values and make your reports look pretty.

    More details Less
    Start now

    0% completed 0 of 22 exercises done

    3. Numeric functions

    Master numeric functions in SQL. Learn about the caveats of mathematical operators in SQL, various rounding functions in SQL and computing proportions in SQL.

    More details Less
    Start now

    0% completed 0 of 28 exercises done

    4. Date and time functions

    Study date and time functions and learn how to select events from a period of time.

    More details Less
    Start now

    0% completed 0 of 46 exercises done

    5. Nulls

    NULLs are tricky. Learn how to avoid common mistakes with NULL and what SQL functions there are to deal with NULL.

    More details Less
    Start now

    0% completed 0 of 30 exercises done

    6. Aggregate functions

    Deepen your understanding of SQL aggregate functions: COUNT, AVG and SUM. Practice which variant of COUNT or AVG to choose in typical use cases.

    More details Less
    Start now

    0% completed 0 of 37 exercises done

    7. CASE WHEN

    Learn how to include conditions in your SQL queries. Practice computing simple summary reports.

    More details Less
    Start now

    0% completed 0 of 29 exercises done

    8. Final Quiz

    Check the knowledge of SQL functions in the quiz.

    More details Less
    Start now

    0% completed 0 of 12 exercises done

    Reviews

    Average rating

    4.8/596.0 (20)

    Details

    5 Stars 90%
    4 Stars 0%
    3 Stars 10%
    2 Stars 0%
    1 Stars 0%
      Load more reviews

      Comments

      0