</ iframe ></noscript> <!-- For Large Screens header _InnerLayout_FullWidth_B4_NonStickyNavbar_TW--> <div class="bg-[#010413] h-[3.4rem] z-[110] w-full shadow-lg lg:!block hidden relative"> <nav class=" flex items-center justify-between custom-container px-2"> <div class="mx-auto flex justify-between w-full"> <div class="flex items-center space-x-4 w-full my-1"> <main-search class="w-full" [showLogo]="true"></main-search> </div> <!-- LoggedUserHiddenVars Partial --> <input type="hidden" id="ImageCDN" data-value="https://cdn-images-gf-prod.azureedge.net" /> <input type="hidden" id="Username" data-value="" /> <input type="hidden" id="UserRoleInSelectedCompany" data-value="" /> <input type="hidden" id="ShowSetupCompanyLink4CompanyAdmin" data-value="" /> <input type="hidden" id="SelectedCompanyPackageId" data-value="-1" /> <input type="hidden" id="SelectedCompanyPackageName" data-value="" /> <input type="hidden" id="UpgradeLinkUrl" data-value="" /> <input type="hidden" id="UpgradeLinkTitle" data-value="" /> <input type="hidden" id="ChangeCompanyLink" data-value="" /> <input type="hidden" id="DebugMode" data-value="" /> <input type="hidden" id="ShowSwitchToPreviousUser" data-value="" /> <input type="hidden" id="PreviousUser" data-value="" /> <input type="hidden" id="CartItemCount" data-value="" /> <div class="hidden lg:flex items-center"> <!-- For Large Screens --> <div class="hidden lg:flex items-center"> <style> .Image-icon-xs { height: 40px; width: 40px; } .topdrpheadercolor { background: black; color: white; } .topdrpCard-top { border-top: 4px solid #00b9bd; } .viewcartdrp-menu { left: auto; right: 21%; min-width: 25%; } .cartitemscount { border-radius: 50%; color: #fff; display: inline-block; font-size: 12px; height: 18px; line-height: 16px; padding: 2px; position: relative; text-align: center; float: right; min-width: 20px; background: red; } </style> <ul class="flex space-x-2 my-1 "> <li> <a class="inline-flex items-center px-4 py-[10px] text-white border border-orange-500 bg-[#000]-600 rounded-[4px] text-sm font-semibold transition duration-200 whitespace-nowrap" href="/account/login"> Login </a> </li> <li> <a class="inline-flex items-center px-4 py-[10px] text-white border border-orange-500 bg-[#e56932] rounded-[4px] text-sm font-semibold transition duration-200 whitespace-nowrap" href="/Account/Register"> Get Started </a> </li> </ul> <div id="changeCompanyModal" class="normal-width-popup" style="display:none;"> <div class="modal-overlay"> <div class="modal-container lg:w-[70%] w-full"> <div class="modal-content mt-[15px]"> <div class="modal-header"> <h3 class="text-2xl font-semibold p-3 py-4">Change Company</h3> <button class="p-0 ml-auto bg-transparent border-0 text-black float-right text-3xl leading-none font-semibold outline-none focus:outline-none" id="CloseModelIcon" onclick="closeChangeCompany()"> <span id="popupCloseIcon" class="text-white text-2xl block outline-none focus:outline-none p-3 py-4 bg-[#c94d4d] rounded-tr-lg">×</span> </button> </div> <div> <app-change-company></app-change-company> </div> </div> </div> </div> </div> <script> function openChangeCompany() { const changeCompanyModal = document.getElementById("changeCompanyModal"); if (changeCompanyModal) { changeCompanyModal.style.display = "block"; } } function closeChangeCompany() { const changeCompanyModal = document.getElementById("changeCompanyModal"); if (changeCompanyModal) { changeCompanyModal.style.display = "none"; } } document.addEventListener("DOMContentLoaded", function () { // Get modal elements const changeCompanyModal = document.getElementById("changeCompanyModal"); const closeModelIcon = document.getElementById("CloseModelIcon"); // Get dropdown elements const cartButton = document.getElementById("cartButton"); const cartDropdown = document.getElementById("cartDropdown"); const topHeaderIcon = document.getElementById("topHeaderIcon"); const topHeaderdropdown = document.getElementById("topHeaderdropdown"); const closeDropdownIcon = document.getElementById("closeDropdown"); // Close modal when clicking the close icon if (closeModelIcon && changeCompanyModal) { closeModelIcon.addEventListener("click", function () { changeCompanyModal.style.display = "none"; }); } // Toggle cart dropdown visibility if (cartButton && cartDropdown) { cartButton.addEventListener("click", function (e) { e.stopPropagation(); const isVisible = cartDropdown.classList.contains("opacity-100"); cartDropdown.classList.toggle("opacity-100", !isVisible); cartDropdown.classList.toggle("visible", !isVisible); cartDropdown.classList.toggle("opacity-0", isVisible); cartDropdown.classList.toggle("invisible", isVisible); }); } // Toggle top header dropdown visibility if (topHeaderIcon && topHeaderdropdown) { topHeaderIcon.addEventListener("click", function (e) { e.stopPropagation(); const isVisible = topHeaderdropdown.classList.contains("opacity-100"); topHeaderdropdown.classList.toggle("opacity-100", !isVisible); topHeaderdropdown.classList.toggle("visible", !isVisible); topHeaderdropdown.classList.toggle("opacity-0", isVisible); topHeaderdropdown.classList.toggle("invisible", isVisible); }); } // Close dropdowns when clicking outside document.addEventListener("click", function () { if (cartDropdown) { cartDropdown.classList.add("opacity-0", "invisible"); cartDropdown.classList.remove("opacity-100", "visible"); } if (topHeaderdropdown) { topHeaderdropdown.classList.add("opacity-0", "invisible"); topHeaderdropdown.classList.remove("opacity-100", "visible"); } }); // Close cart dropdown when clicking the close icon if (closeDropdownIcon && cartDropdown) { closeDropdownIcon.addEventListener("click", function () { cartDropdown.classList.add("opacity-0", "invisible"); cartDropdown.classList.remove("opacity-100", "visible"); }); } }); </script> </div> </div> </div> </nav> </div> <!-- For Small Screens header _InnerLayout_FullWidth_B4_NonStickyNavbar_TW--> <div class="lg:hidden flex bg-[#010413] fixed top-0 right-0 left-0 z-[555]" style="border-bottom: 0.25px solid #2a6a55;"> <div class="w-full flex justify-center items-center relative py-1 px-2 gap-0.5 custom-container"> <div class="w-full"> <div class="flex items-center space-x-4"> <main-search class="w-full" [showLogo]="true"></main-search> </div> </div> <div class=""> <!-- For Small Screens --> <div class="lg:hidden flex justify-end right-1"> <style> .Image-icon-xs { height: 40px; width: 40px; } .topdrpheadercolor { background: black; color: white; } .topdrpCard-top { border-top: 4px solid #00b9bd; } .viewcartdrp-menu { left: auto; } .drpMenuLeft { left: auto; right: 0; } .moreLinks .dropdown-toggle::after { display: none; } .moreLinks .dropdown-menu { min-width: 15rem; } .moreLinks small { font-size: 65%; } .cursor-pointer { position: relative; z-index: 10; } </style> <div class="flex gap-1 items-center"> <!-- Login Button --> <div class="my-auto"> <a href="/account/login" class="inline-flex items-center justify-center px-1.5 py-2 border bg-white border-orange-500 text-orange-500 rounded-md hover:bg-orange-500 hover:text-white transition-colors duration-200" title="Login"> <i class="fa-solid fa-right-to-bracket"></i> </a> </div> <!-- Register Button --> <div class="my-auto"> <a href="/account/register" class="inline-flex items-center justify-center px-1.5 py-2 border hover:bg-white border-[#6dd5c0] hover:!text-[#6dd5c0] rounded-md bg-[#6dd5c0] text-white transition-colors duration-200" title="Register"> <i class="fa-solid fa-user-plus"></i> </a> </div> </div> <div id="changeCompanyModalsmall" class="normal-width-popup hidden"> <div class="modal-overlay"> <div class="modal-container lg:w-[70%] w-full"> <div class="modal-content mt-[15px]"> <div class="modal-header"> <h3 class="text-2xl font-semibold p-3 py-4">Change Company</h3> <button class="p-0 ml-auto bg-transparent border-0 text-black float-right text-3xl leading-none font-semibold outline-none focus:outline-none" id="CloseModelIconsmall" onclick="closeChangeCompanySmall()"> <span id="popupCloseIconsmall" class="text-white text-2xl block outline-none focus:outline-none p-3 py-4 bg-[#c94d4d] rounded-tr-lg">×</span> </button> </div> <div> <app-change-company></app-change-company> </div> </div> </div> </div> </div> <script> function openChangeCompanySmall() { const modal = document.getElementById('changeCompanyModalsmall'); if (modal) { console.log('Opening modal', modal); modal.classList.remove("hidden"); modal.classList.add("block"); } } function closeChangeCompanySmall() { const modal = document.getElementById('changeCompanyModalsmall'); if (modal) { console.log('Closing modal', modal); modal.classList.remove("block"); modal.classList.add("hidden"); } } document.addEventListener("DOMContentLoaded", function () { const toggleButton = document.getElementById("dropdownToggle"); const dropdownContent = document.getElementById("dropdownContent"); const dropdownButton = document.getElementById('dropdownheaderButton'); const dropdownMenu = document.getElementById('dropdownMenu'); const topHeaderIcon = document.getElementById('topHeaderIcon'); const closeModelIcon = document.getElementById('CloseModelIcon'); const topHeaderdropdown = document.getElementById('topHeaderdropdown'); // Toggle top header dropdown visibility if (dropdownButton && topHeaderdropdown) { dropdownButton.addEventListener('click', function (e) { e.stopPropagation(); const isVisible = topHeaderdropdown.classList.contains('opacity-100'); topHeaderdropdown.classList.toggle('opacity-100', !isVisible); topHeaderdropdown.classList.toggle('visible', !isVisible); topHeaderdropdown.classList.toggle('opacity-0', isVisible); topHeaderdropdown.classList.toggle('invisible', isVisible); }); } // Toggle dropdown visibility if (toggleButton && dropdownContent) { toggleButton.addEventListener("click", function (event) { event.stopPropagation(); dropdownContent.classList.toggle("hidden"); if (dropdownMenu) dropdownMenu.classList.add("hidden"); }); } // Toggle dropdown menu visibility if (dropdownButton && dropdownMenu) { dropdownButton.addEventListener("click", function (event) { event.stopPropagation(); dropdownMenu.classList.toggle("hidden"); }); } // Close all dropdowns when clicking outside document.addEventListener("click", function () { if (dropdownContent) dropdownContent.classList.add("hidden"); if (dropdownMenu) dropdownMenu.classList.add("hidden"); if (topHeaderdropdown) { topHeaderdropdown.classList.add('opacity-0', 'invisible'); topHeaderdropdown.classList.remove('opacity-100', 'visible'); } }); // Close dropdowns when clicking inside if (dropdownContent) { dropdownContent.addEventListener("click", function () { dropdownContent.classList.add("hidden"); }); } if (dropdownMenu) { dropdownMenu.addEventListener("click", function () { dropdownMenu.classList.add("hidden"); }); } }); </script> <!-- Show on small screens --> </div> </div> </div> </div> <input type="hidden" id="CourseId" data-value="1717" /> <input type="hidden" id="PreviewType" data-value="" /> <input type="hidden" id="EncyrptedData" data-value="" /> <input type="hidden" id="CUID" data-value="zgVCpLsHyok=" /> <input type="hidden" id="CouponId" data-value="0" /> <div class="sticky top-0 pl-2 py-0 z-50 bg-opacity-90 w-full bg-[#010413] transition-opacity duration-300 ease-in-out hidden" id="stickyElement"> <div class="custom-container px-2 py-2 text-white"> <div class="w-full"> <span class="bg-[#00ae6b] text-white preview-header-badge">Course</span> <h3 class="md:!text-3xl text-xl font-semibold mb-1">SQL server - from basic setup to code execution</h3> </div> </div> </div> <div class="md:!pt-0 pb-3 md:!px-2 relative bg-gray-900 text-white w-full headercommon block" id="previewhead"> <div class="custom-container pt-0.5 px-2"> <span class=""> <span class="bg-[#00ae6b] text-white preview-header-badge">Course</span> </span> <div class="mt-1 mb-0 md:!text-sm text-[13px] text-gray-300 flex items-center space-x-2"> <a class="text-[#42bda8] font-semibold" href="/courses/information-technology">Information Technology</a> <span class="text-[#42bda8]">></span> <a class="text-[#42bda8] font-semibold" href="/courses/sql-server">SQL Server</a> </div> <h1 class="md:!text-3xl text-xl lg:!leading-none leading-none font-semibold">SQL server - from basic setup to code execution</h1> <div class="w-full md:w-1/4 mt-1"> <div class="trained_by_with_dates text-white rounded-sm shadow p-1"> <div class=""> <div class="flex flex-col items-center"> <div class="w-full text-center"> <p class="text-[0.8rem] text-gray-300">Trained by:</p> <div class="flex flex-row items-center justify-center gap-6"> <div class="flex flex-row"> <b class="block -mr-[15px]"> <a href="/user/taurius"> <img src="https://cdn-images-gf-prod.azureedge.net/assets/user/200_200_gdye3117GD.png" class="rounded-full border" style="height:30px; width: 30px;" /> </a> </b> </div> <div class="text-[0.8rem] font-medium text-white"> taurius litvinavicius </div> </div> </div> </div> </div> </div> </div> </div> </div> <nav aria-label="breadcrumb" class="bg-[#f0f4f8]"> <div class="custom-container py-0.5"> <div class="flex text-gray-900 p-1"> <div class="flex align-middle"> <span class="pl-1 flex md:!text-sm text-[12px] hover:bg-gray-200 hover:rounded-md justify-center items-center"> <button routerLink="/" class="flex my-auto ml-auto rounded-full hover:bg-gray-200 hover:rounded-md"> <svg class="w-3 h-3" viewBox="-5 0 24 24" version="1.1" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:sketch="http://www.bohemiancoding.com/sketch/ns" fill="#000000"> <g id="SVGRepo_bgCarrier" stroke-width="0"></g> <g id="SVGRepo_tracerCarrier" stroke-linecap="round" stroke-linejoin="round"></g> <g id="SVGRepo_iconCarrier"> <title>chevron-left</title> <desc>Created with Sketch Beta.</desc> <defs></defs> <g id="Page-1" stroke="none" stroke-width="1" fill="none" fill-rule="evenodd" sketch:type="MSPage"> <g id="Icon-Set" sketch:type="MSLayerGroup" transform="translate(-421.000000, -1195.000000)" fill="#000000"> <path d="M423.429,1206.98 L434.686,1196.7 C435.079,1196.31 435.079,1195.67 434.686,1195.28 C434.293,1194.89 433.655,1194.89 433.263,1195.28 L421.282,1206.22 C421.073,1206.43 420.983,1206.71 420.998,1206.98 C420.983,1207.26 421.073,1207.54 421.282,1207.75 L433.263,1218.69 C433.655,1219.08 434.293,1219.08 434.686,1218.69 C435.079,1218.29 435.079,1217.66 434.686,1217.27 L423.429,1206.98" id="chevron-left" sketch:type="MSShapeGroup"></path> </g> </g> </g> </svg> </button> <span class="p-1 flex text-sm text-muted hover:bg-gray-200 hover:rounded-md"> <span class=""><a href="/"><i class=""></i> Home</a></span> <span class="ml-1 mt-[5.5px]"> <svg class="w-3 h-3" viewBox="0 -6.5 36 36" version="1.1" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" fill="#000000"> <g id="SVGRepo_bgCarrier" stroke-width="0"></g> <g id="SVGRepo_tracerCarrier" stroke-linecap="round" stroke-linejoin="round"></g> <g id="SVGRepo_iconCarrier"> <title>right-arrow</title> <desc>Created with Sketch.</desc> <g id="icons" stroke="none" stroke-width="1" fill="none" fill-rule="evenodd"> <g id="ui-gambling-website-lined-icnos-casinoshunter" transform="translate(-212.000000, -159.000000)" fill="#252528" fill-rule="nonzero"> <g id="square-filled" transform="translate(50.000000, 120.000000)"> <path d="M187.108012,39.2902857 L197.649804,49.7417043 L197.708994,49.7959169 C197.889141,49.9745543 197.986143,50.2044182 198,50.4382227 L198,50.5617773 C197.986143,50.7955818 197.889141,51.0254457 197.708994,51.2040831 L197.6571,51.2479803 L187.108012,61.7097143 C186.717694,62.0967619 186.084865,62.0967619 185.694547,61.7097143 C185.30423,61.3226668 185.30423,60.6951387 185.694547,60.3080911 L194.702666,51.3738496 L162.99947,51.3746291 C162.447478,51.3746291 162,50.9308997 162,50.3835318 C162,49.8361639 162.447478,49.3924345 162.99947,49.3924345 L194.46779,49.3916551 L185.694547,40.6919089 C185.30423,40.3048613 185.30423,39.6773332 185.694547,39.2902857 C186.084865,38.9032381 186.717694,38.9032381 187.108012,39.2902857 Z M197.115357,50.382693 L186.401279,61.0089027 L197.002151,50.5002046 L197.002252,50.4963719 L196.943142,50.442585 L196.882737,50.382693 L197.115357,50.382693 Z" id="right-arrow"></path> </g> </g> </g> </g> </svg> </span> </span> <span class="py-1 flex text-sm text-gray-800 hover:bg-gray-200 hover:rounded-md "> <span>Course</span> </span> </span> </div> </div> </div> </nav> <div class="custom-body md:!mb-0 mb-20"> <div class="custom-container px-2 py-0.5" id="MainContainer"> <div class="flex flex-wrap mb-10 py-2"> <div class="lg:w-9/12"> <div class="border border-gray-200 shadow-custom-small lg:mr-4 md:!p-4 px-2 rounded-md bg-white"> <div class="card-body"> <app-course-introvideo></app-course-introvideo> <div class="flex flex-wrap" id="showSticky"> <div class="w-full"> <div class="clearfix space30"></div> <h2 class="md:!text-[1.75rem] text-[1.5rem] font-semibold mt-3 mb-2">Course Summary</h2> <div class="description preview-description text-justify lg:!text-[1rem] leading-6 course-container"><p>Everything you need to know to use SQL server is here.</p> <p>From setup on windows server, to various queries and stored procedures.</p> <p>And alongside these basics, you will also learn how to establish connections, how to establish them in C#, how to use file tables, how to create jobs and use other more advanced features of SQL server.</p></div> <div class="clearfix space30"></div> <div> <h2 class="md:!text-[1.75rem] text-[1.5rem] font-semibold mt-3 mb-2">Who can benefit?</h2> <div id="whocanbenefit" class="preview-description text-justify lg:!text-[1rem] leading-6 course-container"><p>Programmers who want to learn SQL server</p></div> </div> <div> <h2 class="md:!text-[1.75rem] text-[1.5rem] font-semibold mt-3 mb-2">What you will learn?</h2> <span id="whatwillyoulearn" class="preview-description text-justify lg:!text-[1rem] leading-6 course-container"><p>Everything you need to know to use SQL server is here.</p> <p>From setup on windows server, to various queries and stored procedures.</p> <p>And alongside these basics, you will also learn how to establish connections, how to establish them in C#, how to use file tables, how to create jobs and use other more advanced features of SQL server.</p></span> </div> <div> <h2 class="md:!text-[1.75rem] text-[1.5rem] font-semibold mt-3 mb-2">How to get certified?</h2> <div id="howtogetcertified" class="preview-description text-justify lg:!text-[1rem] leading-6 course-container"><p>N/A</p></div> </div> </div> </div> <app-root> </app-root> </div> </div> </div> <div class="lg:w-3/12"> <app-course-price-info> </app-course-price-info> </div> </div> </div> <app-course-join></app-course-join> </div> <script> window.addEventListener('scroll', function () { const stickyElement = document.getElementById('stickyElement'); const previewhead = document.getElementById('previewhead'); if (window.scrollY >= 50) { stickyElement.classList.remove('hidden'); stickyElement.classList.add('block'); previewhead.classList.add('hidden'); previewhead.classList.remove('block'); } else { stickyElement.classList.add('hidden'); stickyElement.classList.remove('block'); previewhead.classList.add('block'); previewhead.classList.remove('hidden'); } }); </script> <link rel="stylesheet" href="/css/course-preview-app.css" /> <script src="/js/course-preview-app.js"></script> <!-- Footer --> <footer class="page-footer text-white p-2" style="background: #152F4F;"> <!-- Copyright --> <div class="footer-copyright text-center py-3"> © Copyright 2025 <a href="https://www.guruface.com/"> GuruFace Inc.</a> </div> <!-- Copyright --> </footer> <!-- Footer --> <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script> </body> </html>