PostgreSQL Fundamental
irna
Tue, 12/19/2023 - 04:20
Duration
2 Days
Price
--- Call Us ---
In this course you will learn the fundamental concepts of this open source database. With in-depth tutorials and a practical, hands on workshop, you will learn about the basics and advanced features of PostgreSQL and how to develop applications with PostgreSQL as the back-end.
Key Outcomes:
You will learn:
- How relational databases work and how are they relevant in today’s times
- What sort of a database management system is PostgreSQL
- How to install and setup PostgreSQL and run queries on it
- How to create applications with PostgreSQL as a back end database management system
Objectives
- Module 1: Introduction
o History of PostgreSQL
o Major Features
o etc - Module 2: PostgreSQL System Architecture
o Architectural Summary
o Shared Memory
o etc - Module 3: Creating and Managing Databases
o Object Hierarchy
o Creating Databases
o etc - Module 4: Postgres Data Dictionary
o The System Catalog Schema
o System Information views/tables
o etc - Module 5: Configuration
o Setting PostgreSQL Parameters
o Access Control
o etc - Module 6: Security
o Authentication
o Authorization
o etc - Module 7: Backup and Recovery & Point-in Time Recovery
o Backup Types
o SQL Dump
o etc - Module 8: Routine Maintenance
o Explain and Explain Analyze
o Table Statistics
o etc - Module 9: Table Partitioning
o Partitioning
o Partitioning Methods
o etc - Module 10: Database Monitoring
o Database Statistics
o The Statistics Collector
o etc
Contact
- Nurman (+62 857-2375-3840)
- Irna (+62 822-1664-7749)
- Puji (+62 813-2424-2115)
- Shafa (+62 813-9049-0664)