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 PostgreSQLwork with PostgreSQL Groupsdescribe the various object-sensitive privileges within PostgreSQLwork with Privilege configurationwork with the command line option (psql)work with the VACUUM commandwork with the PostgreSQL data and configuration files
-
backup PostgreSQL objectsrestore PostgreSQL objectremove database objectswork with scriptswork with reportsWorking with PostgreSQL tables and managing the PostgreSQL RDBMS
IN THIS COURSE
-
1.Roles and Users3m 37sUP NEXT
-
2.Groups9m 10s
-
3.Privileges in PostgreSQL5m 40s
-
4.PostgreSQL privilege in action6m 8s
-
5.Using the Command-Line Prompt5m 47s
-
6.Using the VACUUM options6m 1s
-
7.PostgreSQL data files4m 41s
-
8.Object backup5m
-
9.Object restore5m 14s
-
10.Managing PostgreSQL objects6m 56s
-
11.Scripts5m 44s
-
12.Reports4m 37s
-
13.Exercise: Administrating PostgreSQL and using SELECT5m 47s
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.