PostgreSQL: Client Applications

Focused View

Adam Wilbert

2:34:40

0 View

[1] Introduction

[1] Work with PostgreSQL on the command line.mp4

01:05

[2] What you should know.mp4

00:23

[3] Use the exercise files.mp4

00:37

[2] 1. Set Up Your PostgreSQL Toolset

[1] What are PostgreSQL client applications.mp4

04:26

[2] Locate client applications on Windows.mp4

02:25

[3] Locate client applications on macOS.mp4

05:44

[4] Set environment variables on Windows.mp4

04:15

[5] Set path on macOS.mp4

03:56

[6] Create a PostgreSQL server.mp4

06:37

[3] 2. Using the Psql Interactive Terminal

[1] Connect to a PostgreSQL server.mp4

07:11

[2] Create a database.mp4

03:20

[3] Execute SQL commands.mp4

07:01

[4] Backslash (meta) commands.mp4

04:06

[5] Get help with SQL command keywords.mp4

05:36

[6] Execute commands from a file.mp4

02:43

[7] List database contents.mp4

07:39

[8] Describe object configuration.mp4

02:29

[9] Challenge Obtain database information.mp4

01:14

[10] Solution Obtain database information.mp4

04:52

[4] 3. Customize the Psql Environment

[1] Streamline password submission.mp4

08:01

[2] Change the prompt style.mp4

06:36

[3] Save custom environment settings.mp4

03:54

[5] 4. Input and Output Options

[1] Input queries from the command line.mp4

02:52

[2] Format aligned text output.mp4

05:15

[3] Output results to external files.mp4

05:30

[4] Save query results to .csv.mp4

03:28

[5] Output HTML and LaTeX tables.mp4

03:20

[6] Export files from the command line.mp4

01:48

[7] Challenge Export a data table.mp4

00:50

[8] Solution Export a data table.mp4

06:00

[6] 5. Backup and Restore a PostgreSQL Database

[1] Create backups with pg dump.mp4

04:09

[2] Configure backup options.mp4

03:36

[3] Data-only and schema-only backups.mp4

03:10

[4] Create a backup of a single table.mp4

02:51

[5] Restoring plain-text backups.mp4

02:38

[6] Custom archive backup files.mp4

03:45

[7] Restoring database archives with pg restore.mp4

04:21

[8] Partial database restores.mp4

05:53

[7] Conclusion

[1] Next steps.mp4

01:04

Description

PostgreSQL is one of the most popular open-source database management systems. In this course, Adam Wilbert introduces you to the command line tools used in professional PostgreSQL database administration. These tools are used for remote management of the server and provide detailed insight into the configuration and operation of the server. Adam starts by locating or installing the tools, then explores the operation of the main utility, psql. Psql provides a wide array of configurable options that can be combined to create flexible workflows for sending SQL commands to the server, or for exporting query results to external files. Adam finishes the course with a detailed look at the command line utilities used to create and restore database backups.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

PostgreSQL

Adam Wilbert

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.