Data Retrieval

PostgreSQL 9.4.5    |    Beginner
  • 11 videos | 1h 23m 8s
  • Includes Assessment
  • Earns a Badge
Likes 28 Likes 28
Make your data work for you. Learn to ensure data integrity using constraints and analyze data using the SELECT command and WHERE, GROUP BY, DISTINCT, and ORDER BY clauses. And explore how to speed up searches using indexes and views.

WHAT YOU WILL LEARN

  • describe the FOREIGN KEY - REFERENCES constraint
    work with the FOREIGN KEY - REFERENCES constraint
    describe the more advance options of the SELECT command
    work with the WHERE clause
    work with the WHERE clause
    work with the GROUP BY clause
  • Use the DISTINCT option
    utilize the ORDER BY clause
    work with aggregate functions, operators and column labels
    create and work with PostgreSQL Views
    create and work with table Indexes

IN THIS COURSE

  • 7m 31s
    Upon completion of this video, you will be able to describe the FOREIGN KEY REFERENCES constraint. FREE ACCESS
  • 8m 36s
    In this video, you will work with the FOREIGN KEY REFERENCES constraint. FREE ACCESS
  • Locked
    3.  The SELECT command
    9m 51s
    Upon completion of this video, you will be able to describe the more advanced options of the SELECT command. FREE ACCESS
  • Locked
    4.  The WHERE clause #1
    7m 27s
    Learn how to work with the WHERE clause. FREE ACCESS
  • Locked
    5.  The WHERE clause #2
    6m 33s
    In this video, learn how to use the WHERE clause. FREE ACCESS
  • Locked
    6.  The GROUP BY clause
    9m 33s
    Find out how to work with the GROUP BY clause. FREE ACCESS
  • Locked
    7.  The DISTINCT option
    5m 17s
    During this video, you will learn how to use the DISTINCT option. FREE ACCESS
  • Locked
    8.  The ORDER BY Clause
    7m 20s
    In this video, learn how to use the ORDER BY clause. FREE ACCESS
  • Locked
    9.  SELECT item functions
    5m 45s
    In this video, you will learn how to work with aggregate functions, operators, and column labels. FREE ACCESS
  • Locked
    10.  Working with Views
    6m 24s
    In this video, you will create and work with PostgreSQL views. FREE ACCESS
  • Locked
    11.  Working with Indexes
    8m 51s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Channel PostgreSQL
Likes 72 Likes 72  
Course Database Fundamentals: Getting Started with SQL
Course Getting Started with Snowflake: Queries, Dashboards, & Tables

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course DDL, DML, & Constraints
Likes 24 Likes 24  
Course Java SE 11: Flow Control & Debugging
Likes 278 Likes 278  
Course SQL Programming with MariaDB: Getting Started with MariaDB for Data Analysis
Likes 23 Likes 23