Objects & Retrieving Data
PostgreSQL 9.4.5
| Beginner
- 12 Videos | 1h 27m 57s
- Includes Assessment
- Earns a Badge
PostgreSQL is an open-source DBMS that supports most SQL constructs. Learn about downloading, installing and configuring the PostgreSQL RDBMS, as well as creating a database, using database objects, and retrieving data.
WHAT YOU WILL LEARN
-
outline the PostgreSQL productdownload and install PostgreSQLlogin to the Administration Console and connect to the default databasework with the components of the PostgreSQL architectureoutline security fundamentals for PostgreSQL objectscreate database objects
-
create schema objectsdefine the various data types and understand the PRIMARY KEY constraintcreate a tableadd data to a tableretrieve data from tablesretrieve data using the Query builder tool
IN THIS COURSE
-
1.What is PostgreSQL?4m 35sUP NEXT
-
2.Downloading and Installing6m 20s
-
3.Working with PostgreSQL Admin Console7m 21s
-
4.PostgreSQL Architecture9m 19s
-
5.PostgreSQL Security9m 41s
-
6.Creating Database objects8m 21s
-
7.Creating Schema objects8m 25s
-
8.Data types and the PRIMARY KEY constraint8m 25s
-
9.Creating Tables7m 46s
-
10.Adding Data to a Tables3m 24s
-
11.Retrieving Data #16m 58s
-
12.Retrieving Data #27m 25s
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.