Data Retrieval
PostgreSQL 9.4.5
| Beginner
- 11 Videos | 1h 23m 8s
- 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 constraintwork with the FOREIGN KEY - REFERENCES constraintdescribe the more advance options of the SELECT commandwork with the WHERE clausework with the WHERE clausework with the GROUP BY clause
-
Use the DISTINCT optionutilize the ORDER BY clausework with aggregate functions, operators and column labelscreate and work with PostgreSQL Viewscreate 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.