Data Retrieval

PostgreSQL 9.4.5    |    Beginner
  • 11 videos | 1h 23m 8s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 79 users Rating 4.7 of 79 users (79)
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

Course Queries in Snowflake: Search Optimization, External Table Partitions, & Views
Rating 4.6 of 43 users Rating 4.6 of 43 users (43)
Course CompTIA Data+: Database Concepts
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)
Book Getting Started with SQL and Databases: Managing and Manipulating Data with SQL

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course DDL, DML, & Constraints
Rating 4.6 of 100 users Rating 4.6 of 100 users (100)
Course Microsoft Azure Administrator: Monitoring
Rating 4.6 of 36 users Rating 4.6 of 36 users (36)
Course Hadoop & MapReduce Getting Started
Rating 4.7 of 54 users Rating 4.7 of 54 users (54)