Data Retrieval

PostgreSQL 9.4.5
  • 11 Videos | 1h 27m 38s
  • Includes Assessment
  • Earns a Badge
Likes 10 Likes 10
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

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 72 Likes 72  
CHANNEL PostgreSQL
Likes 36 Likes 36  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 45 Likes 45  
Likes 72 Likes 72  
Likes 1176 Likes 1176