{"id":12660,"date":"2026-05-31T19:06:27","date_gmt":"2026-05-31T13:36:27","guid":{"rendered":"https:\/\/www.scaler.com\/blog\/?p=12660"},"modified":"2026-07-24T12:45:26","modified_gmt":"2026-07-24T07:15:26","slug":"sql-syllabus","status":"publish","type":"post","link":"https:\/\/www.scaler.com\/blog\/sql-syllabus\/","title":{"rendered":"SQL Syllabus: Full Course Structure & Topics Covered"},"content":{"rendered":"\n

One of the important elements that runs many services and applications online is SQL. Regardless of whether you are buying something, checking your website analytics, booking a place, or even surfing any social networking site, SQL is used to get these done. And precisely because of this, SQL remains one of the most sought-after skills in data analysis, backend development, business intelligence, and software engineering.<\/p>\n\n\n\n

And we also understand that, as a beginner, it gets hard to map out what to learn and how. The way an ideal SQL course would go about doing this is to gradually and progressively lead you through SQL all the way from the fundamentals to the intricate world of SQL window functions, SQL optimizations, reporting, and database design.<\/p>\n\n\n\n

This guide will cover a SQL full course roadmap.<\/p>\n\n\n\n

If you’re just getting started, a dedicated SQL tutorial can help you with your learning: SQL Tutorial<\/a>.<\/p>\n\n\n\n

<\/span>What Is SQL and Why Is It Important?<\/strong><\/span><\/h2>\n\n\n\n

Structured Query Language (SQL) is simply the language for working with databases. Whenever an application requires storing user information, ordering, creating reports, or fetching data, SQL is often used to store, retrieve, and manage this data.<\/p>\n\n\n\n

The first reason why a lot of people start learning SQL is that it has various uses in multiple positions in the IT field. Data analysts will use SQL when creating their reports and dashboards, backend engineers use SQL when managing databases of their applications, and full-stack developers use SQL when developing complete web applications. SQL is often used in testing processes, business intelligence tasks, and during technical interviews.<\/p>\n\n\n\n\nScaler Carousel<\/title>\n\n<!-- Plus Jakarta Sans Font -->\n<link href=\"https:\/\/fonts.googleapis.com\/css2?family=Plus+Jakarta+Sans:wght@400;500;600;700&display=swap\" rel=\"stylesheet\">\n<!-- Swiper CSS -->\n<link rel=\"stylesheet\" href=\"https:\/\/cdn.jsdelivr.net\/npm\/swiper@11\/swiper-bundle.min.css\">\n\n<style>\n.scaler-carousel {\n font-family: 'Plus Jakarta Sans', sans-serif;\n max-width: 900px;\n margin: 24px auto;\n padding: 0;\n box-sizing: border-box;\n}\n.scaler-carousel *,\n.scaler-carousel *::before,\n.scaler-carousel *::after {\n box-sizing: border-box;\n}\n\n\/* Header *\/\n.scaler-header {\n text-align: center;\n margin-bottom: 20px;\n}\n.scaler-header-title {\n font-size: 22px;\n font-weight: 700;\n color: #1a1a2e;\n margin: 0 0 6px;\n line-height: 1.2;\n}\n.scaler-header-subtitle {\n font-size: 14px;\n color: #6b7280;\n margin: 0;\n font-weight: 500;\n}\n\n\/* Swiper *\/\n.swiper.scaler-swiper {\n padding-bottom: 48px;\n}\n.scaler-swiper .swiper-slide {\n height: auto;\n display: flex;\n align-items: stretch;\n}\n\/* Navigation arrows \u2014 styled to match the topics HorizontalScroll controls *\/\n.scaler-swiper .swiper-button-next,\n.scaler-swiper .swiper-button-prev {\n width: 46px;\n height: 46px;\n border-radius: 8px;\n background: #ffffff;\n box-shadow: 0 8px 16px 0 rgba(50, 71, 102, 0.16);\n top: calc(50% - 24px); \/* centre on the cards, ignoring the pagination space below *\/\n transform: translateY(-50%);\n margin-top: 0;\n}\n.scaler-swiper .swiper-button-prev { left: 10px; }\n.scaler-swiper .swiper-button-next { right: 10px; }\n\/* hide Swiper's default font-icon arrow and draw the topics chevron via a mask *\/\n.scaler-swiper .swiper-button-next::after,\n.scaler-swiper .swiper-button-prev::after {\n content: \"\";\n width: 20px;\n height: 20px;\n background-color: #61738e;\n -webkit-mask: url(\"data:image\/svg+xml,%3Csvg xmlns='http:\/\/www.w3.org\/2000\/svg' viewBox='0 0 32 32'%3E%3Cpath d='M5.313 16l10.688-10.688 10.688 10.688-1.938 1.875-7.438-7.438v16.25h-2.625v-16.25l-7.5 7.438z'\/%3E%3C\/svg%3E\") no-repeat center \/ contain;\n mask: url(\"data:image\/svg+xml,%3Csvg xmlns='http:\/\/www.w3.org\/2000\/svg' viewBox='0 0 32 32'%3E%3Cpath d='M5.313 16l10.688-10.688 10.688 10.688-1.938 1.875-7.438-7.438v16.25h-2.625v-16.25l-7.5 7.438z'\/%3E%3C\/svg%3E\") no-repeat center \/ contain;\n}\n.scaler-swiper .swiper-button-prev::after { transform: rotate(-90deg); }\n.scaler-swiper .swiper-button-next::after { transform: rotate(90deg); }\n.scaler-swiper .swiper-button-disabled {\n opacity: 0.35;\n pointer-events: none;\n}\n.scaler-swiper .swiper-pagination-bullet-active {\n background: #255aad;\n}\n\n\/* Card *\/\n.scaler-card {\n display: flex;\n flex-direction: column;\n gap: 14px;\n width: 100%;\n background: #ffffff;\n border: 1px solid #e5e7eb;\n border-radius: 16px;\n padding: 24px;\n box-shadow: 0 2px 8px rgba(0, 0, 0, 0.06);\n transition: box-shadow 0.2s ease;\n}\n.scaler-card:hover {\n box-shadow: 0 6px 16px rgba(0, 0, 0, 0.10);\n}\n\n\/* NSDC badge *\/\n.scaler-badge {\n display: inline-flex;\n align-items: center;\n align-self: flex-start;\n background: #f3f4f6;\n color: #111827;\n font-size: 12px;\n font-weight: 600;\n padding: 4px 10px;\n border-radius: 20px;\n white-space: nowrap;\n letter-spacing: 0.1px;\n}\n\n\/* Top: icon + title + description *\/\n.scaler-card-top {\n display: flex;\n align-items: flex-start;\n gap: 12px;\n min-height: 100px;\n}\n.scaler-icon-wrap {\n display: flex;\n align-items: center;\n justify-content: center;\n width: 64px;\n height: 64px;\n border-radius: 12px;\n background: #f3f4f6;\n color: #374151;\n flex-shrink: 0;\n}\n.scaler-icon-wrap svg {\n width: 26px;\n height: 26px;\n}\n.scaler-card-top-content {\n flex: 1;\n min-width: 0;\n display: flex;\n flex-direction: column;\n gap: 5px;\n}\n.scaler-title {\n font-size: 16px;\n font-weight: 700;\n color: #111827;\n margin: 0;\n line-height: 1.35;\n}\n.scaler-desc {\n font-size: 13px;\n color: #6b7280;\n margin: 0;\n line-height: 1.45;\n}\n\n\/* Stats row *\/\n.scaler-stats {\n display: flex;\n border-top: 1px solid #e5e7eb;\n border-bottom: 1px solid #e5e7eb;\n padding: 12px 0;\n}\n.scaler-stat {\n display: flex;\n flex-direction: column;\n align-items: center;\n gap: 2px;\n flex: 1;\n min-width: 0;\n text-align: center;\n}\n.scaler-stat:not(:last-child) {\n border-right: 1px solid #d1d5db;\n}\n.scaler-stat-value {\n font-size: 14px;\n font-weight: 700;\n color: #111827;\n white-space: nowrap;\n}\n.scaler-stat-label {\n font-size: 12px;\n color: #9ca3af;\n}\n\n\/* Company logos *\/\n.scaler-logos {\n display: flex;\n align-items: center;\n gap: 12px;\n flex-wrap: nowrap;\n}\n.scaler-company-logo {\n height: 20px !important;\n width: auto !important;\n max-width: 70px;\n object-fit: contain;\n display: inline-block;\n}\n.scaler-logo-more {\n font-size: 12px;\n color: #9ca3af;\n white-space: nowrap;\n}\n.scaler-logo-strip {\n display: block;\n width: 100% !important;\n max-width: 100%;\n min-width: 0;\n height: auto !important;\n object-fit: contain;\n}\n\n\/* CTA *\/\n.scaler-card-btns {\n margin-top: auto;\n}\n.scaler-card-btns button {\n display: flex;\n align-items: center;\n justify-content: center;\n gap: 8px;\n width: 100%;\n padding: 12px 16px;\n border: none;\n border-radius: 10px;\n background-color: #255aad;\n color: #ffffff;\n font-family: 'Plus Jakarta Sans', sans-serif;\n font-size: 14px;\n font-weight: 600;\n cursor: pointer;\n text-decoration: none;\n transition: opacity 0.15s ease;\n}\n.scaler-card-btns button:hover,\n.scaler-card-btns button:focus {\n opacity: 0.88;\n color: #ffffff;\n}\n.scaler-card-btns button svg {\n flex-shrink: 0;\n}\n\n@media (max-width: 1000px) {\n .scaler-carousel { max-width: 96vw; }\n}\n<\/style>\n\n\n<div class=\"scaler-carousel\">\n <div class=\"scaler-header\">\n <h2 class=\"scaler-header-title\"><span class=\"ez-toc-section\" id=\"transform-your-career\"><\/span>Transform Your Career<span class=\"ez-toc-section-end\"><\/span><\/h2>\n <p class=\"scaler-header-subtitle\">Choose from our industry-leading programs designed for career success<\/p>\n <\/div>\n\n <div class=\"swiper scaler-swiper\">\n <div class=\"swiper-wrapper\">\n\n <!-- CARD 1 -->\n <div class=\"swiper-slide\">\n <div class=\"scaler-card\">\n <div class=\"scaler-badge\">NSDC Certified<\/div>\n <div class=\"scaler-card-top\">\n <div class=\"scaler-icon-wrap\">\n <svg width=\"26\" height=\"26\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><polyline points=\"16 18 22 12 16 6\"\/><polyline points=\"8 6 2 12 8 18\"\/><\/svg>\n <\/div>\n <div class=\"scaler-card-top-content\">\n <h3 class=\"scaler-title\">Modern Software and AI Engineering Program<\/h3>\n <p class=\"scaler-desc\">Master full-stack development with AI integration<\/p>\n <\/div>\n <\/div>\n <div class=\"scaler-stats\">\n <div class=\"scaler-stat\"><span class=\"scaler-stat-value\">12 Months<\/span><span class=\"scaler-stat-label\">Duration<\/span><\/div>\n <div class=\"scaler-stat\"><span class=\"scaler-stat-value\">AI-Led<\/span><span class=\"scaler-stat-label\">Curriculum<\/span><\/div>\n <div class=\"scaler-stat\"><span class=\"scaler-stat-value\">Career Support<\/span><span class=\"scaler-stat-label\">Support<\/span><\/div>\n <\/div>\n <div class=\"scaler-logos\">\n <img decoding=\"async\" class=\"scaler-company-logo\" src=\"https:\/\/upload.wikimedia.org\/wikipedia\/commons\/2\/2f\/Google_2015_logo.svg\" alt=\"Google\" loading=\"lazy\">\n <img decoding=\"async\" class=\"scaler-company-logo\" src=\"https:\/\/upload.wikimedia.org\/wikipedia\/commons\/a\/a9\/Amazon_logo.svg\" alt=\"Amazon\" loading=\"lazy\">\n <img decoding=\"async\" class=\"scaler-company-logo\" src=\"https:\/\/upload.wikimedia.org\/wikipedia\/commons\/4\/42\/Paytm_logo.png\" alt=\"Paytm\" loading=\"lazy\">\n <span class=\"scaler-logo-more\">+1000 more<\/span>\n <\/div>\n <div class=\"scaler-card-btns\">\n <button onclick=\"window.open('https:\/\/www.scaler.com\/academy\/', '_blank')\">\n Go to Program\n <svg width=\"14\" height=\"14\" viewBox=\"0 0 16 16\" fill=\"none\" aria-hidden=\"true\"><path d=\"M3 8H13M13 8L9 4M13 8L9 12\" stroke=\"currentColor\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\"\/><\/svg>\n <\/button>\n <\/div>\n <\/div>\n <\/div>\n\n <!-- CARD 2 -->\n <div class=\"swiper-slide\">\n <div class=\"scaler-card\">\n <div class=\"scaler-badge\">NSDC Certified<\/div>\n <div class=\"scaler-card-top\">\n <div class=\"scaler-icon-wrap\">\n <svg width=\"26\" height=\"26\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><ellipse cx=\"12\" cy=\"5\" rx=\"9\" ry=\"3\"\/><path d=\"M3 5v14c0 1.66 4.03 3 9 3s9-1.34 9-3V5\"\/><path d=\"M3 12c0 1.66 4.03 3 9 3s9-1.34 9-3\"\/><\/svg>\n <\/div>\n <div class=\"scaler-card-top-content\">\n <h3 class=\"scaler-title\">Modern Data Science and ML with specialisation in AI<\/h3>\n <p class=\"scaler-desc\">Advanced data science techniques with AI specialization<\/p>\n <\/div>\n <\/div>\n <div class=\"scaler-stats\">\n <div class=\"scaler-stat\"><span class=\"scaler-stat-value\">12 Months<\/span><span class=\"scaler-stat-label\">Duration<\/span><\/div>\n <div class=\"scaler-stat\"><span class=\"scaler-stat-value\">AI-Led<\/span><span class=\"scaler-stat-label\">Curriculum<\/span><\/div>\n <div class=\"scaler-stat\"><span class=\"scaler-stat-value\">Career Support<\/span><span class=\"scaler-stat-label\">Support<\/span><\/div>\n <\/div>\n <div class=\"scaler-logos\">\n <img decoding=\"async\" class=\"scaler-company-logo\" src=\"https:\/\/upload.wikimedia.org\/wikipedia\/commons\/2\/2f\/Google_2015_logo.svg\" alt=\"Google\" loading=\"lazy\">\n <img decoding=\"async\" class=\"scaler-company-logo\" src=\"https:\/\/upload.wikimedia.org\/wikipedia\/commons\/a\/a9\/Amazon_logo.svg\" alt=\"Amazon\" loading=\"lazy\">\n <img decoding=\"async\" class=\"scaler-company-logo\" src=\"https:\/\/upload.wikimedia.org\/wikipedia\/commons\/4\/42\/Paytm_logo.png\" alt=\"Paytm\" loading=\"lazy\">\n <span class=\"scaler-logo-more\">+1000 more<\/span>\n <\/div>\n <div class=\"scaler-card-btns\">\n <button onclick=\"window.open('https:\/\/www.scaler.com\/data-science-course\/', '_blank')\">\n Go to Program\n <svg width=\"14\" height=\"14\" viewBox=\"0 0 16 16\" fill=\"none\" aria-hidden=\"true\"><path d=\"M3 8H13M13 8L9 4M13 8L9 12\" stroke=\"currentColor\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\"\/><\/svg>\n <\/button>\n <\/div>\n <\/div>\n <\/div>\n\n <!-- CARD 3 -->\n <div class=\"swiper-slide\">\n <div class=\"scaler-card\">\n <div class=\"scaler-badge\">NSDC Certified<\/div>\n <div class=\"scaler-card-top\">\n <div class=\"scaler-icon-wrap\">\n <svg width=\"26\" height=\"26\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><path d=\"M12 2L13.5 8.5L20 10L13.5 11.5L12 18L10.5 11.5L4 10L10.5 8.5L12 2Z\"\/><\/svg>\n <\/div>\n <div class=\"scaler-card-top-content\">\n <h3 class=\"scaler-title\">Advanced AIML with Specialisation in Agentic AI<\/h3>\n <p class=\"scaler-desc\">Deep dive into AIML with focus on Agentic systems<\/p>\n <\/div>\n <\/div>\n <div class=\"scaler-stats\">\n <div class=\"scaler-stat\"><span class=\"scaler-stat-value\">12 Months<\/span><span class=\"scaler-stat-label\">Duration<\/span><\/div>\n <div class=\"scaler-stat\"><span class=\"scaler-stat-value\">AI-Led<\/span><span class=\"scaler-stat-label\">Curriculum<\/span><\/div>\n <div class=\"scaler-stat\"><span class=\"scaler-stat-value\">Career Support<\/span><span class=\"scaler-stat-label\">Support<\/span><\/div>\n <\/div>\n <div class=\"scaler-logos\">\n <img decoding=\"async\" class=\"scaler-company-logo\" src=\"https:\/\/upload.wikimedia.org\/wikipedia\/commons\/2\/2f\/Google_2015_logo.svg\" alt=\"Google\" loading=\"lazy\">\n <img decoding=\"async\" class=\"scaler-company-logo\" src=\"https:\/\/upload.wikimedia.org\/wikipedia\/commons\/a\/a9\/Amazon_logo.svg\" alt=\"Amazon\" loading=\"lazy\">\n <img decoding=\"async\" class=\"scaler-company-logo\" src=\"https:\/\/upload.wikimedia.org\/wikipedia\/commons\/4\/42\/Paytm_logo.png\" alt=\"Paytm\" loading=\"lazy\">\n <span class=\"scaler-logo-more\">+1000 more<\/span>\n <\/div>\n <div class=\"scaler-card-btns\">\n <button onclick=\"window.open('https:\/\/www.scaler.com\/ai-machine-learning-course\/', '_blank')\">\n Go to Program\n <svg width=\"14\" height=\"14\" viewBox=\"0 0 16 16\" fill=\"none\" aria-hidden=\"true\"><path d=\"M3 8H13M13 8L9 4M13 8L9 12\" stroke=\"currentColor\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\"\/><\/svg>\n <\/button>\n <\/div>\n <\/div>\n <\/div>\n\n <!-- CARD 4 -->\n <div class=\"swiper-slide\">\n <div class=\"scaler-card\">\n <div class=\"scaler-badge\">NSDC Certified<\/div>\n <div class=\"scaler-card-top\">\n <div class=\"scaler-icon-wrap\">\n <svg width=\"26\" height=\"26\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\">\n <path d=\"M17.5 19H9a7 7 0 1 1 6.71-9h1.79a4.5 4.5 0 1 1 0 9Z\" \/>\n <path d=\"M9.2 15.2a3 3 0 1 0 4.24-4.24\" \/>\n <\/svg>\n <\/div>\n <div class=\"scaler-card-top-content\">\n <h3 class=\"scaler-title\">DevOps, Cloud & AI Platform Engineering<\/h3>\n <p class=\"scaler-desc\">Build and manage AI-powered cloud infrastructure<\/p>\n <\/div>\n <\/div>\n <div class=\"scaler-stats\">\n <div class=\"scaler-stat\"><span class=\"scaler-stat-value\">12 Months<\/span><span class=\"scaler-stat-label\">Duration<\/span><\/div>\n <div class=\"scaler-stat\"><span class=\"scaler-stat-value\">AI-Led<\/span><span class=\"scaler-stat-label\">Curriculum<\/span><\/div>\n <div class=\"scaler-stat\"><span class=\"scaler-stat-value\">Career Support<\/span><span class=\"scaler-stat-label\">Support<\/span><\/div>\n <\/div>\n <div class=\"scaler-logos\">\n <img decoding=\"async\" class=\"scaler-company-logo\" src=\"https:\/\/upload.wikimedia.org\/wikipedia\/commons\/2\/2f\/Google_2015_logo.svg\" alt=\"Google\" loading=\"lazy\">\n <img decoding=\"async\" class=\"scaler-company-logo\" src=\"https:\/\/upload.wikimedia.org\/wikipedia\/commons\/a\/a9\/Amazon_logo.svg\" alt=\"Amazon\" loading=\"lazy\">\n <img decoding=\"async\" class=\"scaler-company-logo\" src=\"https:\/\/upload.wikimedia.org\/wikipedia\/commons\/4\/42\/Paytm_logo.png\" alt=\"Paytm\" loading=\"lazy\">\n <span class=\"scaler-logo-more\">+1000 more<\/span>\n <\/div>\n <div class=\"scaler-card-btns\">\n <button onclick=\"window.open('https:\/\/www.scaler.com\/devops-course\/', '_blank')\">\n Go to Program\n <svg width=\"14\" height=\"14\" viewBox=\"0 0 16 16\" fill=\"none\" aria-hidden=\"true\"><path d=\"M3 8H13M13 8L9 4M13 8L9 12\" stroke=\"currentColor\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\"\/><\/svg>\n <\/button>\n <\/div>\n <\/div>\n <\/div>\n\n <!-- CARD 5 -->\n <div class=\"swiper-slide\">\n <div class=\"scaler-card\">\n <div class=\"scaler-badge\">NSDC Certified<\/div>\n <div class=\"scaler-card-top\">\n <div class=\"scaler-icon-wrap\">\n <svg width=\"26\" height=\"26\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\">\n <line x1=\"3\" y1=\"22\" x2=\"21\" y2=\"22\" \/>\n <line x1=\"6\" y1=\"18\" x2=\"6\" y2=\"11\" \/>\n <line x1=\"10\" y1=\"18\" x2=\"10\" y2=\"11\" \/>\n <line x1=\"14\" y1=\"18\" x2=\"14\" y2=\"11\" \/>\n <line x1=\"18\" y1=\"18\" x2=\"18\" y2=\"11\" \/>\n <polygon points=\"12 2 20 7 4 7\" \/>\n <\/svg>\n <\/div>\n <div class=\"scaler-card-top-content\">\n <h3 class=\"scaler-title\">AI Engineering Advanced Certification by IIT-Roorkee<\/h3>\n <p class=\"scaler-desc\">Premier AI engineering certification from IIT-Roorkee<\/p>\n <\/div>\n <\/div>\n <div class=\"scaler-stats\">\n <div class=\"scaler-stat\"><span class=\"scaler-stat-value\">3 Months<\/span><span class=\"scaler-stat-label\">Duration<\/span><\/div>\n <div class=\"scaler-stat\"><span class=\"scaler-stat-value\">AI-Led<\/span><span class=\"scaler-stat-label\">Curriculum<\/span><\/div>\n <div class=\"scaler-stat\"><span class=\"scaler-stat-value\">Career Support<\/span><span class=\"scaler-stat-label\">Support<\/span><\/div>\n <\/div>\n <div class=\"scaler-logos\">\n <img decoding=\"async\" class=\"scaler-logo-strip\" src=\"https:\/\/scaler-blog-prod-wp-content.s3.ap-south-1.amazonaws.com\/wp-content\/uploads\/2026\/07\/08135139\/iitr-icons-strip.png\" alt=\"Program highlights\" loading=\"lazy\">\n <\/div>\n <div class=\"scaler-card-btns\">\n <button onclick=\"window.open('https:\/\/www.scaler.com\/iit-roorkee-advanced-ai-engineering-course\/', '_blank')\">\n Go to Program\n <svg width=\"14\" height=\"14\" viewBox=\"0 0 16 16\" fill=\"none\" aria-hidden=\"true\"><path d=\"M3 8H13M13 8L9 4M13 8L9 12\" stroke=\"currentColor\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\"\/><\/svg>\n <\/button>\n <\/div>\n <\/div>\n <\/div>\n\n <!-- Continue for remaining cards (6\u20138) using same pattern -->\n\n <\/div>\n <div class=\"swiper-button-next\"><\/div>\n <div class=\"swiper-button-prev\"><\/div>\n <div class=\"swiper-pagination\"><\/div>\n <\/div>\n<\/div>\n\n<!-- Swiper.js -->\n<script src=\"https:\/\/cdn.jsdelivr.net\/npm\/swiper@11\/swiper-bundle.min.js\"><\/script>\n<script>\ndocument.addEventListener(\"DOMContentLoaded\", function () {\n const pathParts = window.location.pathname.split(\"\/\").filter(Boolean);\n const slug = pathParts[pathParts.length - 1] || \"\";\n const readableSlug = encodeURIComponent(slug);\n const buttons = document.querySelectorAll(\".scaler-card-btns button\");\n\n buttons.forEach((btn) => {\n const baseURL = btn.getAttribute(\"onclick\").match(\/'(.*?)'\/)[1];\n if (!baseURL.includes(\"utm_source=\")) {\n const separator = baseURL.includes(\"?\") ? \"&\" : \"?\";\n const updatedURL = `${baseURL}${separator}utm_source=blog&utm_medium=program_carousel&utm_content=${readableSlug}`;\n btn.setAttribute(\"onclick\", `window.open('${updatedURL}', '_blank')`);\n }\n });\n\n new Swiper(\".scaler-swiper\", {\n slidesPerView: 1,\n spaceBetween: 28,\n grabCursor: true,\n navigation: { nextEl: \".swiper-button-next\", prevEl: \".swiper-button-prev\" },\n pagination: { el: \".swiper-pagination\", dynamicBullets: true, clickable: true },\n breakpoints: { 1000: { slidesPerView: 2 } },\n keyboard: { enabled: true },\n });\n});\n<\/script>\n\n\n\n<p class=\"wp-block-paragraph\">Another problem that arises for beginners while learning SQL is confusing between SQL itself, databases, and DBMS systems. The easiest way to think about all of these three concepts would be to say that databases store data, DBMS manages it, and SQL interacts with it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Among other technologies in the programming world, SQL is relatively friendly towards beginners since learners can start writing their first queries from very early stages of studying.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Understanding basic DBMS concepts makes SQL easier to learn. You can check out this <a href=\"https:\/\/www.scaler.com\/topics\/dbms\/\">DBMS Tutorial<\/a> for further learning. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"who-should-learn-sql\"><\/span><strong>Who Should Learn SQL?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">SQL is one of those skills that is useful in a lot of tech careers sooner or later. Whether you want to work with data, applications, dashboards, testing, or backend systems, SQL usually ends up being part of the job. Here are some examples:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Role<\/strong><\/td><td><strong>SQL in Use<\/strong><\/td><\/tr><tr><td>Students & Freshers<\/td><td>Helps build database and interview fundamentals<\/td><\/tr><tr><td>Data Analysts<\/td><td>Used for reports, dashboards, and data analysis<\/td><\/tr><tr><td>Backend Developers<\/td><td>Helps manage application databases and APIs<\/td><\/tr><tr><td>Full-Stack Developers<\/td><td>Used for handling data across applications<\/td><\/tr><tr><td>BI & Reporting Learners<\/td><td>Useful for dashboards and reporting workflows<\/td><\/tr><tr><td>Product Analysts<\/td><td>Helps analyze user and product data<\/td><\/tr><tr><td>QA Engineers<\/td><td>Used for testing and validating database records<\/td><\/tr><tr><td>Interview Candidates<\/td><td>Commonly asked in technical interviews<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Learners interested in analytics usually continue toward data visualization and reporting, while backend and full-stack developers use SQL heavily with APIs and databases in real-world applications.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To learn about data science skills, you can check this: <a href=\"https:\/\/www.scaler.com\/data-science-course\/\">Data Science & ML Course with AI Specialization<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"prerequisites-before-starting-the-sql-syllabus\"><\/span><strong>Prerequisites Before Starting the SQL Syllabus<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">One of the best things about SQL is that learners don’t have to be great programmers before they start learning the language. It requires only basic computer skills and knowledge of how tables and spreadsheets work. Logical thinking is also important when learning SQL.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Programming may be useful in the future, but it is not required for beginner-level SQL. Basic DBMS knowledge is also not required at first because it can be learned gradually along with SQL knowledge.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You are ready to learn SQL if you can:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Interpret data in rows and columns<\/li>\n\n\n\n<li>Use spreadsheet software such as Excel or Google Sheets with ease<\/li>\n\n\n\n<li>Have fundamental computer literacy skills<\/li>\n\n\n\n<li>Enjoy analytical thought processes<\/li>\n<\/ul>\n\n\n<meta charset=\"UTF-8\">\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n\n <!-- Source Sans Pro (topics font) -->\n <link href=\"https:\/\/fonts.googleapis.com\/css2?family=Source+Sans+3:wght@400;600;700&display=swap\" rel=\"stylesheet\">\n <link rel=\"stylesheet\" href=\"https:\/\/cdn.jsdelivr.net\/npm\/swiper@11\/swiper-bundle.min.css\">\n <script src=\"https:\/\/cdn.jsdelivr.net\/npm\/swiper@11\/swiper-bundle.min.js\"><\/script>\n\n <style>\n :root {\n \/* topics design tokens (variables.scss) *\/\n --scaler-primary: #005bb3; \/* primary-color-80 *\/\n --scaler-primary-30: #8acaff; \/* primary-color-30 *\/\n --scaler-brand-blue: #255aad;\n --scaler-live: #ee001d; \/* accent-v5-60 *\/\n --scaler-live-bg: #ffe6e9; \/* accent-v5-10 *\/\n --scaler-card-bg: #ffffff; \/* neutral-scale-0 *\/\n --scaler-surface: #f4f6f9; \/* neutral-scale-2 *\/\n --scaler-text-primary: #1a2c47; \/* neutral-scale-12 *\/\n --scaler-text-secondary: #61738e; \/* neutral-scale-9 *\/\n --scaler-border: #d6dee5; \/* neutral-scale-4 *\/\n --scaler-radius: 16px;\n --scaler-radius-sm: 8px;\n --scaler-shadow: 0 8px 16px 0 rgba(50, 71, 102, 0.16);\n }\n\n .scaler-events-carousel * { box-sizing: border-box; }\n\n .scaler-events-carousel {\n font-family: \"Source Sans 3\", \"Source Sans Pro\", \"Roboto\", Arial, sans-serif;\n padding: 24px;\n position: relative;\n width: 100%;\n }\n .scaler-events-carousel__inner {\n max-width: 1000px;\n margin: 0 auto;\n position: relative;\n width: 100%;\n }\n\n \/* Header \u2014 calendar icon + \"Live Masterclasses\" *\/\n .scaler-events-header {\n display: flex;\n align-items: center;\n gap: 8px;\n margin-bottom: 8px;\n padding: 8px 0;\n }\n .scaler-events-header__icon { display: inline-flex; color: var(--scaler-text-primary); }\n .scaler-events-header__icon svg { width: 24px; height: 24px; }\n .scaler-events-header__title {\n font-size: 18px;\n font-weight: 700;\n color: var(--scaler-text-primary);\n line-height: 1.3;\n margin: 0;\n }\n\n \/* Swiper wrap (holds side arrows) *\/\n .scaler-events-swiper-wrap { position: relative; }\n .scaler-events-carousel .swiper { width: 100%; padding: 4px; }\n .scaler-event-swiper .swiper-slide {\n width: 296px; \/* topics card_container width *\/\n height: auto;\n display: flex;\n }\n\n \/* Event Card \u2014 matches topics EventCard *\/\n .scaler-event-card {\n background: var(--scaler-card-bg);\n border: 1px solid var(--scaler-border);\n border-radius: var(--scaler-radius);\n padding: 16px;\n display: flex;\n flex-direction: column;\n height: 100%;\n width: 100%;\n cursor: pointer;\n }\n\n \/* Header row: headshot + title\/name *\/\n .scaler-event-card__header { display: flex; align-items: flex-start; }\n .scaler-event-card__image-wrapper {\n position: relative;\n width: 88px;\n height: 88px;\n min-width: 88px;\n border-radius: var(--scaler-radius-sm);\n overflow: hidden;\n background: var(--scaler-primary-30);\n }\n .scaler-event-card__image {\n position: absolute;\n top: 0; left: 0;\n width: 100%; height: 100%;\n object-fit: cover;\n }\n \/* attendee-count footer (default) *\/\n .scaler-event-card__img-footer {\n position: absolute;\n left: 0; right: 0; bottom: 0;\n display: flex;\n align-items: center;\n justify-content: center;\n gap: 4px;\n padding: 1px 8px;\n background: var(--scaler-surface);\n color: var(--scaler-text-primary);\n font-size: 13px;\n line-height: 22px;\n }\n .scaler-event-card__img-footer svg { width: 14px; height: 14px; }\n \/* live chip (shown when status === current) *\/\n .scaler-event-card__live-badge {\n position: absolute;\n left: 0; right: 0; bottom: 0;\n display: flex;\n align-items: center;\n justify-content: center;\n gap: 5px;\n padding: 1px 8px;\n background: var(--scaler-live-bg);\n color: var(--scaler-live);\n font-size: 12px;\n line-height: 22px;\n text-transform: uppercase;\n letter-spacing: 0.18em;\n }\n .scaler-event-card__live-badge::before {\n content: \"\";\n width: 6px; height: 6px;\n background: var(--scaler-live);\n border-radius: 50%;\n }\n .scaler-event-card__text { margin-left: 16px; min-width: 0; }\n .scaler-event-card__title {\n font-size: 20px;\n font-weight: 600;\n color: var(--scaler-text-primary);\n margin: 0;\n line-height: 1.4;\n display: -webkit-box;\n -webkit-line-clamp: 2;\n -webkit-box-orient: vertical;\n overflow: hidden;\n }\n .scaler-event-card__speaker {\n margin-top: 8px;\n font-size: 14px;\n line-height: 1.4;\n color: var(--scaler-text-primary);\n }\n\n \/* Takeaways *\/\n .scaler-event-card__takeaways {\n margin-top: 12px;\n min-height: 50px;\n max-height: 50px;\n overflow: hidden;\n }\n .scaler-event-card__takeaway-item {\n display: flex;\n align-items: flex-start;\n gap: 6px;\n }\n .scaler-event-card__dot {\n width: 4px; height: 4px;\n min-width: 4px;\n border-radius: 50%;\n background: var(--scaler-text-secondary);\n margin-top: 11px;\n }\n .scaler-event-card__takeaway-text {\n flex: 1;\n min-width: 0;\n font-size: 14px;\n line-height: 24px;\n color: var(--scaler-text-primary);\n white-space: nowrap;\n overflow: hidden;\n text-overflow: ellipsis;\n }\n .scaler-event-card__knowmore,\n .scaler-event-card__knowmore:link,\n .scaler-event-card__knowmore:visited {\n flex-shrink: 0;\n font-size: 14px;\n line-height: 24px;\n color: var(--scaler-primary) !important;\n text-decoration: none;\n white-space: nowrap;\n }\n .scaler-event-card__knowmore:hover { text-decoration: underline; }\n\n \/* Date + duration *\/\n .scaler-event-card__meta {\n display: flex;\n align-items: center;\n justify-content: space-between;\n margin-top: 20px;\n font-size: 13px;\n line-height: 24px;\n color: var(--scaler-text-primary);\n }\n .scaler-event-card__duration {\n display: flex;\n align-items: center;\n gap: 4px;\n }\n .scaler-event-card__duration svg { width: 15px; height: 15px; }\n\n .scaler-event-card__spacer { flex-grow: 1; min-height: 4px; }\n\n \/* CTA \u2014 outlined \"Register with 1-Click\" *\/\n .scaler-event-card__cta,\n .scaler-event-card__cta:link,\n .scaler-event-card__cta:visited {\n display: flex;\n align-items: center;\n justify-content: center;\n width: 100%;\n margin-top: 16px;\n padding: 8px;\n background: transparent;\n color: var(--scaler-primary) !important;\n font-family: inherit;\n font-size: 14px;\n font-weight: 600;\n line-height: 24px;\n text-decoration: none;\n border: 1px solid var(--scaler-primary);\n border-radius: var(--scaler-radius-sm);\n cursor: pointer;\n transition: background 0.2s ease, color 0.2s ease;\n }\n .scaler-event-card__cta:hover,\n .scaler-event-card__cta:focus {\n background: var(--scaler-primary);\n color: #fff !important;\n }\n\n \/* Side navigation arrows *\/\n .scaler-events-nav__btn {\n position: absolute !important;\n top: 50% !important;\n transform: translateY(-50%) !important;\n z-index: 2;\n width: 46px !important;\n height: 46px !important;\n min-width: 46px;\n display: flex !important;\n align-items: center;\n justify-content: center;\n padding: 0 !important;\n background: var(--scaler-card-bg) !important;\n border: none !important;\n border-radius: var(--scaler-radius-sm) !important;\n box-shadow: var(--scaler-shadow) !important;\n color: var(--scaler-text-secondary) !important;\n cursor: pointer;\n transition: opacity 0.2s ease, visibility 0.2s ease;\n }\n .scaler-nav-prev { left: 8px !important; }\n .scaler-nav-next { right: 8px !important; }\n .scaler-events-nav__btn svg {\n width: 20px !important;\n height: 20px !important;\n fill: var(--scaler-text-secondary) !important;\n }\n .scaler-events-nav__btn.swiper-button-disabled {\n opacity: 0;\n visibility: hidden;\n pointer-events: none;\n }\n\n \/* View All Events *\/\n .scaler-events-viewall,\n .scaler-events-viewall:link,\n .scaler-events-viewall:visited {\n display: flex;\n align-items: center;\n justify-content: center;\n gap: 6px;\n margin-top: 12px;\n font-size: 14px;\n font-weight: 600;\n color: var(--scaler-brand-blue) !important;\n text-decoration: none;\n }\n .scaler-events-viewall:hover { text-decoration: underline; }\n .scaler-events-viewall svg { width: 16px; height: 16px; fill: var(--scaler-brand-blue); }\n\n \/* hide swiper defaults *\/\n .scaler-events-pagination { display: none; }\n .scaler-events-carousel .swiper-button-prev,\n .scaler-events-carousel .swiper-button-next { display: none; }\n\n \/* Skeleton & Empty States *\/\n .scaler-event-card--skeleton { pointer-events: none; }\n .scaler-event-card--skeleton .scaler-event-card__image-wrapper,\n .scaler-event-card--skeleton .scaler-event-card__title,\n .scaler-event-card--skeleton .scaler-event-card__speaker,\n .scaler-event-card--skeleton .scaler-event-card__takeaways,\n .scaler-event-card--skeleton .scaler-event-card__meta,\n .scaler-event-card--skeleton .scaler-event-card__cta {\n background: linear-gradient(90deg, var(--scaler-border) 25%, var(--scaler-surface) 50%, var(--scaler-border) 75%);\n background-size: 200% 100%;\n animation: shimmer 1.5s infinite;\n color: transparent !important;\n border-color: transparent !important;\n border-radius: 4px;\n }\n .scaler-event-card--skeleton .scaler-event-card__title { min-height: 44px; }\n .scaler-event-card--skeleton .scaler-event-card__speaker { min-height: 16px; }\n .scaler-event-card--skeleton .scaler-event-card__meta { min-height: 24px; }\n .scaler-event-card--skeleton .scaler-event-card__cta { min-height: 40px; }\n .scaler-event-card--skeleton .scaler-event-card__image,\n .scaler-event-card--skeleton .scaler-event-card__img-footer,\n .scaler-event-card--skeleton .scaler-event-card__live-badge { display: none; }\n\n @keyframes shimmer {\n 0% { background-position: 200% 0; }\n 100% { background-position: -200% 0; }\n }\n\n .scaler-events-empty {\n text-align: center;\n padding: 40px 20px;\n color: var(--scaler-text-secondary);\n font-size: 15px;\n }\n\n @media (max-width: 768px) {\n .scaler-events-carousel { padding: 16px; }\n .scaler-event-swiper .swiper-slide { width: calc(100vw - 52px); }\n .scaler-events-nav__btn { display: none; }\n }\n <\/style>\n\n\n\n <div class=\"scaler-events-carousel js-scaler-carousel\">\n\n <template class=\"js-event-card-template\">\n <div class=\"swiper-slide\">\n <article class=\"scaler-event-card\">\n <div class=\"scaler-event-card__header\">\n <div class=\"scaler-event-card__image-wrapper\">\n <img decoding=\"async\" src=\"\" alt=\"\" class=\"scaler-event-card__image\" loading=\"lazy\">\n <div class=\"scaler-event-card__img-footer\">\n <svg fill=\"currentColor\" viewBox=\"0 0 32 32\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M11.199 7.957c-3.086 0-5.588 2.502-5.588 5.588s2.502 5.588 5.588 5.588c3.086 0 5.588-2.502 5.588-5.588s-2.502-5.588-5.588-5.588zM3.611 13.545c0-4.191 3.397-7.588 7.588-7.588s7.588 3.397 7.588 7.588c0 4.191-3.397 7.588-7.588 7.588s-7.588-3.397-7.588-7.588z\"\/><path d=\"M21.090 6.369h0.003c1.989 0 3.897 0.79 5.303 2.197s2.197 3.314 2.197 5.303-0.79 3.897-2.197 5.303c-1.406 1.407-3.314 2.197-5.303 2.197-0.552 0-1-0.448-1-1s0.448-1 1-1c1.459 0 2.858-0.579 3.889-1.611s1.611-2.43 1.611-3.889c0-1.459-0.58-2.858-1.611-3.889s-2.429-1.611-3.888-1.611c-0.507 0.002-1.013 0.070-1.502 0.203-0.533 0.145-1.082-0.17-1.227-0.703s0.17-1.082 0.703-1.227c0.659-0.179 1.339-0.27 2.021-0.272z\"\/><path d=\"M10.906 21.364c-1.605 0-3.186 0.386-4.61 1.126s-2.649 1.811-3.572 3.124c-0.318 0.452-0.941 0.561-1.393 0.243s-0.561-0.941-0.243-1.393c1.107-1.576 2.577-2.862 4.286-3.749s3.606-1.351 5.532-1.351 3.823 0.463 5.532 1.351c1.709 0.888 3.179 2.174 4.286 3.749 0.318 0.452 0.209 1.076-0.243 1.393s-1.076 0.209-1.393-0.243c-0.923-1.313-2.148-2.385-3.572-3.124s-3.005-1.126-4.61-1.126z\"\/><\/svg>\n <span class=\"js-event-count\"><\/span>\n <\/div>\n <div class=\"scaler-event-card__live-badge\" style=\"display: none;\">Live<\/div>\n <\/div>\n <div class=\"scaler-event-card__text\">\n <h3 class=\"scaler-event-card__title\"><\/h3>\n <div class=\"scaler-event-card__speaker js-event-speaker\"><\/div>\n <\/div>\n <\/div>\n\n <div class=\"scaler-event-card__takeaways js-event-takeaways\"><\/div>\n\n <div class=\"scaler-event-card__spacer\"><\/div>\n\n <div class=\"scaler-event-card__meta\">\n <span class=\"js-event-date\"><\/span>\n <span class=\"scaler-event-card__duration\">\n <svg fill=\"currentColor\" viewBox=\"0 0 32 32\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M16 6.333c6.443 0 11.667 5.223 11.667 11.667s-5.223 11.667-11.667 11.667c-6.443 0-11.667-5.223-11.667-11.667v0c0.008-6.44 5.226-11.659 11.666-11.667h0.001zM16 28.333c5.707 0 10.333-4.626 10.333-10.333s-4.626-10.333-10.333-10.333c-5.707 0-10.333 4.626-10.333 10.333v0c0.007 5.704 4.629 10.326 10.333 10.333h0.001z\"\/><path d=\"M16 18.667c-0 0-0.001 0-0.001 0-0.184 0-0.35-0.074-0.471-0.195v0c-0.121-0.121-0.195-0.287-0.195-0.471s0.075-0.351 0.195-0.471l4.951-4.952c0.121-0.121 0.287-0.195 0.471-0.195s0.351 0.075 0.471 0.195v0c0.121 0.121 0.195 0.287 0.195 0.471s-0.075 0.351-0.195 0.471l-4.949 4.951c-0.121 0.121-0.288 0.196-0.472 0.196v0z\"\/><path d=\"M19 3.667h-6c-0.368 0-0.667-0.298-0.667-0.667v0c0-0.368 0.298-0.667 0.667-0.667v0h6c0.368 0 0.667 0.298 0.667 0.667v0c0 0.368-0.298 0.667-0.667 0.667v0z\"\/><\/svg>\n <span class=\"js-event-duration\"><\/span>\n <\/span>\n <\/div>\n\n <a href=\"#\" class=\"scaler-event-card__cta js-event-cta\">Register with 1-Click<\/a>\n <\/article>\n <\/div>\n <\/template>\n\n <div class=\"scaler-events-carousel__inner\">\n <header class=\"scaler-events-header\">\n <span class=\"scaler-events-header__icon\">\n <svg fill=\"currentColor\" viewBox=\"0 0 33 32\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M6.406 6.8c-0.11 0-0.2 0.090-0.2 0.2v20c0 0.11 0.090 0.2 0.2 0.2h20c0.11 0 0.2-0.090 0.2-0.2v-20c0-0.11-0.090-0.2-0.2-0.2h-20zM4.606 7c0-0.994 0.806-1.8 1.8-1.8h20c0.994 0 1.8 0.806 1.8 1.8v20c0 0.994-0.806 1.8-1.8 1.8h-20c-0.994 0-1.8-0.806-1.8-1.8v-20z\"\/><path d=\"M22.406 3.2c0.442 0 0.8 0.358 0.8 0.8v4c0 0.442-0.358 0.8-0.8 0.8s-0.8-0.358-0.8-0.8v-4c0-0.442 0.358-0.8 0.8-0.8z\"\/><path d=\"M10.406 3.2c0.442 0 0.8 0.358 0.8 0.8v4c0 0.442-0.358 0.8-0.8 0.8s-0.8-0.358-0.8-0.8v-4c0-0.442 0.358-0.8 0.8-0.8z\"\/><path d=\"M4.606 12c0-0.442 0.358-0.8 0.8-0.8h22c0.442 0 0.8 0.358 0.8 0.8s-0.358 0.8-0.8 0.8h-22c-0.442 0-0.8-0.358-0.8-0.8z\"\/><path d=\"M21.488 16.451c0.303 0.322 0.288 0.828-0.034 1.131l-5.838 5.5c-0.309 0.291-0.791 0.29-1.099-0.002l-3.162-3c-0.321-0.304-0.334-0.81-0.030-1.131s0.81-0.334 1.131-0.030l2.614 2.48 5.287-4.981c0.322-0.303 0.828-0.288 1.131 0.034z\"\/><\/svg>\n <\/span>\n <h2 class=\"scaler-events-header__title\"><span class=\"ez-toc-section\" id=\"live-masterclasses\"><\/span>Live Masterclasses<span class=\"ez-toc-section-end\"><\/span><\/h2>\n <\/header>\n\n <div class=\"scaler-events-swiper-wrap\">\n <div class=\"swiper scaler-event-swiper\">\n <div class=\"swiper-wrapper scaler-events-wrapper\"><\/div>\n <div class=\"swiper-pagination scaler-events-pagination\"><\/div>\n <\/div>\n\n <button class=\"scaler-events-nav__btn scaler-nav-prev\" aria-label=\"Previous slide\">\n <svg fill=\"currentColor\" viewBox=\"0 0 32 32\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"transform: rotate(-90deg);\"><path d=\"M5.313 16l10.688-10.688 10.688 10.688-1.938 1.875-7.438-7.438v16.25h-2.625v-16.25l-7.5 7.438z\"\/><\/svg>\n <\/button>\n <button class=\"scaler-events-nav__btn scaler-nav-next\" aria-label=\"Next slide\">\n <svg fill=\"currentColor\" viewBox=\"0 0 32 32\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"transform: rotate(90deg);\"><path d=\"M5.313 16l10.688-10.688 10.688 10.688-1.938 1.875-7.438-7.438v16.25h-2.625v-16.25l-7.5 7.438z\"\/><\/svg>\n <\/button>\n <\/div>\n\n <a class=\"scaler-events-viewall\" href=\"https:\/\/www.scaler.com\/events\/\">\n <span>View All Events<\/span>\n <svg fill=\"currentColor\" viewBox=\"0 0 32 32\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"transform: rotate(90deg);\"><path d=\"M5.313 16l10.688-10.688 10.688 10.688-1.938 1.875-7.438-7.438v16.25h-2.625v-16.25l-7.5 7.438z\"\/><\/svg>\n <\/a>\n <\/div>\n <\/div>\n\n <script>\n document.addEventListener(\"DOMContentLoaded\", () => {\n\n const monthNames = [\"January\",\"February\",\"March\",\"April\",\"May\",\"June\",\"July\",\"August\",\"September\",\"October\",\"November\",\"December\"];\n\n function formatTime(st) {\n const t = new Date(st);\n const date = t.getDate();\n const month = monthNames[t.getMonth()];\n const year = t.getFullYear();\n const h = t.getHours();\n const m = String(t.getMinutes()).padStart(2, \"0\");\n let time;\n if (h === 0) time = `12:${m} AM`;\n else if (h === 12) time = `12:${m} PM`;\n else if (h > 12) time = `${h - 12}:${m} PM`;\n else time = `${h}:${m} AM`;\n return `${date} ${month} ${year} | ${time}`;\n }\n\n const carouselInstances = document.querySelectorAll('.js-scaler-carousel');\n\n carouselInstances.forEach(container => {\n\n if(container.dataset.initialized === \"true\") return;\n container.dataset.initialized = \"true\";\n\n const swiperElement = container.querySelector(\".scaler-event-swiper\");\n const swiperWrapper = container.querySelector(\".scaler-events-wrapper\");\n const template = container.querySelector(\".js-event-card-template\");\n const nextBtn = container.querySelector(\".scaler-nav-next\");\n const prevBtn = container.querySelector(\".scaler-nav-prev\");\n const paginationEl = container.querySelector(\".scaler-events-pagination\");\n\n if (!swiperWrapper || !template) {\n console.error(\"Scaler Carousel: Missing required elements inside container\");\n return;\n }\n\n const swiper = new Swiper(swiperElement, {\n slidesPerView: \"auto\",\n spaceBetween: 16,\n grabCursor: true,\n observer: true,\n observeParents: true,\n pagination: {\n el: paginationEl,\n clickable: true,\n dynamicBullets: true\n },\n navigation: {\n nextEl: nextBtn,\n prevEl: prevBtn\n },\n });\n\n function showSkeletons(count = 4) {\n swiperWrapper.innerHTML = \"\";\n for (let i = 0; i < count; i++) {\n const clone = template.content.cloneNode(true);\n const card = clone.querySelector(\".scaler-event-card\");\n card.classList.add(\"scaler-event-card--skeleton\");\n swiperWrapper.appendChild(clone);\n }\n swiper.update();\n }\n\n function renderEvents(events) {\n swiperWrapper.innerHTML = \"\";\n\n if (events.length === 0) {\n swiperWrapper.innerHTML = `<div class=\"scaler-events-empty\">No upcoming masterclasses found.<\/div>`;\n return;\n }\n\n const pathParts = location.pathname.split(\"\/\").filter(Boolean);\n const currentSlug = pathParts.length > 0 ? pathParts[pathParts.length - 1] : \"homepage\";\n\n events.forEach(event => {\n const attr = event.attributes;\n const cd = attr.custom_data || {};\n const clone = template.content.cloneNode(true);\n const joinUrl = `\/event\/${attr.slug}\/?utm_source=blog&utm_medium=master_class&utm_content=${currentSlug}`;\n\n \/\/ Instructor headshot\n const instructor = (cd.instructors && cd.instructors[0]) || {};\n const img = clone.querySelector(\".scaler-event-card__image\");\n img.src = instructor.media_url || attr.image_url ||\n \"https:\/\/images.unsplash.com\/photo-1531891437562-4301cf35b7e4?w=200&h=200&fit=crop\";\n img.alt = instructor.name || attr.instructor_name || attr.title;\n\n \/\/ Title + speaker\n clone.querySelector(\".scaler-event-card__title\").textContent = attr.title;\n clone.querySelector(\".js-event-speaker\").textContent = instructor.name || attr.instructor_name || \"\";\n\n \/\/ Live chip vs attendee count\n const isLive = attr.status === \"current\";\n const footer = clone.querySelector(\".scaler-event-card__img-footer\");\n const liveBadge = clone.querySelector(\".scaler-event-card__live-badge\");\n if (isLive) {\n footer.style.display = \"none\";\n liveBadge.style.display = \"flex\";\n liveBadge.textContent = \"Live\";\n } else if (attr.registration_count) {\n clone.querySelector(\".js-event-count\").textContent = attr.registration_count;\n } else {\n footer.style.display = \"none\";\n }\n\n \/\/ Takeaways (up to 2, Know More on the last)\n const takeaways = (cd.takeaways || []).slice(0, 2);\n const listEl = clone.querySelector(\".js-event-takeaways\");\n listEl.innerHTML = \"\";\n takeaways.forEach((t, idx) => {\n const item = document.createElement(\"div\");\n item.className = \"scaler-event-card__takeaway-item\";\n const dot = document.createElement(\"span\");\n dot.className = \"scaler-event-card__dot\";\n const txt = document.createElement(\"span\");\n txt.className = \"scaler-event-card__takeaway-text\";\n txt.textContent = t;\n item.appendChild(dot);\n item.appendChild(txt);\n if (idx === takeaways.length - 1) {\n const km = document.createElement(\"a\");\n km.className = \"scaler-event-card__knowmore\";\n km.textContent = \"Know More\";\n km.href = joinUrl;\n item.appendChild(km);\n }\n listEl.appendChild(item);\n });\n\n \/\/ Date + duration\n clone.querySelector(\".js-event-date\").textContent = formatTime(attr.start_time);\n let hrs = \"\";\n if (attr.duration) {\n hrs = (attr.duration \/ 60).toFixed(2);\n } else if (attr.end_time) {\n hrs = (Math.abs(new Date(attr.start_time) - new Date(attr.end_time)) \/ 3600000).toFixed(2);\n }\n clone.querySelector(\".js-event-duration\").textContent = hrs ? `${hrs} Hrs` : \"\";\n\n \/\/ CTA\n clone.querySelector(\".js-event-cta\").href = joinUrl;\n\n swiperWrapper.appendChild(clone);\n });\n\n swiper.update();\n swiper.slideTo(0);\n }\n\n async function fetchEvents() {\n try {\n showSkeletons();\n const res = await fetch(\n \"https:\/\/www.scaler.com\/api\/v4\/events?event_type[]=company&distributor=scaler&type=upcoming&serializer_mode=L2&limit=8&program[]=software_development&program[]=data_science&program[]=devops&program[]=ai_ml\"\n );\n const json = await res.json();\n const events = json.data || [];\n renderEvents(events);\n } catch (error) {\n console.error(\"Failed to load events:\", error);\n if(swiperWrapper) swiperWrapper.innerHTML = `<div class=\"scaler-events-empty\">Failed to load events.<\/div>`;\n }\n }\n\n fetchEvents();\n });\n });\n <\/script>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"complete-sql-syllabus-at-a-glance\"><\/span><strong>Complete SQL Syllabus at a Glance<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The following SQL course syllabus provides a structured overview of the topics typically covered in beginner-to-advanced SQL learning paths. <\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Module<\/strong><\/td><td><strong>Topics Covered<\/strong><\/td><td><strong>What You Will Learn<\/strong><\/td><\/tr><tr><td>Module 1: SQL & Database Fundamentals<\/td><td>Databases, RDBMS, tables, rows, columns, schema, primary keys, foreign keys<\/td><td>Understand how relational databases work<\/td><\/tr><tr><td>Module 2: SQL Commands<\/td><td>DDL, DML, DQL, DCL, TCL, CREATE, INSERT, UPDATE, DELETE, SELECT<\/td><td>Learn how SQL commands are organized and used<\/td><\/tr><tr><td>Module 3: Basic SQL Queries<\/td><td>SELECT, WHERE, ORDER BY, DISTINCT, LIMIT, aliases, filtering<\/td><td>Write and execute basic SQL queries<\/td><\/tr><tr><td>Module 4: Aggregation & Grouping<\/td><td>COUNT, SUM, AVG, MIN, MAX, GROUP BY, HAVING<\/td><td>Create reports and summary-based queries<\/td><\/tr><tr><td>Module 5: SQL Joins<\/td><td>Inner Join, Left Join, Right Join, Full Join, Self Join<\/td><td>Combine and query data from multiple tables<\/td><\/tr><tr><td>Module 6: Subqueries & CTEs<\/td><td>Nested queries, correlated subqueries, EXISTS, WITH clauses<\/td><td>Solve layered and intermediate SQL problems<\/td><\/tr><tr><td>Module 7: SQL Functions<\/td><td>String functions, date functions, aggregate functions, CASE<\/td><td>Clean, transform, and analyze data<\/td><\/tr><tr><td>Module 8: Advanced SQL<\/td><td>Window functions, views, indexes, transactions, optimization basics<\/td><td>Work with advanced analytics and database operations<\/td><\/tr><tr><td>Module 9: Database Design<\/td><td>ER models, normalization, constraints, relationships<\/td><td>Design structured relational databases<\/td><\/tr><tr><td>Module 10: Projects & Interview Prep<\/td><td>SQL projects, reporting queries, interview questions, optimization<\/td><td>Build practical SQL skills and prepare for interviews<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"module-1-%e2%80%93-sql-and-relational-database-fundamentals\"><\/span><strong>Module 1 – SQL and Relational Database Fundamentals<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">This is the module that gives learners an idea about how relational databases operate. Before delving into queries and joins, it is necessary to have some knowledge about how data is organized and linked within a database.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Most SQL problems become easier once you understand how tables relate to each other. This introduces core database concepts such as tables, rows, columns, schemas, primary keys, foreign keys, relationships, and constraints, which form the foundation of relational databases. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">At this stage, you’ll also encounter popular relational database systems such as MySQL, PostgreSQL, SQL Server, and Oracle. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"module-2-%e2%80%93-sql-commands-ddl-dml-dql-dcl-and-tcl\"><\/span><strong>Module 2 – SQL Commands: DDL, DML, DQL, DCL, and TCL<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">After understanding databases and tables, learners move toward SQL commands used for creating, managing, retrieving, and modifying data. Now you\u2019ll be able to write queries with commands like CREATE, INSERT, UPDATE, DELETE, and SELECT. Here\u2019s what they do:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Command Category<\/strong><\/td><td><strong>Purpose<\/strong><\/td><td><strong>Common Commands<\/strong><\/td><td><strong>When It Is Used<\/strong><\/td><\/tr><tr><td>DDL (Data Definition Language) <\/td><td>Defines database structure<\/td><td>CREATE, ALTER, DROP, TRUNCATE<\/td><td>Creating or modifying tables<\/td><\/tr><tr><td>DML(Data Manipulation Language) <\/td><td>Modifies table data<\/td><td>INSERT, UPDATE, DELETE<\/td><td>Managing records<\/td><\/tr><tr><td>DQL (Data Query Language) <\/td><td>Retrieves data<\/td><td>SELECT<\/td><td>Fetching data from tables<\/td><\/tr><tr><td>DCL (Data Control Language) <\/td><td>Controls access permissions<\/td><td>GRANT, REVOKE<\/td><td>Managing user permissions<\/td><\/tr><tr><td>TCL(Transaction Control Language) <\/td><td>Manages transactions<\/td><td>COMMIT, ROLLBACK, SAVEPOINT<\/td><td>Handling transaction changes<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Most beginner practice in this module involves creating tables, inserting records, updating data, and running simple SQL queries.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Want to practice SQL commands? You can start with this <a href=\"https:\/\/www.scaler.com\/topics\/dbms\/sql-commands\/\">SQL Command Practice<\/a>.<\/p>\n\n\n<meta charset=\"UTF-8\">\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n\n <!-- Source Sans Pro (topics font) -->\n <link href=\"https:\/\/fonts.googleapis.com\/css2?family=Source+Sans+3:wght@400;600;700&display=swap\" rel=\"stylesheet\">\n <link rel=\"stylesheet\" href=\"https:\/\/cdn.jsdelivr.net\/npm\/swiper@11\/swiper-bundle.min.css\">\n <script src=\"https:\/\/cdn.jsdelivr.net\/npm\/swiper@11\/swiper-bundle.min.js\"><\/script>\n\n <style>\n :root {\n --cl-primary: #005bb3;\n --cl-brand-blue: #255aad;\n --cl-card-bg: #ffffff;\n --cl-surface: #f6f7f8;\n --cl-border: #d6dee5;\n --cl-text-primary: #1a2c47; \/* neutral-scale-12 *\/\n --cl-text-secondary: #61738e; \/* neutral-scale-9 *\/\n --cl-radius: 16px;\n --cl-radius-sm: 8px;\n --cl-shadow: 0 8px 16px 0 rgba(50, 71, 102, 0.16);\n }\n\n .scaler-courses * { box-sizing: border-box; }\n\n .scaler-courses {\n font-family: \"Source Sans 3\", \"Source Sans Pro\", \"Roboto\", Arial, sans-serif;\n padding: 24px;\n width: 100%;\n }\n .scaler-courses__inner {\n max-width: 1000px;\n margin: 0 auto;\n position: relative;\n width: 100%;\n }\n\n \/* Header *\/\n .scaler-courses__header {\n display: flex;\n align-items: center;\n gap: 8px;\n margin-bottom: 8px;\n padding: 8px 0;\n }\n .scaler-courses__header-icon { display: inline-flex; color: var(--cl-text-primary); }\n .scaler-courses__header-icon svg { width: 24px; height: 24px; }\n .scaler-courses__title {\n font-size: 18px;\n font-weight: 700;\n color: var(--cl-text-primary);\n line-height: 1.3;\n margin: 0;\n }\n\n \/* Swiper *\/\n .scaler-courses__swiper-wrap { position: relative; }\n .scaler-courses .swiper { width: 100%; padding: 4px; }\n .scaler-courses-swiper .swiper-slide {\n width: 296px;\n height: auto;\n display: flex;\n }\n\n \/* Card *\/\n .scaler-course-card {\n display: flex;\n flex-direction: column;\n width: 100%;\n height: 100%;\n min-height: 336px;\n background: var(--cl-card-bg);\n border: 1px solid var(--cl-border);\n border-radius: var(--cl-radius);\n overflow: hidden;\n text-decoration: none;\n cursor: pointer;\n transition: box-shadow 0.2s ease;\n }\n .scaler-course-card:hover { box-shadow: 0 2px 12px rgba(50, 71, 102, 0.12); }\n\n .scaler-course-card__image {\n width: 100%;\n height: 128px;\n min-height: 128px;\n object-fit: cover;\n background: var(--cl-surface);\n display: block;\n }\n\n .scaler-course-card__detail {\n display: flex;\n flex-direction: column;\n flex: 1 1 auto;\n padding: 16px 16px 8px;\n }\n .scaler-course-card__heading,\n .scaler-course-card__heading:link,\n .scaler-course-card__heading:visited {\n font-size: 20px;\n font-weight: 600;\n line-height: 1.4;\n color: var(--cl-text-primary) !important;\n margin: 0 0 8px;\n white-space: nowrap;\n overflow: hidden;\n text-overflow: ellipsis;\n }\n .scaler-course-card__instructor {\n font-size: 14px;\n line-height: 1.86;\n color: var(--cl-text-primary);\n white-space: nowrap;\n overflow: hidden;\n text-overflow: ellipsis;\n }\n .scaler-course-card__instructor b { font-weight: 700; }\n .scaler-course-card__desc {\n flex-grow: 1;\n margin-top: 8px;\n margin-bottom: 12px;\n font-size: 16px;\n line-height: 1.5;\n color: var(--cl-text-secondary);\n display: -webkit-box;\n -webkit-line-clamp: 2;\n -webkit-box-orient: vertical;\n overflow: hidden;\n }\n\n .scaler-course-card__footer {\n display: flex;\n align-items: center;\n justify-content: space-between;\n width: 100%;\n }\n .scaler-course-card__stat {\n display: flex;\n align-items: center;\n gap: 4px;\n font-size: 14px;\n color: var(--cl-text-primary);\n }\n .scaler-course-card__stat svg { width: 18px; height: 18px; flex-shrink: 0; }\n .scaler-course-card__stat img { width: 20px; height: 20px; flex-shrink: 0; }\n\n \/* Side arrows *\/\n .scaler-courses__nav {\n position: absolute !important;\n top: 50% !important;\n transform: translateY(-50%) !important;\n z-index: 2;\n width: 46px !important; height: 46px !important; min-width: 46px;\n display: flex !important; align-items: center; justify-content: center;\n padding: 0 !important;\n background: var(--cl-card-bg) !important;\n border: none !important;\n border-radius: var(--cl-radius-sm) !important;\n box-shadow: var(--cl-shadow) !important;\n color: var(--cl-text-secondary) !important;\n cursor: pointer;\n transition: opacity 0.2s ease, visibility 0.2s ease;\n }\n .scaler-courses__nav--prev { left: 8px !important; }\n .scaler-courses__nav--next { right: 8px !important; }\n .scaler-courses__nav svg { width: 20px !important; height: 20px !important; fill: var(--cl-text-secondary) !important; }\n .scaler-courses__nav.swiper-button-disabled { opacity: 0; visibility: hidden; pointer-events: none; }\n\n .scaler-courses .swiper-button-prev,\n .scaler-courses .swiper-button-next,\n .scaler-courses .swiper-pagination { display: none; }\n\n \/* Skeleton *\/\n .scaler-course-card--skeleton { pointer-events: none; }\n .scaler-course-card--skeleton .scaler-course-card__image,\n .scaler-course-card--skeleton .scaler-course-card__heading,\n .scaler-course-card--skeleton .scaler-course-card__instructor,\n .scaler-course-card--skeleton .scaler-course-card__desc,\n .scaler-course-card--skeleton .scaler-course-card__footer {\n background: linear-gradient(90deg, var(--cl-border) 25%, var(--cl-surface) 50%, var(--cl-border) 75%);\n background-size: 200% 100%;\n animation: cl-shimmer 1.5s infinite;\n color: transparent !important;\n border-radius: 4px;\n }\n .scaler-course-card--skeleton .scaler-course-card__heading { height: 24px; margin: 0 0 8px; }\n .scaler-course-card--skeleton .scaler-course-card__instructor { height: 16px; }\n .scaler-course-card--skeleton .scaler-course-card__footer { height: 20px; }\n @keyframes cl-shimmer { 0% { background-position: 200% 0; } 100% { background-position: -200% 0; } }\n\n .scaler-courses__empty { display: none; }\n\n @media (max-width: 768px) {\n .scaler-courses { padding: 16px; }\n .scaler-courses-swiper .swiper-slide { width: 260px; }\n .scaler-courses__nav { display: none !important; }\n }\n <\/style>\n\n\n <div class=\"scaler-courses js-scaler-courses\">\n\n <template class=\"js-course-card-template\">\n <div class=\"swiper-slide\">\n <a class=\"scaler-course-card js-course-link\" href=\"#\" target=\"_blank\" rel=\"noopener\">\n <img decoding=\"async\" class=\"scaler-course-card__image js-course-image\" src=\"\" alt=\"\" loading=\"lazy\">\n <div class=\"scaler-course-card__detail\">\n <div class=\"scaler-course-card__heading js-course-title\"><\/div>\n <div class=\"scaler-course-card__instructor js-course-instructor\"><\/div>\n <div class=\"scaler-course-card__desc js-course-desc\"><\/div>\n <div class=\"scaler-course-card__footer\">\n <span class=\"scaler-course-card__stat js-course-star\">\n <svg fill=\"currentColor\" viewBox=\"0 0 32 32\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M14.83 2.868c0.342-0.239 0.75-0.368 1.168-0.368s0.826 0.128 1.168 0.368c0.338 0.236 0.596 0.569 0.741 0.955l2.759 6.936c0.003 0.007 0.007 0.013 0.013 0.017s0.013 0.007 0.020 0.007l7.402 0.476c0.411 0.036 0.802 0.194 1.124 0.452s0.559 0.607 0.683 1 0.127 0.815 0.011 1.211c-0.116 0.396-0.347 0.748-0.664 1.013l-5.655 4.714c-0.013 0.011-0.022 0.025-0.028 0.040s-0.006 0.032-0.002 0.047l1.821 7.163c0.107 0.395 0.094 0.812-0.037 1.2-0.133 0.391-0.38 0.734-0.71 0.983s-0.727 0.393-1.14 0.413c-0.413 0.020-0.822-0.084-1.175-0.3l-0.015-0.009-6.307-4.005c-0.004-0.003-0.009-0.004-0.014-0.004s-0.009 0.001-0.013 0.004l-5.876 3.721c-0.389 0.235-0.839 0.347-1.292 0.323s-0.889-0.184-1.251-0.459c-0.361-0.275-0.632-0.652-0.777-1.082-0.143-0.426-0.157-0.885-0.038-1.319l1.684-6.629c0.004-0.016 0.003-0.033-0.002-0.049s-0.015-0.030-0.027-0.040l-5.653-4.714c-0.317-0.264-0.548-0.617-0.664-1.013s-0.112-0.817 0.011-1.211c0.124-0.394 0.361-0.742 0.683-1s0.713-0.416 1.124-0.452l0.023-0.002 7.38-0.476c0.007-0 0.014-0.003 0.020-0.007s0.010-0.010 0.013-0.017l0.008-0.020 2.746-6.913c0.145-0.386 0.403-0.719 0.741-0.956z\"\/><\/svg>\n <span class=\"js-course-star-val\"><\/span>\n <\/span>\n <span class=\"scaler-course-card__stat\">\n <img decoding=\"async\" src=\"https:\/\/d19zaobb0foqu6.cloudfront.net\/topics\/images\/user-check-dark.svg\" alt=\"Enrolled\" loading=\"lazy\">\n <span class=\"js-course-reg\"><\/span>\n <\/span>\n <\/div>\n <\/div>\n <\/a>\n <\/div>\n <\/template>\n\n <div class=\"scaler-courses__inner\">\n <div class=\"scaler-courses__header\">\n <span class=\"scaler-courses__header-icon\">\n <svg fill=\"currentColor\" viewBox=\"0 0 32 32\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M26.259 23.289h-20.518c-1.193 0-2.16-0.967-2.16-2.16v0-14.588c0-1.193 0.967-2.16 2.16-2.16v0h20.518c1.193 0 2.16 0.967 2.16 2.16v0 14.588c0 1.193-0.967 2.16-2.16 2.16v0zM5.741 5.501c-0.574 0-1.040 0.466-1.040 1.040v0 14.588c0 0.574 0.466 1.040 1.040 1.040v0h20.518c0.574 0 1.040-0.466 1.040-1.040v0-14.588c0-0.574-0.466-1.040-1.040-1.040v0z\"\/><path d=\"M19.764 27.619h-7.53c-0.309 0-0.56-0.251-0.56-0.56v0c0-0.309 0.251-0.56 0.56-0.56h7.53c0.309 0 0.56 0.251 0.56 0.56v0c0 0.309-0.251 0.56-0.56 0.56v0z\"\/><path d=\"M14.023 9.322c0.116 0 0.223 0.035 0.312 0.096l-0.002-0.001 5.93 3.953c0.151 0.102 0.249 0.272 0.249 0.466s-0.098 0.364-0.247 0.465l-0.002 0.001-5.93 3.953c-0.087 0.059-0.195 0.094-0.31 0.094-0.309 0-0.56-0.25-0.56-0.559v-7.906c0-0.309 0.251-0.56 0.56-0.56v0zM18.943 13.835l-4.36-2.906v5.813z\"\/><\/svg>\n <\/span>\n <h2 class=\"scaler-courses__title\"><span class=\"ez-toc-section\" id=\"free-courses-by-top-scaler-instructors\"><\/span>Free Courses by top Scaler instructors<span class=\"ez-toc-section-end\"><\/span><\/h2>\n <\/div>\n\n <div class=\"scaler-courses__swiper-wrap\">\n <div class=\"swiper scaler-courses-swiper\">\n <div class=\"swiper-wrapper js-courses-wrapper\"><\/div>\n <div class=\"swiper-pagination\"><\/div>\n <\/div>\n\n <button class=\"scaler-courses__nav scaler-courses__nav--prev js-courses-prev\" aria-label=\"Previous\">\n <svg fill=\"currentColor\" viewBox=\"0 0 32 32\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"transform: rotate(-90deg);\"><path d=\"M5.313 16l10.688-10.688 10.688 10.688-1.938 1.875-7.438-7.438v16.25h-2.625v-16.25l-7.5 7.438z\"\/><\/svg>\n <\/button>\n <button class=\"scaler-courses__nav scaler-courses__nav--next js-courses-next\" aria-label=\"Next\">\n <svg fill=\"currentColor\" viewBox=\"0 0 32 32\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"transform: rotate(90deg);\"><path d=\"M5.313 16l10.688-10.688 10.688 10.688-1.938 1.875-7.438-7.438v16.25h-2.625v-16.25l-7.5 7.438z\"\/><\/svg>\n <\/button>\n <\/div>\n <\/div>\n <\/div>\n\n <script>\n document.addEventListener(\"DOMContentLoaded\", () => {\n const EXTRA_COUNT_ADDED = 1000;\n\n \/\/ Mirrors getInstructorStar(): first token of the headline.\n function getInstructorStar(headline) {\n return (headline || \"\").toString().split(\" \")[0] || \"\";\n }\n\n document.querySelectorAll(\".js-scaler-courses\").forEach(container => {\n if (container.dataset.initialized === \"true\") return;\n container.dataset.initialized = \"true\";\n\n const swiperElement = container.querySelector(\".scaler-courses-swiper\");\n const wrapper = container.querySelector(\".js-courses-wrapper\");\n const template = container.querySelector(\".js-course-card-template\");\n const nextBtn = container.querySelector(\".js-courses-next\");\n const prevBtn = container.querySelector(\".js-courses-prev\");\n\n if (!wrapper || !template) return;\n\n const swiper = new Swiper(swiperElement, {\n slidesPerView: \"auto\",\n spaceBetween: 16,\n grabCursor: true,\n observer: true,\n observeParents: true,\n navigation: { nextEl: nextBtn, prevEl: prevBtn },\n });\n\n const pathParts = location.pathname.split(\"\/\").filter(Boolean);\n const currentSlug = pathParts.length > 0 ? pathParts[pathParts.length - 1] : \"homepage\";\n\n function showSkeletons(count = 4) {\n wrapper.innerHTML = \"\";\n for (let i = 0; i < count; i++) {\n const clone = template.content.cloneNode(true);\n clone.querySelector(\".scaler-course-card\").classList.add(\"scaler-course-card--skeleton\");\n wrapper.appendChild(clone);\n }\n swiper.update();\n }\n\n function renderCourses(courses) {\n wrapper.innerHTML = \"\";\n if (!courses.length) { container.style.display = \"none\"; return; }\n\n courses.forEach(item => {\n const a = item.attributes || {};\n const clone = template.content.cloneNode(true);\n const instructor = (a.instructors_data && a.instructors_data[0]) || {};\n\n clone.querySelector(\".js-course-link\").href =\n `https:\/\/www.scaler.com\/topics\/course\/${a.slug}\/?utm_source=blog&utm_medium=free_courses&utm_content=${currentSlug}`;\n\n const img = clone.querySelector(\".js-course-image\");\n img.src = a.cover_image_thumbnail || a.featured_image || \"\";\n img.alt = a.title || \"\";\n\n clone.querySelector(\".js-course-title\").textContent = a.title || \"\";\n\n const instrEl = clone.querySelector(\".js-course-instructor\");\n if (instructor.name) {\n instrEl.innerHTML = \"A Course by <b><\/b>\";\n instrEl.querySelector(\"b\").textContent = instructor.name;\n } else {\n instrEl.style.display = \"none\";\n }\n\n clone.querySelector(\".js-course-desc\").textContent = a.description || \"\";\n\n \/\/ Star\n const star = getInstructorStar(instructor.star_headline);\n const starWrap = clone.querySelector(\".js-course-star\");\n if (star && star !== \"0\") clone.querySelector(\".js-course-star-val\").textContent = star;\n else starWrap.style.display = \"none\";\n\n \/\/ Enrolled count (+1000 like topics)\n clone.querySelector(\".js-course-reg\").textContent =\n ((a.user_registration_count || 0) + EXTRA_COUNT_ADDED).toLocaleString(\"en-US\");\n\n wrapper.appendChild(clone);\n });\n\n swiper.update();\n swiper.slideTo(0);\n }\n\n async function fetchCourses() {\n try {\n showSkeletons();\n \/\/ Public same-origin endpoint (topics course search). Returns 6 free courses.\n const res = await fetch(\"\/topics\/api\/v1\/search\/courses\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application\/json\",\n \"Accept\": \"application\/json\",\n \"X-Requested-With\": \"XMLHttpRequest\",\n },\n body: JSON.stringify({\n filters: {\n q: \"\",\n page: { limit: 6, current_page: 1 },\n sort: { key: \"user_registration_count\", order: \"desc\" },\n filter_type: null,\n tags: [],\n program: [],\n level: [],\n category_type: [],\n },\n }),\n });\n const json = await res.json();\n const courses = (json && json.data) || [];\n renderCourses(courses);\n } catch (error) {\n console.error(\"Failed to load courses:\", error);\n container.style.display = \"none\";\n }\n }\n\n fetchCourses();\n });\n });\n <\/script>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"module-3-%e2%80%93-basic-sql-queries-and-filtering\"><\/span><strong>Module 3 – Basic SQL Queries and Filtering<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">This is generally the level at which you can start formulating SQL queries and processing actual data in tables. Most people tend to start with basic SELECT queries before moving forward to advanced topics like filters, sortings, and record retrieval from databases.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Concepts covered in this unit include SELECT, FROM, WHERE, ORDER BY, LIMIT\/TOP, DISTINCT, aliases, comparison operators, logical operators, LIKE, IN, BETWEEN, and NULL.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Some beginner-level SQL query examples usually include:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">— Fetch all employee records<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SELECT * FROM employees;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">— Filter employees with a salary above 50,000<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SELECT * FROM employees<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">WHERE salary > 50000;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">— Sort products by price<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SELECT * FROM products<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">ORDER BY price DESC;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">— Find unique departments<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SELECT DISTINCT department<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">FROM employees;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">— Find employees in specific departments<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SELECT * FROM employees<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">WHERE department IN (‘Sales’, ‘Marketing’);<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">These examples are basically some of the most common SQL query patterns used in databases. As you progress further, they combine filtering, sorting, grouping, and joins to solve more complex business and analytics problems. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"module-4-%e2%80%93-aggregation-grouping-and-reporting-queries\"><\/span><strong>Module 4 – Aggregation, Grouping, and Reporting Queries<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">After gaining proficiency with fundamental SQL commands, the next level in learning the programming language involves gaining skills in summarizing and analyzing data. This is the module during which the learner begins to realize practical uses of SQL in reporting and analytics.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The functions in focus in the current module include such basic functions as COUNT, SUM, AVG, MIN, and MAX, and also GROUP BY and HAVING statements. It typically involves the use of such statements in generating summary tables and reports from databases.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">These aggregate functions in SQL are commonly used to summarize large datasets and generate reports for analytics and business decision-making. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">During this module, we often carry out tasks related to calculating the number of sales made, the average salary of employees, the total number of customers, the number of products grouped into categories, and other such tasks.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"module-5-%e2%80%93-sql-joins-with-examples\"><\/span><strong>Module 5 – SQL Joins with Examples<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">It is one of the key topics in SQL, since in real life, databases do not contain information in one table but store it in several tables. It is when people comprehend how different sets of data relate to each other.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">One of the most often-tested concepts in SQL is joins, since it is unlikely that all database information will be kept in one table alone in the real world. This course aims to help students know how to perform joins correctly and not fall into traps like duplicate records.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">All practice cases in this module include tables named customers, orders, and products. People mostly create queries to select customers’ orders, merge the product set with the sales set, join several tables, and create reports based on relevant datasets.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To learn more about joins, you can check out: <a href=\"https:\/\/www.scaler.com\/topics\/sql\/joins-in-sql\/\">SQL JOINS<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"module-6-%e2%80%93-subqueries-nested-queries-and-ctes\"><\/span><strong>Module 6 – Subqueries, Nested Queries, and CTEs<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">After learning about joins and filters, learners move towards creating more complex SQL statements using sub-queries and CTEs.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This module will deal with scalar sub-queries, correlated sub-queries, EXISTS\/ NOT EXISTS, IN using sub-queries, and WITH statements or CTEs. We will know when to use join operations, sub-queries, and CTEs.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The major application of this is filtering records by using nested queries and simplifying complex SQL queries using CTEs.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"module-7-%e2%80%93-sql-functions-for-data-cleaning-and-analysis\"><\/span><strong>Module 7 – SQL Functions for Data Cleaning and Analysis<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">After getting acquainted with querying, your next step would be learning about the various methods of transforming and analyzing data through the use of SQL functions.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This module covers various types of SQL functions, such as string functions, date functions, numeric functions, aggregate functions, the CASE statement, COALESCE, and NULLIF functions.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">These functions are commonly used when cleaning data, formatting data, dealing with missing data, calculating, and generating reports. At this point, your practice will include name formatting, date extraction, replacing NULLs, summing up, and analysis of sales\/employees’ data.<\/p>\n\n\n<style data-wp-block-html=\"css\">\n<style>\n :root {\n --sp-brand: #255aad; \/* brand blue *\/\n --sp-brand-hover: #19468c;\n --sp-card-bg: #ffffff; \/* neutral-scale-0 *\/\n --sp-surface: #f4f6f9; \/* neutral-scale-2 *\/\n --sp-pill-bg: #f8fafc;\n --sp-border: #d6dee5; \/* neutral-scale-4 *\/\n --sp-text-primary: #1a2c47; \/* neutral-scale-12 *\/\n --sp-text-secondary: #61738e; \/* neutral-scale-9 *\/\n }\n\n .scaler-placement * { box-sizing: border-box; }\n\n .scaler-placement {\n font-family: \"Source Sans 3\", \"Source Sans Pro\", \"Roboto\", Arial, sans-serif;\n width: 100%;\n max-width: 100%;\n margin: 24px auto;\n display: flex;\n flex-direction: column;\n }\n\n \/* ---- Placement report (OnlineCallout) ---- *\/\n .scaler-placement__title {\n font-size: 24px;\n font-weight: 600;\n line-height: 1.3;\n color: var(--sp-text-primary);\n margin: 0 0 16px;\n }\n\n .scaler-placement__card {\n display: flex;\n flex-direction: column;\n width: 100%;\n background: var(--sp-card-bg);\n border: 1px solid var(--sp-border);\n border-radius: 20px;\n padding: 16px;\n box-shadow: 0 8px 32px rgba(37, 90, 173, 0.04);\n overflow: hidden;\n gap: 5px;\n }\n\n .scaler-placement__top {\n display: flex;\n flex-direction: row;\n align-items: center;\n width: 100%;\n gap: 18px;\n }\n\n .scaler-placement__stat-block {\n display: flex;\n flex-direction: column;\n justify-content: center;\n align-items: center;\n width: 30%;\n min-width: 200px;\n flex-shrink: 0;\n background: var(--sp-surface);\n border: 1px solid var(--sp-border);\n border-radius: 16px;\n padding: 16px 10px;\n gap: 8px;\n }\n .scaler-placement__stat-number {\n font-size: 48px;\n font-weight: 600;\n line-height: 1;\n color: var(--sp-brand);\n text-align: center;\n }\n .scaler-placement__stat-label {\n font-size: 13px;\n font-weight: 600;\n line-height: 14px;\n color: rgba(37, 90, 173, 0.85);\n text-transform: uppercase;\n letter-spacing: 0.8px;\n }\n\n .scaler-placement__info {\n display: flex;\n flex-direction: column;\n justify-content: center;\n flex: 1;\n gap: 10px;\n }\n .scaler-placement__proof-header {\n display: flex;\n flex-direction: row;\n align-items: center;\n gap: 8px;\n }\n .scaler-placement__proof-header svg { width: 18px; height: 18px; flex-shrink: 0; }\n .scaler-placement__proof-label {\n font-size: 12px;\n font-weight: 600;\n line-height: 16px;\n color: var(--sp-brand);\n text-transform: uppercase;\n letter-spacing: 1px;\n }\n .scaler-placement__body-text {\n font-size: 16px;\n font-weight: 400;\n line-height: 24px;\n color: var(--sp-text-primary);\n margin: 0;\n }\n\n .scaler-placement__bottom {\n display: flex;\n flex-direction: column;\n align-items: flex-start;\n margin-left: calc(30% + 18px);\n width: calc(70% - 18px);\n gap: 12px;\n }\n .scaler-placement__stats-row {\n display: flex;\n flex-direction: row;\n align-items: center;\n gap: 24px;\n }\n .scaler-placement__stat-item {\n display: flex;\n flex-direction: row;\n align-items: center;\n gap: 8px;\n }\n .scaler-placement__stat-item > svg {\n color: var(--sp-brand);\n width: 18px;\n height: 18px;\n flex-shrink: 0;\n }\n .scaler-placement__stat-text {\n display: flex;\n flex-direction: row;\n align-items: center;\n gap: 4px;\n }\n .scaler-placement__stat-value {\n font-size: 16px;\n font-weight: 600;\n line-height: 24px;\n color: var(--sp-text-primary);\n }\n .scaler-placement__stat-desc {\n font-size: 14px;\n font-weight: 400;\n line-height: 20px;\n color: var(--sp-text-secondary);\n }\n\n .scaler-placement__cta,\n .scaler-placement__cta:link,\n .scaler-placement__cta:visited {\n display: inline-flex;\n align-items: center;\n align-self: flex-start;\n font-size: 14px;\n font-weight: 600;\n line-height: 20px;\n color: var(--sp-brand) !important;\n gap: 6px;\n text-decoration: none;\n cursor: pointer;\n margin-top: 2px;\n transition: color 0.25s ease;\n }\n .scaler-placement__cta:hover,\n .scaler-placement__cta:focus { color: var(--sp-brand-hover) !important; }\n .scaler-placement__cta svg {\n width: 14px;\n height: 14px;\n fill: currentColor;\n transition: transform 0.25s ease;\n }\n .scaler-placement__cta:hover svg { transform: translateX(3px); }\n\n \/* ---- Hiring Partners ---- *\/\n .scaler-hiring {\n display: flex;\n align-items: center;\n justify-content: center;\n flex-wrap: wrap;\n gap: 8px 12px;\n margin: 24px 0 8px;\n padding-top: 16px;\n border-top: 1px solid var(--sp-border);\n }\n .scaler-hiring__label {\n font-size: 14px;\n color: var(--sp-text-secondary);\n white-space: nowrap;\n }\n .scaler-hiring__pills {\n display: flex;\n align-items: center;\n flex-wrap: wrap;\n gap: 8px;\n }\n .scaler-hiring__pill {\n display: inline-flex;\n align-items: center;\n gap: 6px;\n padding: 5px 12px 5px 5px;\n background: var(--sp-pill-bg);\n border-radius: 999px;\n }\n .scaler-hiring__badge {\n display: inline-flex;\n align-items: center;\n justify-content: center;\n flex-shrink: 0;\n width: 24px;\n height: 24px;\n border-radius: 50%;\n background: #ffffff;\n }\n .scaler-hiring__logo {\n width: 16px !important;\n height: 16px !important;\n object-fit: contain;\n margin: 0 !important;\n display: block;\n }\n .scaler-hiring__name {\n font-size: 14px;\n font-weight: 600;\n color: var(--sp-text-primary);\n }\n .scaler-hiring__more {\n font-size: 14px;\n color: var(--sp-text-secondary);\n }\n\n @media (max-width: 768px) {\n .scaler-placement__title { font-size: 18px; margin-bottom: 12px; }\n .scaler-placement__card { gap: 16px; border-radius: 16px; }\n .scaler-placement__top { gap: 12px; }\n .scaler-placement__stat-block { width: 35%; min-width: 110px; padding: 12px 8px; gap: 4px; }\n .scaler-placement__stat-number { font-size: 24px; }\n .scaler-placement__stat-label { font-size: 10px; }\n .scaler-placement__body-text { font-size: 14px; line-height: 20px; }\n .scaler-placement__bottom { margin-left: 0; width: 100%; gap: 16px; }\n .scaler-placement__stats-row { flex-wrap: wrap; gap: 10px 16px; }\n .scaler-placement__stat-value { font-size: 14px; line-height: 20px; }\n .scaler-placement__stat-desc { font-size: 12px; line-height: 16px; }\n }\n<\/style>\n\n<meta charset=\"UTF-8\">\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n\n <!-- Source Sans Pro (topics font) -->\n <link href=\"https:\/\/fonts.googleapis.com\/css2?family=Source+Sans+3:wght@400;600;700&display=swap\" rel=\"stylesheet\">\n\n<div class=\"scaler-placement\">\n <h2 class=\"scaler-placement__title\"><span class=\"ez-toc-section\" id=\"scaler-placement-report-and-statistics\"><\/span>Scaler Placement Report and Statistics<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n <div class=\"scaler-placement__card\">\n <div class=\"scaler-placement__top\">\n <div class=\"scaler-placement__stat-block\">\n <div class=\"scaler-placement__stat-number\">\u20b923L<\/div>\n <div class=\"scaler-placement__stat-label\">AVG CTC<\/div>\n <\/div>\n <div class=\"scaler-placement__info\">\n <div class=\"scaler-placement__proof-header\">\n <svg viewBox=\"0 0 21 21\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M8.64 0 0 8.683V21h12.257l8.64-8.683V0H8.64zm-.11 17.257H3.725v-4.828H8.53v4.828zm7.901-1.88-4.174 4.194V8.684H1.447l4.076-4.14h10.914l-.006 10.83v.004z\" fill=\"#255aad\"><\/path><\/svg>\n <span class=\"scaler-placement__proof-label\">SCALER PLACEMENT PROOF<\/span>\n <\/div>\n <p class=\"scaler-placement__body-text\">\n Scaler learners achieved 2.5x salary growth with average post-Scaler CTC reaching \u20b923L.\n <\/p>\n <\/div>\n <\/div>\n\n <div class=\"scaler-placement__bottom\">\n <div class=\"scaler-placement__stats-row\">\n <div class=\"scaler-placement__stat-item\">\n <svg fill=\"currentColor\" viewBox=\"0 0 32 32\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M11.199 7.957c-3.086 0-5.588 2.502-5.588 5.588s2.502 5.588 5.588 5.588c3.086 0 5.588-2.502 5.588-5.588s-2.502-5.588-5.588-5.588zM3.611 13.545c0-4.191 3.397-7.588 7.588-7.588s7.588 3.397 7.588 7.588c0 4.191-3.397 7.588-7.588 7.588s-7.588-3.397-7.588-7.588z\"><\/path><path d=\"M21.090 6.369h0.003c1.989 0 3.897 0.79 5.303 2.197s2.197 3.314 2.197 5.303-0.79 3.897-2.197 5.303c-1.406 1.407-3.314 2.197-5.303 2.197-0.552 0-1-0.448-1-1s0.448-1 1-1c1.459 0 2.858-0.579 3.889-1.611s1.611-2.43 1.611-3.889c0-1.459-0.58-2.858-1.611-3.889s-2.429-1.611-3.888-1.611c-0.507 0.002-1.013 0.070-1.502 0.203-0.533 0.145-1.082-0.17-1.227-0.703s0.17-1.082 0.703-1.227c0.659-0.179 1.339-0.27 2.021-0.272z\"><\/path><path d=\"M10.906 21.364c-1.605 0-3.186 0.386-4.61 1.126s-2.649 1.811-3.572 3.124c-0.318 0.452-0.941 0.561-1.393 0.243s-0.561-0.941-0.243-1.393c1.107-1.576 2.577-2.862 4.286-3.749s3.606-1.351 5.532-1.351 3.823 0.463 5.532 1.351c1.709 0.888 3.179 2.174 4.286 3.749 0.318 0.452 0.209 1.076-0.243 1.393s-1.076 0.209-1.393-0.243c-0.923-1.313-2.148-2.385-3.572-3.124s-3.005-1.126-4.61-1.126z\"><\/path><path d=\"M25.704 22.493c-1.424-0.74-3.005-1.125-4.61-1.124-0.552 0-1-0.447-1.001-0.999s0.447-1 0.999-1.001c1.926-0.001 3.824 0.462 5.533 1.349s3.179 2.174 4.286 3.751c0.317 0.452 0.208 1.076-0.244 1.393s-1.076 0.208-1.393-0.244c-0.922-1.313-2.147-2.385-3.571-3.125z\"><\/path><\/svg>\n <div class=\"scaler-placement__stat-text\">\n <span class=\"scaler-placement__stat-value\">11,000+<\/span>\n <span class=\"scaler-placement__stat-desc\">placements<\/span>\n <\/div>\n <\/div>\n <div class=\"scaler-placement__stat-item\">\n <svg fill=\"currentColor\" viewBox=\"0 0 32 32\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M1.2 27.5c0-0.442 0.358-0.8 0.8-0.8h28c0.442 0 0.8 0.358 0.8 0.8s-0.358 0.8-0.8 0.8h-28c-0.442 0-0.8-0.358-0.8-0.8z\"><\/path><path d=\"M3.727 4.227c0.338-0.338 0.795-0.527 1.273-0.527h12c0.477 0 0.935 0.19 1.273 0.527s0.527 0.795 0.527 1.273v22c0 0.442-0.358 0.8-0.8 0.8s-0.8-0.358-0.8-0.8v-22c0-0.053-0.021-0.104-0.059-0.141s-0.088-0.059-0.141-0.059h-12c-0.053 0-0.104 0.021-0.141 0.059s-0.059 0.088-0.059 0.141v22c0 0.442-0.358 0.8-0.8 0.8s-0.8-0.358-0.8-0.8v-22c0-0.477 0.19-0.935 0.527-1.273z\"><\/path><path d=\"M17.2 12.5c0-0.442 0.358-0.8 0.8-0.8h9c0.477 0 0.935 0.19 1.273 0.527s0.527 0.795 0.527 1.273v14c0 0.442-0.358 0.8-0.8 0.8s-0.8-0.358-0.8-0.8v-14c0-0.053-0.021-0.104-0.059-0.141s-0.088-0.059-0.141-0.059h-9c-0.442 0-0.8-0.358-0.8-0.8z\"><\/path><path d=\"M7.2 9.5c0-0.442 0.358-0.8 0.8-0.8h4c0.442 0 0.8 0.358 0.8 0.8s-0.358 0.8-0.8 0.8h-4c-0.442 0-0.8-0.358-0.8-0.8z\"><\/path><path d=\"M9.2 17.5c0-0.442 0.358-0.8 0.8-0.8h4c0.442 0 0.8 0.358 0.8 0.8s-0.358 0.8-0.8 0.8h-4c-0.442 0-0.8-0.358-0.8-0.8z\"><\/path><path d=\"M7.2 22.5c0-0.442 0.358-0.8 0.8-0.8h4c0.442 0 0.8 0.358 0.8 0.8s-0.358 0.8-0.8 0.8h-4c-0.442 0-0.8-0.358-0.8-0.8z\"><\/path><path d=\"M21.2 22.5c0-0.442 0.358-0.8 0.8-0.8h2c0.442 0 0.8 0.358 0.8 0.8s-0.358 0.8-0.8 0.8h-2c-0.442 0-0.8-0.358-0.8-0.8z\"><\/path><path d=\"M21.2 17.5c0-0.442 0.358-0.8 0.8-0.8h2c0.442 0 0.8 0.358 0.8 0.8s-0.358 0.8-0.8 0.8h-2c-0.442 0-0.8-0.358-0.8-0.8z\"><\/path><\/svg>\n <div class=\"scaler-placement__stat-text\">\n <span class=\"scaler-placement__stat-value\">650+<\/span>\n <span class=\"scaler-placement__stat-desc\">companies<\/span>\n <\/div>\n <\/div>\n <div class=\"scaler-placement__stat-item\">\n <svg viewBox=\"0 0 25 24\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M5.60938 18.8906C4.74688 18.0281 5.31875 16.2188 4.87813 15.1594C4.4375 14.1 2.75 13.1719 2.75 12C2.75 10.8281 4.41875 9.9375 4.87813 8.84063C5.3375 7.74375 4.74688 5.97187 5.60938 5.10938C6.47187 4.24688 8.28125 4.81875 9.34063 4.37813C10.4 3.9375 11.3281 2.25 12.5 2.25C13.6719 2.25 14.5625 3.91875 15.6594 4.37813C16.7562 4.8375 18.5281 4.24688 19.3906 5.10938C20.2531 5.97187 19.6812 7.78125 20.1219 8.84063C20.5625 9.9 22.25 10.8281 22.25 12C22.25 13.1719 20.5813 14.0625 20.1219 15.1594C19.6625 16.2562 20.2531 18.0281 19.3906 18.8906C18.5281 19.7531 16.7188 19.1812 15.6594 19.6219C14.6 20.0625 13.6719 21.75 12.5 21.75C11.3281 21.75 10.4375 20.0813 9.34063 19.6219C8.24375 19.1625 6.47187 19.7531 5.60938 18.8906Z\" fill=\"#ffffff\" stroke=\"#255aad\" stroke-width=\"1.4\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><\/path><path d=\"M16.625 9.75L11.1219 15L8.375 12.375\" stroke=\"#255aad\" stroke-width=\"1.4\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><\/path><\/svg>\n <span class=\"scaler-placement__stat-desc\">Verified data<\/span>\n <\/div>\n <\/div>\n\n <a class=\"scaler-placement__cta\" href=\"https:\/\/d2beiqkhq929f0.cloudfront.net\/public_assets\/assets\/000\/195\/869\/original\/Scaler_Career_Report.pdf?1778499863\" target=\"_blank\" rel=\"noopener\">\n See full placement report\n <svg viewBox=\"0 0 32 32\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"transform: rotate(90deg);\"><path d=\"M5.313 16l10.688-10.688 10.688 10.688-1.938 1.875-7.438-7.438v16.25h-2.625v-16.25l-7.5 7.438z\"><\/path><\/svg>\n <\/a>\n <\/div>\n <\/div>\n\n <div class=\"scaler-hiring\">\n <span class=\"scaler-hiring__label\">Hiring Partners:<\/span>\n <div class=\"scaler-hiring__pills\">\n <span class=\"scaler-hiring__pill\">\n <span class=\"scaler-hiring__badge\"><img decoding=\"async\" class=\"scaler-hiring__logo\" src=\"https:\/\/d19zaobb0foqu6.cloudfront.net\/topics\/images\/googleicon_.svg\" alt=\"Google\" loading=\"lazy\"><\/span>\n <span class=\"scaler-hiring__name\">Google<\/span>\n <\/span>\n <span class=\"scaler-hiring__pill\">\n <span class=\"scaler-hiring__badge\"><img decoding=\"async\" class=\"scaler-hiring__logo\" src=\"https:\/\/d19zaobb0foqu6.cloudfront.net\/topics\/images\/amazonicon_.svg\" alt=\"Amazon\" loading=\"lazy\"><\/span>\n <span class=\"scaler-hiring__name\">Amazon<\/span>\n <\/span>\n <span class=\"scaler-hiring__pill\">\n <span class=\"scaler-hiring__badge\"><img decoding=\"async\" class=\"scaler-hiring__logo\" src=\"https:\/\/d19zaobb0foqu6.cloudfront.net\/topics\/images\/microsoft.svg\" alt=\"Microsoft\" loading=\"lazy\"><\/span>\n <span class=\"scaler-hiring__name\">Microsoft<\/span>\n <\/span>\n <span class=\"scaler-hiring__pill\">\n <span class=\"scaler-hiring__badge\"><img decoding=\"async\" class=\"scaler-hiring__logo\" src=\"https:\/\/d19zaobb0foqu6.cloudfront.net\/topics\/images\/flipkarticon_.svg\" alt=\"Flipkart\" loading=\"lazy\"><\/span>\n <span class=\"scaler-hiring__name\">Flipkart<\/span>\n <\/span>\n <span class=\"scaler-hiring__pill\">\n <span class=\"scaler-hiring__badge\"><img decoding=\"async\" class=\"scaler-hiring__logo\" src=\"https:\/\/d19zaobb0foqu6.cloudfront.net\/topics\/images\/adobeicon_.svg\" alt=\"Adobe\" loading=\"lazy\"><\/span>\n <span class=\"scaler-hiring__name\">Adobe<\/span>\n <\/span>\n <span class=\"scaler-hiring__more\">1200+ more<\/span>\n <\/div>\n <\/div>\n <\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"module-8-advanced-sql-window-functions-views-indexes-and-transactions\"><\/span><strong>Module 8 - Advanced SQL: Window Functions, Views, Indexes, and Transactions<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">It's here that SQL will become much more interesting for you!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Some of the topics for this module include: row_number(), rank(), dense_rank(), lead(), lag(), running totals, views, indexes, transactions, ACID properties, committing, and rolling back transactions.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL becomes much more analytical and backend-focused from here. Some of the common tasks done at this level of SQL include things such as ranking rows, working with datasets for comparisons, calculating running totals, speeding up slow queries, and managing transactions.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Many SQL interview questions that seem difficult at first become much easier once you understand window functions.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"module-9-sql-for-data-analysis-backend-development-and-bi\"><\/span><strong>Module 9 - SQL for Data Analysis, Backend Development, and BI<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">So this stage is quite important; here you will have to see what kind of practices you should take in accordance with your goal. Data analysts mainly use SQL for reporting and dashboards, backend developers use it for application databases and APIs, while BI professionals use SQL for preparing dashboard-ready datasets.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Role<\/strong><\/td><td><strong>SQL Topics to Prioritize<\/strong><\/td><td><strong>Project Idea<\/strong><\/td><td><strong>You can learn through<\/strong><\/td><\/tr><tr><td>Data Analyst<\/td><td>Aggregations, joins, functions, window functions<\/td><td>Sales or analytics dashboard<\/td><td><a href=\"https:\/\/www.scaler.com\/data-science-course\/\">Data Science Course<\/a><\/td><\/tr><tr><td>Backend Developer<\/td><td>Database design, joins, transactions, optimization<\/td><td>E-commerce backend database<\/td><td><a href=\"https:\/\/www.scaler.com\/courses\/full-stack-developer\/\">Full Stack Developer Course<\/a><\/td><\/tr><tr><td>BI & Reporting Learner<\/td><td>Reporting queries, filtering, and dashboard datasets<\/td><td>Business reporting dashboard<\/td><td><a href=\"https:\/\/www.scaler.com\/blog\/backend-developer-roadmap\/\">Backend Roadmap <\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"sql-projects-and-practice-labs\"><\/span><strong>SQL Projects and Practice Labs<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">SQL projects are crucial as they provide beginners an opportunity to apply knowledge about how databases and queries work in practical use cases rather than syntax practices alone.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Common beginner-level SQL projects include student databases, library management systems, and employee databases. They emphasize knowledge about tables, queries, filters, and joins.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the intermediate level, common SQL projects include e-commerce sales analysis, customer order systems, HR analytics, and movie databases. Here, the use of joins, aggregations, reports, and functions becomes more emphasized.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">At advanced levels, SQL projects typically center around analytical dashboard databases, cohort analysis, churn analysis, and backend schemas of applications. This is the level where SQL skills are highly applied to reporting and optimization needs.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"sql-interview-preparation-what-to-revise-from-the-syllabus\"><\/span><strong>SQL Interview Preparation: What to Revise from the Syllabus<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">SQL interviews primarily test the ability of the candidate to write SQL queries and solve database-related problems using actual data sets.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Freshers are tested based on joins, filtering, grouping, aggregates, subqueries, constraints, and basic knowledge of normalization. Data analyst positions are more concerned about reporting queries and window functions.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Backend development interviews involve topics like joins, indexing, transaction management, performance tuning, and database design principles. Advanced concepts related to queries, CTE, etc., are also tested for experienced candidates.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can check out these <a href=\"https:\/\/www.interviewbit.com\/sql-interview-questions\/\" target=\"_blank\" rel=\"noopener\">SQL Interview Questions <\/a>for a deeper understanding and practice. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"how-long-does-it-take-to-complete-the-sql-syllabus\"><\/span><strong>How Long Does It Take to Complete the SQL Syllabus?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Learning SQL queries for the beginner level can normally be completed in about one week through continuous practice. Learning SQL queries that are complex, such as joining tables, using functions, the GROUP BY clause, and subqueries, takes around two to five weeks, while learning more complex topics takes six to eight weeks.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Normally, learning how to solve SQL problems or even preparing for interviews requires about two to three months. The best approach to learning SQL is through query solving and practical data sets rather than learning only theoretically.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"free-sql-course-vs-structured-program-what-should-you-choose\"><\/span><strong>Free SQL Course vs Structured Program - What Should You Choose?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Basic SQL can easily be learned through free SQL tutorial programs because most basic SQL involves things like writing SQL queries, filtering, joining, SQL functions, etc. Free SQL tutorial programs would be perfect for students or people learning SQL for the first time. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A good SQL tutorial for beginners typically focuses on query fundamentals, filtering, joins, and hands-on practice before introducing advanced concepts such as window functions and query optimization.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Most people can learn SQL syntax from free resources. The harder part is building enough projects and query-solving experience to use SQL confidently at work. <\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Learning Option<\/strong><\/td><td><strong>Best For<\/strong><\/td><td><strong>Main Focus<\/strong><\/td><\/tr><tr><td><a href=\"https:\/\/www.scaler.com\/topics\/sql\/\">Free SQL Tutorials<\/a><\/td><td>Beginners and self-learners<\/td><td>SQL syntax, commands, and query practice<\/td><\/tr><tr><td><a href=\"https:\/\/www.scaler.com\/topics\/course\/python-sql-data-science\/\">Structured Programs<\/a><\/td><td>Career-focused learners<\/td><td>Projects, mentorship, interviews, and real-world applications<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n<meta charset=\"UTF-8\">\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n\n <!-- Source Sans Pro (topics font) -->\n <link href=\"https:\/\/fonts.googleapis.com\/css2?family=Source+Sans+3:wght@400;600;700&display=swap\" rel=\"stylesheet\">\n <link rel=\"stylesheet\" href=\"https:\/\/cdn.jsdelivr.net\/npm\/swiper@11\/swiper-bundle.min.css\">\n <script src=\"https:\/\/cdn.jsdelivr.net\/npm\/swiper@11\/swiper-bundle.min.js\"><\/script>\n\n <style>\n :root {\n --ss-primary: #005bb3; \/* primary-color-80 *\/\n --ss-card-bg: #ffffff;\n --ss-border: #e6e6e6;\n --ss-quote-bg: #f6f6f6;\n --ss-text-dark: #1c1c1c;\n --ss-text-mid: #6b6b6b;\n --ss-text-muted: #9a9a9a;\n --ss-radius: 12px;\n --ss-radius-sm: 8px;\n --ss-shadow: 0 8px 16px 0 rgba(50, 71, 102, 0.16);\n }\n\n .scaler-ss * { box-sizing: border-box; }\n\n .scaler-ss {\n font-family: \"Source Sans 3\", \"Source Sans Pro\", \"Roboto\", Arial, sans-serif;\n padding: 24px;\n width: 100%;\n }\n .scaler-ss__inner {\n max-width: 1000px;\n margin: 0 auto;\n position: relative;\n width: 100%;\n }\n\n \/* Heading *\/\n .scaler-ss__heading {\n font-size: 26px;\n line-height: 34px;\n font-weight: 700;\n margin: 0 0 16px;\n text-align: center;\n color: var(--ss-text-dark);\n }\n\n \/* Swiper *\/\n .scaler-ss__swiper-wrap { position: relative; }\n .scaler-ss .swiper { width: 100%; padding: 4px; }\n .scaler-ss-swiper .swiper-slide {\n width: 300px; \/* topics card width *\/\n height: auto;\n display: flex;\n }\n\n \/* Card *\/\n .scaler-ss-card {\n display: flex;\n flex-direction: column;\n width: 100%;\n border: 1px solid var(--ss-border);\n border-radius: var(--ss-radius);\n overflow: hidden;\n background: var(--ss-card-bg);\n }\n\n .scaler-ss-card__hike {\n padding: 8px 12px;\n background: var(--ss-primary);\n color: #ffffff;\n font-size: 14px;\n font-weight: 700;\n text-align: center;\n letter-spacing: 0.4px;\n }\n\n .scaler-ss-card__body {\n display: flex;\n flex: 1 1 auto;\n flex-direction: column;\n gap: 12px;\n padding: 16px;\n }\n\n \/* Person *\/\n .scaler-ss-card__person {\n display: flex;\n align-items: center;\n gap: 10px;\n }\n .scaler-ss-card__avatar {\n width: 44px;\n height: 44px;\n min-width: 44px;\n border-radius: 50%;\n object-fit: cover;\n background: var(--ss-quote-bg);\n }\n .scaler-ss-card__name {\n font-size: 16px;\n font-weight: 700;\n line-height: 20px;\n color: var(--ss-text-dark);\n }\n .scaler-ss-card__city {\n font-size: 13px;\n line-height: 18px;\n color: var(--ss-text-mid);\n }\n\n \/* Before \/ Now transition *\/\n .scaler-ss-card__transition {\n display: flex;\n align-items: center;\n justify-content: space-between;\n gap: 8px;\n }\n .scaler-ss-card__col {\n flex: 1;\n min-width: 0;\n }\n .scaler-ss-card__col-label {\n font-size: 11px;\n font-weight: 600;\n letter-spacing: 0.4px;\n color: var(--ss-text-muted);\n margin-bottom: 2px;\n }\n .scaler-ss-card__col-role {\n font-size: 13px;\n line-height: 18px;\n color: var(--ss-text-mid);\n }\n .scaler-ss-card__col-company {\n font-size: 14px;\n font-weight: 700;\n line-height: 20px;\n color: var(--ss-text-dark);\n }\n .scaler-ss-card__company-logo {\n margin-top: 2px;\n max-width: 64px;\n max-height: 20px;\n width: auto;\n height: auto;\n object-fit: contain;\n display: block;\n }\n .scaler-ss-card__arrow {\n flex-shrink: 0;\n width: 28px;\n height: 8px;\n color: var(--ss-text-mid);\n fill: currentColor;\n }\n\n \/* Quote *\/\n .scaler-ss-card__quote {\n font-size: 13px;\n font-style: italic;\n line-height: 19px;\n color: var(--ss-text-mid);\n background: var(--ss-quote-bg);\n border-radius: var(--ss-radius-sm);\n padding: 8px 10px;\n }\n\n \/* View Profile *\/\n .scaler-ss-card__cta,\n .scaler-ss-card__cta:link,\n .scaler-ss-card__cta:visited {\n display: block;\n margin-top: auto;\n text-align: center;\n font-size: 14px;\n font-weight: 600;\n color: var(--ss-primary) !important;\n text-decoration: none;\n border: 1px solid var(--ss-primary);\n border-radius: var(--ss-radius-sm);\n padding: 9px 12px;\n cursor: pointer;\n transition: background 0.2s ease, color 0.2s ease;\n }\n .scaler-ss-card__cta:hover,\n .scaler-ss-card__cta:focus {\n background: var(--ss-primary);\n color: #ffffff !important;\n }\n\n \/* Side navigation arrows *\/\n .scaler-ss__nav {\n position: absolute !important;\n top: 50% !important;\n transform: translateY(-50%) !important;\n z-index: 2;\n width: 46px !important;\n height: 46px !important;\n min-width: 46px;\n display: flex !important;\n align-items: center;\n justify-content: center;\n padding: 0 !important;\n background: var(--ss-card-bg) !important;\n border: none !important;\n border-radius: var(--ss-radius-sm) !important;\n box-shadow: var(--ss-shadow) !important;\n color: #61738e !important;\n cursor: pointer;\n transition: opacity 0.2s ease, visibility 0.2s ease;\n }\n .scaler-ss__nav--prev { left: 8px !important; }\n .scaler-ss__nav--next { right: 8px !important; }\n .scaler-ss__nav svg {\n width: 20px !important;\n height: 20px !important;\n fill: #61738e !important;\n }\n .scaler-ss__nav.swiper-button-disabled {\n opacity: 0;\n visibility: hidden;\n pointer-events: none;\n }\n\n .scaler-ss .swiper-button-prev,\n .scaler-ss .swiper-button-next,\n .scaler-ss .swiper-pagination { display: none; }\n\n \/* Skeleton *\/\n .scaler-ss-card--skeleton { pointer-events: none; }\n .scaler-ss-card--skeleton .scaler-ss-card__hike,\n .scaler-ss-card--skeleton .scaler-ss-card__avatar,\n .scaler-ss-card--skeleton .scaler-ss-card__person-text,\n .scaler-ss-card--skeleton .scaler-ss-card__transition,\n .scaler-ss-card--skeleton .scaler-ss-card__quote,\n .scaler-ss-card--skeleton .scaler-ss-card__cta {\n background: linear-gradient(90deg, var(--ss-border) 25%, var(--ss-quote-bg) 50%, var(--ss-border) 75%);\n background-size: 200% 100%;\n animation: ss-shimmer 1.5s infinite;\n color: transparent !important;\n border-color: transparent !important;\n border-radius: 4px;\n }\n .scaler-ss-card--skeleton .scaler-ss-card__person-text { flex: 1; height: 32px; }\n .scaler-ss-card--skeleton .scaler-ss-card__transition { height: 56px; }\n .scaler-ss-card--skeleton .scaler-ss-card__quote { height: 48px; }\n .scaler-ss-card--skeleton .scaler-ss-card__cta { height: 38px; }\n\n @keyframes ss-shimmer {\n 0% { background-position: 200% 0; }\n 100% { background-position: -200% 0; }\n }\n\n @media (max-width: 768px) {\n .scaler-ss { padding: 16px; }\n .scaler-ss__heading { font-size: 22px; line-height: 30px; }\n .scaler-ss-swiper .swiper-slide { width: 270px; }\n .scaler-ss__nav { display: none !important; }\n }\n <\/style>\n\n\n\n <div class=\"scaler-ss js-scaler-ss\">\n\n <template class=\"js-ss-card-template\">\n <div class=\"swiper-slide\">\n <article class=\"scaler-ss-card\">\n <div class=\"scaler-ss-card__hike js-ss-hike\"><\/div>\n <div class=\"scaler-ss-card__body\">\n <div class=\"scaler-ss-card__person\">\n <img decoding=\"async\" class=\"scaler-ss-card__avatar js-ss-avatar\" src=\"\" alt=\"\" loading=\"lazy\">\n <div class=\"scaler-ss-card__person-text\">\n <div class=\"scaler-ss-card__name js-ss-name\"><\/div>\n <div class=\"scaler-ss-card__city js-ss-city\"><\/div>\n <\/div>\n <\/div>\n\n <div class=\"scaler-ss-card__transition\">\n <div class=\"scaler-ss-card__col\">\n <div class=\"scaler-ss-card__col-label\">BEFORE:<\/div>\n <div class=\"scaler-ss-card__col-role js-ss-before-role\"><\/div>\n <div class=\"scaler-ss-card__col-company js-ss-before-company\"><\/div>\n <\/div>\n <svg class=\"scaler-ss-card__arrow\" viewBox=\"0 0 32 8\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M31.3882 4.35355C31.5835 4.15829 31.5835 3.84171 31.3882 3.64645L28.2062 0.464466C28.011 0.269204 27.6944 0.269204 27.4991 0.464466C27.3039 0.659728 27.3039 0.976311 27.4991 1.17157L30.3276 4L27.4991 6.82843C27.3039 7.02369 27.3039 7.34027 27.4991 7.53553C27.6944 7.7308 28.011 7.7308 28.2062 7.53553L31.3882 4.35355ZM0.034668 4.5H31.0347V3.5H0.034668V4.5Z\"><\/path><\/svg>\n <div class=\"scaler-ss-card__col\">\n <div class=\"scaler-ss-card__col-label\">NOW:<\/div>\n <div class=\"scaler-ss-card__col-role js-ss-now-role\"><\/div>\n <div class=\"js-ss-now-company\"><\/div>\n <\/div>\n <\/div>\n\n <div class=\"scaler-ss-card__quote js-ss-quote\"><\/div>\n\n <a class=\"scaler-ss-card__cta js-ss-cta\" href=\"#\" target=\"_blank\" rel=\"noopener\">View Profile<\/a>\n <\/div>\n <\/article>\n <\/div>\n <\/template>\n\n <div class=\"scaler-ss__inner\">\n <h2 class=\"scaler-ss__heading\"><span class=\"ez-toc-section\" id=\"scaler-alumni-and-their-success-stories\"><\/span>Scaler Alumni and Their Success Stories<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n <div class=\"scaler-ss__swiper-wrap\">\n <div class=\"swiper scaler-ss-swiper\">\n <div class=\"swiper-wrapper js-ss-wrapper\"><\/div>\n <\/div>\n\n <button class=\"scaler-ss__nav scaler-ss__nav--prev js-ss-prev\" aria-label=\"Previous\">\n <svg fill=\"currentColor\" viewBox=\"0 0 32 32\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"transform: rotate(-90deg);\"><path d=\"M5.313 16l10.688-10.688 10.688 10.688-1.938 1.875-7.438-7.438v16.25h-2.625v-16.25l-7.5 7.438z\"><\/path><\/svg>\n <\/button>\n <button class=\"scaler-ss__nav scaler-ss__nav--next js-ss-next\" aria-label=\"Next\">\n <svg fill=\"currentColor\" viewBox=\"0 0 32 32\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"transform: rotate(90deg);\"><path d=\"M5.313 16l10.688-10.688 10.688 10.688-1.938 1.875-7.438-7.438v16.25h-2.625v-16.25l-7.5 7.438z\"><\/path><\/svg>\n <\/button>\n <\/div>\n <\/div>\n <\/div>\n\n <script>\n document.addEventListener(\"DOMContentLoaded\", () => {\n\n const ASSET_CDN = \"https:\/\/d2beiqkhq929f0.cloudfront.net\/public_assets\/assets\";\n const AVATAR_FALLBACK =\n \"data:image\/svg+xml,%3Csvg xmlns='http:\/\/www.w3.org\/2000\/svg' width='44' height='44' viewBox='0 0 44 44'%3E%3Ccircle cx='22' cy='22' r='22' fill='%23e6e6e6'\/%3E%3Ccircle cx='22' cy='17' r='7' fill='%23b9b9b9'\/%3E%3Cpath d='M8 40c0-8 6.3-13 14-13s14 5 14 13' fill='%23b9b9b9'\/%3E%3C\/svg%3E\";\n\n \/\/ Mirrors buildAssetUrl(): pass through absolute urls, else build the CDN url.\n function buildAssetUrl(raw) {\n if (!raw) return \"\";\n if (String(raw).startsWith(\"http\")) return raw;\n return `${ASSET_CDN}\/${raw}\/original`;\n }\n\n const instances = document.querySelectorAll(\".js-scaler-ss\");\n\n instances.forEach(container => {\n if (container.dataset.initialized === \"true\") return;\n container.dataset.initialized = \"true\";\n\n const swiperElement = container.querySelector(\".scaler-ss-swiper\");\n const wrapper = container.querySelector(\".js-ss-wrapper\");\n const template = container.querySelector(\".js-ss-card-template\");\n const nextBtn = container.querySelector(\".js-ss-next\");\n const prevBtn = container.querySelector(\".js-ss-prev\");\n\n if (!wrapper || !template) {\n console.error(\"Scaler Success Stories: missing required elements\");\n return;\n }\n\n const swiper = new Swiper(swiperElement, {\n slidesPerView: \"auto\",\n spaceBetween: 16,\n grabCursor: true,\n observer: true,\n observeParents: true,\n navigation: { nextEl: nextBtn, prevEl: prevBtn },\n });\n\n const pathParts = location.pathname.split(\"\/\").filter(Boolean);\n const currentSlug = pathParts.length > 0 ? pathParts[pathParts.length - 1] : \"homepage\";\n const profileUrl =\n `https:\/\/www.scaler.com\/review\/?utm_source=blog&utm_medium=success_stories&utm_content=${currentSlug}`;\n\n function showSkeletons(count = 4) {\n wrapper.innerHTML = \"\";\n for (let i = 0; i < count; i++) {\n const clone = template.content.cloneNode(true);\n clone.querySelector(\".scaler-ss-card\").classList.add(\"scaler-ss-card--skeleton\");\n wrapper.appendChild(clone);\n }\n swiper.update();\n }\n\n function renderStories(stories) {\n wrapper.innerHTML = \"\";\n if (!stories.length) {\n container.style.display = \"none\"; \/\/ match topics: render nothing when empty\n return;\n }\n\n stories.forEach(story => {\n const a = story.attributes || {};\n const clone = template.content.cloneNode(true);\n\n const hike = String(a.growth || \"\").replace(\"%\", \"\").trim() || \"150\";\n clone.querySelector(\".js-ss-hike\").textContent = `${hike}% HIKE`;\n\n \/\/ Avatar\n const avatar = buildAssetUrl(a.image_url) || a.generated_thumbnail_url || \"\";\n const img = clone.querySelector(\".js-ss-avatar\");\n img.src = avatar || AVATAR_FALLBACK;\n img.alt = a.name || \"Scaler alumnus\";\n img.onerror = function () { this.onerror = null; this.src = AVATAR_FALLBACK; };\n\n clone.querySelector(\".js-ss-name\").textContent = a.name || \"\";\n const cityEl = clone.querySelector(\".js-ss-city\");\n if (a.city) cityEl.textContent = a.city; else cityEl.style.display = \"none\";\n\n \/\/ BEFORE\n clone.querySelector(\".js-ss-before-role\").textContent = a.pre_scaler_role || a.pre_academy_company || \"\";\n const beforeCompany = clone.querySelector(\".js-ss-before-company\");\n if (a.pre_academy_company) beforeCompany.textContent = a.pre_academy_company;\n else beforeCompany.style.display = \"none\";\n\n \/\/ NOW\n clone.querySelector(\".js-ss-now-role\").textContent = a.role || \"\";\n const nowCompanyBox = clone.querySelector(\".js-ss-now-company\");\n const companyLogo = buildAssetUrl(a.company_logo_url);\n if (companyLogo) {\n const logo = document.createElement(\"img\");\n logo.className = \"scaler-ss-card__company-logo\";\n logo.src = companyLogo;\n logo.alt = a.post_academy_company || \"company\";\n logo.loading = \"lazy\";\n logo.onerror = function () {\n this.onerror = null;\n this.replaceWith(Object.assign(document.createElement(\"div\"), {\n className: \"scaler-ss-card__col-company\",\n textContent: a.post_academy_company || \"\",\n }));\n };\n nowCompanyBox.appendChild(logo);\n } else if (a.post_academy_company) {\n nowCompanyBox.className = \"scaler-ss-card__col-company\";\n nowCompanyBox.textContent = a.post_academy_company;\n }\n\n \/\/ Quote (clip to 110 chars like topics)\n const quoteEl = clone.querySelector(\".js-ss-quote\");\n quoteEl.textContent = `\u201c${String(a.content).slice(0, 110)}\u2026\u201d`;\n\n \/\/ View Profile\n clone.querySelector(\".js-ss-cta\").href = profileUrl;\n\n wrapper.appendChild(clone);\n });\n\n swiper.update();\n swiper.slideTo(0);\n }\n\n async function fetchStories() {\n try {\n showSkeletons();\n \/\/ Same-origin POST on www.scaler.com (the blog canonical host).\n \/\/ The endpoint only returns JSON when the Referer is a \/topics\/ page\n \/\/ (a soft anti-hotlinking gate); a \/blog\/ referer gets a Turbolinks\n \/\/ redirect. Since blog + topics are the same origin, we set the\n \/\/ fetch referrer to a topics URL so the server serves the data.\n const res = await fetch(\"\/success-stories\/testimonials\", {\n method: \"POST\",\n credentials: \"include\",\n referrer: \"https:\/\/www.scaler.com\/topics\/\",\n referrerPolicy: \"unsafe-url\",\n headers: {\n \"Content-Type\": \"application\/json\",\n \"Accept\": \"application\/json\",\n \"X-Requested-With\": \"XMLHttpRequest\",\n },\n \/\/ q:{} => all programs (no program filter)\n body: JSON.stringify({\n page_number: 1,\n per_page: 12,\n sort_by: \"eligible_for_qna\",\n new_quick_filters: true,\n quick_filter: [],\n q: {},\n }),\n });\n const json = await res.json();\n const all = (json && json.data && json.data.data) || [];\n \/\/ Only show stories that carry a testimonial quote (matches topics).\n const withQuote = all.filter(s => s.attributes && s.attributes.content);\n renderStories(withQuote);\n } catch (error) {\n console.error(\"Failed to load success stories:\", error);\n container.style.display = \"none\";\n }\n }\n\n fetchStories();\n });\n });\n <\/script>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"faqs\"><\/span><strong>FAQs<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>1. What is the complete SQL syllabus for beginners?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A complete SQL syllabus for beginners usually starts with database fundamentals, tables, and SQL commands before moving toward queries, filtering, joins, functions, subqueries, and window functions. Most SQL courses also include projects, reporting queries, and interview preparation at later stages.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>2. What topics are covered in an SQL course?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">An SQL course usually covers databases, tables, SQL commands, queries, filtering, joins, functions, subqueries, CTEs, window functions, database design, transactions, and SQL projects. Advanced courses may also include query optimization and interview preparation.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>3. How do I start learning SQL from scratch?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The best way to start learning SQL from scratch is by first understanding databases and tables, and then practicing basic SQL queries like SELECT, WHERE, INSERT, and JOIN. Consistent hands-on query practice with small datasets usually helps much more than only reading theory.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>4. Is SQL easy for beginners?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Yes, SQL is generally considered beginner-friendly compared to many programming technologies. Most beginners can start writing simple queries and working with data within a few days of practice.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>5. How long does it take to learn SQL?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can learn basic SQL in a few weeks with regular practice. But getting comfortable with joins, subqueries, projects, and interview-level SQL usually takes a couple of months of consistent hands-on work.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>6. What are the prerequisites for learning SQL?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL does not have any significant prerequisites. Knowledge about computers, ability to understand tables and spreadsheets, and logical reasoning are all that is required. Programming skills can help further down the road, but it is not essential at the beginner level of SQL knowledge.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>7. What are the most important SQL commands?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Some of the most important SQL commands include SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, WHERE, GROUP BY, and JOIN. These commands are commonly used for retrieving, managing, filtering, and organizing data inside databases. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>8. What are DDL, DML, DQL, DCL, and TCL commands in SQL?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">DDL, DML, DQL, DCL, and TCL are different categories of SQL commands based on what they do. DDL commands are used to create or modify database structures, DML commands handle inserting or updating data, DQL commands fetch data, DCL commands manage permissions, and TCL commands control transactions inside the database. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>9. What are joins in SQL?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In SQL, joins are utilized to join two or more tables by combining data from different tables based on common columns. The purpose of joining tables is to facilitate data retrieval that is stored in different tables, which explains the reason why joins are widely used in relational databases.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>10. What are window functions in SQL?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Window functions in SQL are used when you want to perform calculations across multiple rows without actually grouping the data. They are commonly used for ranking, running totals, row comparisons, and analytics-related queries. Functions like ROW_NUMBER, RANK, LEAD, and LAG are some of the most commonly used window functions.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>11. Is SQL required for data analyst jobs?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Yes, SQL is regarded as one of the most crucial skill sets for the role of data analyst. The task of data analysts requires the usage of SQL on a daily basis for purposes such as data extraction, data filtering, report generation, trend analysis, and preparing data for dashboards.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>12. Is SQL useful for backend development?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Yes, SQL is very useful for backend development because most backend applications work with databases. Backend developers use SQL for storing user data, handling authentication systems, managing transactions, building APIs, and fetching data from databases efficiently. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>13. What SQL projects should I build?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Simple projects, such as creating databases for students, employees, and libraries, can be done by beginners. Some of the good intermediate projects may involve the analysis of e-commerce sales, customer order management systems, and HR analytics. Some of the advanced SQL projects typically involve data analytics and dashboard creation, among others.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Examples of advanced SQL projects are analytics dashboards, cohort analysis, and churn analysis.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>14. Is a free SQL course enough?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Yes, free SQL courses are usually enough for learning SQL basics like queries, joins, filtering, and functions. But if your goal is backend development, data analytics, projects, or interview preparation, structured learning and hands-on practice can help a lot more.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>15. What should I learn after SQL?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">After learning SQL, what you need to study next will vary depending on your professional ambition. Typically, the next step for a data analyst is to learn Power BI, Excel, Python, and data visualization, whereas backend and full stack developers can further their studies on APIs, backend frameworks, and databases.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>16. What SQL topics are important for interviews?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Some of the most important SQL interview topics include joins, GROUP BY, aggregate functions, subqueries, window functions, normalization, indexes, transactions, and query optimization. Interviewers also often ask candidates to solve practical SQL query problems using real-world datasets. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>One of the important elements that runs many services and applications online is SQL. Regardless of whether you are buying something, checking your website analytics, booking a place, or even surfing any social networking site, SQL is used to get these done. And precisely because of this, SQL remains one of the most sought-after skills […]<\/p>\n","protected":false},"author":241,"featured_media":12661,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[320],"tags":[385,384],"class_list":["post-12660","post","type-post","status-publish","format-standard","has-post-thumbnail","category-syllabus","tag-sql","tag-sql-syllabus"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.scaler.com\/blog\/wp-json\/wp\/v2\/posts\/12660","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.scaler.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.scaler.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.scaler.com\/blog\/wp-json\/wp\/v2\/users\/241"}],"replies":[{"embeddable":true,"href":"https:\/\/www.scaler.com\/blog\/wp-json\/wp\/v2\/comments?post=12660"}],"version-history":[{"count":2,"href":"https:\/\/www.scaler.com\/blog\/wp-json\/wp\/v2\/posts\/12660\/revisions"}],"predecessor-version":[{"id":13744,"href":"https:\/\/www.scaler.com\/blog\/wp-json\/wp\/v2\/posts\/12660\/revisions\/13744"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.scaler.com\/blog\/wp-json\/wp\/v2\/media\/12661"}],"wp:attachment":[{"href":"https:\/\/www.scaler.com\/blog\/wp-json\/wp\/v2\/media?parent=12660"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.scaler.com\/blog\/wp-json\/wp\/v2\/categories?post=12660"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.scaler.com\/blog\/wp-json\/wp\/v2\/tags?post=12660"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}