General information
Discovery of PgAdmin and PostgreSQL
The objectives of this training are:
- To acquire the theoretical and technical knowledge necessary for data administration in GBS
- Know how to create a schema, tables, a view
- Make selection requests, update, delete data
- Know how to modify data and create rules on tables
| Duration | 2 days (14h) |
| Mode | Present or distancial |
| Level | Beginner |
| Basis required | None |
Training programme
Theory
- Definition of a DBMS
- Data administration principles
Practice
- Presentation of the PgAdmin and PostgreSQL environment (extension)
- Creating a schema
- Table Creation
- Creation of sequence and constraints
- Select Data in SQL
- Updating data in SQL
- Delete Data in SQL
- Creating a View
