We may earn an affiliate commission when you visit our partners.
Gerald Britton, Ami Levin, and Jason Browning, Ph.D.

SQL (“sequel” or Structured Query Language) is a common language used to query and manage data in relational database and data stream management systems. This skill will teach you how to use SQL to query data from the PostgreSQL relational database.

Read more

SQL (“sequel” or Structured Query Language) is a common language used to query and manage data in relational database and data stream management systems. This skill will teach you how to use SQL to query data from the PostgreSQL relational database.

What You'll Learn

  • Querying data with the SELECT statement
  • Filtering data with the WHERE clause
  • Combining data with JOINs
  • Aggregating data
  • Inserting, updating, and deleting data
  • Enroll now

    Share

    Help others find this collection page by sharing it with your friends and followers:

    What's inside

    Five courses

    Querying Data from PostgreSQL

    (1 hours)
    In this course, you'll learn the basics of querying data from PostgreSQL, a popular open-source database platform. You'll learn how to select data from tables, apply criteria and filters to limit your results, and retrieve data from multiple tables. By the end of this course, you'll have the skills and knowledge of PostgreSQL necessary to easily retrieve data from relational databases.

    Combining and Filtering Data with PostgreSQL 9

    (1 hours)
    This course teaches how to use PostgreSQL to filter and combine data. Using SQL, you’ll learn how to join data from multiple tables, combine result sets, and use aggregate and window functions.

    PostgreSQL Data Manipulation Playbook

    (2 hours)
    Data modifications are critical for application design. This course covers challenges associated with multi-user data access and the tools that PostgreSQL provides to tackle them, so you can avoid data consistency issues.

    PostgreSQL Functions Playbook

    (2 hours)
    Most programming languages come with built-in functions, and SQL is no exception. This course teaches you about the ANSI SQL functions and operators implemented by PostgreSQL and a good portion of those unique to this popular system.

    Capturing Logic with Custom Functions in PostgreSQL

    (1 hours)
    Whether you are new to PostgreSQL or an experienced developer, this course will teach you how to build custom functions in PostgreSQL. You will learn how to move from a basic query to a fully-parameterized function, write functions using PL/pgSQL, and explore important matters relating to polymorphism, security, defensive programming, and error handling.

    Save this collection

    Save Querying Data with SQL from PostgreSQL to your list so you can find it easily later:
    Save
    Our mission

    OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

    Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

    Find this site helpful? Tell a friend about us.

    Affiliate disclosure

    We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

    Your purchases help us maintain our catalog and keep our servers humming without ads.

    Thank you for supporting OpenCourser.

    © 2016 - 2024 OpenCourser