Postgre SQL Database Administration
irna
Fri, 09/30/2022 - 07:40
Duration
5 Days
Price
--- Call Us ---
Choosing a database product that will be used for data storage from the applications that we will create is very important, there are many aspects that we must pay attention to, including the features of the database product and its license. PostgreSQL is a relational database product that is included in the open source software category, but also has many features.
Key Outcomes:
- Be able to install PostgreSQL and also how to manage databases, schemas, and tables to how to query using the command-line psql.
- Be able to query PostgreSQL databases until they are connected to the application to be created.
Objectives
- Introduction to PostgreSQL
- Installing PostgreSQL on Windows
- The PostgreSQL Files and Programs
- Managing PostgreSQL on Windows
- The psql Program
- Using Basic SQL
- Using Advanced SQL
- PostgreSQL Functions
- Stored Procedures and Triggers
- Security
- Performance
- Java
Contact
- Nurman (+62 857-2375-3840)
- Irna (+62 822-1664-7749)
- Puji (+62 813-2424-2115)
- Shafa (+62 813-9049-0664)