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

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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SQL Developer
Likes 285 Likes 285  
Likes 2989 Likes 2989  
Likes 24 Likes 24