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.

YOU MIGHT ALSO LIKE

Channel Oracle Database 12c: RAC and Grid Infrastructure Administration
Course Database Fundamentals: Getting Started with SQL
Channel Cybersecurity

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course MySQL: Triggers & Stored Procedures
Course User Management
Book PostgreSQL Configuration: Best Practices for Performance and Security