SkillGild
PostgreSQL 14 Administration
Back to Dashboard

Hey there, great course, right? Do you like this course?

All of the most interesting lessons further. In order to continue you just need to purchase it

Enroll course

Course sections

Section 1
First Steps
1
PSQL - Introducing PostgreSQL 14
2
PSQL - How to get PostgreSQL
3
PSQL - Connecting to the PostgreSQL server
4
PSQL - Connecting to the PostgreSQL server
5
PSQL - Enabling access for network/remote users
6
PSQL - Enabling access for network/remote users
7
PSQL - Using the pgAdmin4 GUI tool
8
PSQL - Using the pgAdmin4 GUI tool
9
PSQL - Using the OmniDB GUI tool
10
PSQL - Using the psql query and scripting tool
11
PSQL - Using the psql query and scripting tool
12
PSQL - Changing your password securely
13
PSQL - Changing your password securely
14
PSQL - Avoiding hardcoding your password
15
PSQL - Avoiding hardcoding your password
16
PSQL - Using a connection service file
17
PSQL - Using a connection service file
18
PSQL - Troubleshooting a failed connection
19
PSQL - Troubleshooting a failed connection
20
PSQL - PostgreSQL in the cloud
21
PSQL - PostgreSQL in the cloud
Section 2
Exploring the Database
1
PSQL - What type of server is this?
2
PSQL - What version is the server?
3
PSQL - What is the server uptime?
4
PSQL - Locating the database server files
5
PSQL - Locating the database server's message log
6
PSQL - Locating the database's system identifier
7
PSQL - Listing databases on the database server
8
PSQL - How many tables are there in a database?
9
PSQL - How much disk space does a database use?
10
PSQL - How much disk space does a table use?
11
PSQL - Which are my biggest tables?
12
PSQL - How many rows are there in a table?
13
PSQL - Quickly estimating the number of rows in a table
14
PSQL - Listing extensions in this database
15
PSQL - Understanding object dependencies
Section 3
Exploring the Database
1
PSQL - What type of server is this?
2
PSQL - What version is the server?
3
PSQL - What is the server uptime?
4
PSQL - Locating the database server files
5
PSQL - Locating the database server's message log
6
PSQL - Locating the database's system identifier
7
PSQL - Listing databases on the database server
8
PSQL - How many tables are there in a database?
9
PSQL - How much disk space does a database use?
10
PSQL - How much disk space does a table use?
11
PSQL - Which are my biggest tables?
12
PSQL - How many rows are there in a table?
13
PSQL - Quickly estimating the number of rows in a table
14
PSQL - Listing extensions in this database
15
PSQL - Understanding object dependencies
Section 4
Server Configuration
1
PSQL - RTFM
2
PSQL - Planning a new database
3
PSQL - Setting configuration parameters for the database server
4
PSQL - Setting configuration parameters in your programs
5
PSQL - Finding the configuration settings for your session
6
PSQL - Finding parameters with non-default settings
7
PSQL - Setting parameters for particular groups of users
8
PSQL - A basic server configuration checklist
9
PSQL - Adding an external module to PostgreSQL
10
PSQL - Using an installed module/extension
11
PSQL - Managing installed extensions
Section 5
Server Configuration
1
PSQL - RTFM
2
PSQL - Planning a new database
3
PSQL - Setting configuration parameters for the database server
4
PSQL - Setting configuration parameters in your programs
5
PSQL - Finding the configuration settings for your session
6
PSQL - Finding parameters with non-default settings
7
PSQL - Setting parameters for particular groups of users
8
PSQL - A basic server configuration checklist
9
PSQL - Adding an external module to PostgreSQL
10
PSQL - Using an installed module/extension
11
PSQL - Managing installed extensions
Section 6
Security
1
PSQL - Overview of PostgreSQL security
2
PSQL - Overview of PostgreSQL security
3
PSQL - The PostgreSQL superuser
4
PSQL - The PostgreSQL superuser
5
PSQL - Revoking user access to a table
6
PSQL - Revoking user access to a table
7
PSQL - Granting user access to a table
8
PSQL - Granting user access to specific columns
9
PSQL - Granting user access to specific rows
10
PSQL - Creating a new user
11
PSQL - Temporarily preventing a user from connecting
12
PSQL - Removing a user without dropping their data
13
PSQL - Removing a user without dropping their data
14
PSQL - Checking whether all users have a secure password
15
PSQL - Checking whether all users have a secure password
16
PSQL - Giving limited superuser powers to specific users
17
PSQL - Giving limited superuser powers to specific users
18
PSQL - Auditing database access
19
PSQL - Auditing database access
20
PSQL - Integrating with LDAP
21
PSQL - Always knowing which user is logged in
22
PSQL - Using SSL certificates to authenticate
23
PSQL - Connecting using encryption (SSL/GSSAPI)
24
PSQL - Mapping external usernames to database roles
25
PSQL - Using SSL certificates to authenticate
26
PSQL - Using column-level encryption
27
PSQL - Mapping external usernames to database roles
28
PSQL - Using column-level encryption
29
PSQL - Setting up cloud security using predefined roles
Section 7
Server Control
1
PSQL - Overview of controlling the database server
2
PSQL - Starting the database server manually
3
PSQL - Starting the database server manually
4
PSQL - Stopping the server safely and quickly
5
PSQL - Stopping the server safely and quickly
6
PSQL - Stopping the server in an emergency
7
PSQL - Reloading the server configuration files
8
PSQL - Restarting the server quickly
9
PSQL - Restarting the server quickly
10
PSQL - Preventing new connections
11
PSQL - Restricting users to only one session each
12
PSQL - Pushing users off the system
13
PSQL - Pushing users off the system
14
PSQL - Using multiple schemas
15
PSQL - Deciding on a design for multitenancy
16
PSQL - Giving users their own private databases
17
PSQL - Using multiple schemas
18
PSQL - Running multiple servers on one system
19
PSQL - Giving users their own private databases
20
PSQL - Setting up a connection pool
21
PSQL - Running multiple servers on one system
22
PSQL - Accessing multiple servers using the same host and port
23
PSQL - Setting up a connection pool
24
PSQL - Accessing multiple servers using the same host and port
Section 8
Database Administration
1
PSQL - Writing a script that either succeeds entirely or fails entirely
2
PSQL - Writing a psql script that exits on the first error
3
PSQL - Using psql variables
4
PSQL - Placing query output into psql variables
5
PSQL - Writing a conditional psql script
6
PSQL- Investigating a psql error
7
PSQL - Setting the psql prompt with useful information
8
PSQL - Using pgAdmin for DBA tasks
9
PSQL - Scheduling jobs for regular background execution
10
PSQL - Performing actions on many tables
11
PSQL - Adding/removing columns on a table
12
PSQL - Changing the data type of a column
13
PSQL - Changing the definition of an enum data type
14
PSQL - Adding a constraint concurrently
15
PSQL - Adding/removing schemas
16
PSQL - Moving objects between schemas
17
PSQL - Adding/removing tablespaces
18
PSQL - Moving objects between tablespaces
19
PSQL - Accessing objects in other PostgreSQL databases
20
PSQL - Accessing objects in other foreign databases
21
PSQL - Making views updatable
22
PSQL- Using GENERATED data columns
23
PSQL - Using data compression
Section 9
Tables and Data
1
PSQL - Choosing good names for database objects
2
PSQL - Choosing good names for database objects
3
PSQL - Handling objects with quoted names
4
PSQL - Handling objects with quoted names
5
PSQL - Enforcing the same name and definition for columns
6
PSQL - Enforcing the same name and definition for columns
7
PSQL - Identifying and removing duplicates
8
PSQL - Identifying and removing duplicates
9
PSQL - Preventing duplicate rows
10
PSQL - Preventing duplicate rows
11
PSQL - Finding a unique key for a set of data
12
PSQL - Finding a unique key for a set of data
13
PSQL - Generating test data
14
PSQL - Generating test data
15
PSQL - Randomly sampling data
16
PSQL - Randomly sampling data
17
PSQL - Loading data from a spreadsheet
18
PSQL - Loading data from a spreadsheet
19
PSQL - Loading data from flat files
20
PSQL - Making bulk data changes using server-side procedures with transactions
21
PSQL - Making bulk data changes using server-side procedures with transactions
Section 10
Monitoring and Diagnosis
1
PSQL - Overview of PostgreSQL monitoring
2
PSQL - Overview of PostgreSQL monitoring
3
PSQL - Cloud-native monitoring
4
PSQL - Cloud-native monitoring
5
PSQL - Providing PostgreSQL information to monitoring tools
6
PSQL - Providing PostgreSQL information to monitoring tools
7
PSQL - Real-time viewing using pgAdmin
8
PSQL - Checking whether a user is connected
9
PSQL- Checking whether a computer is connected
10
PSQL - Repeatedly executing a query in psql
11
PSQL - Repeatedly executing a query in psql
12
PSQL - Checking which queries are running
13
PSQL - Checking which queries are running
14
PSQL - Monitoring the progress of commands
15
PSQL - Monitoring the progress of commands
16
PSQL - Knowing who is blocking a query
17
PSQL - Checking which queries are active or blocked
18
PSQL - Killing a specific session
19
PSQL - Knowing who is blocking a query
20
PSQL - Detecting an in-doubt prepared transaction
21
PSQL - Killing a specific session
22
PSQL - Knowing whether anybody is using a specific table
23
PSQL - Detecting an in-doubt prepared transaction
24
PSQL - Usage of disk space by temporary data
25
PSQL - Knowing whether anybody is using a specific table
26
PSQL - Analyzing the real-time performance of your queries
27
PSQL - Knowing when a table was last used
28
PSQL - Investigating and reporting a bug
29
PSQL - Understanding why queries slow down
30
PSQL - Analyzing the real-time performance of your queries
31
PSQL - Investigating and reporting a bug
Section 11
Database Administration
1
PSQL - Writing a script that either succeeds entirely or fails entirely
2
PSQL - Writing a psql script that exits on the first error
3
PSQL - Using psql variables
4
PSQL - Placing query output into psql variables
5
PSQL - Writing a conditional psql script
6
PSQL- Investigating a psql error
7
PSQL - Setting the psql prompt with useful information
8
PSQL - Using pgAdmin for DBA tasks
9
PSQL - Scheduling jobs for regular background execution
10
PSQL - Performing actions on many tables
11
PSQL - Adding/removing columns on a table
12
PSQL - Changing the data type of a column
13
PSQL - Changing the definition of an enum data type
14
PSQL - Adding a constraint concurrently
15
PSQL - Adding/removing schemas
16
PSQL - Moving objects between schemas
17
PSQL - Adding/removing tablespaces
18
PSQL - Moving objects between tablespaces
19
PSQL - Accessing objects in other PostgreSQL databases
20
PSQL - Accessing objects in other foreign databases
21
PSQL - Making views updatable
22
PSQL- Using GENERATED data columns
23
PSQL - Using data compression
Section 12
Performance and Concurrency
1
PSQL - Finding slow SQL statements
2
PSQL - Finding slow SQL statements
3
PSQL - Finding out what makes SQL slow
4
PSQL - Finding out what makes SQL slow
5
PSQL - Reducing the number of rows returned
6
PSQL - Reducing the number of rows returned
7
PSQL - Simplifying complex SQL queries
8
PSQL - Speeding up queries without rewriting them
9
PSQL - Speeding up queries without rewriting them
10
PSQL - Discovering why a query is not using an index
11
PSQL - Discovering why a query is not using an index
12
PSQL - Using parallel query
13
PSQL - Forcing a query to use an index
14
PSQL - Creating time-series tables using partitioning
15
PSQL - Creating time-series tables using partitioning
16
PSQL - Using optimistic locking to avoid long lock waits
17
PSQL - Using optimistic locking to avoid long lock waits
18
PSQL - Reporting performance problems
Section 13
Regular Maintenance
1
PSQL - Controlling automatic database maintenance
2
PSQL - Controlling automatic database maintenance
3
PSQL - Avoiding auto-freezing and page corruptions
4
PSQL - Removing issues that cause bloat
5
PSQL - Removing old prepared transactions
6
PSQL - Actions for heavy users of temporary tables
7
PSQL - Actions for heavy users of temporary tables
8
PSQL - Identifying and fixing bloated tables and indexes
9
PSQL - Identifying and fixing bloated tables and indexes
10
PSQL - Monitoring and tuning a vacuum
11
PSQL - Monitoring and tuning a vacuum
12
PSQL - Maintaining indexes
13
PSQL - Maintaining indexes
14
PSQL - Finding unused indexes
15
PSQL - Finding unused indexes
16
PSQL - Carefully removing unwanted indexes
17
PSQL - Carefully removing unwanted indexes
18
PSQL - Planning maintenance
19
PSQL - Planning maintenance
Section 14
Replication and Upgrades
1
PSQL - Replication concepts
2
PSQL - Replication concepts
3
PSQL - Replication best practices
4
PSQL - Replication best practices
5
PSQL - Setting up streaming replication
6
PSQL - Setting up streaming replication
7
PSQL - Setting up streaming replication security
8
PSQL - Setting up streaming replication security
9
PSQL - Hot Standby and read scalability
10
PSQL - Hot Standby and read scalability
11
PSQL - Managing streaming replication
12
PSQL - Managing streaming replication
13
PSQL - Using repmgr
14
PSQL - Using replication slots
15
PSQL - Using replication slots
16
PSQL - Monitoring replication
17
PSQL - Monitoring replication
18
PSQL - Performance and sync rep
19
PSQL - Performance and sync rep
20
PSQL - Delaying, pausing, and synchronizing replication
21
PSQL - Delaying, pausing, and synchronizing replication
22
PSQL - BDR
23
PSQL - Logical replication
24
PSQL - Archiving transaction log data
25
PSQL - BDR
26
PSQL - Upgrading minor releases
27
PSQL - Archiving transaction log data
28
PSQL - Major upgrades in-place
29
PSQL - Major upgrades in-place
30
PSQL - Major upgrades online
Section 15
Backup and Recovery
1
PSQL - Understanding and controlling crash recovery
2
PSQL - Understanding and controlling crash recovery
3
PSQL - Planning your backups
4
PSQL - Planning your backups
5
PSQL - Hot logical backups of one database
6
PSQL - Hot logical backups of one database
7
PSQL - Hot logical backups of all databases
8
PSQL - Hot logical backups of all databases
9
PSQL - Backups of database object definitions
10
PSQL - Backups of database object definitions
11
PSQL - A standalone hot physical backup
12
PSQL - A standalone hot physical backup
13
PSQL - Hot physical backups with Barman
14
PSQL - Hot physical backups with Barman
15
PSQL - Recovery of all databases
16
PSQL - Recovery to a point in time
17
PSQL - Recovery to a point in time
18
PSQL - Recovery of a dropped/damaged table
19
PSQL - Recovery of a dropped/damaged database
20
PSQL - Recovery of a dropped/damaged database
21
PSQL - Extracting a logical backup from a physical one
22
PSQL - Improving performance of logical backup/recovery
23
PSQL - Improving performance of logical backup/recovery
24
PSQL - Improving performance of physical backup/recovery
25
PSQL - Improving performance of physical backup/recovery
26
PSQL - Validating backups
27
PSQL - Validating backups

C Program to list all files and sub-directories in a directory

Lesson is locked. Please Buy course to proceed.