Security & Administration

PostgreSQL 9.4.5    |    Beginner
  • 13 videos | 1h 14m 22s
  • Includes Assessment
  • Earns a Badge
Managing data and users are important tasks for a database administrator. Learn about administrative tasks like securing objects, managing groups, as well as command line management options, scripting, and reporting.

WHAT YOU WILL LEARN

  • Work with object security in postgresql
    Work with postgresql groups
    Describe the various object-sensitive privileges within postgresql
    Work with privilege configuration
    Work with the command line option (psql)
    Work with the vacuum command
    Work with the postgresql data and configuration files
  • Backup postgresql objects
    Restore postgresql object
    Remove database objects
    Work with scripts
    Work with reports
    Working with postgresql tables and managing the postgresql rdbms

IN THIS COURSE

  • 3m 37s
    In this video, you will work with object security in PostgreSQL. FREE ACCESS
  • 9m 10s
    Find out how to work with PostgreSQL groups. FREE ACCESS
  • Locked
    3.  Privileges in PostgreSQL
    5m 40s
    After completing this video, you will be able to describe the various object-sensitive privileges within PostgreSQL. FREE ACCESS
  • Locked
    4.  PostgreSQL privilege in action
    6m 8s
    Learn how to configure Privilege. FREE ACCESS
  • Locked
    5.  Using the Command-Line Prompt
    5m 47s
  • Locked
    6.  Using the VACUUM options
    6m 1s
    Find out how to work with the VACUUM command. FREE ACCESS
  • Locked
    7.  PostgreSQL data files
    4m 41s
    In this video, you will work with PostgreSQL data and configuration files. FREE ACCESS
  • Locked
    8.  Object backup
    5m
    In this video, find out how to backup PostgreSQL databases. FREE ACCESS
  • Locked
    9.  Object restore
    5m 14s
    During this video, you will learn how to restore PostgreSQL objects. FREE ACCESS
  • Locked
    10.  Managing PostgreSQL objects
    6m 56s
    During this video, you will learn how to delete database objects. FREE ACCESS
  • Locked
    11.  Scripts
    5m 44s
    Learn how to work with scripts. FREE ACCESS
  • Locked
    12.  Reports
    4m 37s
    Learn how to work with reports. FREE ACCESS
  • Locked
    13.  Exercise: Administrating PostgreSQL and using SELECT
    5m 47s
    In this video, find out how to work with PostgreSQL tables and manage the PostgreSQL RDBMS. 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.