PostgreSQL Essentials
Corso
A Milano
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
Descrizione
-
Tipologia
Corso
-
Luogo
Milano
This training is designed for Database Administrators and Architects who want to learn PostgreSQL from basics.
You will learn PostgreSQL architecture, installation, designing as well as how to perform backup and recovery databases in PostgreSQL.
Sedi e date
Luogo
Inizio del corso
Inizio del corso
Profilo del corso
There are no specific requirements needed to attend this course. It is recommended to start with this training if you have never taken a formal training of PostgreSQL
Opinioni
Materie
- PostgreSQL
- SQL
Programma
- Introduction
- System Architecture and Internals
- Process Architecture
- Memory Internals
- Storage Architecture
- Installations
- Downloading PostgreSQL
- Preparing System for Installation
- Install PostgreSQL
- Create, Start, Stop a Database Server
- Viewing Information
- PSQL Tool
- Connecting to a Database
- Executing SQL
- psql Meta Commands
- PGAdmin4
- Connecting to a Database
- Basic Tasks using GUI
- Database Designing
- Database Users
- Creating and Managing Databases
- Schemas
- Tables
- Data Types
- Sequences
- Views
- Materialized Views
- Database Backups
- Logical or SQL Dump Backups
- Physical Backups - Offline
- Physical Backups - Online
- Archiving
- Restoring Backups
- Restoring SQL Dumps
- Restoring Offline Backups
- Point in Time Recovery
- Partial Restore
- Proactive Maintenance
- Database Statistics
- Data Fragmentation and Vacuuming
- Data Re-organization
- Automatic Maintenance Configuration
- Re-indexing
- System Parameters
- Parameter File
- Changing Server Parameters
- Resource Parameters
- Planner Parameters
- Logging Parameters
- Transaction Logging Parameters
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
PostgreSQL Essentials