{"id":8564,"date":"2024-09-24T09:10:52","date_gmt":"2024-09-24T08:10:52","guid":{"rendered":"https:\/\/republify.se\/?post_type=product&#038;p=8564"},"modified":"2026-01-09T08:03:46","modified_gmt":"2026-01-09T07:03:46","slug":"introduction-to-postgresql","status":"publish","type":"product","link":"https:\/\/republify.se\/index.php\/produkt\/introduction-to-postgresql\/","title":{"rendered":"Introduction to PostgreSQL"},"content":{"rendered":"<div><strong>Prerequisites:<\/strong><\/div>\n<div>fundamentals of databases and SQL and\u00a0basic knowledge of Unix OS<\/div>\n<div><\/div>\n<div><strong>Skills to be gained:<\/strong><\/div>\n<div><\/div>\n<div>general idea of PostgreSQL architecture<\/div>\n<div>basics of installation, configuring, and managing the server<\/div>\n<div>physical and logical data layout<\/div>\n<div>basic administration tasks<\/div>\n<div>authentication and access control<\/div>\n<div>overview of backups and replication<\/div>\n<div><\/div>\n<div><strong>Topics<\/strong><\/div>\n<div><\/div>\n<div><strong>\u00a0 Basic Tools<\/strong><\/div>\n<div>1. Installation and Management; psql<\/div>\n<div><\/div>\n<div><strong>\u00a0 Architecture<\/strong><\/div>\n<div>2. PostgreSQL Overview<\/div>\n<div><\/div>\n<div>3. Isolation and MVCC<\/div>\n<div><\/div>\n<div>4. Vacuum course materials<\/div>\n<div><\/div>\n<div>5. Buffer Cache and WAL<\/div>\n<div><\/div>\n<div>\u00a0 <strong>Data Organization \u00a0<\/strong><\/div>\n<div>6. Logical Structure<\/div>\n<div><\/div>\n<div>7. Physical Structure<\/div>\n<div><\/div>\n<div>\u00a0 <strong>Administration Tasks<\/strong><\/div>\n<div>8. Monitoring<\/div>\n<div><\/div>\n<div>\u00a0<strong> Access Control \u00a0<\/strong><\/div>\n<div>9. Access Control Overview<\/div>\n<div><\/div>\n<div>\u00a0 <strong>Backup and Replication<\/strong><\/div>\n<div>10. Backup Overview<\/div>\n<div><\/div>\n<div>11. Replication Overview<\/div>\n","protected":false},"excerpt":{"rendered":"<p><strong>This is an introduction course to PostgreSQL, a free open-source database system that supports both relational (SQL) and non-relational (JSON) queries.<\/strong><\/p>\n<p>PostgreSQL is a back-end database for dynamic websites and web applications and supports the most important programming languages as Python, Java, C\/C++, C#, Node.js, Go, Ruby, Perl and Tcl<\/p>\n","protected":false},"featured_media":7782,"comment_status":"open","ping_status":"closed","template":"","meta":{"wds_primary_product_brand":0,"wds_primary_product_cat":0},"product_brand":[],"product_cat":[50,29],"product_tag":[],"class_list":{"0":"post-8564","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-sql-server","7":"product_cat-technical","9":"first","10":"instock","11":"taxable","12":"shipping-taxable","13":"purchasable","14":"product-type-simple"},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/product\/8564","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/comments?post=8564"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/media\/7782"}],"wp:attachment":[{"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/media?parent=8564"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/product_brand?post=8564"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/product_cat?post=8564"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/product_tag?post=8564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}