PostgreSQL

PostgreSQL Training

Duration: 4 Days

Course fee:$299.00 (₹20306.59)

This four days training is designed for database administrators, developers, system architect and IT professionals. This training will provides knowledge to setup, configure, manage and administor your database. This training also cover high availablity, clustering, backup and recovery of database. At the end of training you will be able to fine tune your database by following best practices.

Product Description

This four days training is designed for database administrators, developers, system architect and IT professionals. This training will provides knowledge to setup, configure, manage and administer your database. This training also cover high availability, clustering, backup and recovery of database. At the end of training you will be able to fine tune your database by following best practices.

Objectives:

  • Install and manage your database
  • Make your database secure
  • Achieve High availability
  • Get High Performance by following best practices

Advantages of PostgreSQL Training

  • Larger deployment  provides opportunity to build larger profits.
  • Flexible content Research and Low cost  trial deployment
  • Scalability and Cross platform compatibility

Additional Information

Day 1

1. Introduction of PostgreSQL

2. New Featrues of PostgreSQL

3. Installation of PostgreSQL

4. Creating your first Database

5. Managing Databases& Access
   – Roles
   – Users
   – Groups

6. Introduction to PSQL

7. PSQL Commands

8. PSQL Meta-Commands

9. PSQL SET Parameters

10. Information Commands

11. Working with pgAdmin III

12. Registering a server

13. Viewing and Editing Data

14. Query Tool

15. Databases

16. Languages

17. Schemas

18. Domains

19. Functions

20. Sequences

21. Tables

22. Columns

23. Constraints

24. Indexes

25. Maintenance

26. Rules

27. Triggers

28. Types

29. Views

30. Tablespaces

31. SQL

32. Data Types

33. Tables

34. SQL Queries

35. Quoting

36. Using SQL Functions

37. Constraints

38. Dropping or Removing Database Objects

39. Views

40. Sequences

41. indexes

Day 2

1. Security Basics

2. Security levels

3. Authentication&Authorization

4. Understanding pg_hba.conf file

5. Object ownership

6. Access control

7. Application access parameters

8. Backup and Recovery

9. Backup Types

10. SQL Dump

11. Cluster Dump

12. Offline Copy Backup

13. Continuous Archiving

14. pg_basebackup

15. Point-In Time Recovery

16. pg_upgrade

17. Routine Maintenance

18. Explain and Explain Analyze

19. Table Statistics

20. Updating Planner Statistics

21. Vacuuming

22. Scheduling Auto Vacuum

23. Preventing Transaction ID Wraparound Failures

24. The Visibility Map

25. Routine Reindexing

26. Postgres Data Dictionary

27. The System Catalog Schema

28. System Information views/tables

29. System Information Functions

30. Moving Data

31. The COPY Command

Day 3

1. PostgreSQL System Architecture

2. Architectural Overview

3. Shared Memory

4. Inter-process Communications

5. Statement Processing

6. Utility Processes

7. Disk Read Buffering

8. Write Buffering

9. Background Writer Cleaning Scan

10. Commit & Checkpoint

11. Physical Database Architecture

12. Data Directory Layout

13. Installation Directory Layout

14. Page Layout

15. Configuration

16. Setting PostgreSQL Parameters

17. Access Control

18. Connection Settings

19. Security and Authentication Settings

20. Memory Settings

21. Query Planner Settings

22. WAL Settings

23. Log Management

24. Backgaround Writer Settings

25. Statement Behavior

26. Vacuum Cost Settings

27. Autovacuum Settings

28. Transactions and Concurrency

29. Transaction Definition Effects of Concurrency

30. Transaction Isolation Levels

31. Multi-Version Concurrency Control Overview (MVCC)

32. Internal Identifiers

33. Transaction Wraparound

34. MVCC Maintenance

35. Performance Tuning

36. Hardware Configuration

37. OS Configuration

38. Server Parameter Tuning

39. Connection Settings

40. Memory Parameters

41. Memory settings for Planner

42. WAL Parameters

43. Explain Plan

44. Statistics Collection

45. Indexes

46. Inserting Large Amount of Data

47. pg_dump

48. Non-Durable Settings

Day 4

1. Replication & Failover

2. Database High Availability

3. High Availability Options

4. Hot Streaming Replication, Architecture and Setup

5. Slony-I Replication, Architecture and Setup

6. Switchovers and Failovers

7. Replication Limitations

8. Table Partitioning

9. Partitioning Methods

10. Partitioning Setup

11. Partitioning and Constraint Exclusion

12. Caveats

13. Monitoring

14. Database Monitoring

15. Database Statistics

16. The Statistics Collector

17. Database Statistic Tables

18. Operating System Process Monitoring

19. Current Sessions and Locks

20. Log Slow Running Queries

21. Disk Usage

22. Clustering

23. Creating a database cluster

24. Starting and Stopping the Server (pg_ctl)

25. Connect to the server using psql

Reviews

There are no reviews yet.

Be the first to review “PostgreSQL Training”

INQUIRY

Please fill this for and we'll get back to you as soon as possible!

TOP mautic is open source marketing automation