{"id":12419,"date":"2021-01-11T14:49:36","date_gmt":"2021-01-11T22:49:36","guid":{"rendered":"https:\/\/careerkarma.com\/blog\/?p=12419"},"modified":"2023-12-01T04:08:00","modified_gmt":"2023-12-01T12:08:00","slug":"sql-group-by","status":"publish","type":"post","link":"https:\/\/careerkarma.com\/blog\/sql-group-by\/","title":{"rendered":"SQL Group By: A Complete Guide"},"content":{"rendered":"\n<p><em>The SQL GROUP BY statement appears in aggregate functions. It is used to collate the data you select from a query by a particular column. You can specify multiple columns which will be grouped using the GROUP BY statement.<\/em><\/p>\n\n\n\n<p>When you\u2019re working with aggregate functions in SQL, it is often necessary to group rows together by common column values.<\/p>\n\n\n\n<p>For example, say you want to get a list of branch names for your business. Beside this information you want to see the number of employees who work for those branches. You would need to use an aggregate function and group by the branch name.<\/p>\n\n\n\n<p>That\u2019s where the SQL <em>GROUP BY<\/em> clause comes in.  In this tutorial, we are going to discuss how to use the <em>GROUP BY<\/em> clause.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Aggregate Functions Refresher<\/h2>\n\n\n\n<p>Often\u2014when you\u2019re working with a database\u2014you are not looking to see the actual data within the database. Instead, you may want information about the data. For example, you may want to know the number of unique products your business sells or the maximum score on a leaderboard.<\/p>\n\n\n\n<p>There are a number of functions built-in to <em>SQL<\/em> that allow you to get this information. These are called aggregate functions.<\/p>\n\n\n\n<p>For example, let\u2019s say you wanted to find out how many employees are sales associates, you could use the <em>COUNT<\/em> function. The <em>COUNT<\/em> function counts and returns the number of rows that meet a specific set of criteria. Other aggregate functions include SUM, AVG, MIN, and MAX.<\/p>\n\n\n\n<p>If you\u2019re looking to learn more about aggregate functions, read our <a href=\"https:\/\/careerkarma.com\/blog\/sql-aggregate-functions\/\">SQL aggregate functions guide<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL GROUP BY<\/h2>\n\n\n\n<p>The SQL GROUP BY clause collates rows. GROUP BY clauses are common in queries that use aggregate functions such as MIN and MAX. The GROUP BY statement tells SQL how to aggregate the information in any non-aggregate column you have queried.<\/p>\n\n\n\n<p>The syntax for the GROUP BY statement is:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>SELECT COUNT(column1_name), column2_name\nFROM table1_name\nGROUP BY column2_name;<\/pre><\/div>\n\n\n\n<p>We have used an aggregate function in our query and specified another column.<\/p>\n\n\n\n<p>In any query this is the case, we need to use a GROUP BY statement. The GROUP BY statement tells SQL how to display the branch data even though it is outside the aggregate function. You need to group by the table that is not in the aggregate function. <\/p>\n\n\n\n<p>The GROUP BY clause is only used in <a href=\"https:\/\/careerkarma.com\/blog\/sql-select\/\">SQL SELECT statements<\/a>.<\/p>\n\n\n\n<p>Let&#8217;s take a look at an example of the GROUP BY clause in SQL.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">GROUP BY SQL Example<\/h2>\n\n\n\n<p>Let&#8217;s say we want to find the total number of employees with each title given to the workforce. In other words, we want to know how many sales associates we have, how many marketing directors we have, and so on.<\/p>\n\n\n\n<p>We could use the following query to retrieve this information:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>SELECT title, COUNT(title)\nFROM employees\nGROUP BY title;<\/pre><\/div>\n\n\n\n<p>The query returns multiple records:<\/p>\n\n\n\n<table class=\"wp-block-table course-info-table\"><tbody><tr><td>title<\/td><td>count<\/td><\/tr><tr><td>Senior Sales Associate<\/td><td>1<\/td><\/tr><tr><td>Sales Associate<\/td><td>4<\/td><\/tr><tr><td>Vice President of Sales<\/td><td>1<\/td><\/tr><tr><td>Marketing Director<\/td><td>1<\/td><\/tr><\/tbody><\/table>\n\n\n\n<p>(4 rows)<\/p>\n\n\n\n<p>Our <em>GROUP BY<\/em> query has returned a list of unique titles held by employees. We can see the number of employees who hold that title next to each title.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">When Should You Use a GROUP BY in SQL?<\/h2>\n\n\n\n<p>A <em>GROUP BY<\/em> clause is only necessary when you are looking to get more information than what is returned from the aggregate function. We discussed this a bit earlier.<\/p>\n\n\n\n<p>If you are looking to get the number of customers you have, you only need to run a regular query. Here\u2019s an example of a query that would return this information:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>SELECT COUNT(name) FROM customers;<\/pre><\/div>\n\n\n\n<p>Our query groups the result and returns:<\/p>\n\n\n\n<table class=\"wp-block-table course-info-table\"><tbody><tr><td>count<\/td><\/tr><tr><td>7<\/td><\/tr><\/tbody><\/table>\n\n\n\n<p>(1 row)<\/p>\n\n\n\n<p>If you want to know how many customers are on each of your loyalty plans, you would need to use a <em>GROUP BY<\/em> statement. Here is an example of a query that would get a list of loyalty plans and the number of customers on each plan:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>SELECT loyalty_plan, COUNT(loyalty_plan)\nFROM customers\nGROUP BY loyalty_plan;<\/pre><\/div>\n\n\n\n<p>Our query collects data. Then, our query returns:<\/p>\n\n\n\n<table class=\"wp-block-table course-info-table\"><tbody><tr><td>loyalty_plan<\/td><td>count<\/td><\/tr><tr><td>Gold<\/td><td>1<\/td><\/tr><tr><td>None<\/td><td>3<\/td><\/tr><tr><td>Silver<\/td><td>1<\/td><\/tr><tr><td>Bronze<\/td><td>2<\/td><\/tr><\/tbody><\/table>\n\n\n\n<p>(4 rows)<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL Group By Multiple Columns<\/h2>\n\n\n\n<p>If we wanted to, we could perform a <em>GROUP BY<\/em> on multiple columns. For example, say we wanted to get a list of how many employees we had at each branch with certain titles. We could retrieve this data using the following query:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>SELECT branch, title, COUNT(title)\nFROM employees\nGROUP BY branch, title;<\/pre><\/div>\n\n\n\n<p>Our query result set shows:<\/p>\n\n\n\n<table class=\"wp-block-table course-info-table\"><tbody><tr><td>branch<\/td><td>title<\/td><td>count<\/td><\/tr><tr><td>Stamford<\/td><td>Sales Associate<\/td><td>1<\/td><\/tr><tr><td>Albany<\/td><td>Vice President of Sales<\/td><td>1<\/td><\/tr><tr><td>San Francisco<\/td><td>Sales Associate<\/td><td>1<\/td><\/tr><tr><td>San Francisco<\/td><td>Senior Sales Associate<\/td><td>1<\/td><\/tr><tr><td>Albany<\/td><td>Marketing Director<\/td><td>1<\/td><\/tr><tr><td>Boston<\/td><td>Sales Associate<\/td><td>2<\/td><\/tr><\/tbody><\/table>\n\n\n\n<p>(6 rows)<\/p>\n\n\n\n<p>Our query creates a list of the title held by each employee. We can see the number of people who hold that title. Our data is grouped by the branch for which each employee works, and their titles.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>The <em>SQL GROUP BY<\/em> clause is necessary in any statement where an aggregate function is used and an additional table is queried. You should group by the column not mentioned int he aggregate function. <\/p>\n\n\n\n<p>Are you looking for a challenge? Write a statement that finds out how many employees work at each branch.<\/p>\n\n\n\n<p>The table is called &#8220;employees&#8221; and the column in which branch names are stored is &#8220;branch&#8221;. Go back to the tutorial above and see if your query makes sense based on what we have discussed.<\/p>\n\n\n\n<p>We have written a complete guide on how to learn SQL. This guide is suitable for beginners and those who are already on their way to mastering SQL. Check it out on our <a href=\"https:\/\/careerkarma.com\/blog\/learn-sql\/\">How to Learn SQL page<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"The SQL GROUP BY statement appears in aggregate functions. It is used to collate the data you select from a query by a particular column. You can specify multiple columns which will be grouped using the GROUP BY statement. When you\u2019re working with aggregate functions in SQL, it is often necessary to group rows together&hellip;","protected":false},"author":240,"featured_media":12420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[17284],"tags":[],"class_list":{"0":"post-12419","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-sql"},"acf":{"post_sub_title":"","sprint_id":"","query_class":"SQL","school_sft":"","parent_sft":"","school_privacy_policy":"","has_review":null,"is_sponser_post":"","is_guest_post":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.4 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Group By: A Complete Guide: A Complete Guide | Career Karma<\/title>\n<meta name=\"description\" content=\"The SQL \u201cgroup by\u201d clause allows developers to group rows together by common column values when using aggregate functions. Learn more in this article.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/careerkarma.com\/blog\/sql-group-by\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Group By: A Complete Guide\" \/>\n<meta property=\"og:description\" content=\"The SQL \u201cgroup by\u201d clause allows developers to group rows together by common column values when using aggregate functions. Learn more in this article.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/careerkarma.com\/blog\/sql-group-by\/\" \/>\n<meta property=\"og:site_name\" content=\"Career Karma\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/facebook.com\/careerkarmaapp\" \/>\n<meta property=\"article:published_time\" content=\"2021-01-11T22:49:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-01T12:08:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-GROUP-BY.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"667\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"James Gallagher\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@career_karma\" \/>\n<meta name=\"twitter:site\" content=\"@career_karma\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"James Gallagher\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-group-by\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-group-by\\\/\"},\"author\":{\"name\":\"James Gallagher\",\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/#\\\/schema\\\/person\\\/e79364792443fbff794a144c67ec8e94\"},\"headline\":\"SQL Group By: A Complete Guide\",\"datePublished\":\"2021-01-11T22:49:36+00:00\",\"dateModified\":\"2023-12-01T12:08:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-group-by\\\/\"},\"wordCount\":904,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-group-by\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/SQL-GROUP-BY.jpg\",\"articleSection\":[\"SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-group-by\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-group-by\\\/\",\"url\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-group-by\\\/\",\"name\":\"SQL Group By: A Complete Guide: A Complete Guide | Career Karma\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-group-by\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-group-by\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/SQL-GROUP-BY.jpg\",\"datePublished\":\"2021-01-11T22:49:36+00:00\",\"dateModified\":\"2023-12-01T12:08:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/#\\\/schema\\\/person\\\/e79364792443fbff794a144c67ec8e94\"},\"description\":\"The SQL \u201cgroup by\u201d clause allows developers to group rows together by common column values when using aggregate functions. Learn more in this article.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-group-by\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-group-by\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-group-by\\\/#primaryimage\",\"url\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/SQL-GROUP-BY.jpg\",\"contentUrl\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/SQL-GROUP-BY.jpg\",\"width\":1000,\"height\":667},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-group-by\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog\",\"item\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL\",\"item\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SQL Group By: A Complete Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/\",\"name\":\"Career Karma\",\"description\":\"Latest Coding Bootcamp News &amp; Career Hacks from Industry Insiders\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/#\\\/schema\\\/person\\\/e79364792443fbff794a144c67ec8e94\",\"name\":\"James Gallagher\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/james-gallagher-150x150.jpg\",\"url\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/james-gallagher-150x150.jpg\",\"contentUrl\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/james-gallagher-150x150.jpg\",\"caption\":\"James Gallagher\"},\"description\":\"James Gallagher is a self-taught programmer and the technical content manager at Career Karma. He has experience in range of programming languages and extensive expertise in Python, HTML, CSS, and JavaScript. James has written hundreds of programming tutorials, and he frequently contributes to publications like Codecademy, Treehouse, Repl.it, Afrotech, and others.\",\"url\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/author\\\/jamesgallagher\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Group By: A Complete Guide: A Complete Guide | Career Karma","description":"The SQL \u201cgroup by\u201d clause allows developers to group rows together by common column values when using aggregate functions. Learn more in this article.","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:\/\/careerkarma.com\/blog\/sql-group-by\/","og_locale":"en_US","og_type":"article","og_title":"SQL Group By: A Complete Guide","og_description":"The SQL \u201cgroup by\u201d clause allows developers to group rows together by common column values when using aggregate functions. Learn more in this article.","og_url":"https:\/\/careerkarma.com\/blog\/sql-group-by\/","og_site_name":"Career Karma","article_publisher":"http:\/\/facebook.com\/careerkarmaapp","article_published_time":"2021-01-11T22:49:36+00:00","article_modified_time":"2023-12-01T12:08:00+00:00","og_image":[{"width":1000,"height":667,"url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-GROUP-BY.jpg","type":"image\/jpeg"}],"author":"James Gallagher","twitter_card":"summary_large_image","twitter_creator":"@career_karma","twitter_site":"@career_karma","twitter_misc":{"Written by":"James Gallagher","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/careerkarma.com\/blog\/sql-group-by\/#article","isPartOf":{"@id":"https:\/\/careerkarma.com\/blog\/sql-group-by\/"},"author":{"name":"James Gallagher","@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94"},"headline":"SQL Group By: A Complete Guide","datePublished":"2021-01-11T22:49:36+00:00","dateModified":"2023-12-01T12:08:00+00:00","mainEntityOfPage":{"@id":"https:\/\/careerkarma.com\/blog\/sql-group-by\/"},"wordCount":904,"commentCount":0,"image":{"@id":"https:\/\/careerkarma.com\/blog\/sql-group-by\/#primaryimage"},"thumbnailUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-GROUP-BY.jpg","articleSection":["SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/careerkarma.com\/blog\/sql-group-by\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/careerkarma.com\/blog\/sql-group-by\/","url":"https:\/\/careerkarma.com\/blog\/sql-group-by\/","name":"SQL Group By: A Complete Guide: A Complete Guide | Career Karma","isPartOf":{"@id":"https:\/\/careerkarma.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/careerkarma.com\/blog\/sql-group-by\/#primaryimage"},"image":{"@id":"https:\/\/careerkarma.com\/blog\/sql-group-by\/#primaryimage"},"thumbnailUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-GROUP-BY.jpg","datePublished":"2021-01-11T22:49:36+00:00","dateModified":"2023-12-01T12:08:00+00:00","author":{"@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94"},"description":"The SQL \u201cgroup by\u201d clause allows developers to group rows together by common column values when using aggregate functions. Learn more in this article.","breadcrumb":{"@id":"https:\/\/careerkarma.com\/blog\/sql-group-by\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/careerkarma.com\/blog\/sql-group-by\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/careerkarma.com\/blog\/sql-group-by\/#primaryimage","url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-GROUP-BY.jpg","contentUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-GROUP-BY.jpg","width":1000,"height":667},{"@type":"BreadcrumbList","@id":"https:\/\/careerkarma.com\/blog\/sql-group-by\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/careerkarma.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL","item":"https:\/\/careerkarma.com\/blog\/sql\/"},{"@type":"ListItem","position":3,"name":"SQL Group By: A Complete Guide"}]},{"@type":"WebSite","@id":"https:\/\/careerkarma.com\/blog\/#website","url":"https:\/\/careerkarma.com\/blog\/","name":"Career Karma","description":"Latest Coding Bootcamp News &amp; Career Hacks from Industry Insiders","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/careerkarma.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94","name":"James Gallagher","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/01\/james-gallagher-150x150.jpg","url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/01\/james-gallagher-150x150.jpg","contentUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/01\/james-gallagher-150x150.jpg","caption":"James Gallagher"},"description":"James Gallagher is a self-taught programmer and the technical content manager at Career Karma. He has experience in range of programming languages and extensive expertise in Python, HTML, CSS, and JavaScript. James has written hundreds of programming tutorials, and he frequently contributes to publications like Codecademy, Treehouse, Repl.it, Afrotech, and others.","url":"https:\/\/careerkarma.com\/blog\/author\/jamesgallagher\/"}]}},"_links":{"self":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts\/12419","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/users\/240"}],"replies":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/comments?post=12419"}],"version-history":[{"count":0,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts\/12419\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/media\/12420"}],"wp:attachment":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/media?parent=12419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/categories?post=12419"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/tags?post=12419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}