{"id":22067,"date":"2023-02-22T02:41:19","date_gmt":"2023-02-22T02:41:19","guid":{"rendered":"https:\/\/www.booksofall.com\/vi\/?post_type=product&#038;p=22067"},"modified":"2023-02-22T02:41:44","modified_gmt":"2023-02-22T02:41:44","slug":"postgresql-tutorial","status":"publish","type":"product","link":"https:\/\/www.booksofall.com\/vi\/postgresql-tutorial\/","title":{"rendered":"PostgreSQL Tutorial"},"content":{"rendered":"<p><a href=\"https:\/\/www.postgresql.org\/\">PostgreSQL<\/a> is a powerful, open source object-relational database system. It has more than 15 years of active development phase and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.<\/p>\n<p>This tutorial will give you a quick start with <a href=\"https:\/\/www.postgresql.org\/\">PostgreSQL<\/a> and make you comfortable with <a href=\"https:\/\/www.packtpub.com\/product\/postgresql-server-programming-second-edition\/9781783980581#:~:text=PostgreSQL%20includes%20its%20own%20programming,is%20the%20shorthand%20for%20PostgreSQL.\">PostgreSQL programming<\/a>.<\/p>\n<p>What is PostgreSQL?<\/p>\n<p>PostgreSQL (pronounced as post-gress-Q-L) is an open source relational <a href=\"https:\/\/www.techopedia.com\/definition\/24361\/database-management-systems-dbms\">database management system (DBMS)<\/a> developed by a worldwide team of volunteers. PostgreSQL is not controlled by any corporation or other private entity and the source code is available free of charge.<\/p>\n<p>A Brief History of PostgreSQL<\/p>\n<p>PostgreSQL, originally called Postgres, was created at <a href=\"https:\/\/www.ucb.com\/\">UCB<\/a> by a computer science professor named <a href=\"https:\/\/en.wikipedia.org\/wiki\/Michael_Stonebraker\">Michael Stonebraker<\/a>. Stonebraker started Postgres in 1986 as a follow-up project to its predecessor, Ingres, now owned by Computer Associates.<\/p>\n<p>1. 1977-1985: A project called INGRES was developed.<\/p>\n<ul>\n<li>Proof-of-concept for relational databases<\/li>\n<li>Established the company Ingres in 1980<\/li>\n<li>Bought by Computer Associates in 1994<\/li>\n<\/ul>\n<p>2. 1986-1994: POSTGRES<\/p>\n<ul>\n<li>Development of the concepts in INGRES with a focus on object orientation and the query language &#8211; Quel<\/li>\n<li>The code base of INGRES was not used as a basis for POSTGRES<\/li>\n<li>Commercialized as Illustra (bought by Informix, bought by IBM)<\/li>\n<\/ul>\n<p>3. 1994-1995: Postgres95<\/p>\n<ul>\n<li>Support for SQL was added in 1994<\/li>\n<li>Released as Postgres95 in 1995<\/li>\n<li>Re-released as PostgreSQL 6.0 in 1996<\/li>\n<li>Establishment of the PostgreSQL Global Development Team<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p><iframe frameborder=\"0\" allowtransparency=\"true\" allowFullscreen=\"true\" style=\"width: 100%; height: 700px; border: none;\" src=\"https:\/\/online.visual-paradigm.com\/share\/book\/postgresql-tutorial-19kzuxee68?enforceShowPromotionBar=true&#038;p=1\"><\/iframe><\/p>\n","protected":false},"featured_media":22072,"template":"","meta":{"_yoast_wpseo_title":"","_yoast_wpseo_metadesc":""},"product_brand":[],"product_cat":[360],"product_tag":[],"class_list":{"0":"post-22067","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-postgresql","8":"first","9":"instock","10":"shipping-taxable","11":"product-type-simple"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>PostgreSQL Tutorial - BooksOfAll Vietnamese<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.booksofall.com\/vi\/postgresql-tutorial\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL Tutorial - BooksOfAll Vietnamese\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.booksofall.com\/vi\/postgresql-tutorial\/\" \/>\n<meta property=\"og:site_name\" content=\"BooksOfAll Vietnamese\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-22T02:41:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.booksofall.com\/vi\/wp-content\/uploads\/sites\/10\/2023\/02\/img_63f57dcf2b2b3.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.booksofall.com\/vi\/wp-content\/uploads\/sites\/10\/2023\/02\/img_63f57dcf2b2b3.png\" \/>\n<meta name=\"twitter:label1\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.booksofall.com\/vi\/postgresql-tutorial\/\",\"url\":\"https:\/\/www.booksofall.com\/vi\/postgresql-tutorial\/\",\"name\":\"PostgreSQL Tutorial - BooksOfAll Vietnamese\",\"isPartOf\":{\"@id\":\"https:\/\/www.booksofall.com\/vi\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.booksofall.com\/vi\/postgresql-tutorial\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.booksofall.com\/vi\/postgresql-tutorial\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.booksofall.com\/vi\/wp-content\/uploads\/sites\/10\/2023\/02\/img_63f57dcf2b2b3.png\",\"datePublished\":\"2023-02-22T02:41:19+00:00\",\"dateModified\":\"2023-02-22T02:41:44+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.booksofall.com\/vi\/postgresql-tutorial\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.booksofall.com\/vi\/postgresql-tutorial\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/www.booksofall.com\/vi\/postgresql-tutorial\/#primaryimage\",\"url\":\"https:\/\/www.booksofall.com\/vi\/wp-content\/uploads\/sites\/10\/2023\/02\/img_63f57dcf2b2b3.png\",\"contentUrl\":\"https:\/\/www.booksofall.com\/vi\/wp-content\/uploads\/sites\/10\/2023\/02\/img_63f57dcf2b2b3.png\",\"width\":\"521\",\"height\":\"745\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.booksofall.com\/vi\/postgresql-tutorial\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.booksofall.com\/vi\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Categories\",\"item\":\"https:\/\/www.booksofall.com\/vi\/categories\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"PostgreSQL Tutorial\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.booksofall.com\/vi\/#website\",\"url\":\"https:\/\/www.booksofall.com\/vi\/\",\"name\":\"BooksOfAll Vietnamese\",\"description\":\"Biggest IT eBooks library and learning resources - Free eBooks for programming, computing, artificial intelligence and more.\",\"publisher\":{\"@id\":\"https:\/\/www.booksofall.com\/vi\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.booksofall.com\/vi\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.booksofall.com\/vi\/#organization\",\"name\":\"BooksOfAll Vietnamese\",\"url\":\"https:\/\/www.booksofall.com\/vi\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/www.booksofall.com\/vi\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.booksofall.com\/vi\/wp-content\/uploads\/sites\/10\/2022\/06\/booksofall-logo-2.png\",\"contentUrl\":\"https:\/\/www.booksofall.com\/vi\/wp-content\/uploads\/sites\/10\/2022\/06\/booksofall-logo-2.png\",\"width\":166,\"height\":30,\"caption\":\"BooksOfAll Vietnamese\"},\"image\":{\"@id\":\"https:\/\/www.booksofall.com\/vi\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PostgreSQL Tutorial - BooksOfAll Vietnamese","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.booksofall.com\/vi\/postgresql-tutorial\/","og_locale":"vi_VN","og_type":"article","og_title":"PostgreSQL Tutorial - BooksOfAll Vietnamese","og_url":"https:\/\/www.booksofall.com\/vi\/postgresql-tutorial\/","og_site_name":"BooksOfAll Vietnamese","article_modified_time":"2023-02-22T02:41:44+00:00","og_image":[{"url":"https:\/\/www.booksofall.com\/vi\/wp-content\/uploads\/sites\/10\/2023\/02\/img_63f57dcf2b2b3.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_image":"https:\/\/www.booksofall.com\/vi\/wp-content\/uploads\/sites\/10\/2023\/02\/img_63f57dcf2b2b3.png","twitter_misc":{"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"1 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.booksofall.com\/vi\/postgresql-tutorial\/","url":"https:\/\/www.booksofall.com\/vi\/postgresql-tutorial\/","name":"PostgreSQL Tutorial - BooksOfAll Vietnamese","isPartOf":{"@id":"https:\/\/www.booksofall.com\/vi\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.booksofall.com\/vi\/postgresql-tutorial\/#primaryimage"},"image":{"@id":"https:\/\/www.booksofall.com\/vi\/postgresql-tutorial\/#primaryimage"},"thumbnailUrl":"https:\/\/www.booksofall.com\/vi\/wp-content\/uploads\/sites\/10\/2023\/02\/img_63f57dcf2b2b3.png","datePublished":"2023-02-22T02:41:19+00:00","dateModified":"2023-02-22T02:41:44+00:00","breadcrumb":{"@id":"https:\/\/www.booksofall.com\/vi\/postgresql-tutorial\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.booksofall.com\/vi\/postgresql-tutorial\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/www.booksofall.com\/vi\/postgresql-tutorial\/#primaryimage","url":"https:\/\/www.booksofall.com\/vi\/wp-content\/uploads\/sites\/10\/2023\/02\/img_63f57dcf2b2b3.png","contentUrl":"https:\/\/www.booksofall.com\/vi\/wp-content\/uploads\/sites\/10\/2023\/02\/img_63f57dcf2b2b3.png","width":"521","height":"745"},{"@type":"BreadcrumbList","@id":"https:\/\/www.booksofall.com\/vi\/postgresql-tutorial\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.booksofall.com\/vi\/"},{"@type":"ListItem","position":2,"name":"Categories","item":"https:\/\/www.booksofall.com\/vi\/categories\/"},{"@type":"ListItem","position":3,"name":"PostgreSQL Tutorial"}]},{"@type":"WebSite","@id":"https:\/\/www.booksofall.com\/vi\/#website","url":"https:\/\/www.booksofall.com\/vi\/","name":"BooksOfAll Vietnamese","description":"Biggest IT eBooks library and learning resources - Free eBooks for programming, computing, artificial intelligence and more.","publisher":{"@id":"https:\/\/www.booksofall.com\/vi\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.booksofall.com\/vi\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/www.booksofall.com\/vi\/#organization","name":"BooksOfAll Vietnamese","url":"https:\/\/www.booksofall.com\/vi\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/www.booksofall.com\/vi\/#\/schema\/logo\/image\/","url":"https:\/\/www.booksofall.com\/vi\/wp-content\/uploads\/sites\/10\/2022\/06\/booksofall-logo-2.png","contentUrl":"https:\/\/www.booksofall.com\/vi\/wp-content\/uploads\/sites\/10\/2022\/06\/booksofall-logo-2.png","width":166,"height":30,"caption":"BooksOfAll Vietnamese"},"image":{"@id":"https:\/\/www.booksofall.com\/vi\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.booksofall.com\/vi\/wp-json\/wp\/v2\/product\/22067","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.booksofall.com\/vi\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/www.booksofall.com\/vi\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.booksofall.com\/vi\/wp-json\/wp\/v2\/media\/22072"}],"wp:attachment":[{"href":"https:\/\/www.booksofall.com\/vi\/wp-json\/wp\/v2\/media?parent=22067"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/www.booksofall.com\/vi\/wp-json\/wp\/v2\/product_brand?post=22067"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/www.booksofall.com\/vi\/wp-json\/wp\/v2\/product_cat?post=22067"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/www.booksofall.com\/vi\/wp-json\/wp\/v2\/product_tag?post=22067"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}