Objects & Retrieving Data
PostgreSQL 9.4.5
12 Videos | 1h 33m 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 product
download and install PostgreSQL
login to the Administration Console and connect to the default database
work with the components of the PostgreSQL architecture
outline security fundamentals for PostgreSQL objects
create database objects -
create schema objects
define the various data types and understand the PRIMARY KEY constraint
create a table
add data to a table
retrieve data from tables
retrieve 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.
