{"id":4298,"date":"2024-02-02T14:44:39","date_gmt":"2024-02-02T09:14:39","guid":{"rendered":"https:\/\/pczippo.com\/?p=4298"},"modified":"2024-02-02T14:44:39","modified_gmt":"2024-02-02T09:14:39","slug":"start-from-scratch-a-step-by-step-guide-for-learning-sql-queries","status":"publish","type":"post","link":"https:\/\/pczippo.com\/tech\/start-from-scratch-a-step-by-step-guide-for-learning-sql-queries\/","title":{"rendered":"Start from Scratch: A Step-by-Step Guide for Learning SQL Queries"},"content":{"rendered":"\n<p class=\"has-background\" style=\"background-color:#d7d6d6\"><strong>Complex queries might be scary, but this guide will show you how to work more readily with SQL queries.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/pczippo.com\/wp-content\/uploads\/2024\/02\/main-12-1-2024x574.jpg\" alt=\"\" class=\"wp-image-4326\" style=\"width:1170px;height:auto\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>SQL Queries,<\/strong> which stands for Structured Query Language, is a programming language that is used to manage and manipulate data in a relational database management system (RDBMS). It is a widely used language in many organizations for ensuring smooth data access. SQL is a required skill in many job postings due to its widespread use, which makes it important for people to learn.<\/p>\n\n\n\n<p>One of the common challenges for those learning SQL is understanding queries, especially when they are written by someone else. In companies, we often work as a team and need to read and comprehend SQL queries. Therefore, it is crucial to practice deconstructing and understanding SQL queries.<\/p>\n\n\n\n<p>This <a href=\"https:\/\/pczippo.com\/category\/tech\/\" target=\"_blank\" rel=\"noreferrer noopener\">article<\/a> will guide you through a step-by-step process of reading and understanding SQL queries. How can we achieve this? Let&#8217;s find out.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>1. Understand The Structure Of SQL Queries<\/strong><\/h2>\n\n\n\n<p>When encountering a SQL query, the first thing we need to do is comprehend its overall aim. The broad aim does not imply a complete understanding of the query&#8217;s structure; rather, it refers to the overall flows.<\/p>\n\n\n\n<p>To comprehend the general SQL query, we need to first understand the standard SQL queries.&nbsp; Most SQL queries begin with the SELECT clause and continue with the FROM clause. From there, the queries are typically followed by JOIN, WHERE, GROUP BY, ORDER BY, and HAVING clauses.<\/p>\n\n\n\n<p>The clauses mentioned above are common in the SQL queries we need to comprehend. Each clause has the following functions:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>SELECT:<\/strong> Columns to extract from the table<\/li>\n\n\n\n<li><strong>FROM:<\/strong> Table from which the data was obtained<\/li>\n\n\n\n<li><strong>JOIN:<\/strong> Combine tables using the supplied identifier.<\/li>\n\n\n\n<li><strong>WHERE:<\/strong> Data filters based on the condition.<\/li>\n\n\n\n<li><strong>GROUP BY:<\/strong> Organize the data by column value and enable aggregation.<\/li>\n\n\n\n<li><strong>ORDER BY:<\/strong> Arrange the data result order by the specific column.<\/li>\n\n\n\n<li><strong>HAVING:<\/strong> The filter condition for the aggregation function, which cannot be provided WHERE<\/li>\n<\/ul>\n\n\n\n<p>These are the usual clauses that you should expect to see while first learning about the generic SQL query format. Let&#8217;s utilize the example code to understand more.<\/p>\n\n\n\n<pre class=\"wp-block-code has-background\" style=\"background-color:#ebebeb\"><code><strong>SELECT \n  customers.name, \n  purchases.product, \n  SUM(price) as total_price \nFROM \n  purchases \n  JOIN customers ON purchases.cust_id = customers.id \nWHERE \n  purchases.category = 'kitchen' \nGROUP BY \n  customers.name, \n  purchases.product \nHAVING \n  total_price > 10000 \nORDER BY \n  total_price DESC;<\/strong><\/code><\/pre>\n\n\n\n<p>When reviewing the query above, try to locate the standard clauses. The clause would explain what data was selected (<strong>SELECT<\/strong>), where it came from (<strong>FROM and JOIN<\/strong>), and the conditions (<strong>WHERE, GROUP BY, ORDER BY, and HAVING<\/strong>).<\/p>\n\n\n\n<p>For example, reading the query above would provide you a comprehension of the following:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>We attempt to obtain three types of data: the name from a table named customers, the product from a table called purchases, and the aggregation of price columns that do not identify the table&#8217;s origin and are referred to as total price (information from clause <strong>SELECT<\/strong>).<\/li>\n\n\n\n<li>The total data would come from the purchases and customers tables, which would be joined using the cust_id column from purchases and the id column from the customer&#8217;s table (Information from clause <strong>FROM<\/strong> and <strong>JOIN<\/strong>).<\/li>\n\n\n\n<li>To use the aggregation function, select data with the category column value &#8216;kitchen&#8217; from the purchases table (Information from clause <strong>WHERE<\/strong>).<\/li>\n\n\n\n<li>Group by the name and product column from the respective table (Information from clause GROUP BY).<\/li>\n\n\n\n<li>Filter the result sum for total price greater than 10000 (Information from clause <strong>HAVING<\/strong>).<\/li>\n\n\n\n<li><strong><\/strong>Order the data descending by total price (information from clause&nbsp;<strong>ORDER BY).<\/strong><\/li>\n<\/ol>\n\n\n\n<p>That is the general SQL query format you must understand and identify. From there, we may investigate further using the advanced query. Let&#8217;s go on to the next step.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-alpha-channel-opacity has-background is-style-wide\" style=\"background-color:#000000;color:#000000\"\/>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"has-text-align-center\"><strong>Also Read:<a href=\"https:\/\/appsrs.com\/apple-vision-pro-price-release-date-and-everything-you-should-know\/\">Apple Vision Pro: Price, Release Date, And Everything You Should Know!<\/a><\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-alpha-channel-opacity has-background is-style-wide\" style=\"background-color:#000000;color:#000000\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>2. The Final Select<\/strong><\/h2>\n\n\n\n<p>There will be times when you come across a complex query with multiple SELECT clauses. In this scenario, we need to understand the query&#8217;s ultimate result, or the final (first) SELECT statement. The trick is to understand what the query output is intended to be.<\/p>\n\n\n\n<p>Let\u2019s Try out one more code:<\/p>\n\n\n\n<pre class=\"wp-block-code has-background\" style=\"background-color:#ebebeb\"><code><strong>WITH customerspending AS (\n  SELECT \n    customers.id, \n    SUM(purchases.price) as total_spending \n  FROM \n    purchases \n    JOIN customers ON purchases.cust_id = customers.id \n  GROUP BY \n    customers.id\n) \nSELECT \n  c.name, \n  pd.product, \n  pd.total_product_price, \n  cs.total_spending \nFROM \n  (\n    SELECT \n      purchases.cust_id, \n      purchases.product, \n      SUM(purchases.price) as total_product_price \n    FROM \n      purchases \n    WHERE \n      purchases.category = 'kitchen' \n    GROUP BY \n      purchases.cust_id, \n      purchases.product \n    HAVING \n      SUM(purchases.price) > 10000\n  ) AS pd \n  JOIN customers c ON pd.cust_id = c.id \n  JOIN customerspending cs ON c.id = cs.id \nORDER BY \n  pd.total_product_price DESC;<\/strong><\/code><\/pre>\n\n\n\n<p>The query is more complex and lengthy now, but the primary attention should be on the final <strong>SELECT<\/strong>, which appears to attempt to produce the customer&#8217;s entire spending and purchase history. Try to determine what the desired final result is and break it down from there.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>3. The Final Condition Clause<\/strong><\/h2>\n\n\n\n<p>The inquiries provide us with information into what the result should be. The next step is to determine the conditions for the final <strong>SELECT<\/strong> statement. The conditions clause, which included <strong>WHERE<\/strong>, <strong>GROUP BY<\/strong>, <strong>ORDER BY<\/strong>, and <strong>HAVING<\/strong>, determined the overall data result.<\/p>\n\n\n\n<p>Try to read and grasp the conditions of our query, and we will have a better understanding of the final answer. For example, in our previous <strong>SQL query<\/strong>, the final condition is simply <strong>ORDER BY<\/strong>. This signifies that the final result will be sorted by total product price in descending order.<\/p>\n\n\n\n<p>Knowing the final conditions will help you grasp a substantial portion of the query and the overall query intent.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>4. The Final Join<\/strong><\/h2>\n\n\n\n<p>First and foremost, we must understand the source of the data. After we&#8217;ve determined which data to select and under what conditions, we need to understand the source. The last <strong>JOIN<\/strong> clause would help us understand how the tables connect and how data flows.<\/p>\n\n\n\n<p>For example, the prior complex query indicates that we used Join twice. This signifies that we used at least three data sources to produce the final result. This information will be required in the subsequent steps to better understand how each data source is obtained, particularly when the data source is derived from the subquery.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>5. Reverse Order Reading And Repeat<\/strong><\/h2>\n\n\n\n<p>After we&#8217;ve determined what the end result should be and where it comes from, we need to go deeper into the intricacies. From here, we&#8217;d go back and look at each subquery to figure out why it&#8217;s set up that way.<\/p>\n\n\n\n<p>However, we do not attempt to examine them in top-down frameworks. Instead, we should start with the subqueries that are closest to the final result and work our way up to the one that is the furthest away. We should first try to understand the code in the example<\/p>\n\n\n\n<pre class=\"wp-block-code has-background\" style=\"background-color:#ebebeb\"><code><strong>SELECT \n  purchases.cust_id, \n  purchases.product, \n  SUM(purchases.price) as total_product_price \nFROM \n  purchases \nWHERE \n  purchases.category = 'kitchen' \nGROUP BY \n  purchases.cust_id, \n  purchases.product \nHAVING \n  SUM(purchases.price) > 10000<\/strong><\/code><\/pre>\n\n\n\n<p>Then, we are moving to the furthest code which is this one:<\/p>\n\n\n\n<pre class=\"wp-block-code has-background\" style=\"background-color:#ebebeb\"><code><strong>WITH customerspending AS (\n  SELECT \n    customers.id, \n    SUM(purchases.price) as total_spending \n  FROM \n    purchases \n    JOIN customers ON purchases.cust_id = customers.id \n  GROUP BY \n    customers.id\n)<\/strong><\/code><\/pre>\n\n\n\n<p>We can plainly see the author&#8217;s thought process when we split out each subquery from closest to the result to farthest.<\/p>\n\n\n\n<p>If you are having trouble comprehending each subquery, try repeating the method above. With a little practice, you&#8217;ll get better at reading and understanding the query.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Conclusion<\/strong><\/h2>\n\n\n\n<p>Being able to read and interpret SQL queries is an important skill that is required by every firm in the present era. If you wish to understand complex SQL queries more easily, it is recommended that you follow the step-by-step guide given below. The steps include understanding the general SQL query structure, comprehending the Final Select, understanding the Final Condition Clause, and reading the last join in reverse order and repeating it until you understand it completely.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-alpha-channel-opacity has-background is-style-wide\" style=\"background-color:#000000;color:#000000\"\/>\n\n\n\n<p class=\"has-text-align-center\"><strong>Continue reading&#8230;&#8230;&#8230;<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-pc-zippo wp-block-embed-pc-zippo wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"6IDhWOsOqg\"><a href=\"https:\/\/pczippo.com\/tech\/how-to-check-which-gpu-is-in-your-system-6-easy-steps\/\">How To Check Which GPU Is In Your System \u2013 6 Easy Steps<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;How To Check Which GPU Is In Your System \u2013 6 Easy Steps&#8221; &#8212; PC Zippo\" src=\"https:\/\/pczippo.com\/tech\/how-to-check-which-gpu-is-in-your-system-6-easy-steps\/embed\/#?secret=V6QAZM77PQ#?secret=6IDhWOsOqg\" data-secret=\"6IDhWOsOqg\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Complex queries might be scary, but this guide will show you how to work more readily with SQL queries. SQL Queries, which stands for Structured Query Language, is a programming language that is used to manage and manipulate data in a relational database management system (RDBMS). It is a widely used language in many organizations [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4327,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[22],"tags":[516,517,518,519,520,521,522,523,524,495],"class_list":{"0":"post-4298","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-tech","8":"tag-codingbeginner","9":"tag-databaselearning","10":"tag-datascience","11":"tag-learncoding","12":"tag-programmingguide","13":"tag-sqlqueries","14":"tag-sqltutorial","15":"tag-startfromscratch","16":"tag-techeducation","17":"tag-techskills","18":"entry"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Start from Scratch: A Step-by-Step Guide for Learning SQL Queries - PCZIPPO<\/title>\n<meta name=\"description\" content=\"Master SQL with ease! Begin your journey with &#039;Start from Scratch,&#039; a step-by-step guide for learning SQL queries. Level up in 120 characters!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pczippo.com\/tech\/start-from-scratch-a-step-by-step-guide-for-learning-sql-queries\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Start from Scratch: A Step-by-Step Guide for Learning SQL Queries - PCZIPPO\" \/>\n<meta property=\"og:description\" content=\"Master SQL with ease! Begin your journey with &#039;Start from Scratch,&#039; a step-by-step guide for learning SQL queries. Level up in 120 characters!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pczippo.com\/tech\/start-from-scratch-a-step-by-step-guide-for-learning-sql-queries\/\" \/>\n<meta property=\"og:site_name\" content=\"PCZIPPO\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-02T09:14:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pczippo.com\/wp-content\/uploads\/2024\/02\/main-1-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1456\" \/>\n\t<meta property=\"og:image:height\" content=\"816\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/pczippo.com\/tech\/start-from-scratch-a-step-by-step-guide-for-learning-sql-queries\/\",\"url\":\"https:\/\/pczippo.com\/tech\/start-from-scratch-a-step-by-step-guide-for-learning-sql-queries\/\",\"name\":\"Start from Scratch: A Step-by-Step Guide for Learning SQL Queries - PCZIPPO\",\"isPartOf\":{\"@id\":\"https:\/\/pczippo.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/pczippo.com\/tech\/start-from-scratch-a-step-by-step-guide-for-learning-sql-queries\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/pczippo.com\/tech\/start-from-scratch-a-step-by-step-guide-for-learning-sql-queries\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pczippo.com\/wp-content\/uploads\/2024\/02\/main-1-1.jpg\",\"datePublished\":\"2024-02-02T09:14:39+00:00\",\"author\":{\"@id\":\"https:\/\/pczippo.com\/#\/schema\/person\/9020a73457220b1cc2efee969f1530ec\"},\"description\":\"Master SQL with ease! Begin your journey with 'Start from Scratch,' a step-by-step guide for learning SQL queries. Level up in 120 characters!\",\"breadcrumb\":{\"@id\":\"https:\/\/pczippo.com\/tech\/start-from-scratch-a-step-by-step-guide-for-learning-sql-queries\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/pczippo.com\/tech\/start-from-scratch-a-step-by-step-guide-for-learning-sql-queries\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/pczippo.com\/tech\/start-from-scratch-a-step-by-step-guide-for-learning-sql-queries\/#primaryimage\",\"url\":\"https:\/\/pczippo.com\/wp-content\/uploads\/2024\/02\/main-1-1.jpg\",\"contentUrl\":\"https:\/\/pczippo.com\/wp-content\/uploads\/2024\/02\/main-1-1.jpg\",\"width\":1456,\"height\":816,\"caption\":\"SQL Queries\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/pczippo.com\/tech\/start-from-scratch-a-step-by-step-guide-for-learning-sql-queries\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/pczippo.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Start from Scratch: A Step-by-Step Guide for Learning SQL Queries\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/pczippo.com\/#website\",\"url\":\"https:\/\/pczippo.com\/\",\"name\":\"PCZIPPO\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/pczippo.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/pczippo.com\/#\/schema\/person\/9020a73457220b1cc2efee969f1530ec\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/pczippo.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9f7565c1ae2b2c876509cf71a9bcc2b235b05eff93078c5475c473fcfb168cc6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9f7565c1ae2b2c876509cf71a9bcc2b235b05eff93078c5475c473fcfb168cc6?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/pczippo.com\"],\"url\":\"https:\/\/pczippo.com\/author\/intowninfotech_w6\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Start from Scratch: A Step-by-Step Guide for Learning SQL Queries - PCZIPPO","description":"Master SQL with ease! Begin your journey with 'Start from Scratch,' a step-by-step guide for learning SQL queries. Level up in 120 characters!","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:\/\/pczippo.com\/tech\/start-from-scratch-a-step-by-step-guide-for-learning-sql-queries\/","og_locale":"en_US","og_type":"article","og_title":"Start from Scratch: A Step-by-Step Guide for Learning SQL Queries - PCZIPPO","og_description":"Master SQL with ease! Begin your journey with 'Start from Scratch,' a step-by-step guide for learning SQL queries. Level up in 120 characters!","og_url":"https:\/\/pczippo.com\/tech\/start-from-scratch-a-step-by-step-guide-for-learning-sql-queries\/","og_site_name":"PCZIPPO","article_published_time":"2024-02-02T09:14:39+00:00","og_image":[{"width":1456,"height":816,"url":"https:\/\/pczippo.com\/wp-content\/uploads\/2024\/02\/main-1-1.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/pczippo.com\/tech\/start-from-scratch-a-step-by-step-guide-for-learning-sql-queries\/","url":"https:\/\/pczippo.com\/tech\/start-from-scratch-a-step-by-step-guide-for-learning-sql-queries\/","name":"Start from Scratch: A Step-by-Step Guide for Learning SQL Queries - PCZIPPO","isPartOf":{"@id":"https:\/\/pczippo.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pczippo.com\/tech\/start-from-scratch-a-step-by-step-guide-for-learning-sql-queries\/#primaryimage"},"image":{"@id":"https:\/\/pczippo.com\/tech\/start-from-scratch-a-step-by-step-guide-for-learning-sql-queries\/#primaryimage"},"thumbnailUrl":"https:\/\/pczippo.com\/wp-content\/uploads\/2024\/02\/main-1-1.jpg","datePublished":"2024-02-02T09:14:39+00:00","author":{"@id":"https:\/\/pczippo.com\/#\/schema\/person\/9020a73457220b1cc2efee969f1530ec"},"description":"Master SQL with ease! Begin your journey with 'Start from Scratch,' a step-by-step guide for learning SQL queries. Level up in 120 characters!","breadcrumb":{"@id":"https:\/\/pczippo.com\/tech\/start-from-scratch-a-step-by-step-guide-for-learning-sql-queries\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pczippo.com\/tech\/start-from-scratch-a-step-by-step-guide-for-learning-sql-queries\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pczippo.com\/tech\/start-from-scratch-a-step-by-step-guide-for-learning-sql-queries\/#primaryimage","url":"https:\/\/pczippo.com\/wp-content\/uploads\/2024\/02\/main-1-1.jpg","contentUrl":"https:\/\/pczippo.com\/wp-content\/uploads\/2024\/02\/main-1-1.jpg","width":1456,"height":816,"caption":"SQL Queries"},{"@type":"BreadcrumbList","@id":"https:\/\/pczippo.com\/tech\/start-from-scratch-a-step-by-step-guide-for-learning-sql-queries\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pczippo.com\/"},{"@type":"ListItem","position":2,"name":"Start from Scratch: A Step-by-Step Guide for Learning SQL Queries"}]},{"@type":"WebSite","@id":"https:\/\/pczippo.com\/#website","url":"https:\/\/pczippo.com\/","name":"PCZIPPO","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pczippo.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/pczippo.com\/#\/schema\/person\/9020a73457220b1cc2efee969f1530ec","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pczippo.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9f7565c1ae2b2c876509cf71a9bcc2b235b05eff93078c5475c473fcfb168cc6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9f7565c1ae2b2c876509cf71a9bcc2b235b05eff93078c5475c473fcfb168cc6?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/pczippo.com"],"url":"https:\/\/pczippo.com\/author\/intowninfotech_w6\/"}]}},"featured_image_src":"https:\/\/pczippo.com\/wp-content\/uploads\/2024\/02\/main-1-1.jpg","featured_image_src_square":"https:\/\/pczippo.com\/wp-content\/uploads\/2024\/02\/main-1-1.jpg","author_info":{"display_name":"admin","author_link":"https:\/\/pczippo.com\/author\/intowninfotech_w6\/"},"_links":{"self":[{"href":"https:\/\/pczippo.com\/wp-json\/wp\/v2\/posts\/4298","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pczippo.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pczippo.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pczippo.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pczippo.com\/wp-json\/wp\/v2\/comments?post=4298"}],"version-history":[{"count":0,"href":"https:\/\/pczippo.com\/wp-json\/wp\/v2\/posts\/4298\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pczippo.com\/wp-json\/wp\/v2\/media\/4327"}],"wp:attachment":[{"href":"https:\/\/pczippo.com\/wp-json\/wp\/v2\/media?parent=4298"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pczippo.com\/wp-json\/wp\/v2\/categories?post=4298"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pczippo.com\/wp-json\/wp\/v2\/tags?post=4298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}