Objects & Retrieving Data

PostgreSQL 9.4.5    |    Beginner
  • 12 videos | 1h 27m 57s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 164 users Rating 4.6 of 164 users (164)
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

  • 4m 35s
    In this video, you will outline the PostgreSQL database. FREE ACCESS
  • 6m 20s
    This video will show you how to download and install PostgreSQL. FREE ACCESS
  • Locked
    3.  Working with PostgreSQL Admin Console
    7m 21s
    In this video, you will learn how to login to the Administration Console and connect to the default database. FREE ACCESS
  • Locked
    4.  PostgreSQL Architecture
    9m 19s
    Learn how to work with the components of the PostgreSQL architecture. FREE ACCESS
  • Locked
    5.  PostgreSQL Security
    9m 41s
    Find out how to outline security fundamentals for PostgreSQL objects. FREE ACCESS
  • Locked
    6.  Creating Database objects
    8m 21s
    In this video, you will learn how to create database objects. FREE ACCESS
  • Locked
    7.  Creating Schema objects
    8m 25s
    In this video, you will learn how to create schema objects. FREE ACCESS
  • Locked
    8.  Data types and the PRIMARY KEY constraint
    8m 25s
    In this video, you will learn about the different data types and the PRIMARY KEY constraint. FREE ACCESS
  • Locked
    9.  Creating Tables
    7m 46s
    In this video, you will learn how to create a table. FREE ACCESS
  • Locked
    10.  Adding Data to a Tables
    3m 24s
    In this video, you will learn how to add data to a table. FREE ACCESS
  • Locked
    11.  Retrieving Data #1
    6m 58s
    Learn how to retrieve data from a table. FREE ACCESS
  • Locked
    12.  Retrieving Data #2
    7m 25s
    In this video, find out how to retrieve data using the Query builder tool. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book Getting Started with SQL and Databases: Managing and Manipulating Data with SQL
Book Beginning Database Design Solutions: Understanding and Implementing Database Design Concepts for the Cloud and Beyond, Second Edition
Course CompTIA Data+: Database Concepts
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Security & Administration
Rating 4.6 of 91 users Rating 4.6 of 91 users (91)
Course Connecting a Node.js and Express.js Backend with a PostgreSQL Database
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Course Signing in, creating and opening documents in Word for the Web
Rating 4.8 of 4 users Rating 4.8 of 4 users (4)