{"id":22310,"date":"2023-06-15T12:04:52","date_gmt":"2023-06-15T12:04:52","guid":{"rendered":"https:\/\/machinelearningplus.com\/?p=22310"},"modified":"2023-06-15T17:23:14","modified_gmt":"2023-06-15T17:23:14","slug":"sql-joins","status":"publish","type":"post","link":"https:\/\/machinelearningplus.com\/sql\/sql-joins\/","title":{"rendered":"SQL Joins &#8211; A Comprehensive Guide"},"content":{"rendered":"<p><strong>Deep dive into the world of SQL (Structured Query Language), specifically focusing on a pivotal concept \u2013 SQL Joins.<\/strong><\/p>\n<p>Joins are a crucial tool for working with relational databases, allowing us to combine data from multiple tables to generate meaningful insights.<\/p>\n<p>Lets break down this complex topic into manageable chunks, topped with examples, to ensure you have a clear understanding of SQL Joins by the end of this post.<\/p>\n<h2>What is a SQL Join?<\/h2>\n<p>SQL Joins are used to combine rows from two or more tables based on a related column between them, often a primary key in one table that corresponds to a foreign key in another.<\/p>\n<h2>Types of SQL Joins<\/h2>\n<p>There are four main types of SQL Joins<\/p>\n<ol>\n<li><strong>INNER JOIN<\/strong>: Returns records that have matching values in both tables.<\/p>\n<\/li>\n<li>\n<p><strong>LEFT (OUTER) JOIN<\/strong>: Returns all records from the left table, and the matched records from the right table.<\/p>\n<\/li>\n<li>\n<p><strong>RIGHT (OUTER) JOIN<\/strong>: Returns all records from the right table, and the matched records from the left table.<\/p>\n<\/li>\n<li>\n<p><strong>FULL (OUTER) JOIN<\/strong>: Returns all records when there is a match in either the left or the right table.<\/p>\n<\/li>\n<\/ol>\n<p>Let&#8217;s illustrate these concepts using a simple database with two tables, <code>Customers<\/code> and <code>Orders<\/code>.<\/p>\n<h3>Customers table:<\/h3>\n<pre><code class=\"language-python\">| CustomerID | Name  |\n|------------|-------|\n| 1          | John  |\n| 2          | Peter |\n| 3          | Mary  |\n| 4          | Sally |\n<\/code><\/pre>\n<h3>Orders table:<\/h3>\n<pre><code class=\"language-python\">| OrderID | CustomerID | Product |\n|---------|------------|---------|\n| 1       | 1          | Apples  |\n| 2       | 2          | Bananas |\n| 3       | 4          | Grapes  |\n| 4       | 5          | Oranges |\n<\/code><\/pre>\n<h2>1. INNER JOIN<\/h2>\n<p>The <code>INNER JOIN<\/code> keyword selects records that have matching values in both tables.<\/p>\n<p>SQL Statement:<\/p>\n<pre><code class=\"language-python\">SELECT Customers.Name, Orders.Product\nFROM Customers\nINNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID;\n<\/code><\/pre>\n<p>This returns:<\/p>\n<pre><code class=\"language-python\">| Name  | Product |\n|-------|---------|\n| John  | Apples  |\n| Peter | Bananas |\n| Sally | Grapes  |\n<\/code><\/pre>\n<p>Only the customers who have at least one order are shown.<\/p>\n<h2>2. LEFT JOIN<\/h2>\n<p>The <code>LEFT JOIN<\/code> keyword returns all records from the left table (<code>Customers<\/code>), and the matched records from the right table (<code>Orders<\/code>). The result is <code>NULL<\/code> from the right side if there is no match.<\/p>\n<p>SQL Statement:<\/p>\n<pre><code class=\"language-python\">SELECT Customers.Name, Orders.Product\nFROM Customers\nLEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;\n<\/code><\/pre>\n<p>This returns:<\/p>\n<pre><code class=\"language-python\">| Name  | Product |\n|-------|---------|\n| John  | Apples  |\n| Peter | Bananas |\n| Mary  | NULL    |\n| Sally | Grapes  |\n<\/code><\/pre>\n<p><code>Mary<\/code>, who has not made any orders, still appears in the results.<\/p>\n<h2>3. RIGHT JOIN<\/h2>\n<p>The <code>RIGHT JOIN<\/code> keyword returns all records from the right table (<code>Orders<\/code>), and the matched records from the left table (<code>Customers<\/code>). The result is NULL from the left side when there is no match.<\/p>\n<p>SQL Statement:<\/p>\n<pre><code class=\"language-python\">SELECT Customers.Name, Orders.Product\nFROM Customers\nRIGHT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;\n<\/code><\/pre>\n<p>This returns:<\/p>\n<pre><code class=\"language-python\">| Name  | Product |\n|-------|---------|\n| John  | Apples  |\n| Peter | Bananas |\n| Sally | Grapes  |\n| NULL  | Oranges |\n<\/code><\/pre>\n<p>The order of Oranges made by an unknown customer (CustomerID 5, not present in Customers table) still appears in the results.<\/p>\n<h2>4. FULL JOIN<\/h2>\n<p>The <code>FULL JOIN<\/code> keyword returns all records when there is a match in the left (<code>Customers<\/code>) or the right (<code>Orders<\/code>) table. Records that do not have a match in the other table are shown as <code>NULL<\/code>.<\/p>\n<p>SQL Statement:<\/p>\n<pre><code class=\"language-python\">SELECT Customers.Name, Orders.Product\nFROM Customers\nFULL JOIN Orders ON Customers.CustomerID = Orders.CustomerID;\n<\/code><\/pre>\n<p>This returns:<\/p>\n<pre><code class=\"language-python\">| Name  | Product |\n|-------|---------|\n| John  | Apples  |\n| Peter | Bananas |\n| Mary  | NULL    |\n| Sally | Grapes  |\n| NULL  | Oranges |\n<\/code><\/pre>\n<p>Every record from both tables has been included in the results.<\/p>\n<h2>Conclusion<\/h2>\n<p>SQL Joins are a powerful tool in database manipulation and analysis. Understanding their functionality allows you to combine data in ways that can provide powerful insights. Hopefully, this post has given you a solid understanding of the different types of SQL Joins and how to use them effectively.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Deep dive into the world of SQL (Structured Query Language), specifically focusing on a pivotal concept \u2013 SQL Joins. Joins are a crucial tool for working with relational databases, allowing us to combine data from multiple tables to generate meaningful insights. Lets break down this complex topic into manageable chunks, topped with examples, to ensure [&hellip;]<\/p>\n","protected":false},"author":38,"featured_media":22538,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[2091],"tags":[2094,2092],"class_list":["post-22310","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-data-engineering","tag-sql"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Joins - A Comprehensive Guide - machinelearningplus<\/title>\n<meta name=\"description\" content=\"Deep dive into the world of SQL (Structured Query Language), specifically focusing on a pivotal concept \u2013 SQL Joins.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/localhost:8080\/sql\/sql-joins\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Joins - A Comprehensive Guide - machinelearningplus\" \/>\n<meta property=\"og:description\" content=\"Deep dive into the world of SQL (Structured Query Language), specifically focusing on a pivotal concept \u2013 SQL Joins.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/localhost:8080\/sql\/sql-joins\/\" \/>\n<meta property=\"og:site_name\" content=\"machinelearningplus\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-15T12:04:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-15T17:23:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/localhost:8080\/wp-content\/uploads\/2023\/06\/SQL-Joins.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1080\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Jagdeesh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jagdeesh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"TechArticle\",\"@id\":\"https:\\\/\\\/localhost:8080\\\/sql\\\/sql-joins\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/localhost:8080\\\/sql\\\/sql-joins\\\/\"},\"author\":{\"name\":\"Jagdeesh\",\"@id\":\"https:\\\/\\\/machinelearningplus.com\\\/#\\\/schema\\\/person\\\/b1493170590ee4eb9622bcaea5b3b7da\"},\"headline\":\"SQL Joins &#8211; A Comprehensive Guide\",\"datePublished\":\"2023-06-15T12:04:52+00:00\",\"dateModified\":\"2023-06-15T17:23:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/localhost:8080\\\/sql\\\/sql-joins\\\/\"},\"wordCount\":435,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/machinelearningplus.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/localhost:8080\\\/sql\\\/sql-joins\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/machinelearningplus.com\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/SQL-Joins.png\",\"keywords\":[\"Data Engineering\",\"SQL\"],\"articleSection\":[\"SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/localhost:8080\\\/sql\\\/sql-joins\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/localhost:8080\\\/sql\\\/sql-joins\\\/\",\"url\":\"https:\\\/\\\/localhost:8080\\\/sql\\\/sql-joins\\\/\",\"name\":\"SQL Joins - A Comprehensive Guide - machinelearningplus\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/machinelearningplus.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/localhost:8080\\\/sql\\\/sql-joins\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/localhost:8080\\\/sql\\\/sql-joins\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/machinelearningplus.com\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/SQL-Joins.png\",\"datePublished\":\"2023-06-15T12:04:52+00:00\",\"dateModified\":\"2023-06-15T17:23:14+00:00\",\"description\":\"Deep dive into the world of SQL (Structured Query Language), specifically focusing on a pivotal concept \u2013 SQL Joins.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/localhost:8080\\\/sql\\\/sql-joins\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/localhost:8080\\\/sql\\\/sql-joins\\\/#primaryimage\",\"url\":\"https:\\\/\\\/machinelearningplus.com\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/SQL-Joins.png\",\"contentUrl\":\"https:\\\/\\\/machinelearningplus.com\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/SQL-Joins.png\",\"width\":1080,\"height\":1080,\"caption\":\"SQL Joins\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/machinelearningplus.com\\\/#website\",\"url\":\"https:\\\/\\\/machinelearningplus.com\\\/\",\"name\":\"machinelearningplus\",\"description\":\"Learn Data Science (AI \\\/ ML) Online\",\"publisher\":{\"@id\":\"https:\\\/\\\/machinelearningplus.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/machinelearningplus.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/machinelearningplus.com\\\/#organization\",\"name\":\"machinelearningplus\",\"url\":\"https:\\\/\\\/machinelearningplus.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/machinelearningplus.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/machinelearningplus.com\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/MachineLearningplus-logo.svg\",\"contentUrl\":\"https:\\\/\\\/machinelearningplus.com\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/MachineLearningplus-logo.svg\",\"width\":348,\"height\":36,\"caption\":\"machinelearningplus\"},\"image\":{\"@id\":\"https:\\\/\\\/machinelearningplus.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/machinelearningplus.com\\\/#\\\/schema\\\/person\\\/b1493170590ee4eb9622bcaea5b3b7da\",\"name\":\"Jagdeesh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/machinelearningplus.com\\\/wp-content\\\/litespeed\\\/avatar\\\/8a303ceb6bbccb62c3dbc14787297f84.jpg?ver=1776363391\",\"url\":\"https:\\\/\\\/machinelearningplus.com\\\/wp-content\\\/litespeed\\\/avatar\\\/8a303ceb6bbccb62c3dbc14787297f84.jpg?ver=1776363391\",\"contentUrl\":\"https:\\\/\\\/machinelearningplus.com\\\/wp-content\\\/litespeed\\\/avatar\\\/8a303ceb6bbccb62c3dbc14787297f84.jpg?ver=1776363391\",\"caption\":\"Jagdeesh\"},\"url\":\"https:\\\/\\\/machinelearningplus.com\\\/author\\\/jagdeesh\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Joins - A Comprehensive Guide - machinelearningplus","description":"Deep dive into the world of SQL (Structured Query Language), specifically focusing on a pivotal concept \u2013 SQL Joins.","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:\/\/localhost:8080\/sql\/sql-joins\/","og_locale":"en_US","og_type":"article","og_title":"SQL Joins - A Comprehensive Guide - machinelearningplus","og_description":"Deep dive into the world of SQL (Structured Query Language), specifically focusing on a pivotal concept \u2013 SQL Joins.","og_url":"https:\/\/localhost:8080\/sql\/sql-joins\/","og_site_name":"machinelearningplus","article_published_time":"2023-06-15T12:04:52+00:00","article_modified_time":"2023-06-15T17:23:14+00:00","og_image":[{"width":1080,"height":1080,"url":"https:\/\/localhost:8080\/wp-content\/uploads\/2023\/06\/SQL-Joins.png","type":"image\/png"}],"author":"Jagdeesh","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jagdeesh","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"TechArticle","@id":"https:\/\/localhost:8080\/sql\/sql-joins\/#article","isPartOf":{"@id":"https:\/\/localhost:8080\/sql\/sql-joins\/"},"author":{"name":"Jagdeesh","@id":"https:\/\/machinelearningplus.com\/#\/schema\/person\/b1493170590ee4eb9622bcaea5b3b7da"},"headline":"SQL Joins &#8211; A Comprehensive Guide","datePublished":"2023-06-15T12:04:52+00:00","dateModified":"2023-06-15T17:23:14+00:00","mainEntityOfPage":{"@id":"https:\/\/localhost:8080\/sql\/sql-joins\/"},"wordCount":435,"commentCount":0,"publisher":{"@id":"https:\/\/machinelearningplus.com\/#organization"},"image":{"@id":"https:\/\/localhost:8080\/sql\/sql-joins\/#primaryimage"},"thumbnailUrl":"https:\/\/machinelearningplus.com\/wp-content\/uploads\/2023\/06\/SQL-Joins.png","keywords":["Data Engineering","SQL"],"articleSection":["SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/localhost:8080\/sql\/sql-joins\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/localhost:8080\/sql\/sql-joins\/","url":"https:\/\/localhost:8080\/sql\/sql-joins\/","name":"SQL Joins - A Comprehensive Guide - machinelearningplus","isPartOf":{"@id":"https:\/\/machinelearningplus.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/localhost:8080\/sql\/sql-joins\/#primaryimage"},"image":{"@id":"https:\/\/localhost:8080\/sql\/sql-joins\/#primaryimage"},"thumbnailUrl":"https:\/\/machinelearningplus.com\/wp-content\/uploads\/2023\/06\/SQL-Joins.png","datePublished":"2023-06-15T12:04:52+00:00","dateModified":"2023-06-15T17:23:14+00:00","description":"Deep dive into the world of SQL (Structured Query Language), specifically focusing on a pivotal concept \u2013 SQL Joins.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/localhost:8080\/sql\/sql-joins\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/localhost:8080\/sql\/sql-joins\/#primaryimage","url":"https:\/\/machinelearningplus.com\/wp-content\/uploads\/2023\/06\/SQL-Joins.png","contentUrl":"https:\/\/machinelearningplus.com\/wp-content\/uploads\/2023\/06\/SQL-Joins.png","width":1080,"height":1080,"caption":"SQL Joins"},{"@type":"WebSite","@id":"https:\/\/machinelearningplus.com\/#website","url":"https:\/\/machinelearningplus.com\/","name":"machinelearningplus","description":"Learn Data Science (AI \/ ML) Online","publisher":{"@id":"https:\/\/machinelearningplus.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/machinelearningplus.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/machinelearningplus.com\/#organization","name":"machinelearningplus","url":"https:\/\/machinelearningplus.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/machinelearningplus.com\/#\/schema\/logo\/image\/","url":"https:\/\/machinelearningplus.com\/wp-content\/uploads\/2022\/05\/MachineLearningplus-logo.svg","contentUrl":"https:\/\/machinelearningplus.com\/wp-content\/uploads\/2022\/05\/MachineLearningplus-logo.svg","width":348,"height":36,"caption":"machinelearningplus"},"image":{"@id":"https:\/\/machinelearningplus.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/machinelearningplus.com\/#\/schema\/person\/b1493170590ee4eb9622bcaea5b3b7da","name":"Jagdeesh","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/machinelearningplus.com\/wp-content\/litespeed\/avatar\/8a303ceb6bbccb62c3dbc14787297f84.jpg?ver=1776363391","url":"https:\/\/machinelearningplus.com\/wp-content\/litespeed\/avatar\/8a303ceb6bbccb62c3dbc14787297f84.jpg?ver=1776363391","contentUrl":"https:\/\/machinelearningplus.com\/wp-content\/litespeed\/avatar\/8a303ceb6bbccb62c3dbc14787297f84.jpg?ver=1776363391","caption":"Jagdeesh"},"url":"https:\/\/machinelearningplus.com\/author\/jagdeesh\/"}]}},"_links":{"self":[{"href":"https:\/\/machinelearningplus.com\/wp-json\/wp\/v2\/posts\/22310","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/machinelearningplus.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/machinelearningplus.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/machinelearningplus.com\/wp-json\/wp\/v2\/users\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/machinelearningplus.com\/wp-json\/wp\/v2\/comments?post=22310"}],"version-history":[{"count":0,"href":"https:\/\/machinelearningplus.com\/wp-json\/wp\/v2\/posts\/22310\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/machinelearningplus.com\/wp-json\/wp\/v2\/media\/22538"}],"wp:attachment":[{"href":"https:\/\/machinelearningplus.com\/wp-json\/wp\/v2\/media?parent=22310"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/machinelearningplus.com\/wp-json\/wp\/v2\/categories?post=22310"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/machinelearningplus.com\/wp-json\/wp\/v2\/tags?post=22310"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}