Objects & Retrieving Data

PostgreSQL 9.4.5
  • 12 Videos | 1h 33m 57s
  • Includes Assessment
  • Earns a Badge
Likes 48 Likes 48
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

  • Playable
    1. 
    What is PostgreSQL?
    4m 35s
    UP NEXT
  • Playable
    2. 
    Downloading and Installing
    6m 20s
  • Locked
    3. 
    Working with PostgreSQL Admin Console
    7m 21s
  • Locked
    4. 
    PostgreSQL Architecture
    9m 19s
  • Locked
    5. 
    PostgreSQL Security
    9m 41s
  • Locked
    6. 
    Creating Database objects
    8m 21s
  • Locked
    7. 
    Creating Schema objects
    8m 25s
  • Locked
    8. 
    Data types and the PRIMARY KEY constraint
    8m 25s
  • Locked
    9. 
    Creating Tables
    7m 46s
  • Locked
    10. 
    Adding Data to a Tables
    3m 24s
  • Locked
    11. 
    Retrieving Data #1
    6m 58s
  • Locked
    12. 
    Retrieving Data #2
    7m 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.

YOU MIGHT ALSO LIKE

Likes 27 Likes 27  
Likes 214 Likes 214  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 13 Likes 13  
Likes 10 Likes 10  
Likes 244 Likes 244