{"id":81,"date":"2026-03-06T06:33:24","date_gmt":"2026-03-06T06:33:24","guid":{"rendered":"https:\/\/gigz.pk\/sql\/?post_type=lesson&#038;p=81"},"modified":"2026-03-16T18:51:04","modified_gmt":"2026-03-16T18:51:04","slug":"subquerier","status":"publish","type":"lesson","link":"https:\/\/gigz.pk\/sql\/lesson\/subquerier\/","title":{"rendered":"\u00a0Subquerier"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Subquerier is a platform designed to help users efficiently query, analyze, and manage data from multiple sources. This guide will walk you through the key features, functions, and best practices for using Subquerier effectively.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>1. Logging In<\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open your web browser and go to the Subquerier website.<\/li>\n\n\n\n<li>Enter your registered email address and password.<\/li>\n\n\n\n<li>Click <strong>Login<\/strong> to access the dashboard.<\/li>\n\n\n\n<li>If you forget your password, use the <strong>Forgot Password<\/strong> link to reset it.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>2. Dashboard Overview<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The dashboard provides a summary of your data queries and activity. Key sections include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Recent Queries<\/strong>: Displays your latest executed queries.<\/li>\n\n\n\n<li><strong>Saved Queries<\/strong>: Shows queries you have saved for future use.<\/li>\n\n\n\n<li><strong>Analytics Summary<\/strong>: Provides an overview of query performance and results.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>3. Creating a Query<\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Click <strong>New Query<\/strong> on the dashboard.<\/li>\n\n\n\n<li>Select the <strong>data source<\/strong> you want to query.<\/li>\n\n\n\n<li>Enter your query using the provided query builder or SQL editor.<\/li>\n\n\n\n<li>Click <strong>Run<\/strong> to execute the query.<\/li>\n\n\n\n<li>View results in the output panel.<\/li>\n\n\n\n<li>Save the query for future use if needed.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>4. Editing and Managing Queries<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>To <strong>edit<\/strong> a query, select it from your saved queries list and click <strong>Edit<\/strong>.<\/li>\n\n\n\n<li>To <strong>delete<\/strong> a query, select the query and click <strong>Delete<\/strong>.<\/li>\n\n\n\n<li>Use <strong>tags<\/strong> or <strong>folders<\/strong> to organize queries for easier access.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>5. Exporting Query Results<\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>After running a query, click <strong>Export<\/strong>.<\/li>\n\n\n\n<li>Choose the file format: CSV, Excel, or JSON.<\/li>\n\n\n\n<li>Click <strong>Download<\/strong> to save the results to your device.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>6. Using Filters<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Filters help refine your data queries:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Add <strong>conditions<\/strong> such as date ranges, categories, or numerical values.<\/li>\n\n\n\n<li>Combine multiple filters using AND\/OR operators.<\/li>\n\n\n\n<li>Preview filtered results before saving or exporting.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>7. Collaboration<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Subquerier allows team collaboration:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Share saved queries with team members via email or platform links.<\/li>\n\n\n\n<li>Set <strong>permissions<\/strong> to allow viewing or editing.<\/li>\n\n\n\n<li>Comment on queries for better collaboration and discussion.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>8. Tips &amp; Best Practices<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Always <strong>save queries<\/strong> for future reference.<\/li>\n\n\n\n<li>Use <strong>descriptive names<\/strong> for queries and tags.<\/li>\n\n\n\n<li>Regularly <strong>review and clean up<\/strong> unused queries to keep your workspace organized.<\/li>\n\n\n\n<li>Test complex queries with smaller data sets first.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>9. Support<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Access the <strong>Help Center<\/strong> from the dashboard for tutorials and FAQs.<\/li>\n\n\n\n<li>Contact Subquerier support through the <strong>Support<\/strong> link for technical assistance.<\/li>\n<\/ul>\n\n\n<div class=\"yoast-breadcrumbs\"><span><span><a href=\"https:\/\/gigz.pk\/sql\/\">Home<\/a><\/span> \u00bb <span class=\"breadcrumb_last\" aria-current=\"page\">Intermediate SQL for Data Professionals (SQL-201) >Advanced Joins &#038; Subqueries > Subquerier<\/span><\/span><\/div>\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block\"><div class=\"schema-faq-section\" id=\"faq-question-1773686027926\"><strong class=\"schema-faq-question\"><\/strong> <p class=\"schema-faq-answer\"><\/p> <\/div> <\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"menu_order":29,"template":"","class_list":["post-81","lesson","type-lesson","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u00a0Subquerier - SQL Learning Hub<\/title>\n<meta name=\"description\" content=\"&quot;Subquerier helps you efficiently run, analyze, and manage SQL queries from multiple data sources with collaboration tools.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/gigz.pk\/sql\/lesson\/subquerier\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00a0Subquerier - SQL Learning Hub\" \/>\n<meta property=\"og:description\" content=\"&quot;Subquerier helps you efficiently run, analyze, and manage SQL queries from multiple data sources with collaboration tools.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/gigz.pk\/sql\/lesson\/subquerier\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Learning Hub\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-16T18:51:04+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\\\/\\\/gigz.pk\\\/sql\\\/lesson\\\/subquerier\\\/\",\"url\":\"https:\\\/\\\/gigz.pk\\\/sql\\\/lesson\\\/subquerier\\\/\",\"name\":\"\u00a0Subquerier - SQL Learning Hub\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/gigz.pk\\\/sql\\\/#website\"},\"datePublished\":\"2026-03-06T06:33:24+00:00\",\"dateModified\":\"2026-03-16T18:51:04+00:00\",\"description\":\"\\\"Subquerier helps you efficiently run, analyze, and manage SQL queries from multiple data sources with collaboration tools.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/gigz.pk\\\/sql\\\/lesson\\\/subquerier\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/gigz.pk\\\/sql\\\/lesson\\\/subquerier\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/gigz.pk\\\/sql\\\/lesson\\\/subquerier\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/gigz.pk\\\/sql\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Intermediate SQL for Data Professionals (SQL-201) >Advanced Joins & Subqueries > Subquerier\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/gigz.pk\\\/sql\\\/#website\",\"url\":\"https:\\\/\\\/gigz.pk\\\/sql\\\/\",\"name\":\"SQL Learning Hub\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/gigz.pk\\\/sql\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00a0Subquerier - SQL Learning Hub","description":"\"Subquerier helps you efficiently run, analyze, and manage SQL queries from multiple data sources with collaboration tools.","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:\/\/gigz.pk\/sql\/lesson\/subquerier\/","og_locale":"en_US","og_type":"article","og_title":"\u00a0Subquerier - SQL Learning Hub","og_description":"\"Subquerier helps you efficiently run, analyze, and manage SQL queries from multiple data sources with collaboration tools.","og_url":"https:\/\/gigz.pk\/sql\/lesson\/subquerier\/","og_site_name":"SQL Learning Hub","article_modified_time":"2026-03-16T18:51:04+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["WebPage","FAQPage"],"@id":"https:\/\/gigz.pk\/sql\/lesson\/subquerier\/","url":"https:\/\/gigz.pk\/sql\/lesson\/subquerier\/","name":"\u00a0Subquerier - SQL Learning Hub","isPartOf":{"@id":"https:\/\/gigz.pk\/sql\/#website"},"datePublished":"2026-03-06T06:33:24+00:00","dateModified":"2026-03-16T18:51:04+00:00","description":"\"Subquerier helps you efficiently run, analyze, and manage SQL queries from multiple data sources with collaboration tools.","breadcrumb":{"@id":"https:\/\/gigz.pk\/sql\/lesson\/subquerier\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/gigz.pk\/sql\/lesson\/subquerier\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/gigz.pk\/sql\/lesson\/subquerier\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/gigz.pk\/sql\/"},{"@type":"ListItem","position":2,"name":"Intermediate SQL for Data Professionals (SQL-201) >Advanced Joins & Subqueries > Subquerier"}]},{"@type":"WebSite","@id":"https:\/\/gigz.pk\/sql\/#website","url":"https:\/\/gigz.pk\/sql\/","name":"SQL Learning Hub","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/gigz.pk\/sql\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/gigz.pk\/sql\/wp-json\/wp\/v2\/lesson\/81","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gigz.pk\/sql\/wp-json\/wp\/v2\/lesson"}],"about":[{"href":"https:\/\/gigz.pk\/sql\/wp-json\/wp\/v2\/types\/lesson"}],"wp:attachment":[{"href":"https:\/\/gigz.pk\/sql\/wp-json\/wp\/v2\/media?parent=81"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}