{"id":1424,"date":"2024-05-27T11:11:27","date_gmt":"2024-05-27T11:11:27","guid":{"rendered":"https:\/\/dotlabs.ai\/blogs\/?p=1424"},"modified":"2024-05-27T13:56:13","modified_gmt":"2024-05-27T13:56:13","slug":"fundamentals-of-sql-for-data-engineering","status":"publish","type":"post","link":"https:\/\/dotlabs.ai\/blogs\/2024\/05\/27\/fundamentals-of-sql-for-data-engineering\/","title":{"rendered":"Mastering SQL for Data Engineering: Essential Fundamentals and Queries"},"content":{"rendered":"\n


<\/p>\n\n\n

Are\nyou ready to dive into the world of data engineering? SQL (Structured Query\nLanguage) is a foundational tool that every aspiring data engineer should\nmaster. Whether you’re just starting out or looking to brush up on your skills,\nthis guide will walk you through the fundamentals of SQL and equip you with the\nknowledge to write powerful queries for data manipulation and analysis.

<\/o:p><\/span><\/p>\n

Why SQL?<\/o:p><\/span><\/h2>\n

SQL\nis the language of databases, allowing users to interact with and manage data\neffectively. As a data engineer, proficiency in SQL is essential for tasks such\nas data extraction, transformation, and loading (ETL<\/strong>), data modeling, and querying large datasets.

<\/o:p><\/span><\/p>\n

Getting\nStarted<\/o:p><\/span><\/h2>\n

Let’s\nstart with the basics. SQL operates through commands known as queries, which\nare used to retrieve, manipulate, and manage data stored in relational\ndatabases. The primary components of SQL queries include:
<\/span><\/p>

<\/span><\/p>\n\n\n

SELECT:
FROM:
WHERE:
GROUP BY:
HAVING:
ORDER BY:
JOIN:<\/strong>
<\/p>\n\n\n

Used to retrieve data from one or more database tables.<\/span>
<\/span><\/p>

Specifies the table(s) from which to retrieve data.<\/span>
<\/span>Filters data based on specified conditions.<\/span>
<\/span>Groups rows that have the same values into summary rows.<\/span>
<\/span>Filters group rows that do not satisfy a specified condition.<\/span>
<\/span>Sorts the result set in ascending or descending order.<\/span>
<\/span>Combines rows from two or more tables based on a related column between them.<\/span><\/span><\/p>\n\n\n

Let’s\nwalk through some examples to illustrate these concepts:
<\/span>
<\/span><\/strong><\/p>

1. SELECT Statement:

<\/o:p><\/span><\/h3>\n

Case:<\/strong> Enrollment\nin local colleges, 2005

<\/span><\/o:p><\/span><\/p>\n\n\n
\n

SQL<\/o:p><\/span><\/strong><\/p>\n<\/td>\n<\/tr>\n

\n

SELECT\n*<\/span> <\/o:p><\/span><\/p>\n

FROM <\/span>employees;<\/font>

<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody><\/table>\n

This\nquery retrieves all columns from the ’employees’ table.<\/o:p><\/span><\/p>

\n\n<\/p>

The\n\u201c*<\/b>\u201d Asterisk<\/b> in the SQL query refers to all the columns and rows in the\ntable. While the \u201cFROM<\/b>\u201d statement\nrefers to the table from where the data needs to be fetched.

<\/o:p><\/span><\/p>\n

2. Filtering with WHERE\nClause:
<\/span>
<\/span><\/h3>\n \n \n
\n

SQL<\/o:p><\/span><\/strong><\/p>\n <\/td>\n <\/tr>\n

\n

<\/span><\/p>

SELECT\n * FROM orders <\/o:p><\/span><\/p>\n

<\/p><\/span>

WHERE <\/span>order_date\n >= ‘2023-01-01’;<\/span> <\/o:p><\/span><\/p>\n <\/td>\n <\/tr>\n<\/tbody><\/table>\n

This\nquery retrieves orders placed after January 1, 2023.

<\/o:p><\/span><\/p>

\n\n<\/p>

In\nthis query there is a condition implied in the statement posing a condition to\nselect all the data from the orders table where<\/b>\nthe ordering date is 1 January 2023.

<\/o:p><\/span><\/p>\n

3. Aggregating Data with\nGROUP BY:

<\/o:p><\/span><\/h3>\n \n \n
\n

SQL<\/o:p><\/span><\/strong><\/p>\n <\/td>\n <\/tr>\n

\n

<\/span><\/p>

SELECT\n department_id, COUNT(*) AS employee_count <\/o:p><\/span><\/p>\n

<\/p><\/span>

FROM <\/span>employees<\/span>\n <\/o:p><\/span><\/p>\n

GROUP BY <\/span>department_id;<\/span>\n <\/o:p><\/span><\/p>\n <\/td>\n <\/tr>\n<\/tbody><\/table>\n

This\nquery counts the number of employees in each department.<\/o:p><\/span><\/p>

\n\n<\/p>

Here\nwe see that we have selected the \u201cdepartment_id<\/b>\u201d\ncolumn. The Count (*)<\/b> function in\nthis query prompts to count the number of entries (here in this scenario the\nnumber of employees in each department as we have added the Alias function AS employee_count<\/b>) from the Employees\nTable. Then the employees are grouped according to their department ids.

<\/o:p><\/span><\/p>\n

4. Joining Tables:

<\/o:p><\/span><\/h3>\n \n \n
\n

SQL<\/o:p><\/span><\/strong><\/p>\n <\/td>\n <\/tr>\n

\n

<\/span><\/p>

SELECT\n e.employee_id, e.first_name, e.last_name, d.department_name <\/o:p><\/span><\/p>\n

<\/p><\/span>

FROM <\/span>employees\n e<\/span> <\/o:p><\/span><\/p>\n

JOIN <\/span>departments\n d ON e.department_id = d.department_id;<\/span> <\/o:p><\/span><\/p>\n <\/td>\n <\/tr>\n<\/tbody><\/table>\n

This\nquery retrieves employee details along with their department names by joining\nthe ’employees’ and ‘departments’ tables.

<\/o:p><\/span><\/p>

This\nSQL query retrieves data about employees along with the department they belong\nto. It selects the employee_id<\/strong>, first_name<\/strong>, and last_name<\/strong>\ncolumns from the employees<\/strong> table and the department_name<\/strong> column\nfrom the departments<\/strong> table. It then joins the two tables based on the department_id<\/strong>\ncolumn to associate each employee with their respective department using the\nInner JOIN function.

<\/o:p><\/strong><\/span><\/p>

Congratulations!\nYou’ve taken your first steps into the world of SQL for data engineering. By\nmastering these fundamentals and practicing regularly, you’ll be well-equipped\nto handle a variety of data-related tasks and contribute effectively to\ndata-driven projects.

<\/o:p><\/strong><\/span><\/p>

Remember,\nSQL is a powerful tool with endless possibilities. As you continue your\njourney, don’t hesitate to explore advanced topics such as subqueries, window\nfunctions, and performance optimization to further enhance your skills.<\/o:p><\/span><\/p>

\n\n\n\n\n\n\n\n<\/p>

To\nlearn more about technology, read through our blogs on our official blogging\nwebsite <\/span>www.dotlabs.ai\/blogs\/<\/span><\/a>.

<\/o:p><\/span><\/p>\n\n

Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s.<\/p>\n

<\/span><\/p>

<\/span><\/p>

<\/span><\/p>

Dot Labs is an IT\noutsourcing firm that offers a range of services, including software\ndevelopment, quality assurance, and data analytics. With a team of skilled\nprofessionals, Dot Labs offers nearshoring services to companies in North\nAmerica, providing cost savings while ensuring effective communication and\ncollaboration.

<\/o:p><\/span><\/p>

Visit our website: <\/span>www.dotlabs.ai<\/span><\/a>, for more information on how Dot\nLabs can help your business with its IT outsourcing needs.

<\/o:p><\/span><\/p>

\n<\/p>

For more informative\nBlogs on the latest technologies and trends <\/span>click\nhere<\/span><\/a><\/p><\/span><\/p>

<\/span><\/a><\/p>

<\/p>

<\/span><\/a><\/o:p><\/span><\/p>\n\n\n\n\n\n\n","protected":false},"excerpt":{"rendered":"

Explore the intricacies of Medallion Architecture’s Bronze, Silver, and Gold layers in data lake-houses, uncovering theoretical concepts, practical applications, and technology considerations for optimal data management and integration.<\/p>\n","protected":false},"author":2,"featured_media":1443,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"pagelayer_contact_templates":[],"_pagelayer_content":"","footnotes":""},"categories":[38,37],"tags":[],"class_list":["post-1424","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-educational","category-tutorial"],"yoast_head":"\nFundamentals of SQL for Data Engineering | Dot Labs<\/title>\n<meta name=\"description\" content=\"Getting started with SQL for Data Engineering. Learn the fundamentals of SQL and some of the most essential Queries used in SQL in this blog.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dotlabs.ai\/blogs\/2024\/05\/27\/fundamentals-of-sql-for-data-engineering\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fundamentals of SQL for Data Engineering | Dot Labs\" \/>\n<meta property=\"og:description\" content=\"Getting started with SQL for Data Engineering. Learn the fundamentals of SQL and some of the most essential Queries used in SQL in this blog.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dotlabs.ai\/blogs\/2024\/05\/27\/fundamentals-of-sql-for-data-engineering\/\" \/>\n<meta property=\"og:site_name\" content=\"Dot Blogs\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dotlabsai\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-27T11:11:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-27T13:56:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dotlabs.ai\/blogs\/wp-content\/uploads\/2024\/05\/image-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"5836\" \/>\n\t<meta property=\"og:image:height\" content=\"3080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Basim Khan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Basim Khan\" \/>\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\":\"Article\",\"@id\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/2024\\\/05\\\/27\\\/fundamentals-of-sql-for-data-engineering\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/2024\\\/05\\\/27\\\/fundamentals-of-sql-for-data-engineering\\\/\"},\"author\":{\"name\":\"Basim Khan\",\"@id\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/#\\\/schema\\\/person\\\/78401fb87235f953b1737839e409b455\"},\"headline\":\"Mastering SQL for Data Engineering: Essential Fundamentals and Queries\",\"datePublished\":\"2024-05-27T11:11:27+00:00\",\"dateModified\":\"2024-05-27T13:56:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/2024\\\/05\\\/27\\\/fundamentals-of-sql-for-data-engineering\\\/\"},\"wordCount\":722,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/2024\\\/05\\\/27\\\/fundamentals-of-sql-for-data-engineering\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/image-2.png\",\"articleSection\":[\"Educational\",\"Tutorial\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/2024\\\/05\\\/27\\\/fundamentals-of-sql-for-data-engineering\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/2024\\\/05\\\/27\\\/fundamentals-of-sql-for-data-engineering\\\/\",\"url\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/2024\\\/05\\\/27\\\/fundamentals-of-sql-for-data-engineering\\\/\",\"name\":\"Fundamentals of SQL for Data Engineering | Dot Labs\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/2024\\\/05\\\/27\\\/fundamentals-of-sql-for-data-engineering\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/2024\\\/05\\\/27\\\/fundamentals-of-sql-for-data-engineering\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/image-2.png\",\"datePublished\":\"2024-05-27T11:11:27+00:00\",\"dateModified\":\"2024-05-27T13:56:13+00:00\",\"description\":\"Getting started with SQL for Data Engineering. Learn the fundamentals of SQL and some of the most essential Queries used in SQL in this blog.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/2024\\\/05\\\/27\\\/fundamentals-of-sql-for-data-engineering\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/2024\\\/05\\\/27\\\/fundamentals-of-sql-for-data-engineering\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/2024\\\/05\\\/27\\\/fundamentals-of-sql-for-data-engineering\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/image-2.png\",\"contentUrl\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/image-2.png\",\"width\":5836,\"height\":3080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/2024\\\/05\\\/27\\\/fundamentals-of-sql-for-data-engineering\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mastering SQL for Data Engineering: Essential Fundamentals and Queries\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/#website\",\"url\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/\",\"name\":\"Dot Blogs\",\"description\":\"A Technology Company\",\"publisher\":{\"@id\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/#organization\",\"name\":\"Dot Labs\",\"url\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/cropped-BlogsLogo_Gray_TransparentBG_Width320.png.png\",\"contentUrl\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/cropped-BlogsLogo_Gray_TransparentBG_Width320.png.png\",\"width\":320,\"height\":68,\"caption\":\"Dot Labs\"},\"image\":{\"@id\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dotlabsai\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dotlabs-ai\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/#\\\/schema\\\/person\\\/78401fb87235f953b1737839e409b455\",\"name\":\"Basim Khan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/wp-content\\\/litespeed\\\/avatar\\\/fe70d225f8e3da97115062685a8b183f.jpg?ver=1776875138\",\"url\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/wp-content\\\/litespeed\\\/avatar\\\/fe70d225f8e3da97115062685a8b183f.jpg?ver=1776875138\",\"contentUrl\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/wp-content\\\/litespeed\\\/avatar\\\/fe70d225f8e3da97115062685a8b183f.jpg?ver=1776875138\",\"caption\":\"Basim Khan\"},\"sameAs\":[\"http:\\\/\\\/www.dotlabs.ai\"],\"url\":\"https:\\\/\\\/dotlabs.ai\\\/blogs\\\/author\\\/basim-khan\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fundamentals of SQL for Data Engineering | Dot Labs","description":"Getting started with SQL for Data Engineering. Learn the fundamentals of SQL and some of the most essential Queries used in SQL in this blog.","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:\/\/dotlabs.ai\/blogs\/2024\/05\/27\/fundamentals-of-sql-for-data-engineering\/","og_locale":"en_US","og_type":"article","og_title":"Fundamentals of SQL for Data Engineering | Dot Labs","og_description":"Getting started with SQL for Data Engineering. Learn the fundamentals of SQL and some of the most essential Queries used in SQL in this blog.","og_url":"https:\/\/dotlabs.ai\/blogs\/2024\/05\/27\/fundamentals-of-sql-for-data-engineering\/","og_site_name":"Dot Blogs","article_publisher":"https:\/\/www.facebook.com\/dotlabsai","article_published_time":"2024-05-27T11:11:27+00:00","article_modified_time":"2024-05-27T13:56:13+00:00","og_image":[{"width":5836,"height":3080,"url":"https:\/\/dotlabs.ai\/blogs\/wp-content\/uploads\/2024\/05\/image-2.png","type":"image\/png"}],"author":"Basim Khan","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Basim Khan","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dotlabs.ai\/blogs\/2024\/05\/27\/fundamentals-of-sql-for-data-engineering\/#article","isPartOf":{"@id":"https:\/\/dotlabs.ai\/blogs\/2024\/05\/27\/fundamentals-of-sql-for-data-engineering\/"},"author":{"name":"Basim Khan","@id":"https:\/\/dotlabs.ai\/blogs\/#\/schema\/person\/78401fb87235f953b1737839e409b455"},"headline":"Mastering SQL for Data Engineering: Essential Fundamentals and Queries","datePublished":"2024-05-27T11:11:27+00:00","dateModified":"2024-05-27T13:56:13+00:00","mainEntityOfPage":{"@id":"https:\/\/dotlabs.ai\/blogs\/2024\/05\/27\/fundamentals-of-sql-for-data-engineering\/"},"wordCount":722,"commentCount":0,"publisher":{"@id":"https:\/\/dotlabs.ai\/blogs\/#organization"},"image":{"@id":"https:\/\/dotlabs.ai\/blogs\/2024\/05\/27\/fundamentals-of-sql-for-data-engineering\/#primaryimage"},"thumbnailUrl":"https:\/\/dotlabs.ai\/blogs\/wp-content\/uploads\/2024\/05\/image-2.png","articleSection":["Educational","Tutorial"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dotlabs.ai\/blogs\/2024\/05\/27\/fundamentals-of-sql-for-data-engineering\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dotlabs.ai\/blogs\/2024\/05\/27\/fundamentals-of-sql-for-data-engineering\/","url":"https:\/\/dotlabs.ai\/blogs\/2024\/05\/27\/fundamentals-of-sql-for-data-engineering\/","name":"Fundamentals of SQL for Data Engineering | Dot Labs","isPartOf":{"@id":"https:\/\/dotlabs.ai\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dotlabs.ai\/blogs\/2024\/05\/27\/fundamentals-of-sql-for-data-engineering\/#primaryimage"},"image":{"@id":"https:\/\/dotlabs.ai\/blogs\/2024\/05\/27\/fundamentals-of-sql-for-data-engineering\/#primaryimage"},"thumbnailUrl":"https:\/\/dotlabs.ai\/blogs\/wp-content\/uploads\/2024\/05\/image-2.png","datePublished":"2024-05-27T11:11:27+00:00","dateModified":"2024-05-27T13:56:13+00:00","description":"Getting started with SQL for Data Engineering. Learn the fundamentals of SQL and some of the most essential Queries used in SQL in this blog.","breadcrumb":{"@id":"https:\/\/dotlabs.ai\/blogs\/2024\/05\/27\/fundamentals-of-sql-for-data-engineering\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dotlabs.ai\/blogs\/2024\/05\/27\/fundamentals-of-sql-for-data-engineering\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dotlabs.ai\/blogs\/2024\/05\/27\/fundamentals-of-sql-for-data-engineering\/#primaryimage","url":"https:\/\/dotlabs.ai\/blogs\/wp-content\/uploads\/2024\/05\/image-2.png","contentUrl":"https:\/\/dotlabs.ai\/blogs\/wp-content\/uploads\/2024\/05\/image-2.png","width":5836,"height":3080},{"@type":"BreadcrumbList","@id":"https:\/\/dotlabs.ai\/blogs\/2024\/05\/27\/fundamentals-of-sql-for-data-engineering\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dotlabs.ai\/blogs\/"},{"@type":"ListItem","position":2,"name":"Mastering SQL for Data Engineering: Essential Fundamentals and Queries"}]},{"@type":"WebSite","@id":"https:\/\/dotlabs.ai\/blogs\/#website","url":"https:\/\/dotlabs.ai\/blogs\/","name":"Dot Blogs","description":"A Technology Company","publisher":{"@id":"https:\/\/dotlabs.ai\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dotlabs.ai\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dotlabs.ai\/blogs\/#organization","name":"Dot Labs","url":"https:\/\/dotlabs.ai\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dotlabs.ai\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/dotlabs.ai\/blogs\/wp-content\/uploads\/2023\/04\/cropped-BlogsLogo_Gray_TransparentBG_Width320.png.png","contentUrl":"https:\/\/dotlabs.ai\/blogs\/wp-content\/uploads\/2023\/04\/cropped-BlogsLogo_Gray_TransparentBG_Width320.png.png","width":320,"height":68,"caption":"Dot Labs"},"image":{"@id":"https:\/\/dotlabs.ai\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dotlabsai","https:\/\/www.linkedin.com\/company\/dotlabs-ai"]},{"@type":"Person","@id":"https:\/\/dotlabs.ai\/blogs\/#\/schema\/person\/78401fb87235f953b1737839e409b455","name":"Basim Khan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dotlabs.ai\/blogs\/wp-content\/litespeed\/avatar\/fe70d225f8e3da97115062685a8b183f.jpg?ver=1776875138","url":"https:\/\/dotlabs.ai\/blogs\/wp-content\/litespeed\/avatar\/fe70d225f8e3da97115062685a8b183f.jpg?ver=1776875138","contentUrl":"https:\/\/dotlabs.ai\/blogs\/wp-content\/litespeed\/avatar\/fe70d225f8e3da97115062685a8b183f.jpg?ver=1776875138","caption":"Basim Khan"},"sameAs":["http:\/\/www.dotlabs.ai"],"url":"https:\/\/dotlabs.ai\/blogs\/author\/basim-khan\/"}]}},"_links":{"self":[{"href":"https:\/\/dotlabs.ai\/blogs\/wp-json\/wp\/v2\/posts\/1424","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dotlabs.ai\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dotlabs.ai\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dotlabs.ai\/blogs\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dotlabs.ai\/blogs\/wp-json\/wp\/v2\/comments?post=1424"}],"version-history":[{"count":16,"href":"https:\/\/dotlabs.ai\/blogs\/wp-json\/wp\/v2\/posts\/1424\/revisions"}],"predecessor-version":[{"id":1446,"href":"https:\/\/dotlabs.ai\/blogs\/wp-json\/wp\/v2\/posts\/1424\/revisions\/1446"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dotlabs.ai\/blogs\/wp-json\/wp\/v2\/media\/1443"}],"wp:attachment":[{"href":"https:\/\/dotlabs.ai\/blogs\/wp-json\/wp\/v2\/media?parent=1424"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dotlabs.ai\/blogs\/wp-json\/wp\/v2\/categories?post=1424"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dotlabs.ai\/blogs\/wp-json\/wp\/v2\/tags?post=1424"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}