Data Retrieval
PostgreSQL 9.4.5
11 Videos | 1h 27m 38s - Includes Assessment
- Earns a Badge
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
-
1.Foreign Key Constraint7m 31sUP NEXT
-
2.Using FOREIGN KEYS8m 36s
-
3.The SELECT command9m 51s
-
4.The WHERE clause #17m 27s
-
5.The WHERE clause #26m 33s
-
6.The GROUP BY clause9m 33s
-
7.The DISTINCT option5m 17s
-
8.The ORDER BY Clause7m 20s
-
9.SELECT item functions5m 45s
-
10.Working with Views6m 24s
-
11.Working with Indexes8m 51s
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.
