PostgreSQL Database Administration on Windows/Linux- Part 2

Course description
PostgreSQL is an advanced, enterprise class open source Object-Relational Database Management System (ORDBMS). Its is a relational database that supports both SQL (relational) and JSON (non-relational) querying. PostgreSQL possesses robust feature sets including Multi-Version Concurrency Control (MVCC), point in time recovery, granular access controls, tablespaces, asynchronous replication, nested transactions, online/hot backups, a refined query planner/optimizer, and write ahead logging. It supports international character sets, multi-byte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. PostgreSQL is highly scalable both in the quantity of data it can manage and in the number of concurrent users it can accommodate. The course provides the learner with an extensive knowledge of PostgreSQL Database Administration with real time examples. Topics covered are: Introduction to Replication & It's TerminalogiesMaster and Slave ConfigurationWarm & Hot StandbyTypes of ReplicationModes of ReplicationModels of ReplicationLog Based Shipping Standby Initial SetupLog Based Shipping Standby on Windows and LinuxLog Based Shipping Standby FailoverStreaming Replication SetupMonitoring Streaming ReplicationSynchronous Streaming ReplicationConfigure Physical Replication Slots Failover Streaming ReplicationRepmgr - Replication ManagerAutomatic Failover using RepmgrNode Rejoin of Failed PrimaryAdd New Node and Standby FollowSwitch Over From Primary to Standby Cascading Streaming ReplicationWitness ServerUninstall Replication ManagerLogical Replication SetupPublication and SubscriptionLogical Replication SlotsAdd Table to PublicationRefresh SubscriptionCascading Logical ReplicationUninstall Publication and Subscription. Tune PostgreSQL Server parametersShared BuffersWork MemMaintenance Work Mem Postgresql V15 - New Features (Logical Replication)




We have 62214 courses
0 reviews
0 Rating

Udemy is one of the top online learning platforms founded in 2010 currently offering over 175,000 free and paid courses.

Related topics:

On our project for searching online courses, you are able to find a course PostgreSQL Database Administration on Windows/Linux- Part 2 for a fee: 35.54. Selected training refers to category PostgreSQL from a learning platform Udemy, and fits for the difficulty level: any level of expertise. Experienced instructor without any problem will help you in executing new professional peaks. You can read reviews of other users about this online course or share your thoughts to help other students make a decision!

How to get new skills with Skillcombo?

Explore courses that align with your interests, dive into detailed descriptions, and browse through reviews to confidently choose your next learning path. Easily use our filters for level, duration, language, and price to find the right option for your goals.

  • 15+ popular course providers
  • 60000+ online courses in catalog
  • 1000+ IT subjects