Data Analysis with SQL and Power BI
Premium
Notice (8): Undefined index: Message [APP/View/Layouts/lms_inner_layout.ctp, line 391]Code Contextob_start();
include $___viewFn;
$___viewFn = '/data/uat/app/View/Layouts/lms_inner_layout.ctp' $___dataForView = array( 'record' => array( [maximum depth reached] ), 'lmstopics' => array( [maximum depth reached] ), 'relatedcourses' => array( [maximum depth reached] ), 'check_exist' => false, 'languages' => array([maximum depth reached]), 'LastLogin' => array([maximum depth reached]), 's3' => object(Aws\S3\S3Client) {}, 'inputDefaults' => array( [maximum depth reached] ), 'csrfToken' => '6a24002bd597101fd9a60b7eb5250eadb0437194266019a21f1c33d4a70f7eb1', 'content_for_layout' => '<script type="text/javascript" src="/js/jquery-min.js"></script> <style> .loadingmessage { position: fixed; left: 0px; top: 0px; width: 100%; height: 100%; z-index: 9999; background: url('https://uatdigipaathshala.cscacademy.org/gradient-design/img/loading.gif') 50% 50% no-repeat rgb(249,249,249); opacity: .8; } </style> <!-- Show buy now dialog box to proceed payment --> <!-- Start this modal box for show alert for enrollment --> <div id="buynowModal" class="modal fade" style="padding-top:6%;"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title" style="text-align:center;">Please Enter CSC ID</h4> </div> <div class="modal-body"> <form method="post" action="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/paycscwallet" name="paymentproceed" class="search-popup-inner" style="text-align:center;"> <input type="hidden" name="CourseIds" id="CourseIds" value="" /> <input type="hidden" name="UploadCertificateFile" id="UploadCertificateFile" value="" /> <div> <input type="text" name="cscid" placeholder="CSC ID" maxlength="12" id="cscID" oninput="this.value = this.value.replace(/[^0-9.]/g, '').replace(/(\..*)\./g, '$1');"> </div> <div style="padding-top:6%;"><button type="button" id="paynowcscid" class="bt bt-xs bt-bg bt-secondary inline">Pay Now</button></div> </form> </div> </div> </div> </div> <!-- End dialog box --> <!-- Start this modal box for show alert for All payment gateways --> <div id="pgModal" class="modal fade" style="padding-top:6%;"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title" style="text-align:center;">Please Select Payment Gateway</h4> </div> <div class="modal-body"> <form method="post" action="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/" name="pgselected" class="search-popup-inner" style="text-align:center;"> <input type="hidden" name="CourseIds" id="PGCourseIds" value="" /> <div> <input type="radio" name="payment_gateway" id="pgmethod_value" value="2" > CSC Wallet <input type="radio" name="payment_gateway" value="3" id="pgmethod_value" style="margin-left: 10px;"> HDFC </div> <div style="padding-top:6%;"><button type="button" id="pgmethod" class="bt bt-xs bt-bg bt-secondary inline">Proceed Now</button></div> </form> </div> </div> </div> </div> <div id="hdfcModal" class="modal fade" style="padding-top:6%;"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title" style="text-align:center;">Please Select Payment Gateway</h4> </div> <div class="modal-body"> <form method="post" action="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/payhdfc" name="hdfcselected" class="search-popup-inner" style="text-align:center;"> <input type="hidden" name="CourseIds" id="HDFCCourseIds" value="" /> <div> <input type="radio" name="payment_gateway" required="required" value="3" style="margin-left: 10px;"> <img src="https://uatdigipaathshala.cscacademy.org//images/hdfclogo.png" width="115" height="50"> </div> <div style="padding-top:6%;"><button type="submit" id="payhdfconly" class="bt bt-xs bt-bg bt-secondary inline">Proceed Now</button></div> </form> </div> </div> </div> </div> <!-- End dialog box --> <!-- Start this modal box for show upload 10th certificate before payment --> <div id="uploadcertificateModal" class="modal fade" style="padding-top:6%;"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title" id="uploadmessage" style="text-align:center;"></h4> </div> <div class="modal-body"> <form id="upload10certificateform" method="post" action="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/uploadcertificate" class="search-popup-inner" enctype="multipart/form-data" style="text-align:center;"> <input type="hidden" name="CourseIds" id="UploadCourseIds" value="" /> <div> <input type="file" name="upload10certificate" placeholder="Upload 10th Certificate" accept="image/*" id="10certificate" required="required"> <br> <span>File size should be max 1 MB and format JPEG/PNG</span> </div> <div style="padding-top:6%;"><button type="submit" class="bt bt-xs bt-bg bt-secondary inline">Upload</button></div> </form> </div> </div> </div> </div> <!-- End dialog box --> <!-- Start this modal box for show alert for enrollment --> <div id="showenrollmentModal" class="modal fade" style="padding-top:5%;"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title"></h4> </div> <div class="modal-body"> <div id="showenrolledalert"></div> </div> </div> </div> </div> <!-- End this modal box for show alert for enrollment --> <!-- Show loader --> <div id='loadingmessage' class="loadingmessage" style='display:none'> </div> <!-- End loader --> <div id="wrapper-content" class="clearfix"> <section id="page-title" class="single-product-title-wrap single-product-title-margin" > <div data-stellar-background-image="https://uatdigipaathshala.cscacademy.org/lmsfront_layout/img/coursedetails.jpg" data-stellar-background-position="top" data-stellar-background-ratio="0.5" class="page-title-parallax" style="background-image: url('https://uatdigipaathshala.cscacademy.org/lmsfront_layout/img/coursedetails.jpg');background-position:center top;"></div> <div class="container"> <div class="single-product-title-inner pt-bottom" > <div class="m-title"> <h2 class="p-font">COURSE DETAILS</h2> </div> <div class="breadcrumbs-wrap"> <div class="breadcrumbs-inner text-left"> <ul class="breadcrumbs"><li><a href="" class="home"><i class="fa fa-home"></i></a></li><li><a href="#"> Data Analysis with SQL and Power BI </a></li><li></li></ul> </div> </div> </div> </div> </section> <main class="single-product-wrap has-sidebar"> <div class="container clearfix"> <div class="row clearfix"> <div class="col-md-12"><h4 itemprop="name" class="product_title p-font hd-block"> Data Analysis with SQL and Power BI </h4> </div> <div class="site-content-single-product col-md-8"> <div class="single-product-inner"> <div class="woocommerce-notices-wrapper"></div> <div id="product-468" class="product type-product post-468 status-publish first instock product_cat-business-management product_cat-law-economic has-post-thumbnail featured shipping-taxable purchasable product-type-simple"> <div class="row single-product-info clearfix"> <div class="col-md-12 col-sm-12 col-xs-12"> <div class="single-product-image"> <div class="product-flash-wrap"> <span class="on-new product-flash">Premium</span> </div> <div id="single-product-image" class="single-product-image-inner horizontal"> <div class="product-image-slider-wrap"> <div class="product-image-slider"> <div> <!--pre-signed url for s3 bucket--> <a href="https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/courseimage/ff30a605a693ff195c66269a62e02ee1.jpg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2&X-Amz-Signature=9c6acd8afcb27059c0b647f0300da3ff17d3f76503717703e0b9be8bfbde6bd5" itemprop="image" class="woocommerce-main-image" title="" data-rel="prettyPhoto[product-gallery]" data-index="0"><img style="width:768px; height:500px;" src="https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/courseimage/ff30a605a693ff195c66269a62e02ee1.jpg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2&X-Amz-Signature=9c6acd8afcb27059c0b647f0300da3ff17d3f76503717703e0b9be8bfbde6bd5" class="attachment-shop_single size-shop_single" alt="" srcset="https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/courseimage/ff30a605a693ff195c66269a62e02ee1.jpg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2&X-Amz-Signature=9c6acd8afcb27059c0b647f0300da3ff17d3f76503717703e0b9be8bfbde6bd5" /></a></div></div> </div> </div> <script type="text/javascript"> (function ($) { "use strict"; $(document).ready(function () { var $productImageWrap = $('#single-product-image'); G5Plus.woocommerce.singleProductImage($productImageWrap); }); })(jQuery); </script> </div> <div class="instructor-wrap"> </div> <div class="lesson-list margin-top-70"> <div id="tab-description"> <div class="fullwidth" > <div class="vc_row wpb_row vc_row-fluid mg-top-30"><div class="wpb_column vc_column_container vc_col-sm-12"><div class="vc_column-inner"><div class="wpb_wrapper"> <div class="heading color-dark text-left " > <h2 class="heading-color fs-18">Course summary </h2> </div> </div></div></div></div></div> <div class="fullwidth" > <div class="vc_row wpb_row vc_row-fluid mg-top-30"><div class="wpb_column vc_column_container vc_col-sm-12"><div class="vc_column-inner"><div class="wpb_wrapper"> <div class="wpb_text_column wpb_content_element content-icon-list" > <div class="wpb_wrapper"> <p> Admission started for Batch 1. The course is designed to provide how to execute core SQL commands to define, select, manipulate, control access, aggregate and join data and data tables. Understand when and how to use subqueries, several window functions, as well as partitions to complete complex tasks. Clean data, optimize SQL queries, and write select advanced JOINs to enhance analysis performance. Explain which cases you would want to use particular SQL commands, and apply the results from queries to address business problems. </p> </div> </div> </div></div></div></div></div> <div class="fullwidth" > <div class="vc_row wpb_row vc_row-fluid mg-top-30"><div class="wpb_column vc_column_container vc_col-sm-12"><div class="vc_column-inner"><div class="wpb_wrapper"> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <h4 class="lesson-title"> <a href="javascript:;" data-id="lesson_content_5eab1f56ac59b"> Program Guidelines <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"> <!--pre-signed url for s3 bucket--> <a href="https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/publisher/assignment_guidelines/99f08000a1f579341185ff2d06e3d428.pdf?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=60&X-Amz-Signature=1c14bee57b97cca02b3891cfc9da130229f1174b2dea8d0c3412af784c979fdc" target="_blank">Download Now</a> </span> </div> </h4> </div> </div></div></div></div></div> </div> <div class="fullwidth" ><div class="vc_row wpb_row vc_row-fluid mg-top-30"><div class="wpb_column vc_column_container vc_col-sm-12"><div class="vc_column-inner"><div class="wpb_wrapper"> <div class="heading color-dark text-left " > <h2 class="heading-color fs-18"> TOPIC LISTS - </h2> </div> </div></div></div></div></div> <div class="fullwidth" > <div class="vc_row wpb_row vc_row-fluid mg-top-30"><div class="wpb_column vc_column_container vc_col-sm-12"><div class="vc_column-inner"><div class="wpb_wrapper"> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_1"> 1 Faculty and Course Introduction <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/983" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_1"> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_2"> 2 Unit 1 - Fundamentals of Database <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/984" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_2"> <div class="panel-group" id="accordion1" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading1"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion1" href="#collapse1" aria-expanded="true" aria-controls="collapse1"> Unit 1.1 - Introduction to DBMS </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/985" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse1" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading1"> </div> </div> </div> <div class="panel-group" id="accordion2" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading2"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion2" href="#collapse2" aria-expanded="true" aria-controls="collapse2"> Unit 1.2 - Applications of DBMS </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/986" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse2" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading2"> </div> </div> </div> <div class="panel-group" id="accordion3" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading3"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion3" href="#collapse3" aria-expanded="true" aria-controls="collapse3"> Unit 1.3 - Advantages & Disadvantages of DBMS </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/987" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse3" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading3"> </div> </div> </div> <div class="panel-group" id="accordion4" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading4"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion4" href="#collapse4" aria-expanded="true" aria-controls="collapse4"> Unit 1.4 - Properties of DBMS ACID Property </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/988" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse4" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading4"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_3"> 3 Unit 2 - Install and Run <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/989" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_3"> <div class="panel-group" id="accordion5" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading5"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion5" href="#collapse5" aria-expanded="true" aria-controls="collapse5"> Unit 2.1 - Installation of Mysql </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/990" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse5" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading5"> </div> </div> </div> <div class="panel-group" id="accordion6" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading6"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion6" href="#collapse6" aria-expanded="true" aria-controls="collapse6"> Unit 2.1 - MySQL Launch & Run sample scripts </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/991" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse6" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading6"> </div> </div> </div> <div class="panel-group" id="accordion7" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading7"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion7" href="#collapse7" aria-expanded="true" aria-controls="collapse7"> Unit 2.2 - Quiz </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/992" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse7" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading7"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_4"> 4 Unit 3 - DDL <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/993" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_4"> <div class="panel-group" id="accordion8" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading8"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion8" href="#collapse8" aria-expanded="true" aria-controls="collapse8"> Unit 3.1- SQL Commands : Create & Insert </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/995" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse8" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading8"> </div> </div> </div> <div class="panel-group" id="accordion9" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading9"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion9" href="#collapse9" aria-expanded="true" aria-controls="collapse9"> Unit 3.2 - Quiz </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/996" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse9" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading9"> </div> </div> </div> <div class="panel-group" id="accordion10" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading10"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion10" href="#collapse10" aria-expanded="true" aria-controls="collapse10"> Unit 3.3- SQL Commands: Drop & Alter </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/997" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse10" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading10"> </div> </div> </div> <div class="panel-group" id="accordion11" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading11"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion11" href="#collapse11" aria-expanded="true" aria-controls="collapse11"> Unit 3.4 - Quiz </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/999" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse11" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading11"> </div> </div> </div> <div class="panel-group" id="accordion12" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading12"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion12" href="#collapse12" aria-expanded="true" aria-controls="collapse12"> Unit 3.5 - SQL Commands: Delete & Update </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1000" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse12" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading12"> </div> </div> </div> <div class="panel-group" id="accordion13" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading13"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion13" href="#collapse13" aria-expanded="true" aria-controls="collapse13"> Unit 3.6 - Quiz </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1002" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse13" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading13"> </div> </div> </div> <div class="panel-group" id="accordion14" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading14"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion14" href="#collapse14" aria-expanded="true" aria-controls="collapse14"> Unit 3.3.2 - Case Study: Drop & Alter </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/998" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse14" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading14"> </div> </div> </div> <div class="panel-group" id="accordion15" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading15"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion15" href="#collapse15" aria-expanded="true" aria-controls="collapse15"> Unit 3.5.2 - Case Study: Delete & Update </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1001" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse15" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading15"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_5"> 5 Unit 4 - DML <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1003" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_5"> <div class="panel-group" id="accordion16" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading16"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion16" href="#collapse16" aria-expanded="true" aria-controls="collapse16"> Unit 4.1- SQL Commands: Select with Where Clause </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1004" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse16" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading16"> </div> </div> </div> <div class="panel-group" id="accordion17" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading17"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion17" href="#collapse17" aria-expanded="true" aria-controls="collapse17"> Unit 4.2 - Assignment Design a DB for Retail Store </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1006" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse17" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading17"> </div> </div> </div> <div class="panel-group" id="accordion18" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading18"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion18" href="#collapse18" aria-expanded="true" aria-controls="collapse18"> Unit 4.1.2 - Case Study: Select with Where Clause </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1005" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse18" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading18"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_6"> 6 Unit 5 - Data Analysis with SQL <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1007" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_6"> <div class="panel-group" id="accordion19" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading19"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion19" href="#collapse19" aria-expanded="true" aria-controls="collapse19"> Unit 5.1 - SQL Commands: Create a DB and Select with Where Clause on Retail Database </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1008" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse19" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading19"> </div> </div> </div> <div class="panel-group" id="accordion20" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading20"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion20" href="#collapse20" aria-expanded="true" aria-controls="collapse20"> Unit 5.2 - SQL Commands: Select with Groupby and nested query </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1015" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse20" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading20"> </div> </div> </div> <div class="panel-group" id="accordion21" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading21"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion21" href="#collapse21" aria-expanded="true" aria-controls="collapse21"> Unit 5.3 - Select with Condition & Order by nested query </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1018" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse21" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading21"> </div> </div> </div> <div class="panel-group" id="accordion22" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading22"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion22" href="#collapse22" aria-expanded="true" aria-controls="collapse22"> Unit 5.4 - SQL Commands: Joins Operations </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1019" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse22" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading22"> </div> </div> </div> <div class="panel-group" id="accordion23" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading23"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion23" href="#collapse23" aria-expanded="true" aria-controls="collapse23"> Unit 5.1.1.a - Case Study: Create a DB and Select with Where Clause on Retail Database </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1009" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse23" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading23"> </div> </div> </div> <div class="panel-group" id="accordion24" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading24"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion24" href="#collapse24" aria-expanded="true" aria-controls="collapse24"> Unit 5.1.1.b - Case Study: Create a DB and Select with Where Clause on Retail Database </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1010" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse24" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading24"> </div> </div> </div> <div class="panel-group" id="accordion25" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading25"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion25" href="#collapse25" aria-expanded="true" aria-controls="collapse25"> Unit 5.1.2 - Case Study Select Command </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1011" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse25" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading25"> </div> </div> </div> <div class="panel-group" id="accordion26" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading26"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion26" href="#collapse26" aria-expanded="true" aria-controls="collapse26"> Unit 5.1.2.a - Select_video_Edited Case Study </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1012" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse26" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading26"> </div> </div> </div> <div class="panel-group" id="accordion27" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading27"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion27" href="#collapse27" aria-expanded="true" aria-controls="collapse27"> Unit 5.1.3 - Create A Db And Select With Where Clause On Retail Database Part A </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1013" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse27" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading27"> </div> </div> </div> <div class="panel-group" id="accordion28" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading28"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion28" href="#collapse28" aria-expanded="true" aria-controls="collapse28"> Unit 5.1.3.a - Create A Db And Select With Where Clause On Retail Database Part B </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1014" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse28" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading28"> </div> </div> </div> <div class="panel-group" id="accordion29" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading29"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion29" href="#collapse29" aria-expanded="true" aria-controls="collapse29"> Unit 5.2.1.a - Case Study: Select with Groupby and nested query </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1016" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse29" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading29"> </div> </div> </div> <div class="panel-group" id="accordion30" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading30"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion30" href="#collapse30" aria-expanded="true" aria-controls="collapse30"> Unit 5.3.1 - SQL Commands: Select with Condition & Order by nested query </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1017" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse30" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading30"> </div> </div> </div> <div class="panel-group" id="accordion31" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading31"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion31" href="#collapse31" aria-expanded="true" aria-controls="collapse31"> Unit 5.4.2 - SQL Commands: Joins Operations Part 2 </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1020" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse31" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading31"> </div> </div> </div> <div class="panel-group" id="accordion32" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading32"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion32" href="#collapse32" aria-expanded="true" aria-controls="collapse32"> Unit 5.4.3 - SQL Commands: Joins Operations Part 3 </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1021" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse32" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading32"> </div> </div> </div> <div class="panel-group" id="accordion33" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading33"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion33" href="#collapse33" aria-expanded="true" aria-controls="collapse33"> Unit 5.4.4 - SQL Commands: Joins Operations Part 4 </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1022" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse33" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading33"> </div> </div> </div> <div class="panel-group" id="accordion34" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading34"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion34" href="#collapse34" aria-expanded="true" aria-controls="collapse34"> Unit 5.4.5 - SQL Commands: Joins Operations Part 5 </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1023" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse34" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading34"> </div> </div> </div> <div class="panel-group" id="accordion35" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading35"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion35" href="#collapse35" aria-expanded="true" aria-controls="collapse35"> Unit 5.4.5.a - Case Study 1 Railway Reservation Part 1 </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1024" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse35" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading35"> </div> </div> </div> <div class="panel-group" id="accordion36" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading36"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion36" href="#collapse36" aria-expanded="true" aria-controls="collapse36"> Unit 5.4.5.b - Case Study 1 Railway Reservation Part 2 </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1025" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse36" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading36"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_7"> 7 Unit 6 - Data Analysis with SQL on Hands-on <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1026" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_7"> <div class="panel-group" id="accordion37" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading37"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion37" href="#collapse37" aria-expanded="true" aria-controls="collapse37"> Unit 6.1 - Assignment: Basic Analysis on Sakila Database </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1027" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse37" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading37"> </div> </div> </div> <div class="panel-group" id="accordion38" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading38"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion38" href="#collapse38" aria-expanded="true" aria-controls="collapse38"> Unit 6.2 - Assignment: Advance Analysis on Dataset </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1028" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse38" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading38"> </div> </div> </div> <div class="panel-group" id="accordion39" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading39"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion39" href="#collapse39" aria-expanded="true" aria-controls="collapse39"> Unit 6.3 - Project: Connect and Build own Database for Infrastructure Company </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1029" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse39" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading39"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_8"> 8 Unit 7 - Power BI <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1126" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_8"> <div class="panel-group" id="accordion40" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading40"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion40" href="#collapse40" aria-expanded="true" aria-controls="collapse40"> Unit 7.1 - Installation </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1127" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse40" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading40"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_9"> 9 Unit 8 - Data Visualization <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1128" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_9"> <div class="panel-group" id="accordion41" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading41"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion41" href="#collapse41" aria-expanded="true" aria-controls="collapse41"> Unit 8.1 - Basic Visualization – Graphs and Tables </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1129" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse41" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading41"> </div> </div> </div> </div> </div> </div> </div></div></div></div></div> </div> </div> </div> </div> </div> </div> </div> <div class="site-meta-single-product col-md-4"> <div class="summary-product entry-summary"> <div class="meta" style="margin-bottom: 20px;"> <!-- <span class="lb" style="background: #ffbd33;">Language</span> --> <button class=" alt" style="width: 100%; border: none; padding: 0 2%; min-height: 65px;background: #ffbd33; display: flex; justify-content: center; align-items: center;"> <select style="color:#fff ; background: #ffbd33; width: 100%; border: none;" class="" onchange="window.location='https://uatdigipaathshala.cscacademy.org/lmscourses/coursedetails/' + this.value;"> <option selected value="">Select Language</option> </select> <i class="fa fa-caret-down" style="color: white;"></i> </button> <!-- <span class="if" style="padding: 0 ; display: flex; align-items: center; background: #ffbd33;"> <i class="fa fa-caret-down"></i> </span> --> </div> <div class="meta"> <span class="lb p-bg-dark">Duration</span> <span class="if p-bg">60 Days</span> </div> <div class="meta"> <span class="lb p-bg-dark">Price</span> <span class="if p-bg"><span class="woocommerce-Price-amount amount"> <span class="woocommerce-Price-currencySymbol">₹ </span>2596 /- <span style="font-size:9px;">(Inc. All Taxes)</span></span></span> </div> <div style="clear: both"></div> <div class="widget"style="margin-bottom: 0;"> <h4 class="widget-title text-center"><span>ABOUT PUBLISHER</span></h4> <div class="location-map"> <div class="instructor text-center"> <!--pre-signed url for s3 bucket--> <img src="https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/publisher/publisherphoto/6f6c3d54c80bdc757f28c1b89e3910e7.jpg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2&X-Amz-Signature=1959b79a821a3c8e7634dd260688c5a3ba1991c6383db47ad70aa19786cf2fd7" style="width: 167px;height: 88px;"> <div class="info"> <div class="name"><h4 class="p-font"><a href="" target="_blank">CSC ACADEMY AND BTA</a></h4> </div> <div class="phone" style="text-align:left;"> <p> CSC Academy is a publicly invested learning institution that provides access to professional e-learning for learners of diverse backgrounds and educational needs. The Academy is committed to teaching, delivering of specialized courses/ training programmes and ensuring ubiquitous reach of training services and community development programmes including social justice (health, housing, education, financial services, etc.), leadership, communication skills and promotion of entrepreneurship across India. It is known as a premier institution promoting ethical leadership, entrepreneurship and social inclusion as its fundamental principle.&nbsp; The Boston Training Academy (BTA) is a cutting- edge technology solutions provider, operating via a global network of reseller partners. Originating from a high performance, mission-critical server and storage solutions background, Boston now offers training and consultancy to make technology easily available to everyone BTA offers structured and highly customizable courses backed by world-class infrastructure, tools and techniques and delivered by global experts. BTA also offers further consulting services for Artificial Intelligence, Data Science and broader technology related topics. </p> </div> </div> </div></div></div> <div class="enroll-wrap"> <div class="quantity hidden"> </div> <!-- check with auth for free course --> <a href="javascript:void(0)" style="width:100%;" data-search-type="standard"><button type="submit" name="add-to-cart" courseid="85" class="single_add_to_cart_button button alt buy_now" style="width: 100%;font-size: 16px; padding-top: 18px; padding-bottom: 18px; background-color:#ffbd33; text-transform: uppercase;font-weight: 400;letter-spacing: 1px;" >Subscribe Now</button></a> </div> <aside id="g5plus-course-related-2" class="widget widget-course woocommerce"> <h4 class="widget-title"><span>Related Course</span></h4> <div class="widget-content"> <div class="product-listing woocommerce clearfix columns-4"> <div class="course-item-wrap"> <div class="course-thumb"> <img src="https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/courseimage/1923afb314f9e0e6d7c74dcc3c3d619f.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2&X-Amz-Signature=8068e60a1dab50c23ffe0c1e52600614f1d3e365023c4f4f416c913b99167d03" alt="CSC Bal Vidyalaya Educator Foundation Training " width="200" /> </div> <div class="course-info"> <a class="fs-14 fw-medium course-title p-color-hover" href="https://uatdigipaathshala.cscacademy.org/lmscourses/coursedetails/16">CSC Bal Vidyalaya Educator Foundation Training </a> <span><i class="fa fa-user p-color pd-right-10"></i>By : CSC Academy</span> <span><i class="fa fa-calendar p-color pd-right-10"></i>Duration : 30 Days</span> <span > <a href="https://uatdigipaathshala.cscacademy.org/lmscourses/coursedetails/16" class="bt bt-xs bt-bg bt-secondary">Learn Now</a> </span> </div> </div> </div> </div> </aside> </div></div> </div> </div> </main> </div> <!-- Send data for enrollment through API --> <script> $.noConflict(); jQuery(document).ready(function($){ $(".enroll_now").click(function(evt){ var CourseId = $(this).attr("courseid"); $.ajax({//Make the Ajax Request beforeSend:function(){ $('#loader').show(); }, type: "POST", url: "https://uatdigipaathshala.cscacademy.org/admin/lmscourses/enrollstd", data:"courseId="+CourseId, success: function(data){//html = the server response html code $('#loadingmessage').hide(); //store data $error = JSON.parse(data).error; $message = JSON.parse(data).message; //show modal box $("#showenrollmentModal").modal('show'); if($error =='1') { $('#showenrolledalert').html('<div style="text-align: center;">'+$message+'<br><br><a href="https://uatdigipaathshala.cscacademy.org/student"><button type="button" class="btn-sm btn-primary">Login Now</button></a></div>'); } else { $('#showenrolledalert').html('<div style="text-align: center;">'+$message+'<br><br><a href="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/mycourses"><button type="button" class="btn-sm btn-primary">My Course</button></a></div>'); } }, error:function(){ alert("Internal Error Server Not found!");} }); }); // Check restricted course for restricted categories $(".restricted_std").click(function(evt){ var CourseId = $(this).attr("courseid"); $.ajax({//Make the Ajax Request beforeSend:function(){ $('#loader').show(); }, type: "POST", url: "https://uatdigipaathshala.cscacademy.org/admin/lmscourses/restrictedstd", data:"courseId="+CourseId, success: function(data){//html = the server response html code $('#loadingmessage').hide(); //store data $error = JSON.parse(data).error; $message = JSON.parse(data).message; //show modal box $("#showenrollmentModal").modal('show'); if($error =='1') { $('#showenrolledalert').html('<div style="text-align: center;">'+$message+'<br><br><a href="https://uatdigipaathshala.cscacademy.org/student"><button type="button" class="btn-sm btn-primary">Login Now</button></a></div>'); } else { $('#showenrolledalert').html('<div style="text-align: center;">'+$message+'<br><br><a href="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/mycourses"><button type="button" class="btn-sm btn-primary">My Course</button></a></div>'); } }, error:function(){ alert("Internal Error Server Not found!");} }); }); // SHOW BUY NOW POP UP $(".buy_now").click(function(evt){ var CourseId = $(this).attr("courseid"); $.ajax({//Make the Ajax Request beforeSend:function(){ $('#loadingmessage').show(); }, type: "POST", url: "https://uatdigipaathshala.cscacademy.org/admin/lmscourses/bUyNowstd", data:"courseId="+CourseId, success: function(data){//html = the server response html code $('#loadingmessage').hide(); //store data $error = JSON.parse(data).error; $message = JSON.parse(data).message; if($error =='1') { //show modal box $("#showenrollmentModal").modal('show'); $('#showenrolledalert').html('<div style="text-align: center;">'+$message+'<br><br><a href="https://uatdigipaathshala.cscacademy.org/student"><button type="button" class="btn-sm btn-primary">Login Now</button></a></div>'); } else if($error =='5' || $error =='6' || $error =='7') { $Courseid = JSON.parse(data).CourseId; //check if course CCA Course to upload 10th certificate before proceeding payment. if($Courseid == '2') { $("#uploadcertificateModal").modal('show'); $("#UploadCourseIds").val($Courseid); $('#uploadmessage').html('Please Upload 10th certificate first!!'); } else if($Courseid == '74' || $Courseid == '77') { $("#uploadcertificateModal").modal('show'); $("#UploadCourseIds").val($Courseid); $('#uploadmessage').html('Please Upload 12th certificate first!!'); } else { //show payment gateways window if($error =='5') { $("#pgModal").modal('show'); $("#PGCourseIds").val($Courseid); } else if($error =='7') { $("#hdfcModal").modal('show'); $("#HDFCCourseIds").val($Courseid); } else if($error =='6') { $("#buynowModal").modal('show'); $("#CourseIds").val($Courseid); } else { alert('Something went wrong into PG!!'); return false(); } } } else { //show modal box $("#showenrollmentModal").modal('show'); $('#showenrolledalert').html('<div style="text-align: center;">'+$message+'<br><br><a href="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/mycourses"><button type="button" class="btn-sm btn-primary">My Course</button></a></div>'); } }, error:function(){ alert("Internal Error Server Not found!");} }); }); // Upload 10th certificate through ajax $("#upload10certificateform").on('submit',(function(e) { //check file size first!! var file_size = $('#10certificate')[0].files[0].size; if(file_size>2097152) { alert("File size is greater than 2MB, please upload again!!"); return false; } e.preventDefault(); $.ajax({ beforeSend:function(){ $("#uploadcertificateModal").modal('hide'); $('#loadingmessage').show(); }, url: "https://uatdigipaathshala.cscacademy.org/admin/lmscourses/upload10certificate", type: "POST", data: new FormData(this), contentType: false, cache: false, processData:false, success: function(data) { if(JSON.parse(data).error =='4') { $("#uploadcertificateModal").modal('hide'); $("#buynowModal").modal('show'); $("#CourseIds").val($Courseid); $("#UploadCertificateFile").val(JSON.parse(data).UploadCertificateFile); } else { alert(JSON.parse(data).message); } }, error: function(e) { $("#err").html(e).fadeIn(); } }); })); //check CSCID is associated with cscacademy centre or not $("#paynowcscid").click(function(evt){ var cscID = $('#cscID').val(); var courseid = "85"; var vedic_math_medium = "<pre class="cake-error"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr67efab4f3c7b1-trace').style.display = (document.getElementById('cakeErr67efab4f3c7b1-trace').style.display == 'none' ? '' : 'none');"><b>Notice</b> (8)</a>: Undefined variable: auth_user [<b>APP/View/Lmscourses/coursedetails.ctp</b>, line <b>774</b>]<div id="cakeErr67efab4f3c7b1-trace" class="cake-stack-trace" style="display: none;"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr67efab4f3c7b1-code').style.display = (document.getElementById('cakeErr67efab4f3c7b1-code').style.display == 'none' ? '' : 'none')">Code</a> <a href="javascript:void(0);" onclick="document.getElementById('cakeErr67efab4f3c7b1-context').style.display = (document.getElementById('cakeErr67efab4f3c7b1-context').style.display == 'none' ? '' : 'none')">Context</a><pre id="cakeErr67efab4f3c7b1-code" class="cake-code-dump" style="display: none;"><code><span style="color: #000000"> ob_start();</span></code> <code><span style="color: #000000"></span></code> <span class="code-highlight"><code><span style="color: #000000"> include $___viewFn;</span></code></span></pre><pre id="cakeErr67efab4f3c7b1-context" class="cake-context" style="display: none;">$___viewFn = '/data/uat/app/View/Lmscourses/coursedetails.ctp' $___dataForView = array( 'record' => array( [maximum depth reached] ), 'lmstopics' => array( [maximum depth reached] ), 'relatedcourses' => array( [maximum depth reached] ), 'check_exist' => false, 'languages' => array([maximum depth reached]), 'LastLogin' => array([maximum depth reached]), 's3' => object(Aws\S3\S3Client) {}, 'inputDefaults' => array( [maximum depth reached] ), 'csrfToken' => '6a24002bd597101fd9a60b7eb5250eadb0437194266019a21f1c33d4a70f7eb1' ) $record = array( 'Lmsuser' => array( [maximum depth reached] ), 'Lmscourse' => array( [maximum depth reached] ) ) $lmstopics = array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ), (int) 2 => array( [maximum depth reached] ), (int) 3 => array( [maximum depth reached] ), (int) 4 => array( [maximum depth reached] ), (int) 5 => array( [maximum depth reached] ), (int) 6 => array( [maximum depth reached] ), (int) 7 => array( [maximum depth reached] ), (int) 8 => array( [maximum depth reached] ) ) $relatedcourses = array( (int) 0 => array( [maximum depth reached] ) ) $check_exist = false $languages = array() $LastLogin = array() $s3 = object(Aws\S3\S3Client) {} $inputDefaults = array( 'inputDefaults' => array( [maximum depth reached] ) ) $csrfToken = '6a24002bd597101fd9a60b7eb5250eadb0437194266019a21f1c33d4a70f7eb1' $cmd = object(Aws\Command) {} $request = object(GuzzleHttp\Psr7\Request) {} $presignedUrl = 'https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/courseimage/1923afb314f9e0e6d7c74dcc3c3d619f.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2&X-Amz-Signature=8068e60a1dab50c23ffe0c1e52600614f1d3e365023c4f4f416c913b99167d03' $count = (int) 9 $count2 = (int) 41 $count3 = (int) 0 $lmstopic = array( 'Lmstopic' => array( [maximum depth reached] ), 'children' => array( [maximum depth reached] ) ) $children = array( 'Lmstopic' => array( [maximum depth reached] ), 'children' => array([maximum depth reached]) ) $relatedcourse = array( 'Lmscourse' => array( [maximum depth reached] ) )</pre><pre class="stack-trace">include - APP/View/Lmscourses/coursedetails.ctp, line 774 View::_evaluate() - CORE/Cake/View/View.php, line 915 View::_render() - CORE/Cake/View/View.php, line 879 View::render() - CORE/Cake/View/View.php, line 470 Controller::render() - CORE/Cake/Controller/Controller.php, line 959 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 110 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 85 [main] - APP/webroot/index.php, line 96</pre></div></pre>"; var csrfToken = "6a24002bd597101fd9a60b7eb5250eadb0437194266019a21f1c33d4a70f7eb1"; // alert(courseid); $.ajax({//Make the Ajax Request beforeSend:function(){ $("#buynowModal").modal('hide'); $('#loadingmessage').show(); }, type: "POST", url: "https://uatdigipaathshala.cscacademy.org/admin/users/checkCscacademyonboarding", // data:"cscID="+cscID+"course_id="+courseid, data:{cscID:cscID,courseid:courseid,vedic_math_medium:vedic_math_medium,csrfToken:csrfToken}, success: function(data){//html = the server response html code $('#loadingmessage').hide(); if(JSON.parse(data).count =='1') { document.paymentproceed.submit(); } else if(JSON.parse(data).count =='2') { document.paymentproceed.submit(); } else if(JSON.parse(data).count =='3') { alert('Oops!! Seats are full please try in another batch.'); } else if(JSON.parse(data).count =='4') { alert('Oops!! Payments are closed now for this course.'); } else if(JSON.parse(data).count =='5') { document.paymentproceed.submit(); } else if(JSON.parse(data).count =='6') { alert('Kindly register with Spoken Tutorial(Plan 1- All Courses) to Enroll students in This Course'); } else { $("#buynowModal").modal('show'); alert('This course is not active for this VLE!!'); } }, error:function(){ alert("Internal Error Server Not found!");} }); }); $("#pgmethod").click(function(evt){ var pgmethod = $('input[name="payment_gateway"]:checked').val(); if(pgmethod ==2) { $("#pgModal").modal('hide'); $("#buynowModal").modal('show'); $("#CourseIds").val($Courseid); } else if(pgmethod ==3) { $("#pgModal").modal('hide'); $("#hdfcModal").modal('show'); $("#HDFCCourseIds").val($Courseid); } else { alert('Error due to network!!'); return false(); } }); }); </script> ', 'scripts_for_layout' => '', 'title_for_layout' => 'Lmscourses' ) $record = array( 'Lmsuser' => array( [maximum depth reached] ), 'Lmscourse' => array( [maximum depth reached] ) ) $lmstopics = array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ), (int) 2 => array( [maximum depth reached] ), (int) 3 => array( [maximum depth reached] ), (int) 4 => array( [maximum depth reached] ), (int) 5 => array( [maximum depth reached] ), (int) 6 => array( [maximum depth reached] ), (int) 7 => array( [maximum depth reached] ), (int) 8 => array( [maximum depth reached] ) ) $relatedcourses = array( (int) 0 => array( [maximum depth reached] ) ) $check_exist = false $languages = array() $LastLogin = array() $s3 = object(Aws\S3\S3Client) {} $inputDefaults = array( 'inputDefaults' => array( [maximum depth reached] ) ) $csrfToken = '6a24002bd597101fd9a60b7eb5250eadb0437194266019a21f1c33d4a70f7eb1' $content_for_layout = '<script type="text/javascript" src="/js/jquery-min.js"></script> <style> .loadingmessage { position: fixed; left: 0px; top: 0px; width: 100%; height: 100%; z-index: 9999; background: url('https://uatdigipaathshala.cscacademy.org/gradient-design/img/loading.gif') 50% 50% no-repeat rgb(249,249,249); opacity: .8; } </style> <!-- Show buy now dialog box to proceed payment --> <!-- Start this modal box for show alert for enrollment --> <div id="buynowModal" class="modal fade" style="padding-top:6%;"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title" style="text-align:center;">Please Enter CSC ID</h4> </div> <div class="modal-body"> <form method="post" action="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/paycscwallet" name="paymentproceed" class="search-popup-inner" style="text-align:center;"> <input type="hidden" name="CourseIds" id="CourseIds" value="" /> <input type="hidden" name="UploadCertificateFile" id="UploadCertificateFile" value="" /> <div> <input type="text" name="cscid" placeholder="CSC ID" maxlength="12" id="cscID" oninput="this.value = this.value.replace(/[^0-9.]/g, '').replace(/(\..*)\./g, '$1');"> </div> <div style="padding-top:6%;"><button type="button" id="paynowcscid" class="bt bt-xs bt-bg bt-secondary inline">Pay Now</button></div> </form> </div> </div> </div> </div> <!-- End dialog box --> <!-- Start this modal box for show alert for All payment gateways --> <div id="pgModal" class="modal fade" style="padding-top:6%;"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title" style="text-align:center;">Please Select Payment Gateway</h4> </div> <div class="modal-body"> <form method="post" action="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/" name="pgselected" class="search-popup-inner" style="text-align:center;"> <input type="hidden" name="CourseIds" id="PGCourseIds" value="" /> <div> <input type="radio" name="payment_gateway" id="pgmethod_value" value="2" > CSC Wallet <input type="radio" name="payment_gateway" value="3" id="pgmethod_value" style="margin-left: 10px;"> HDFC </div> <div style="padding-top:6%;"><button type="button" id="pgmethod" class="bt bt-xs bt-bg bt-secondary inline">Proceed Now</button></div> </form> </div> </div> </div> </div> <div id="hdfcModal" class="modal fade" style="padding-top:6%;"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title" style="text-align:center;">Please Select Payment Gateway</h4> </div> <div class="modal-body"> <form method="post" action="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/payhdfc" name="hdfcselected" class="search-popup-inner" style="text-align:center;"> <input type="hidden" name="CourseIds" id="HDFCCourseIds" value="" /> <div> <input type="radio" name="payment_gateway" required="required" value="3" style="margin-left: 10px;"> <img src="https://uatdigipaathshala.cscacademy.org//images/hdfclogo.png" width="115" height="50"> </div> <div style="padding-top:6%;"><button type="submit" id="payhdfconly" class="bt bt-xs bt-bg bt-secondary inline">Proceed Now</button></div> </form> </div> </div> </div> </div> <!-- End dialog box --> <!-- Start this modal box for show upload 10th certificate before payment --> <div id="uploadcertificateModal" class="modal fade" style="padding-top:6%;"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title" id="uploadmessage" style="text-align:center;"></h4> </div> <div class="modal-body"> <form id="upload10certificateform" method="post" action="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/uploadcertificate" class="search-popup-inner" enctype="multipart/form-data" style="text-align:center;"> <input type="hidden" name="CourseIds" id="UploadCourseIds" value="" /> <div> <input type="file" name="upload10certificate" placeholder="Upload 10th Certificate" accept="image/*" id="10certificate" required="required"> <br> <span>File size should be max 1 MB and format JPEG/PNG</span> </div> <div style="padding-top:6%;"><button type="submit" class="bt bt-xs bt-bg bt-secondary inline">Upload</button></div> </form> </div> </div> </div> </div> <!-- End dialog box --> <!-- Start this modal box for show alert for enrollment --> <div id="showenrollmentModal" class="modal fade" style="padding-top:5%;"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title"></h4> </div> <div class="modal-body"> <div id="showenrolledalert"></div> </div> </div> </div> </div> <!-- End this modal box for show alert for enrollment --> <!-- Show loader --> <div id='loadingmessage' class="loadingmessage" style='display:none'> </div> <!-- End loader --> <div id="wrapper-content" class="clearfix"> <section id="page-title" class="single-product-title-wrap single-product-title-margin" > <div data-stellar-background-image="https://uatdigipaathshala.cscacademy.org/lmsfront_layout/img/coursedetails.jpg" data-stellar-background-position="top" data-stellar-background-ratio="0.5" class="page-title-parallax" style="background-image: url('https://uatdigipaathshala.cscacademy.org/lmsfront_layout/img/coursedetails.jpg');background-position:center top;"></div> <div class="container"> <div class="single-product-title-inner pt-bottom" > <div class="m-title"> <h2 class="p-font">COURSE DETAILS</h2> </div> <div class="breadcrumbs-wrap"> <div class="breadcrumbs-inner text-left"> <ul class="breadcrumbs"><li><a href="" class="home"><i class="fa fa-home"></i></a></li><li><a href="#"> Data Analysis with SQL and Power BI </a></li><li></li></ul> </div> </div> </div> </div> </section> <main class="single-product-wrap has-sidebar"> <div class="container clearfix"> <div class="row clearfix"> <div class="col-md-12"><h4 itemprop="name" class="product_title p-font hd-block"> Data Analysis with SQL and Power BI </h4> </div> <div class="site-content-single-product col-md-8"> <div class="single-product-inner"> <div class="woocommerce-notices-wrapper"></div> <div id="product-468" class="product type-product post-468 status-publish first instock product_cat-business-management product_cat-law-economic has-post-thumbnail featured shipping-taxable purchasable product-type-simple"> <div class="row single-product-info clearfix"> <div class="col-md-12 col-sm-12 col-xs-12"> <div class="single-product-image"> <div class="product-flash-wrap"> <span class="on-new product-flash">Premium</span> </div> <div id="single-product-image" class="single-product-image-inner horizontal"> <div class="product-image-slider-wrap"> <div class="product-image-slider"> <div> <!--pre-signed url for s3 bucket--> <a href="https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/courseimage/ff30a605a693ff195c66269a62e02ee1.jpg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2&X-Amz-Signature=9c6acd8afcb27059c0b647f0300da3ff17d3f76503717703e0b9be8bfbde6bd5" itemprop="image" class="woocommerce-main-image" title="" data-rel="prettyPhoto[product-gallery]" data-index="0"><img style="width:768px; height:500px;" src="https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/courseimage/ff30a605a693ff195c66269a62e02ee1.jpg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2&X-Amz-Signature=9c6acd8afcb27059c0b647f0300da3ff17d3f76503717703e0b9be8bfbde6bd5" class="attachment-shop_single size-shop_single" alt="" srcset="https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/courseimage/ff30a605a693ff195c66269a62e02ee1.jpg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2&X-Amz-Signature=9c6acd8afcb27059c0b647f0300da3ff17d3f76503717703e0b9be8bfbde6bd5" /></a></div></div> </div> </div> <script type="text/javascript"> (function ($) { "use strict"; $(document).ready(function () { var $productImageWrap = $('#single-product-image'); G5Plus.woocommerce.singleProductImage($productImageWrap); }); })(jQuery); </script> </div> <div class="instructor-wrap"> </div> <div class="lesson-list margin-top-70"> <div id="tab-description"> <div class="fullwidth" > <div class="vc_row wpb_row vc_row-fluid mg-top-30"><div class="wpb_column vc_column_container vc_col-sm-12"><div class="vc_column-inner"><div class="wpb_wrapper"> <div class="heading color-dark text-left " > <h2 class="heading-color fs-18">Course summary </h2> </div> </div></div></div></div></div> <div class="fullwidth" > <div class="vc_row wpb_row vc_row-fluid mg-top-30"><div class="wpb_column vc_column_container vc_col-sm-12"><div class="vc_column-inner"><div class="wpb_wrapper"> <div class="wpb_text_column wpb_content_element content-icon-list" > <div class="wpb_wrapper"> <p> Admission started for Batch 1. The course is designed to provide how to execute core SQL commands to define, select, manipulate, control access, aggregate and join data and data tables. Understand when and how to use subqueries, several window functions, as well as partitions to complete complex tasks. Clean data, optimize SQL queries, and write select advanced JOINs to enhance analysis performance. Explain which cases you would want to use particular SQL commands, and apply the results from queries to address business problems. </p> </div> </div> </div></div></div></div></div> <div class="fullwidth" > <div class="vc_row wpb_row vc_row-fluid mg-top-30"><div class="wpb_column vc_column_container vc_col-sm-12"><div class="vc_column-inner"><div class="wpb_wrapper"> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <h4 class="lesson-title"> <a href="javascript:;" data-id="lesson_content_5eab1f56ac59b"> Program Guidelines <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"> <!--pre-signed url for s3 bucket--> <a href="https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/publisher/assignment_guidelines/99f08000a1f579341185ff2d06e3d428.pdf?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=60&X-Amz-Signature=1c14bee57b97cca02b3891cfc9da130229f1174b2dea8d0c3412af784c979fdc" target="_blank">Download Now</a> </span> </div> </h4> </div> </div></div></div></div></div> </div> <div class="fullwidth" ><div class="vc_row wpb_row vc_row-fluid mg-top-30"><div class="wpb_column vc_column_container vc_col-sm-12"><div class="vc_column-inner"><div class="wpb_wrapper"> <div class="heading color-dark text-left " > <h2 class="heading-color fs-18"> TOPIC LISTS - </h2> </div> </div></div></div></div></div> <div class="fullwidth" > <div class="vc_row wpb_row vc_row-fluid mg-top-30"><div class="wpb_column vc_column_container vc_col-sm-12"><div class="vc_column-inner"><div class="wpb_wrapper"> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_1"> 1 Faculty and Course Introduction <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/983" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_1"> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_2"> 2 Unit 1 - Fundamentals of Database <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/984" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_2"> <div class="panel-group" id="accordion1" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading1"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion1" href="#collapse1" aria-expanded="true" aria-controls="collapse1"> Unit 1.1 - Introduction to DBMS </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/985" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse1" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading1"> </div> </div> </div> <div class="panel-group" id="accordion2" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading2"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion2" href="#collapse2" aria-expanded="true" aria-controls="collapse2"> Unit 1.2 - Applications of DBMS </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/986" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse2" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading2"> </div> </div> </div> <div class="panel-group" id="accordion3" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading3"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion3" href="#collapse3" aria-expanded="true" aria-controls="collapse3"> Unit 1.3 - Advantages & Disadvantages of DBMS </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/987" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse3" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading3"> </div> </div> </div> <div class="panel-group" id="accordion4" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading4"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion4" href="#collapse4" aria-expanded="true" aria-controls="collapse4"> Unit 1.4 - Properties of DBMS ACID Property </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/988" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse4" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading4"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_3"> 3 Unit 2 - Install and Run <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/989" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_3"> <div class="panel-group" id="accordion5" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading5"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion5" href="#collapse5" aria-expanded="true" aria-controls="collapse5"> Unit 2.1 - Installation of Mysql </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/990" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse5" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading5"> </div> </div> </div> <div class="panel-group" id="accordion6" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading6"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion6" href="#collapse6" aria-expanded="true" aria-controls="collapse6"> Unit 2.1 - MySQL Launch & Run sample scripts </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/991" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse6" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading6"> </div> </div> </div> <div class="panel-group" id="accordion7" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading7"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion7" href="#collapse7" aria-expanded="true" aria-controls="collapse7"> Unit 2.2 - Quiz </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/992" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse7" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading7"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_4"> 4 Unit 3 - DDL <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/993" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_4"> <div class="panel-group" id="accordion8" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading8"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion8" href="#collapse8" aria-expanded="true" aria-controls="collapse8"> Unit 3.1- SQL Commands : Create & Insert </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/995" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse8" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading8"> </div> </div> </div> <div class="panel-group" id="accordion9" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading9"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion9" href="#collapse9" aria-expanded="true" aria-controls="collapse9"> Unit 3.2 - Quiz </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/996" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse9" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading9"> </div> </div> </div> <div class="panel-group" id="accordion10" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading10"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion10" href="#collapse10" aria-expanded="true" aria-controls="collapse10"> Unit 3.3- SQL Commands: Drop & Alter </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/997" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse10" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading10"> </div> </div> </div> <div class="panel-group" id="accordion11" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading11"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion11" href="#collapse11" aria-expanded="true" aria-controls="collapse11"> Unit 3.4 - Quiz </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/999" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse11" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading11"> </div> </div> </div> <div class="panel-group" id="accordion12" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading12"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion12" href="#collapse12" aria-expanded="true" aria-controls="collapse12"> Unit 3.5 - SQL Commands: Delete & Update </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1000" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse12" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading12"> </div> </div> </div> <div class="panel-group" id="accordion13" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading13"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion13" href="#collapse13" aria-expanded="true" aria-controls="collapse13"> Unit 3.6 - Quiz </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1002" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse13" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading13"> </div> </div> </div> <div class="panel-group" id="accordion14" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading14"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion14" href="#collapse14" aria-expanded="true" aria-controls="collapse14"> Unit 3.3.2 - Case Study: Drop & Alter </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/998" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse14" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading14"> </div> </div> </div> <div class="panel-group" id="accordion15" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading15"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion15" href="#collapse15" aria-expanded="true" aria-controls="collapse15"> Unit 3.5.2 - Case Study: Delete & Update </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1001" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse15" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading15"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_5"> 5 Unit 4 - DML <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1003" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_5"> <div class="panel-group" id="accordion16" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading16"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion16" href="#collapse16" aria-expanded="true" aria-controls="collapse16"> Unit 4.1- SQL Commands: Select with Where Clause </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1004" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse16" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading16"> </div> </div> </div> <div class="panel-group" id="accordion17" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading17"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion17" href="#collapse17" aria-expanded="true" aria-controls="collapse17"> Unit 4.2 - Assignment Design a DB for Retail Store </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1006" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse17" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading17"> </div> </div> </div> <div class="panel-group" id="accordion18" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading18"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion18" href="#collapse18" aria-expanded="true" aria-controls="collapse18"> Unit 4.1.2 - Case Study: Select with Where Clause </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1005" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse18" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading18"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_6"> 6 Unit 5 - Data Analysis with SQL <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1007" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_6"> <div class="panel-group" id="accordion19" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading19"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion19" href="#collapse19" aria-expanded="true" aria-controls="collapse19"> Unit 5.1 - SQL Commands: Create a DB and Select with Where Clause on Retail Database </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1008" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse19" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading19"> </div> </div> </div> <div class="panel-group" id="accordion20" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading20"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion20" href="#collapse20" aria-expanded="true" aria-controls="collapse20"> Unit 5.2 - SQL Commands: Select with Groupby and nested query </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1015" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse20" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading20"> </div> </div> </div> <div class="panel-group" id="accordion21" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading21"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion21" href="#collapse21" aria-expanded="true" aria-controls="collapse21"> Unit 5.3 - Select with Condition & Order by nested query </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1018" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse21" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading21"> </div> </div> </div> <div class="panel-group" id="accordion22" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading22"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion22" href="#collapse22" aria-expanded="true" aria-controls="collapse22"> Unit 5.4 - SQL Commands: Joins Operations </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1019" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse22" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading22"> </div> </div> </div> <div class="panel-group" id="accordion23" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading23"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion23" href="#collapse23" aria-expanded="true" aria-controls="collapse23"> Unit 5.1.1.a - Case Study: Create a DB and Select with Where Clause on Retail Database </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1009" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse23" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading23"> </div> </div> </div> <div class="panel-group" id="accordion24" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading24"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion24" href="#collapse24" aria-expanded="true" aria-controls="collapse24"> Unit 5.1.1.b - Case Study: Create a DB and Select with Where Clause on Retail Database </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1010" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse24" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading24"> </div> </div> </div> <div class="panel-group" id="accordion25" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading25"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion25" href="#collapse25" aria-expanded="true" aria-controls="collapse25"> Unit 5.1.2 - Case Study Select Command </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1011" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse25" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading25"> </div> </div> </div> <div class="panel-group" id="accordion26" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading26"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion26" href="#collapse26" aria-expanded="true" aria-controls="collapse26"> Unit 5.1.2.a - Select_video_Edited Case Study </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1012" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse26" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading26"> </div> </div> </div> <div class="panel-group" id="accordion27" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading27"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion27" href="#collapse27" aria-expanded="true" aria-controls="collapse27"> Unit 5.1.3 - Create A Db And Select With Where Clause On Retail Database Part A </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1013" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse27" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading27"> </div> </div> </div> <div class="panel-group" id="accordion28" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading28"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion28" href="#collapse28" aria-expanded="true" aria-controls="collapse28"> Unit 5.1.3.a - Create A Db And Select With Where Clause On Retail Database Part B </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1014" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse28" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading28"> </div> </div> </div> <div class="panel-group" id="accordion29" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading29"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion29" href="#collapse29" aria-expanded="true" aria-controls="collapse29"> Unit 5.2.1.a - Case Study: Select with Groupby and nested query </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1016" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse29" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading29"> </div> </div> </div> <div class="panel-group" id="accordion30" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading30"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion30" href="#collapse30" aria-expanded="true" aria-controls="collapse30"> Unit 5.3.1 - SQL Commands: Select with Condition & Order by nested query </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1017" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse30" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading30"> </div> </div> </div> <div class="panel-group" id="accordion31" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading31"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion31" href="#collapse31" aria-expanded="true" aria-controls="collapse31"> Unit 5.4.2 - SQL Commands: Joins Operations Part 2 </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1020" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse31" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading31"> </div> </div> </div> <div class="panel-group" id="accordion32" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading32"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion32" href="#collapse32" aria-expanded="true" aria-controls="collapse32"> Unit 5.4.3 - SQL Commands: Joins Operations Part 3 </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1021" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse32" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading32"> </div> </div> </div> <div class="panel-group" id="accordion33" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading33"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion33" href="#collapse33" aria-expanded="true" aria-controls="collapse33"> Unit 5.4.4 - SQL Commands: Joins Operations Part 4 </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1022" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse33" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading33"> </div> </div> </div> <div class="panel-group" id="accordion34" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading34"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion34" href="#collapse34" aria-expanded="true" aria-controls="collapse34"> Unit 5.4.5 - SQL Commands: Joins Operations Part 5 </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1023" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse34" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading34"> </div> </div> </div> <div class="panel-group" id="accordion35" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading35"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion35" href="#collapse35" aria-expanded="true" aria-controls="collapse35"> Unit 5.4.5.a - Case Study 1 Railway Reservation Part 1 </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1024" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse35" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading35"> </div> </div> </div> <div class="panel-group" id="accordion36" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading36"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion36" href="#collapse36" aria-expanded="true" aria-controls="collapse36"> Unit 5.4.5.b - Case Study 1 Railway Reservation Part 2 </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1025" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse36" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading36"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_7"> 7 Unit 6 - Data Analysis with SQL on Hands-on <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1026" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_7"> <div class="panel-group" id="accordion37" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading37"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion37" href="#collapse37" aria-expanded="true" aria-controls="collapse37"> Unit 6.1 - Assignment: Basic Analysis on Sakila Database </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1027" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse37" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading37"> </div> </div> </div> <div class="panel-group" id="accordion38" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading38"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion38" href="#collapse38" aria-expanded="true" aria-controls="collapse38"> Unit 6.2 - Assignment: Advance Analysis on Dataset </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1028" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse38" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading38"> </div> </div> </div> <div class="panel-group" id="accordion39" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading39"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion39" href="#collapse39" aria-expanded="true" aria-controls="collapse39"> Unit 6.3 - Project: Connect and Build own Database for Infrastructure Company </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1029" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse39" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading39"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_8"> 8 Unit 7 - Power BI <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1126" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_8"> <div class="panel-group" id="accordion40" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading40"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion40" href="#collapse40" aria-expanded="true" aria-controls="collapse40"> Unit 7.1 - Installation </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1127" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse40" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading40"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_9"> 9 Unit 8 - Data Visualization <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1128" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_9"> <div class="panel-group" id="accordion41" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading41"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion41" href="#collapse41" aria-expanded="true" aria-controls="collapse41"> Unit 8.1 - Basic Visualization – Graphs and Tables </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1129" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse41" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading41"> </div> </div> </div> </div> </div> </div> </div></div></div></div></div> </div> </div> </div> </div> </div> </div> </div> <div class="site-meta-single-product col-md-4"> <div class="summary-product entry-summary"> <div class="meta" style="margin-bottom: 20px;"> <!-- <span class="lb" style="background: #ffbd33;">Language</span> --> <button class=" alt" style="width: 100%; border: none; padding: 0 2%; min-height: 65px;background: #ffbd33; display: flex; justify-content: center; align-items: center;"> <select style="color:#fff ; background: #ffbd33; width: 100%; border: none;" class="" onchange="window.location='https://uatdigipaathshala.cscacademy.org/lmscourses/coursedetails/' + this.value;"> <option selected value="">Select Language</option> </select> <i class="fa fa-caret-down" style="color: white;"></i> </button> <!-- <span class="if" style="padding: 0 ; display: flex; align-items: center; background: #ffbd33;"> <i class="fa fa-caret-down"></i> </span> --> </div> <div class="meta"> <span class="lb p-bg-dark">Duration</span> <span class="if p-bg">60 Days</span> </div> <div class="meta"> <span class="lb p-bg-dark">Price</span> <span class="if p-bg"><span class="woocommerce-Price-amount amount"> <span class="woocommerce-Price-currencySymbol">₹ </span>2596 /- <span style="font-size:9px;">(Inc. All Taxes)</span></span></span> </div> <div style="clear: both"></div> <div class="widget"style="margin-bottom: 0;"> <h4 class="widget-title text-center"><span>ABOUT PUBLISHER</span></h4> <div class="location-map"> <div class="instructor text-center"> <!--pre-signed url for s3 bucket--> <img src="https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/publisher/publisherphoto/6f6c3d54c80bdc757f28c1b89e3910e7.jpg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2&X-Amz-Signature=1959b79a821a3c8e7634dd260688c5a3ba1991c6383db47ad70aa19786cf2fd7" style="width: 167px;height: 88px;"> <div class="info"> <div class="name"><h4 class="p-font"><a href="" target="_blank">CSC ACADEMY AND BTA</a></h4> </div> <div class="phone" style="text-align:left;"> <p> CSC Academy is a publicly invested learning institution that provides access to professional e-learning for learners of diverse backgrounds and educational needs. The Academy is committed to teaching, delivering of specialized courses/ training programmes and ensuring ubiquitous reach of training services and community development programmes including social justice (health, housing, education, financial services, etc.), leadership, communication skills and promotion of entrepreneurship across India. It is known as a premier institution promoting ethical leadership, entrepreneurship and social inclusion as its fundamental principle.&nbsp; The Boston Training Academy (BTA) is a cutting- edge technology solutions provider, operating via a global network of reseller partners. Originating from a high performance, mission-critical server and storage solutions background, Boston now offers training and consultancy to make technology easily available to everyone BTA offers structured and highly customizable courses backed by world-class infrastructure, tools and techniques and delivered by global experts. BTA also offers further consulting services for Artificial Intelligence, Data Science and broader technology related topics. </p> </div> </div> </div></div></div> <div class="enroll-wrap"> <div class="quantity hidden"> </div> <!-- check with auth for free course --> <a href="javascript:void(0)" style="width:100%;" data-search-type="standard"><button type="submit" name="add-to-cart" courseid="85" class="single_add_to_cart_button button alt buy_now" style="width: 100%;font-size: 16px; padding-top: 18px; padding-bottom: 18px; background-color:#ffbd33; text-transform: uppercase;font-weight: 400;letter-spacing: 1px;" >Subscribe Now</button></a> </div> <aside id="g5plus-course-related-2" class="widget widget-course woocommerce"> <h4 class="widget-title"><span>Related Course</span></h4> <div class="widget-content"> <div class="product-listing woocommerce clearfix columns-4"> <div class="course-item-wrap"> <div class="course-thumb"> <img src="https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/courseimage/1923afb314f9e0e6d7c74dcc3c3d619f.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2&X-Amz-Signature=8068e60a1dab50c23ffe0c1e52600614f1d3e365023c4f4f416c913b99167d03" alt="CSC Bal Vidyalaya Educator Foundation Training " width="200" /> </div> <div class="course-info"> <a class="fs-14 fw-medium course-title p-color-hover" href="https://uatdigipaathshala.cscacademy.org/lmscourses/coursedetails/16">CSC Bal Vidyalaya Educator Foundation Training </a> <span><i class="fa fa-user p-color pd-right-10"></i>By : CSC Academy</span> <span><i class="fa fa-calendar p-color pd-right-10"></i>Duration : 30 Days</span> <span > <a href="https://uatdigipaathshala.cscacademy.org/lmscourses/coursedetails/16" class="bt bt-xs bt-bg bt-secondary">Learn Now</a> </span> </div> </div> </div> </div> </aside> </div></div> </div> </div> </main> </div> <!-- Send data for enrollment through API --> <script> $.noConflict(); jQuery(document).ready(function($){ $(".enroll_now").click(function(evt){ var CourseId = $(this).attr("courseid"); $.ajax({//Make the Ajax Request beforeSend:function(){ $('#loader').show(); }, type: "POST", url: "https://uatdigipaathshala.cscacademy.org/admin/lmscourses/enrollstd", data:"courseId="+CourseId, success: function(data){//html = the server response html code $('#loadingmessage').hide(); //store data $error = JSON.parse(data).error; $message = JSON.parse(data).message; //show modal box $("#showenrollmentModal").modal('show'); if($error =='1') { $('#showenrolledalert').html('<div style="text-align: center;">'+$message+'<br><br><a href="https://uatdigipaathshala.cscacademy.org/student"><button type="button" class="btn-sm btn-primary">Login Now</button></a></div>'); } else { $('#showenrolledalert').html('<div style="text-align: center;">'+$message+'<br><br><a href="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/mycourses"><button type="button" class="btn-sm btn-primary">My Course</button></a></div>'); } }, error:function(){ alert("Internal Error Server Not found!");} }); }); // Check restricted course for restricted categories $(".restricted_std").click(function(evt){ var CourseId = $(this).attr("courseid"); $.ajax({//Make the Ajax Request beforeSend:function(){ $('#loader').show(); }, type: "POST", url: "https://uatdigipaathshala.cscacademy.org/admin/lmscourses/restrictedstd", data:"courseId="+CourseId, success: function(data){//html = the server response html code $('#loadingmessage').hide(); //store data $error = JSON.parse(data).error; $message = JSON.parse(data).message; //show modal box $("#showenrollmentModal").modal('show'); if($error =='1') { $('#showenrolledalert').html('<div style="text-align: center;">'+$message+'<br><br><a href="https://uatdigipaathshala.cscacademy.org/student"><button type="button" class="btn-sm btn-primary">Login Now</button></a></div>'); } else { $('#showenrolledalert').html('<div style="text-align: center;">'+$message+'<br><br><a href="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/mycourses"><button type="button" class="btn-sm btn-primary">My Course</button></a></div>'); } }, error:function(){ alert("Internal Error Server Not found!");} }); }); // SHOW BUY NOW POP UP $(".buy_now").click(function(evt){ var CourseId = $(this).attr("courseid"); $.ajax({//Make the Ajax Request beforeSend:function(){ $('#loadingmessage').show(); }, type: "POST", url: "https://uatdigipaathshala.cscacademy.org/admin/lmscourses/bUyNowstd", data:"courseId="+CourseId, success: function(data){//html = the server response html code $('#loadingmessage').hide(); //store data $error = JSON.parse(data).error; $message = JSON.parse(data).message; if($error =='1') { //show modal box $("#showenrollmentModal").modal('show'); $('#showenrolledalert').html('<div style="text-align: center;">'+$message+'<br><br><a href="https://uatdigipaathshala.cscacademy.org/student"><button type="button" class="btn-sm btn-primary">Login Now</button></a></div>'); } else if($error =='5' || $error =='6' || $error =='7') { $Courseid = JSON.parse(data).CourseId; //check if course CCA Course to upload 10th certificate before proceeding payment. if($Courseid == '2') { $("#uploadcertificateModal").modal('show'); $("#UploadCourseIds").val($Courseid); $('#uploadmessage').html('Please Upload 10th certificate first!!'); } else if($Courseid == '74' || $Courseid == '77') { $("#uploadcertificateModal").modal('show'); $("#UploadCourseIds").val($Courseid); $('#uploadmessage').html('Please Upload 12th certificate first!!'); } else { //show payment gateways window if($error =='5') { $("#pgModal").modal('show'); $("#PGCourseIds").val($Courseid); } else if($error =='7') { $("#hdfcModal").modal('show'); $("#HDFCCourseIds").val($Courseid); } else if($error =='6') { $("#buynowModal").modal('show'); $("#CourseIds").val($Courseid); } else { alert('Something went wrong into PG!!'); return false(); } } } else { //show modal box $("#showenrollmentModal").modal('show'); $('#showenrolledalert').html('<div style="text-align: center;">'+$message+'<br><br><a href="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/mycourses"><button type="button" class="btn-sm btn-primary">My Course</button></a></div>'); } }, error:function(){ alert("Internal Error Server Not found!");} }); }); // Upload 10th certificate through ajax $("#upload10certificateform").on('submit',(function(e) { //check file size first!! var file_size = $('#10certificate')[0].files[0].size; if(file_size>2097152) { alert("File size is greater than 2MB, please upload again!!"); return false; } e.preventDefault(); $.ajax({ beforeSend:function(){ $("#uploadcertificateModal").modal('hide'); $('#loadingmessage').show(); }, url: "https://uatdigipaathshala.cscacademy.org/admin/lmscourses/upload10certificate", type: "POST", data: new FormData(this), contentType: false, cache: false, processData:false, success: function(data) { if(JSON.parse(data).error =='4') { $("#uploadcertificateModal").modal('hide'); $("#buynowModal").modal('show'); $("#CourseIds").val($Courseid); $("#UploadCertificateFile").val(JSON.parse(data).UploadCertificateFile); } else { alert(JSON.parse(data).message); } }, error: function(e) { $("#err").html(e).fadeIn(); } }); })); //check CSCID is associated with cscacademy centre or not $("#paynowcscid").click(function(evt){ var cscID = $('#cscID').val(); var courseid = "85"; var vedic_math_medium = "<pre class="cake-error"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr67efab4f3c7b1-trace').style.display = (document.getElementById('cakeErr67efab4f3c7b1-trace').style.display == 'none' ? '' : 'none');"><b>Notice</b> (8)</a>: Undefined variable: auth_user [<b>APP/View/Lmscourses/coursedetails.ctp</b>, line <b>774</b>]<div id="cakeErr67efab4f3c7b1-trace" class="cake-stack-trace" style="display: none;"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr67efab4f3c7b1-code').style.display = (document.getElementById('cakeErr67efab4f3c7b1-code').style.display == 'none' ? '' : 'none')">Code</a> <a href="javascript:void(0);" onclick="document.getElementById('cakeErr67efab4f3c7b1-context').style.display = (document.getElementById('cakeErr67efab4f3c7b1-context').style.display == 'none' ? '' : 'none')">Context</a><pre id="cakeErr67efab4f3c7b1-code" class="cake-code-dump" style="display: none;"><code><span style="color: #000000"> ob_start();</span></code> <code><span style="color: #000000"></span></code> <span class="code-highlight"><code><span style="color: #000000"> include $___viewFn;</span></code></span></pre><pre id="cakeErr67efab4f3c7b1-context" class="cake-context" style="display: none;">$___viewFn = '/data/uat/app/View/Lmscourses/coursedetails.ctp' $___dataForView = array( 'record' => array( [maximum depth reached] ), 'lmstopics' => array( [maximum depth reached] ), 'relatedcourses' => array( [maximum depth reached] ), 'check_exist' => false, 'languages' => array([maximum depth reached]), 'LastLogin' => array([maximum depth reached]), 's3' => object(Aws\S3\S3Client) {}, 'inputDefaults' => array( [maximum depth reached] ), 'csrfToken' => '6a24002bd597101fd9a60b7eb5250eadb0437194266019a21f1c33d4a70f7eb1' ) $record = array( 'Lmsuser' => array( [maximum depth reached] ), 'Lmscourse' => array( [maximum depth reached] ) ) $lmstopics = array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ), (int) 2 => array( [maximum depth reached] ), (int) 3 => array( [maximum depth reached] ), (int) 4 => array( [maximum depth reached] ), (int) 5 => array( [maximum depth reached] ), (int) 6 => array( [maximum depth reached] ), (int) 7 => array( [maximum depth reached] ), (int) 8 => array( [maximum depth reached] ) ) $relatedcourses = array( (int) 0 => array( [maximum depth reached] ) ) $check_exist = false $languages = array() $LastLogin = array() $s3 = object(Aws\S3\S3Client) {} $inputDefaults = array( 'inputDefaults' => array( [maximum depth reached] ) ) $csrfToken = '6a24002bd597101fd9a60b7eb5250eadb0437194266019a21f1c33d4a70f7eb1' $cmd = object(Aws\Command) {} $request = object(GuzzleHttp\Psr7\Request) {} $presignedUrl = 'https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/courseimage/1923afb314f9e0e6d7c74dcc3c3d619f.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2&X-Amz-Signature=8068e60a1dab50c23ffe0c1e52600614f1d3e365023c4f4f416c913b99167d03' $count = (int) 9 $count2 = (int) 41 $count3 = (int) 0 $lmstopic = array( 'Lmstopic' => array( [maximum depth reached] ), 'children' => array( [maximum depth reached] ) ) $children = array( 'Lmstopic' => array( [maximum depth reached] ), 'children' => array([maximum depth reached]) ) $relatedcourse = array( 'Lmscourse' => array( [maximum depth reached] ) )</pre><pre class="stack-trace">include - APP/View/Lmscourses/coursedetails.ctp, line 774 View::_evaluate() - CORE/Cake/View/View.php, line 915 View::_render() - CORE/Cake/View/View.php, line 879 View::render() - CORE/Cake/View/View.php, line 470 Controller::render() - CORE/Cake/Controller/Controller.php, line 959 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 110 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 85 [main] - APP/webroot/index.php, line 96</pre></div></pre>"; var csrfToken = "6a24002bd597101fd9a60b7eb5250eadb0437194266019a21f1c33d4a70f7eb1"; // alert(courseid); $.ajax({//Make the Ajax Request beforeSend:function(){ $("#buynowModal").modal('hide'); $('#loadingmessage').show(); }, type: "POST", url: "https://uatdigipaathshala.cscacademy.org/admin/users/checkCscacademyonboarding", // data:"cscID="+cscID+"course_id="+courseid, data:{cscID:cscID,courseid:courseid,vedic_math_medium:vedic_math_medium,csrfToken:csrfToken}, success: function(data){//html = the server response html code $('#loadingmessage').hide(); if(JSON.parse(data).count =='1') { document.paymentproceed.submit(); } else if(JSON.parse(data).count =='2') { document.paymentproceed.submit(); } else if(JSON.parse(data).count =='3') { alert('Oops!! Seats are full please try in another batch.'); } else if(JSON.parse(data).count =='4') { alert('Oops!! Payments are closed now for this course.'); } else if(JSON.parse(data).count =='5') { document.paymentproceed.submit(); } else if(JSON.parse(data).count =='6') { alert('Kindly register with Spoken Tutorial(Plan 1- All Courses) to Enroll students in This Course'); } else { $("#buynowModal").modal('show'); alert('This course is not active for this VLE!!'); } }, error:function(){ alert("Internal Error Server Not found!");} }); }); $("#pgmethod").click(function(evt){ var pgmethod = $('input[name="payment_gateway"]:checked').val(); if(pgmethod ==2) { $("#pgModal").modal('hide'); $("#buynowModal").modal('show'); $("#CourseIds").val($Courseid); } else if(pgmethod ==3) { $("#pgModal").modal('hide'); $("#hdfcModal").modal('show'); $("#HDFCCourseIds").val($Courseid); } else { alert('Error due to network!!'); return false(); } }); }); </script> ' $scripts_for_layout = '' $title_for_layout = 'Lmscourses'include - APP/View/Layouts/lms_inner_layout.ctp, line 391 View::_evaluate() - CORE/Cake/View/View.php, line 915 View::_render() - CORE/Cake/View/View.php, line 879 View::renderLayout() - CORE/Cake/View/View.php, line 534 View::render() - CORE/Cake/View/View.php, line 478 Controller::render() - CORE/Cake/Controller/Controller.php, line 959 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 110 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 85 [main] - APP/webroot/index.php, line 96
Notice (8): Undefined index: Message [APP/View/Layouts/lms_inner_layout.ctp, line 395]Code Contextob_start();
include $___viewFn;
$___viewFn = '/data/uat/app/View/Layouts/lms_inner_layout.ctp' $___dataForView = array( 'record' => array( [maximum depth reached] ), 'lmstopics' => array( [maximum depth reached] ), 'relatedcourses' => array( [maximum depth reached] ), 'check_exist' => false, 'languages' => array([maximum depth reached]), 'LastLogin' => array([maximum depth reached]), 's3' => object(Aws\S3\S3Client) {}, 'inputDefaults' => array( [maximum depth reached] ), 'csrfToken' => '6a24002bd597101fd9a60b7eb5250eadb0437194266019a21f1c33d4a70f7eb1', 'content_for_layout' => '<script type="text/javascript" src="/js/jquery-min.js"></script> <style> .loadingmessage { position: fixed; left: 0px; top: 0px; width: 100%; height: 100%; z-index: 9999; background: url('https://uatdigipaathshala.cscacademy.org/gradient-design/img/loading.gif') 50% 50% no-repeat rgb(249,249,249); opacity: .8; } </style> <!-- Show buy now dialog box to proceed payment --> <!-- Start this modal box for show alert for enrollment --> <div id="buynowModal" class="modal fade" style="padding-top:6%;"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title" style="text-align:center;">Please Enter CSC ID</h4> </div> <div class="modal-body"> <form method="post" action="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/paycscwallet" name="paymentproceed" class="search-popup-inner" style="text-align:center;"> <input type="hidden" name="CourseIds" id="CourseIds" value="" /> <input type="hidden" name="UploadCertificateFile" id="UploadCertificateFile" value="" /> <div> <input type="text" name="cscid" placeholder="CSC ID" maxlength="12" id="cscID" oninput="this.value = this.value.replace(/[^0-9.]/g, '').replace(/(\..*)\./g, '$1');"> </div> <div style="padding-top:6%;"><button type="button" id="paynowcscid" class="bt bt-xs bt-bg bt-secondary inline">Pay Now</button></div> </form> </div> </div> </div> </div> <!-- End dialog box --> <!-- Start this modal box for show alert for All payment gateways --> <div id="pgModal" class="modal fade" style="padding-top:6%;"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title" style="text-align:center;">Please Select Payment Gateway</h4> </div> <div class="modal-body"> <form method="post" action="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/" name="pgselected" class="search-popup-inner" style="text-align:center;"> <input type="hidden" name="CourseIds" id="PGCourseIds" value="" /> <div> <input type="radio" name="payment_gateway" id="pgmethod_value" value="2" > CSC Wallet <input type="radio" name="payment_gateway" value="3" id="pgmethod_value" style="margin-left: 10px;"> HDFC </div> <div style="padding-top:6%;"><button type="button" id="pgmethod" class="bt bt-xs bt-bg bt-secondary inline">Proceed Now</button></div> </form> </div> </div> </div> </div> <div id="hdfcModal" class="modal fade" style="padding-top:6%;"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title" style="text-align:center;">Please Select Payment Gateway</h4> </div> <div class="modal-body"> <form method="post" action="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/payhdfc" name="hdfcselected" class="search-popup-inner" style="text-align:center;"> <input type="hidden" name="CourseIds" id="HDFCCourseIds" value="" /> <div> <input type="radio" name="payment_gateway" required="required" value="3" style="margin-left: 10px;"> <img src="https://uatdigipaathshala.cscacademy.org//images/hdfclogo.png" width="115" height="50"> </div> <div style="padding-top:6%;"><button type="submit" id="payhdfconly" class="bt bt-xs bt-bg bt-secondary inline">Proceed Now</button></div> </form> </div> </div> </div> </div> <!-- End dialog box --> <!-- Start this modal box for show upload 10th certificate before payment --> <div id="uploadcertificateModal" class="modal fade" style="padding-top:6%;"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title" id="uploadmessage" style="text-align:center;"></h4> </div> <div class="modal-body"> <form id="upload10certificateform" method="post" action="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/uploadcertificate" class="search-popup-inner" enctype="multipart/form-data" style="text-align:center;"> <input type="hidden" name="CourseIds" id="UploadCourseIds" value="" /> <div> <input type="file" name="upload10certificate" placeholder="Upload 10th Certificate" accept="image/*" id="10certificate" required="required"> <br> <span>File size should be max 1 MB and format JPEG/PNG</span> </div> <div style="padding-top:6%;"><button type="submit" class="bt bt-xs bt-bg bt-secondary inline">Upload</button></div> </form> </div> </div> </div> </div> <!-- End dialog box --> <!-- Start this modal box for show alert for enrollment --> <div id="showenrollmentModal" class="modal fade" style="padding-top:5%;"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title"></h4> </div> <div class="modal-body"> <div id="showenrolledalert"></div> </div> </div> </div> </div> <!-- End this modal box for show alert for enrollment --> <!-- Show loader --> <div id='loadingmessage' class="loadingmessage" style='display:none'> </div> <!-- End loader --> <div id="wrapper-content" class="clearfix"> <section id="page-title" class="single-product-title-wrap single-product-title-margin" > <div data-stellar-background-image="https://uatdigipaathshala.cscacademy.org/lmsfront_layout/img/coursedetails.jpg" data-stellar-background-position="top" data-stellar-background-ratio="0.5" class="page-title-parallax" style="background-image: url('https://uatdigipaathshala.cscacademy.org/lmsfront_layout/img/coursedetails.jpg');background-position:center top;"></div> <div class="container"> <div class="single-product-title-inner pt-bottom" > <div class="m-title"> <h2 class="p-font">COURSE DETAILS</h2> </div> <div class="breadcrumbs-wrap"> <div class="breadcrumbs-inner text-left"> <ul class="breadcrumbs"><li><a href="" class="home"><i class="fa fa-home"></i></a></li><li><a href="#"> Data Analysis with SQL and Power BI </a></li><li></li></ul> </div> </div> </div> </div> </section> <main class="single-product-wrap has-sidebar"> <div class="container clearfix"> <div class="row clearfix"> <div class="col-md-12"><h4 itemprop="name" class="product_title p-font hd-block"> Data Analysis with SQL and Power BI </h4> </div> <div class="site-content-single-product col-md-8"> <div class="single-product-inner"> <div class="woocommerce-notices-wrapper"></div> <div id="product-468" class="product type-product post-468 status-publish first instock product_cat-business-management product_cat-law-economic has-post-thumbnail featured shipping-taxable purchasable product-type-simple"> <div class="row single-product-info clearfix"> <div class="col-md-12 col-sm-12 col-xs-12"> <div class="single-product-image"> <div class="product-flash-wrap"> <span class="on-new product-flash">Premium</span> </div> <div id="single-product-image" class="single-product-image-inner horizontal"> <div class="product-image-slider-wrap"> <div class="product-image-slider"> <div> <!--pre-signed url for s3 bucket--> <a href="https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/courseimage/ff30a605a693ff195c66269a62e02ee1.jpg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2&X-Amz-Signature=9c6acd8afcb27059c0b647f0300da3ff17d3f76503717703e0b9be8bfbde6bd5" itemprop="image" class="woocommerce-main-image" title="" data-rel="prettyPhoto[product-gallery]" data-index="0"><img style="width:768px; height:500px;" src="https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/courseimage/ff30a605a693ff195c66269a62e02ee1.jpg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2&X-Amz-Signature=9c6acd8afcb27059c0b647f0300da3ff17d3f76503717703e0b9be8bfbde6bd5" class="attachment-shop_single size-shop_single" alt="" srcset="https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/courseimage/ff30a605a693ff195c66269a62e02ee1.jpg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2&X-Amz-Signature=9c6acd8afcb27059c0b647f0300da3ff17d3f76503717703e0b9be8bfbde6bd5" /></a></div></div> </div> </div> <script type="text/javascript"> (function ($) { "use strict"; $(document).ready(function () { var $productImageWrap = $('#single-product-image'); G5Plus.woocommerce.singleProductImage($productImageWrap); }); })(jQuery); </script> </div> <div class="instructor-wrap"> </div> <div class="lesson-list margin-top-70"> <div id="tab-description"> <div class="fullwidth" > <div class="vc_row wpb_row vc_row-fluid mg-top-30"><div class="wpb_column vc_column_container vc_col-sm-12"><div class="vc_column-inner"><div class="wpb_wrapper"> <div class="heading color-dark text-left " > <h2 class="heading-color fs-18">Course summary </h2> </div> </div></div></div></div></div> <div class="fullwidth" > <div class="vc_row wpb_row vc_row-fluid mg-top-30"><div class="wpb_column vc_column_container vc_col-sm-12"><div class="vc_column-inner"><div class="wpb_wrapper"> <div class="wpb_text_column wpb_content_element content-icon-list" > <div class="wpb_wrapper"> <p> Admission started for Batch 1. The course is designed to provide how to execute core SQL commands to define, select, manipulate, control access, aggregate and join data and data tables. Understand when and how to use subqueries, several window functions, as well as partitions to complete complex tasks. Clean data, optimize SQL queries, and write select advanced JOINs to enhance analysis performance. Explain which cases you would want to use particular SQL commands, and apply the results from queries to address business problems. </p> </div> </div> </div></div></div></div></div> <div class="fullwidth" > <div class="vc_row wpb_row vc_row-fluid mg-top-30"><div class="wpb_column vc_column_container vc_col-sm-12"><div class="vc_column-inner"><div class="wpb_wrapper"> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <h4 class="lesson-title"> <a href="javascript:;" data-id="lesson_content_5eab1f56ac59b"> Program Guidelines <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"> <!--pre-signed url for s3 bucket--> <a href="https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/publisher/assignment_guidelines/99f08000a1f579341185ff2d06e3d428.pdf?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=60&X-Amz-Signature=1c14bee57b97cca02b3891cfc9da130229f1174b2dea8d0c3412af784c979fdc" target="_blank">Download Now</a> </span> </div> </h4> </div> </div></div></div></div></div> </div> <div class="fullwidth" ><div class="vc_row wpb_row vc_row-fluid mg-top-30"><div class="wpb_column vc_column_container vc_col-sm-12"><div class="vc_column-inner"><div class="wpb_wrapper"> <div class="heading color-dark text-left " > <h2 class="heading-color fs-18"> TOPIC LISTS - </h2> </div> </div></div></div></div></div> <div class="fullwidth" > <div class="vc_row wpb_row vc_row-fluid mg-top-30"><div class="wpb_column vc_column_container vc_col-sm-12"><div class="vc_column-inner"><div class="wpb_wrapper"> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_1"> 1 Faculty and Course Introduction <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/983" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_1"> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_2"> 2 Unit 1 - Fundamentals of Database <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/984" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_2"> <div class="panel-group" id="accordion1" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading1"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion1" href="#collapse1" aria-expanded="true" aria-controls="collapse1"> Unit 1.1 - Introduction to DBMS </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/985" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse1" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading1"> </div> </div> </div> <div class="panel-group" id="accordion2" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading2"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion2" href="#collapse2" aria-expanded="true" aria-controls="collapse2"> Unit 1.2 - Applications of DBMS </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/986" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse2" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading2"> </div> </div> </div> <div class="panel-group" id="accordion3" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading3"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion3" href="#collapse3" aria-expanded="true" aria-controls="collapse3"> Unit 1.3 - Advantages & Disadvantages of DBMS </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/987" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse3" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading3"> </div> </div> </div> <div class="panel-group" id="accordion4" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading4"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion4" href="#collapse4" aria-expanded="true" aria-controls="collapse4"> Unit 1.4 - Properties of DBMS ACID Property </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/988" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse4" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading4"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_3"> 3 Unit 2 - Install and Run <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/989" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_3"> <div class="panel-group" id="accordion5" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading5"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion5" href="#collapse5" aria-expanded="true" aria-controls="collapse5"> Unit 2.1 - Installation of Mysql </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/990" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse5" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading5"> </div> </div> </div> <div class="panel-group" id="accordion6" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading6"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion6" href="#collapse6" aria-expanded="true" aria-controls="collapse6"> Unit 2.1 - MySQL Launch & Run sample scripts </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/991" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse6" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading6"> </div> </div> </div> <div class="panel-group" id="accordion7" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading7"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion7" href="#collapse7" aria-expanded="true" aria-controls="collapse7"> Unit 2.2 - Quiz </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/992" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse7" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading7"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_4"> 4 Unit 3 - DDL <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/993" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_4"> <div class="panel-group" id="accordion8" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading8"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion8" href="#collapse8" aria-expanded="true" aria-controls="collapse8"> Unit 3.1- SQL Commands : Create & Insert </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/995" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse8" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading8"> </div> </div> </div> <div class="panel-group" id="accordion9" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading9"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion9" href="#collapse9" aria-expanded="true" aria-controls="collapse9"> Unit 3.2 - Quiz </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/996" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse9" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading9"> </div> </div> </div> <div class="panel-group" id="accordion10" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading10"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion10" href="#collapse10" aria-expanded="true" aria-controls="collapse10"> Unit 3.3- SQL Commands: Drop & Alter </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/997" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse10" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading10"> </div> </div> </div> <div class="panel-group" id="accordion11" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading11"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion11" href="#collapse11" aria-expanded="true" aria-controls="collapse11"> Unit 3.4 - Quiz </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/999" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse11" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading11"> </div> </div> </div> <div class="panel-group" id="accordion12" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading12"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion12" href="#collapse12" aria-expanded="true" aria-controls="collapse12"> Unit 3.5 - SQL Commands: Delete & Update </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1000" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse12" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading12"> </div> </div> </div> <div class="panel-group" id="accordion13" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading13"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion13" href="#collapse13" aria-expanded="true" aria-controls="collapse13"> Unit 3.6 - Quiz </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1002" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse13" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading13"> </div> </div> </div> <div class="panel-group" id="accordion14" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading14"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion14" href="#collapse14" aria-expanded="true" aria-controls="collapse14"> Unit 3.3.2 - Case Study: Drop & Alter </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/998" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse14" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading14"> </div> </div> </div> <div class="panel-group" id="accordion15" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading15"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion15" href="#collapse15" aria-expanded="true" aria-controls="collapse15"> Unit 3.5.2 - Case Study: Delete & Update </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1001" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse15" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading15"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_5"> 5 Unit 4 - DML <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1003" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_5"> <div class="panel-group" id="accordion16" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading16"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion16" href="#collapse16" aria-expanded="true" aria-controls="collapse16"> Unit 4.1- SQL Commands: Select with Where Clause </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1004" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse16" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading16"> </div> </div> </div> <div class="panel-group" id="accordion17" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading17"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion17" href="#collapse17" aria-expanded="true" aria-controls="collapse17"> Unit 4.2 - Assignment Design a DB for Retail Store </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1006" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse17" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading17"> </div> </div> </div> <div class="panel-group" id="accordion18" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading18"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion18" href="#collapse18" aria-expanded="true" aria-controls="collapse18"> Unit 4.1.2 - Case Study: Select with Where Clause </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1005" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse18" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading18"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_6"> 6 Unit 5 - Data Analysis with SQL <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1007" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_6"> <div class="panel-group" id="accordion19" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading19"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion19" href="#collapse19" aria-expanded="true" aria-controls="collapse19"> Unit 5.1 - SQL Commands: Create a DB and Select with Where Clause on Retail Database </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1008" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse19" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading19"> </div> </div> </div> <div class="panel-group" id="accordion20" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading20"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion20" href="#collapse20" aria-expanded="true" aria-controls="collapse20"> Unit 5.2 - SQL Commands: Select with Groupby and nested query </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1015" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse20" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading20"> </div> </div> </div> <div class="panel-group" id="accordion21" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading21"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion21" href="#collapse21" aria-expanded="true" aria-controls="collapse21"> Unit 5.3 - Select with Condition & Order by nested query </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1018" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse21" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading21"> </div> </div> </div> <div class="panel-group" id="accordion22" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading22"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion22" href="#collapse22" aria-expanded="true" aria-controls="collapse22"> Unit 5.4 - SQL Commands: Joins Operations </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1019" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse22" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading22"> </div> </div> </div> <div class="panel-group" id="accordion23" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading23"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion23" href="#collapse23" aria-expanded="true" aria-controls="collapse23"> Unit 5.1.1.a - Case Study: Create a DB and Select with Where Clause on Retail Database </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1009" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse23" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading23"> </div> </div> </div> <div class="panel-group" id="accordion24" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading24"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion24" href="#collapse24" aria-expanded="true" aria-controls="collapse24"> Unit 5.1.1.b - Case Study: Create a DB and Select with Where Clause on Retail Database </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1010" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse24" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading24"> </div> </div> </div> <div class="panel-group" id="accordion25" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading25"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion25" href="#collapse25" aria-expanded="true" aria-controls="collapse25"> Unit 5.1.2 - Case Study Select Command </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1011" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse25" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading25"> </div> </div> </div> <div class="panel-group" id="accordion26" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading26"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion26" href="#collapse26" aria-expanded="true" aria-controls="collapse26"> Unit 5.1.2.a - Select_video_Edited Case Study </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1012" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse26" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading26"> </div> </div> </div> <div class="panel-group" id="accordion27" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading27"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion27" href="#collapse27" aria-expanded="true" aria-controls="collapse27"> Unit 5.1.3 - Create A Db And Select With Where Clause On Retail Database Part A </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1013" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse27" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading27"> </div> </div> </div> <div class="panel-group" id="accordion28" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading28"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion28" href="#collapse28" aria-expanded="true" aria-controls="collapse28"> Unit 5.1.3.a - Create A Db And Select With Where Clause On Retail Database Part B </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1014" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse28" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading28"> </div> </div> </div> <div class="panel-group" id="accordion29" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading29"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion29" href="#collapse29" aria-expanded="true" aria-controls="collapse29"> Unit 5.2.1.a - Case Study: Select with Groupby and nested query </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1016" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse29" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading29"> </div> </div> </div> <div class="panel-group" id="accordion30" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading30"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion30" href="#collapse30" aria-expanded="true" aria-controls="collapse30"> Unit 5.3.1 - SQL Commands: Select with Condition & Order by nested query </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1017" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse30" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading30"> </div> </div> </div> <div class="panel-group" id="accordion31" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading31"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion31" href="#collapse31" aria-expanded="true" aria-controls="collapse31"> Unit 5.4.2 - SQL Commands: Joins Operations Part 2 </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1020" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse31" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading31"> </div> </div> </div> <div class="panel-group" id="accordion32" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading32"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion32" href="#collapse32" aria-expanded="true" aria-controls="collapse32"> Unit 5.4.3 - SQL Commands: Joins Operations Part 3 </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1021" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse32" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading32"> </div> </div> </div> <div class="panel-group" id="accordion33" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading33"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion33" href="#collapse33" aria-expanded="true" aria-controls="collapse33"> Unit 5.4.4 - SQL Commands: Joins Operations Part 4 </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1022" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse33" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading33"> </div> </div> </div> <div class="panel-group" id="accordion34" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading34"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion34" href="#collapse34" aria-expanded="true" aria-controls="collapse34"> Unit 5.4.5 - SQL Commands: Joins Operations Part 5 </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1023" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse34" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading34"> </div> </div> </div> <div class="panel-group" id="accordion35" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading35"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion35" href="#collapse35" aria-expanded="true" aria-controls="collapse35"> Unit 5.4.5.a - Case Study 1 Railway Reservation Part 1 </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1024" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse35" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading35"> </div> </div> </div> <div class="panel-group" id="accordion36" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading36"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion36" href="#collapse36" aria-expanded="true" aria-controls="collapse36"> Unit 5.4.5.b - Case Study 1 Railway Reservation Part 2 </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1025" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse36" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading36"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_7"> 7 Unit 6 - Data Analysis with SQL on Hands-on <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1026" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_7"> <div class="panel-group" id="accordion37" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading37"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion37" href="#collapse37" aria-expanded="true" aria-controls="collapse37"> Unit 6.1 - Assignment: Basic Analysis on Sakila Database </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1027" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse37" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading37"> </div> </div> </div> <div class="panel-group" id="accordion38" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading38"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion38" href="#collapse38" aria-expanded="true" aria-controls="collapse38"> Unit 6.2 - Assignment: Advance Analysis on Dataset </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1028" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse38" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading38"> </div> </div> </div> <div class="panel-group" id="accordion39" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading39"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion39" href="#collapse39" aria-expanded="true" aria-controls="collapse39"> Unit 6.3 - Project: Connect and Build own Database for Infrastructure Company </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1029" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse39" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading39"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_8"> 8 Unit 7 - Power BI <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1126" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_8"> <div class="panel-group" id="accordion40" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading40"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion40" href="#collapse40" aria-expanded="true" aria-controls="collapse40"> Unit 7.1 - Installation </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1127" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse40" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading40"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_9"> 9 Unit 8 - Data Visualization <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1128" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_9"> <div class="panel-group" id="accordion41" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading41"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion41" href="#collapse41" aria-expanded="true" aria-controls="collapse41"> Unit 8.1 - Basic Visualization – Graphs and Tables </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1129" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse41" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading41"> </div> </div> </div> </div> </div> </div> </div></div></div></div></div> </div> </div> </div> </div> </div> </div> </div> <div class="site-meta-single-product col-md-4"> <div class="summary-product entry-summary"> <div class="meta" style="margin-bottom: 20px;"> <!-- <span class="lb" style="background: #ffbd33;">Language</span> --> <button class=" alt" style="width: 100%; border: none; padding: 0 2%; min-height: 65px;background: #ffbd33; display: flex; justify-content: center; align-items: center;"> <select style="color:#fff ; background: #ffbd33; width: 100%; border: none;" class="" onchange="window.location='https://uatdigipaathshala.cscacademy.org/lmscourses/coursedetails/' + this.value;"> <option selected value="">Select Language</option> </select> <i class="fa fa-caret-down" style="color: white;"></i> </button> <!-- <span class="if" style="padding: 0 ; display: flex; align-items: center; background: #ffbd33;"> <i class="fa fa-caret-down"></i> </span> --> </div> <div class="meta"> <span class="lb p-bg-dark">Duration</span> <span class="if p-bg">60 Days</span> </div> <div class="meta"> <span class="lb p-bg-dark">Price</span> <span class="if p-bg"><span class="woocommerce-Price-amount amount"> <span class="woocommerce-Price-currencySymbol">₹ </span>2596 /- <span style="font-size:9px;">(Inc. All Taxes)</span></span></span> </div> <div style="clear: both"></div> <div class="widget"style="margin-bottom: 0;"> <h4 class="widget-title text-center"><span>ABOUT PUBLISHER</span></h4> <div class="location-map"> <div class="instructor text-center"> <!--pre-signed url for s3 bucket--> <img src="https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/publisher/publisherphoto/6f6c3d54c80bdc757f28c1b89e3910e7.jpg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2&X-Amz-Signature=1959b79a821a3c8e7634dd260688c5a3ba1991c6383db47ad70aa19786cf2fd7" style="width: 167px;height: 88px;"> <div class="info"> <div class="name"><h4 class="p-font"><a href="" target="_blank">CSC ACADEMY AND BTA</a></h4> </div> <div class="phone" style="text-align:left;"> <p> CSC Academy is a publicly invested learning institution that provides access to professional e-learning for learners of diverse backgrounds and educational needs. The Academy is committed to teaching, delivering of specialized courses/ training programmes and ensuring ubiquitous reach of training services and community development programmes including social justice (health, housing, education, financial services, etc.), leadership, communication skills and promotion of entrepreneurship across India. It is known as a premier institution promoting ethical leadership, entrepreneurship and social inclusion as its fundamental principle.&nbsp; The Boston Training Academy (BTA) is a cutting- edge technology solutions provider, operating via a global network of reseller partners. Originating from a high performance, mission-critical server and storage solutions background, Boston now offers training and consultancy to make technology easily available to everyone BTA offers structured and highly customizable courses backed by world-class infrastructure, tools and techniques and delivered by global experts. BTA also offers further consulting services for Artificial Intelligence, Data Science and broader technology related topics. </p> </div> </div> </div></div></div> <div class="enroll-wrap"> <div class="quantity hidden"> </div> <!-- check with auth for free course --> <a href="javascript:void(0)" style="width:100%;" data-search-type="standard"><button type="submit" name="add-to-cart" courseid="85" class="single_add_to_cart_button button alt buy_now" style="width: 100%;font-size: 16px; padding-top: 18px; padding-bottom: 18px; background-color:#ffbd33; text-transform: uppercase;font-weight: 400;letter-spacing: 1px;" >Subscribe Now</button></a> </div> <aside id="g5plus-course-related-2" class="widget widget-course woocommerce"> <h4 class="widget-title"><span>Related Course</span></h4> <div class="widget-content"> <div class="product-listing woocommerce clearfix columns-4"> <div class="course-item-wrap"> <div class="course-thumb"> <img src="https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/courseimage/1923afb314f9e0e6d7c74dcc3c3d619f.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2&X-Amz-Signature=8068e60a1dab50c23ffe0c1e52600614f1d3e365023c4f4f416c913b99167d03" alt="CSC Bal Vidyalaya Educator Foundation Training " width="200" /> </div> <div class="course-info"> <a class="fs-14 fw-medium course-title p-color-hover" href="https://uatdigipaathshala.cscacademy.org/lmscourses/coursedetails/16">CSC Bal Vidyalaya Educator Foundation Training </a> <span><i class="fa fa-user p-color pd-right-10"></i>By : CSC Academy</span> <span><i class="fa fa-calendar p-color pd-right-10"></i>Duration : 30 Days</span> <span > <a href="https://uatdigipaathshala.cscacademy.org/lmscourses/coursedetails/16" class="bt bt-xs bt-bg bt-secondary">Learn Now</a> </span> </div> </div> </div> </div> </aside> </div></div> </div> </div> </main> </div> <!-- Send data for enrollment through API --> <script> $.noConflict(); jQuery(document).ready(function($){ $(".enroll_now").click(function(evt){ var CourseId = $(this).attr("courseid"); $.ajax({//Make the Ajax Request beforeSend:function(){ $('#loader').show(); }, type: "POST", url: "https://uatdigipaathshala.cscacademy.org/admin/lmscourses/enrollstd", data:"courseId="+CourseId, success: function(data){//html = the server response html code $('#loadingmessage').hide(); //store data $error = JSON.parse(data).error; $message = JSON.parse(data).message; //show modal box $("#showenrollmentModal").modal('show'); if($error =='1') { $('#showenrolledalert').html('<div style="text-align: center;">'+$message+'<br><br><a href="https://uatdigipaathshala.cscacademy.org/student"><button type="button" class="btn-sm btn-primary">Login Now</button></a></div>'); } else { $('#showenrolledalert').html('<div style="text-align: center;">'+$message+'<br><br><a href="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/mycourses"><button type="button" class="btn-sm btn-primary">My Course</button></a></div>'); } }, error:function(){ alert("Internal Error Server Not found!");} }); }); // Check restricted course for restricted categories $(".restricted_std").click(function(evt){ var CourseId = $(this).attr("courseid"); $.ajax({//Make the Ajax Request beforeSend:function(){ $('#loader').show(); }, type: "POST", url: "https://uatdigipaathshala.cscacademy.org/admin/lmscourses/restrictedstd", data:"courseId="+CourseId, success: function(data){//html = the server response html code $('#loadingmessage').hide(); //store data $error = JSON.parse(data).error; $message = JSON.parse(data).message; //show modal box $("#showenrollmentModal").modal('show'); if($error =='1') { $('#showenrolledalert').html('<div style="text-align: center;">'+$message+'<br><br><a href="https://uatdigipaathshala.cscacademy.org/student"><button type="button" class="btn-sm btn-primary">Login Now</button></a></div>'); } else { $('#showenrolledalert').html('<div style="text-align: center;">'+$message+'<br><br><a href="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/mycourses"><button type="button" class="btn-sm btn-primary">My Course</button></a></div>'); } }, error:function(){ alert("Internal Error Server Not found!");} }); }); // SHOW BUY NOW POP UP $(".buy_now").click(function(evt){ var CourseId = $(this).attr("courseid"); $.ajax({//Make the Ajax Request beforeSend:function(){ $('#loadingmessage').show(); }, type: "POST", url: "https://uatdigipaathshala.cscacademy.org/admin/lmscourses/bUyNowstd", data:"courseId="+CourseId, success: function(data){//html = the server response html code $('#loadingmessage').hide(); //store data $error = JSON.parse(data).error; $message = JSON.parse(data).message; if($error =='1') { //show modal box $("#showenrollmentModal").modal('show'); $('#showenrolledalert').html('<div style="text-align: center;">'+$message+'<br><br><a href="https://uatdigipaathshala.cscacademy.org/student"><button type="button" class="btn-sm btn-primary">Login Now</button></a></div>'); } else if($error =='5' || $error =='6' || $error =='7') { $Courseid = JSON.parse(data).CourseId; //check if course CCA Course to upload 10th certificate before proceeding payment. if($Courseid == '2') { $("#uploadcertificateModal").modal('show'); $("#UploadCourseIds").val($Courseid); $('#uploadmessage').html('Please Upload 10th certificate first!!'); } else if($Courseid == '74' || $Courseid == '77') { $("#uploadcertificateModal").modal('show'); $("#UploadCourseIds").val($Courseid); $('#uploadmessage').html('Please Upload 12th certificate first!!'); } else { //show payment gateways window if($error =='5') { $("#pgModal").modal('show'); $("#PGCourseIds").val($Courseid); } else if($error =='7') { $("#hdfcModal").modal('show'); $("#HDFCCourseIds").val($Courseid); } else if($error =='6') { $("#buynowModal").modal('show'); $("#CourseIds").val($Courseid); } else { alert('Something went wrong into PG!!'); return false(); } } } else { //show modal box $("#showenrollmentModal").modal('show'); $('#showenrolledalert').html('<div style="text-align: center;">'+$message+'<br><br><a href="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/mycourses"><button type="button" class="btn-sm btn-primary">My Course</button></a></div>'); } }, error:function(){ alert("Internal Error Server Not found!");} }); }); // Upload 10th certificate through ajax $("#upload10certificateform").on('submit',(function(e) { //check file size first!! var file_size = $('#10certificate')[0].files[0].size; if(file_size>2097152) { alert("File size is greater than 2MB, please upload again!!"); return false; } e.preventDefault(); $.ajax({ beforeSend:function(){ $("#uploadcertificateModal").modal('hide'); $('#loadingmessage').show(); }, url: "https://uatdigipaathshala.cscacademy.org/admin/lmscourses/upload10certificate", type: "POST", data: new FormData(this), contentType: false, cache: false, processData:false, success: function(data) { if(JSON.parse(data).error =='4') { $("#uploadcertificateModal").modal('hide'); $("#buynowModal").modal('show'); $("#CourseIds").val($Courseid); $("#UploadCertificateFile").val(JSON.parse(data).UploadCertificateFile); } else { alert(JSON.parse(data).message); } }, error: function(e) { $("#err").html(e).fadeIn(); } }); })); //check CSCID is associated with cscacademy centre or not $("#paynowcscid").click(function(evt){ var cscID = $('#cscID').val(); var courseid = "85"; var vedic_math_medium = "<pre class="cake-error"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr67efab4f3c7b1-trace').style.display = (document.getElementById('cakeErr67efab4f3c7b1-trace').style.display == 'none' ? '' : 'none');"><b>Notice</b> (8)</a>: Undefined variable: auth_user [<b>APP/View/Lmscourses/coursedetails.ctp</b>, line <b>774</b>]<div id="cakeErr67efab4f3c7b1-trace" class="cake-stack-trace" style="display: none;"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr67efab4f3c7b1-code').style.display = (document.getElementById('cakeErr67efab4f3c7b1-code').style.display == 'none' ? '' : 'none')">Code</a> <a href="javascript:void(0);" onclick="document.getElementById('cakeErr67efab4f3c7b1-context').style.display = (document.getElementById('cakeErr67efab4f3c7b1-context').style.display == 'none' ? '' : 'none')">Context</a><pre id="cakeErr67efab4f3c7b1-code" class="cake-code-dump" style="display: none;"><code><span style="color: #000000"> ob_start();</span></code> <code><span style="color: #000000"></span></code> <span class="code-highlight"><code><span style="color: #000000"> include $___viewFn;</span></code></span></pre><pre id="cakeErr67efab4f3c7b1-context" class="cake-context" style="display: none;">$___viewFn = '/data/uat/app/View/Lmscourses/coursedetails.ctp' $___dataForView = array( 'record' => array( [maximum depth reached] ), 'lmstopics' => array( [maximum depth reached] ), 'relatedcourses' => array( [maximum depth reached] ), 'check_exist' => false, 'languages' => array([maximum depth reached]), 'LastLogin' => array([maximum depth reached]), 's3' => object(Aws\S3\S3Client) {}, 'inputDefaults' => array( [maximum depth reached] ), 'csrfToken' => '6a24002bd597101fd9a60b7eb5250eadb0437194266019a21f1c33d4a70f7eb1' ) $record = array( 'Lmsuser' => array( [maximum depth reached] ), 'Lmscourse' => array( [maximum depth reached] ) ) $lmstopics = array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ), (int) 2 => array( [maximum depth reached] ), (int) 3 => array( [maximum depth reached] ), (int) 4 => array( [maximum depth reached] ), (int) 5 => array( [maximum depth reached] ), (int) 6 => array( [maximum depth reached] ), (int) 7 => array( [maximum depth reached] ), (int) 8 => array( [maximum depth reached] ) ) $relatedcourses = array( (int) 0 => array( [maximum depth reached] ) ) $check_exist = false $languages = array() $LastLogin = array() $s3 = object(Aws\S3\S3Client) {} $inputDefaults = array( 'inputDefaults' => array( [maximum depth reached] ) ) $csrfToken = '6a24002bd597101fd9a60b7eb5250eadb0437194266019a21f1c33d4a70f7eb1' $cmd = object(Aws\Command) {} $request = object(GuzzleHttp\Psr7\Request) {} $presignedUrl = 'https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/courseimage/1923afb314f9e0e6d7c74dcc3c3d619f.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2&X-Amz-Signature=8068e60a1dab50c23ffe0c1e52600614f1d3e365023c4f4f416c913b99167d03' $count = (int) 9 $count2 = (int) 41 $count3 = (int) 0 $lmstopic = array( 'Lmstopic' => array( [maximum depth reached] ), 'children' => array( [maximum depth reached] ) ) $children = array( 'Lmstopic' => array( [maximum depth reached] ), 'children' => array([maximum depth reached]) ) $relatedcourse = array( 'Lmscourse' => array( [maximum depth reached] ) )</pre><pre class="stack-trace">include - APP/View/Lmscourses/coursedetails.ctp, line 774 View::_evaluate() - CORE/Cake/View/View.php, line 915 View::_render() - CORE/Cake/View/View.php, line 879 View::render() - CORE/Cake/View/View.php, line 470 Controller::render() - CORE/Cake/Controller/Controller.php, line 959 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 110 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 85 [main] - APP/webroot/index.php, line 96</pre></div></pre>"; var csrfToken = "6a24002bd597101fd9a60b7eb5250eadb0437194266019a21f1c33d4a70f7eb1"; // alert(courseid); $.ajax({//Make the Ajax Request beforeSend:function(){ $("#buynowModal").modal('hide'); $('#loadingmessage').show(); }, type: "POST", url: "https://uatdigipaathshala.cscacademy.org/admin/users/checkCscacademyonboarding", // data:"cscID="+cscID+"course_id="+courseid, data:{cscID:cscID,courseid:courseid,vedic_math_medium:vedic_math_medium,csrfToken:csrfToken}, success: function(data){//html = the server response html code $('#loadingmessage').hide(); if(JSON.parse(data).count =='1') { document.paymentproceed.submit(); } else if(JSON.parse(data).count =='2') { document.paymentproceed.submit(); } else if(JSON.parse(data).count =='3') { alert('Oops!! Seats are full please try in another batch.'); } else if(JSON.parse(data).count =='4') { alert('Oops!! Payments are closed now for this course.'); } else if(JSON.parse(data).count =='5') { document.paymentproceed.submit(); } else if(JSON.parse(data).count =='6') { alert('Kindly register with Spoken Tutorial(Plan 1- All Courses) to Enroll students in This Course'); } else { $("#buynowModal").modal('show'); alert('This course is not active for this VLE!!'); } }, error:function(){ alert("Internal Error Server Not found!");} }); }); $("#pgmethod").click(function(evt){ var pgmethod = $('input[name="payment_gateway"]:checked').val(); if(pgmethod ==2) { $("#pgModal").modal('hide'); $("#buynowModal").modal('show'); $("#CourseIds").val($Courseid); } else if(pgmethod ==3) { $("#pgModal").modal('hide'); $("#hdfcModal").modal('show'); $("#HDFCCourseIds").val($Courseid); } else { alert('Error due to network!!'); return false(); } }); }); </script> ', 'scripts_for_layout' => '', 'title_for_layout' => 'Lmscourses' ) $record = array( 'Lmsuser' => array( [maximum depth reached] ), 'Lmscourse' => array( [maximum depth reached] ) ) $lmstopics = array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ), (int) 2 => array( [maximum depth reached] ), (int) 3 => array( [maximum depth reached] ), (int) 4 => array( [maximum depth reached] ), (int) 5 => array( [maximum depth reached] ), (int) 6 => array( [maximum depth reached] ), (int) 7 => array( [maximum depth reached] ), (int) 8 => array( [maximum depth reached] ) ) $relatedcourses = array( (int) 0 => array( [maximum depth reached] ) ) $check_exist = false $languages = array() $LastLogin = array() $s3 = object(Aws\S3\S3Client) {} $inputDefaults = array( 'inputDefaults' => array( [maximum depth reached] ) ) $csrfToken = '6a24002bd597101fd9a60b7eb5250eadb0437194266019a21f1c33d4a70f7eb1' $content_for_layout = '<script type="text/javascript" src="/js/jquery-min.js"></script> <style> .loadingmessage { position: fixed; left: 0px; top: 0px; width: 100%; height: 100%; z-index: 9999; background: url('https://uatdigipaathshala.cscacademy.org/gradient-design/img/loading.gif') 50% 50% no-repeat rgb(249,249,249); opacity: .8; } </style> <!-- Show buy now dialog box to proceed payment --> <!-- Start this modal box for show alert for enrollment --> <div id="buynowModal" class="modal fade" style="padding-top:6%;"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title" style="text-align:center;">Please Enter CSC ID</h4> </div> <div class="modal-body"> <form method="post" action="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/paycscwallet" name="paymentproceed" class="search-popup-inner" style="text-align:center;"> <input type="hidden" name="CourseIds" id="CourseIds" value="" /> <input type="hidden" name="UploadCertificateFile" id="UploadCertificateFile" value="" /> <div> <input type="text" name="cscid" placeholder="CSC ID" maxlength="12" id="cscID" oninput="this.value = this.value.replace(/[^0-9.]/g, '').replace(/(\..*)\./g, '$1');"> </div> <div style="padding-top:6%;"><button type="button" id="paynowcscid" class="bt bt-xs bt-bg bt-secondary inline">Pay Now</button></div> </form> </div> </div> </div> </div> <!-- End dialog box --> <!-- Start this modal box for show alert for All payment gateways --> <div id="pgModal" class="modal fade" style="padding-top:6%;"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title" style="text-align:center;">Please Select Payment Gateway</h4> </div> <div class="modal-body"> <form method="post" action="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/" name="pgselected" class="search-popup-inner" style="text-align:center;"> <input type="hidden" name="CourseIds" id="PGCourseIds" value="" /> <div> <input type="radio" name="payment_gateway" id="pgmethod_value" value="2" > CSC Wallet <input type="radio" name="payment_gateway" value="3" id="pgmethod_value" style="margin-left: 10px;"> HDFC </div> <div style="padding-top:6%;"><button type="button" id="pgmethod" class="bt bt-xs bt-bg bt-secondary inline">Proceed Now</button></div> </form> </div> </div> </div> </div> <div id="hdfcModal" class="modal fade" style="padding-top:6%;"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title" style="text-align:center;">Please Select Payment Gateway</h4> </div> <div class="modal-body"> <form method="post" action="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/payhdfc" name="hdfcselected" class="search-popup-inner" style="text-align:center;"> <input type="hidden" name="CourseIds" id="HDFCCourseIds" value="" /> <div> <input type="radio" name="payment_gateway" required="required" value="3" style="margin-left: 10px;"> <img src="https://uatdigipaathshala.cscacademy.org//images/hdfclogo.png" width="115" height="50"> </div> <div style="padding-top:6%;"><button type="submit" id="payhdfconly" class="bt bt-xs bt-bg bt-secondary inline">Proceed Now</button></div> </form> </div> </div> </div> </div> <!-- End dialog box --> <!-- Start this modal box for show upload 10th certificate before payment --> <div id="uploadcertificateModal" class="modal fade" style="padding-top:6%;"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title" id="uploadmessage" style="text-align:center;"></h4> </div> <div class="modal-body"> <form id="upload10certificateform" method="post" action="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/uploadcertificate" class="search-popup-inner" enctype="multipart/form-data" style="text-align:center;"> <input type="hidden" name="CourseIds" id="UploadCourseIds" value="" /> <div> <input type="file" name="upload10certificate" placeholder="Upload 10th Certificate" accept="image/*" id="10certificate" required="required"> <br> <span>File size should be max 1 MB and format JPEG/PNG</span> </div> <div style="padding-top:6%;"><button type="submit" class="bt bt-xs bt-bg bt-secondary inline">Upload</button></div> </form> </div> </div> </div> </div> <!-- End dialog box --> <!-- Start this modal box for show alert for enrollment --> <div id="showenrollmentModal" class="modal fade" style="padding-top:5%;"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title"></h4> </div> <div class="modal-body"> <div id="showenrolledalert"></div> </div> </div> </div> </div> <!-- End this modal box for show alert for enrollment --> <!-- Show loader --> <div id='loadingmessage' class="loadingmessage" style='display:none'> </div> <!-- End loader --> <div id="wrapper-content" class="clearfix"> <section id="page-title" class="single-product-title-wrap single-product-title-margin" > <div data-stellar-background-image="https://uatdigipaathshala.cscacademy.org/lmsfront_layout/img/coursedetails.jpg" data-stellar-background-position="top" data-stellar-background-ratio="0.5" class="page-title-parallax" style="background-image: url('https://uatdigipaathshala.cscacademy.org/lmsfront_layout/img/coursedetails.jpg');background-position:center top;"></div> <div class="container"> <div class="single-product-title-inner pt-bottom" > <div class="m-title"> <h2 class="p-font">COURSE DETAILS</h2> </div> <div class="breadcrumbs-wrap"> <div class="breadcrumbs-inner text-left"> <ul class="breadcrumbs"><li><a href="" class="home"><i class="fa fa-home"></i></a></li><li><a href="#"> Data Analysis with SQL and Power BI </a></li><li></li></ul> </div> </div> </div> </div> </section> <main class="single-product-wrap has-sidebar"> <div class="container clearfix"> <div class="row clearfix"> <div class="col-md-12"><h4 itemprop="name" class="product_title p-font hd-block"> Data Analysis with SQL and Power BI </h4> </div> <div class="site-content-single-product col-md-8"> <div class="single-product-inner"> <div class="woocommerce-notices-wrapper"></div> <div id="product-468" class="product type-product post-468 status-publish first instock product_cat-business-management product_cat-law-economic has-post-thumbnail featured shipping-taxable purchasable product-type-simple"> <div class="row single-product-info clearfix"> <div class="col-md-12 col-sm-12 col-xs-12"> <div class="single-product-image"> <div class="product-flash-wrap"> <span class="on-new product-flash">Premium</span> </div> <div id="single-product-image" class="single-product-image-inner horizontal"> <div class="product-image-slider-wrap"> <div class="product-image-slider"> <div> <!--pre-signed url for s3 bucket--> <a href="https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/courseimage/ff30a605a693ff195c66269a62e02ee1.jpg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2&X-Amz-Signature=9c6acd8afcb27059c0b647f0300da3ff17d3f76503717703e0b9be8bfbde6bd5" itemprop="image" class="woocommerce-main-image" title="" data-rel="prettyPhoto[product-gallery]" data-index="0"><img style="width:768px; height:500px;" src="https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/courseimage/ff30a605a693ff195c66269a62e02ee1.jpg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2&X-Amz-Signature=9c6acd8afcb27059c0b647f0300da3ff17d3f76503717703e0b9be8bfbde6bd5" class="attachment-shop_single size-shop_single" alt="" srcset="https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/courseimage/ff30a605a693ff195c66269a62e02ee1.jpg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2&X-Amz-Signature=9c6acd8afcb27059c0b647f0300da3ff17d3f76503717703e0b9be8bfbde6bd5" /></a></div></div> </div> </div> <script type="text/javascript"> (function ($) { "use strict"; $(document).ready(function () { var $productImageWrap = $('#single-product-image'); G5Plus.woocommerce.singleProductImage($productImageWrap); }); })(jQuery); </script> </div> <div class="instructor-wrap"> </div> <div class="lesson-list margin-top-70"> <div id="tab-description"> <div class="fullwidth" > <div class="vc_row wpb_row vc_row-fluid mg-top-30"><div class="wpb_column vc_column_container vc_col-sm-12"><div class="vc_column-inner"><div class="wpb_wrapper"> <div class="heading color-dark text-left " > <h2 class="heading-color fs-18">Course summary </h2> </div> </div></div></div></div></div> <div class="fullwidth" > <div class="vc_row wpb_row vc_row-fluid mg-top-30"><div class="wpb_column vc_column_container vc_col-sm-12"><div class="vc_column-inner"><div class="wpb_wrapper"> <div class="wpb_text_column wpb_content_element content-icon-list" > <div class="wpb_wrapper"> <p> Admission started for Batch 1. The course is designed to provide how to execute core SQL commands to define, select, manipulate, control access, aggregate and join data and data tables. Understand when and how to use subqueries, several window functions, as well as partitions to complete complex tasks. Clean data, optimize SQL queries, and write select advanced JOINs to enhance analysis performance. Explain which cases you would want to use particular SQL commands, and apply the results from queries to address business problems. </p> </div> </div> </div></div></div></div></div> <div class="fullwidth" > <div class="vc_row wpb_row vc_row-fluid mg-top-30"><div class="wpb_column vc_column_container vc_col-sm-12"><div class="vc_column-inner"><div class="wpb_wrapper"> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <h4 class="lesson-title"> <a href="javascript:;" data-id="lesson_content_5eab1f56ac59b"> Program Guidelines <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"> <!--pre-signed url for s3 bucket--> <a href="https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/publisher/assignment_guidelines/99f08000a1f579341185ff2d06e3d428.pdf?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=60&X-Amz-Signature=1c14bee57b97cca02b3891cfc9da130229f1174b2dea8d0c3412af784c979fdc" target="_blank">Download Now</a> </span> </div> </h4> </div> </div></div></div></div></div> </div> <div class="fullwidth" ><div class="vc_row wpb_row vc_row-fluid mg-top-30"><div class="wpb_column vc_column_container vc_col-sm-12"><div class="vc_column-inner"><div class="wpb_wrapper"> <div class="heading color-dark text-left " > <h2 class="heading-color fs-18"> TOPIC LISTS - </h2> </div> </div></div></div></div></div> <div class="fullwidth" > <div class="vc_row wpb_row vc_row-fluid mg-top-30"><div class="wpb_column vc_column_container vc_col-sm-12"><div class="vc_column-inner"><div class="wpb_wrapper"> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_1"> 1 Faculty and Course Introduction <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/983" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_1"> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_2"> 2 Unit 1 - Fundamentals of Database <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/984" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_2"> <div class="panel-group" id="accordion1" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading1"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion1" href="#collapse1" aria-expanded="true" aria-controls="collapse1"> Unit 1.1 - Introduction to DBMS </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/985" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse1" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading1"> </div> </div> </div> <div class="panel-group" id="accordion2" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading2"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion2" href="#collapse2" aria-expanded="true" aria-controls="collapse2"> Unit 1.2 - Applications of DBMS </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/986" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse2" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading2"> </div> </div> </div> <div class="panel-group" id="accordion3" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading3"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion3" href="#collapse3" aria-expanded="true" aria-controls="collapse3"> Unit 1.3 - Advantages & Disadvantages of DBMS </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/987" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse3" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading3"> </div> </div> </div> <div class="panel-group" id="accordion4" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading4"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion4" href="#collapse4" aria-expanded="true" aria-controls="collapse4"> Unit 1.4 - Properties of DBMS ACID Property </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/988" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse4" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading4"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_3"> 3 Unit 2 - Install and Run <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/989" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_3"> <div class="panel-group" id="accordion5" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading5"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion5" href="#collapse5" aria-expanded="true" aria-controls="collapse5"> Unit 2.1 - Installation of Mysql </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/990" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse5" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading5"> </div> </div> </div> <div class="panel-group" id="accordion6" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading6"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion6" href="#collapse6" aria-expanded="true" aria-controls="collapse6"> Unit 2.1 - MySQL Launch & Run sample scripts </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/991" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse6" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading6"> </div> </div> </div> <div class="panel-group" id="accordion7" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading7"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion7" href="#collapse7" aria-expanded="true" aria-controls="collapse7"> Unit 2.2 - Quiz </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/992" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse7" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading7"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_4"> 4 Unit 3 - DDL <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/993" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_4"> <div class="panel-group" id="accordion8" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading8"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion8" href="#collapse8" aria-expanded="true" aria-controls="collapse8"> Unit 3.1- SQL Commands : Create & Insert </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/995" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse8" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading8"> </div> </div> </div> <div class="panel-group" id="accordion9" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading9"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion9" href="#collapse9" aria-expanded="true" aria-controls="collapse9"> Unit 3.2 - Quiz </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/996" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse9" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading9"> </div> </div> </div> <div class="panel-group" id="accordion10" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading10"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion10" href="#collapse10" aria-expanded="true" aria-controls="collapse10"> Unit 3.3- SQL Commands: Drop & Alter </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/997" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse10" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading10"> </div> </div> </div> <div class="panel-group" id="accordion11" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading11"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion11" href="#collapse11" aria-expanded="true" aria-controls="collapse11"> Unit 3.4 - Quiz </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/999" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse11" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading11"> </div> </div> </div> <div class="panel-group" id="accordion12" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading12"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion12" href="#collapse12" aria-expanded="true" aria-controls="collapse12"> Unit 3.5 - SQL Commands: Delete & Update </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1000" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse12" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading12"> </div> </div> </div> <div class="panel-group" id="accordion13" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading13"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion13" href="#collapse13" aria-expanded="true" aria-controls="collapse13"> Unit 3.6 - Quiz </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1002" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse13" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading13"> </div> </div> </div> <div class="panel-group" id="accordion14" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading14"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion14" href="#collapse14" aria-expanded="true" aria-controls="collapse14"> Unit 3.3.2 - Case Study: Drop & Alter </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/998" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse14" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading14"> </div> </div> </div> <div class="panel-group" id="accordion15" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading15"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion15" href="#collapse15" aria-expanded="true" aria-controls="collapse15"> Unit 3.5.2 - Case Study: Delete & Update </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1001" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse15" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading15"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_5"> 5 Unit 4 - DML <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1003" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_5"> <div class="panel-group" id="accordion16" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading16"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion16" href="#collapse16" aria-expanded="true" aria-controls="collapse16"> Unit 4.1- SQL Commands: Select with Where Clause </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1004" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse16" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading16"> </div> </div> </div> <div class="panel-group" id="accordion17" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading17"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion17" href="#collapse17" aria-expanded="true" aria-controls="collapse17"> Unit 4.2 - Assignment Design a DB for Retail Store </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1006" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse17" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading17"> </div> </div> </div> <div class="panel-group" id="accordion18" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading18"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion18" href="#collapse18" aria-expanded="true" aria-controls="collapse18"> Unit 4.1.2 - Case Study: Select with Where Clause </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1005" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse18" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading18"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_6"> 6 Unit 5 - Data Analysis with SQL <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1007" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_6"> <div class="panel-group" id="accordion19" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading19"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion19" href="#collapse19" aria-expanded="true" aria-controls="collapse19"> Unit 5.1 - SQL Commands: Create a DB and Select with Where Clause on Retail Database </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1008" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse19" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading19"> </div> </div> </div> <div class="panel-group" id="accordion20" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading20"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion20" href="#collapse20" aria-expanded="true" aria-controls="collapse20"> Unit 5.2 - SQL Commands: Select with Groupby and nested query </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1015" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse20" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading20"> </div> </div> </div> <div class="panel-group" id="accordion21" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading21"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion21" href="#collapse21" aria-expanded="true" aria-controls="collapse21"> Unit 5.3 - Select with Condition & Order by nested query </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1018" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse21" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading21"> </div> </div> </div> <div class="panel-group" id="accordion22" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading22"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion22" href="#collapse22" aria-expanded="true" aria-controls="collapse22"> Unit 5.4 - SQL Commands: Joins Operations </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1019" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse22" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading22"> </div> </div> </div> <div class="panel-group" id="accordion23" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading23"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion23" href="#collapse23" aria-expanded="true" aria-controls="collapse23"> Unit 5.1.1.a - Case Study: Create a DB and Select with Where Clause on Retail Database </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1009" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse23" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading23"> </div> </div> </div> <div class="panel-group" id="accordion24" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading24"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion24" href="#collapse24" aria-expanded="true" aria-controls="collapse24"> Unit 5.1.1.b - Case Study: Create a DB and Select with Where Clause on Retail Database </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1010" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse24" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading24"> </div> </div> </div> <div class="panel-group" id="accordion25" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading25"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion25" href="#collapse25" aria-expanded="true" aria-controls="collapse25"> Unit 5.1.2 - Case Study Select Command </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1011" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse25" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading25"> </div> </div> </div> <div class="panel-group" id="accordion26" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading26"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion26" href="#collapse26" aria-expanded="true" aria-controls="collapse26"> Unit 5.1.2.a - Select_video_Edited Case Study </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1012" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse26" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading26"> </div> </div> </div> <div class="panel-group" id="accordion27" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading27"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion27" href="#collapse27" aria-expanded="true" aria-controls="collapse27"> Unit 5.1.3 - Create A Db And Select With Where Clause On Retail Database Part A </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1013" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse27" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading27"> </div> </div> </div> <div class="panel-group" id="accordion28" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading28"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion28" href="#collapse28" aria-expanded="true" aria-controls="collapse28"> Unit 5.1.3.a - Create A Db And Select With Where Clause On Retail Database Part B </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1014" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse28" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading28"> </div> </div> </div> <div class="panel-group" id="accordion29" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading29"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion29" href="#collapse29" aria-expanded="true" aria-controls="collapse29"> Unit 5.2.1.a - Case Study: Select with Groupby and nested query </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1016" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse29" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading29"> </div> </div> </div> <div class="panel-group" id="accordion30" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading30"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion30" href="#collapse30" aria-expanded="true" aria-controls="collapse30"> Unit 5.3.1 - SQL Commands: Select with Condition & Order by nested query </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1017" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse30" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading30"> </div> </div> </div> <div class="panel-group" id="accordion31" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading31"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion31" href="#collapse31" aria-expanded="true" aria-controls="collapse31"> Unit 5.4.2 - SQL Commands: Joins Operations Part 2 </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1020" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse31" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading31"> </div> </div> </div> <div class="panel-group" id="accordion32" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading32"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion32" href="#collapse32" aria-expanded="true" aria-controls="collapse32"> Unit 5.4.3 - SQL Commands: Joins Operations Part 3 </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1021" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse32" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading32"> </div> </div> </div> <div class="panel-group" id="accordion33" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading33"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion33" href="#collapse33" aria-expanded="true" aria-controls="collapse33"> Unit 5.4.4 - SQL Commands: Joins Operations Part 4 </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1022" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse33" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading33"> </div> </div> </div> <div class="panel-group" id="accordion34" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading34"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion34" href="#collapse34" aria-expanded="true" aria-controls="collapse34"> Unit 5.4.5 - SQL Commands: Joins Operations Part 5 </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1023" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse34" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading34"> </div> </div> </div> <div class="panel-group" id="accordion35" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading35"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion35" href="#collapse35" aria-expanded="true" aria-controls="collapse35"> Unit 5.4.5.a - Case Study 1 Railway Reservation Part 1 </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1024" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse35" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading35"> </div> </div> </div> <div class="panel-group" id="accordion36" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading36"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion36" href="#collapse36" aria-expanded="true" aria-controls="collapse36"> Unit 5.4.5.b - Case Study 1 Railway Reservation Part 2 </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1025" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse36" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading36"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_7"> 7 Unit 6 - Data Analysis with SQL on Hands-on <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1026" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_7"> <div class="panel-group" id="accordion37" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading37"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion37" href="#collapse37" aria-expanded="true" aria-controls="collapse37"> Unit 6.1 - Assignment: Basic Analysis on Sakila Database </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1027" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse37" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading37"> </div> </div> </div> <div class="panel-group" id="accordion38" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading38"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion38" href="#collapse38" aria-expanded="true" aria-controls="collapse38"> Unit 6.2 - Assignment: Advance Analysis on Dataset </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1028" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse38" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading38"> </div> </div> </div> <div class="panel-group" id="accordion39" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading39"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion39" href="#collapse39" aria-expanded="true" aria-controls="collapse39"> Unit 6.3 - Project: Connect and Build own Database for Infrastructure Company </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1029" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse39" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading39"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_8"> 8 Unit 7 - Power BI <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1126" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_8"> <div class="panel-group" id="accordion40" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading40"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion40" href="#collapse40" aria-expanded="true" aria-controls="collapse40"> Unit 7.1 - Installation </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1127" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse40" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading40"> </div> </div> </div> </div> </div> </div> <div class="course_lessons_section"> <div class="panel-group" id="accordion_4932" role="tablist" aria-multiselectable="true"> <div class="lesson-title"> <a href="javascript:;" data-id="lesson_content_9"> 9 Unit 8 - Data Visualization <span><i class="fa fa-caret-down"></i></span> </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1128" class="expand">Learn Now </a> </span> </div> </div> <div class="lesson-content" id="lesson_content_9"> <div class="panel-group" id="accordion41" role="tablist" aria-multiselectable="true"> <div class="panel panel-default"> <div class="panel-heading" role="tab" id="heading41"> <h5 class="lesson-title" style="background:#FAFAFA; border-color:#212121;"> <a role="button" data-toggle="collapse" style="color:#212121;" data-parent="#accordion41" href="#collapse41" aria-expanded="true" aria-controls="collapse41"> Unit 8.1 - Basic Visualization – Graphs and Tables </a> <div class="meta"> <span class="badge video"><a href="https://uatdigipaathshala.cscacademy.org/lmstopics/viewtopics/1129" style="color:#212121;padding: 4px;font-size: 12px;" class="bt bt-xs bt-bg bt-secondary">Learn Now </a> </span> </div> </h5> </div> <div id="collapse41" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading41"> </div> </div> </div> </div> </div> </div> </div></div></div></div></div> </div> </div> </div> </div> </div> </div> </div> <div class="site-meta-single-product col-md-4"> <div class="summary-product entry-summary"> <div class="meta" style="margin-bottom: 20px;"> <!-- <span class="lb" style="background: #ffbd33;">Language</span> --> <button class=" alt" style="width: 100%; border: none; padding: 0 2%; min-height: 65px;background: #ffbd33; display: flex; justify-content: center; align-items: center;"> <select style="color:#fff ; background: #ffbd33; width: 100%; border: none;" class="" onchange="window.location='https://uatdigipaathshala.cscacademy.org/lmscourses/coursedetails/' + this.value;"> <option selected value="">Select Language</option> </select> <i class="fa fa-caret-down" style="color: white;"></i> </button> <!-- <span class="if" style="padding: 0 ; display: flex; align-items: center; background: #ffbd33;"> <i class="fa fa-caret-down"></i> </span> --> </div> <div class="meta"> <span class="lb p-bg-dark">Duration</span> <span class="if p-bg">60 Days</span> </div> <div class="meta"> <span class="lb p-bg-dark">Price</span> <span class="if p-bg"><span class="woocommerce-Price-amount amount"> <span class="woocommerce-Price-currencySymbol">₹ </span>2596 /- <span style="font-size:9px;">(Inc. All Taxes)</span></span></span> </div> <div style="clear: both"></div> <div class="widget"style="margin-bottom: 0;"> <h4 class="widget-title text-center"><span>ABOUT PUBLISHER</span></h4> <div class="location-map"> <div class="instructor text-center"> <!--pre-signed url for s3 bucket--> <img src="https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/publisher/publisherphoto/6f6c3d54c80bdc757f28c1b89e3910e7.jpg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2&X-Amz-Signature=1959b79a821a3c8e7634dd260688c5a3ba1991c6383db47ad70aa19786cf2fd7" style="width: 167px;height: 88px;"> <div class="info"> <div class="name"><h4 class="p-font"><a href="" target="_blank">CSC ACADEMY AND BTA</a></h4> </div> <div class="phone" style="text-align:left;"> <p> CSC Academy is a publicly invested learning institution that provides access to professional e-learning for learners of diverse backgrounds and educational needs. The Academy is committed to teaching, delivering of specialized courses/ training programmes and ensuring ubiquitous reach of training services and community development programmes including social justice (health, housing, education, financial services, etc.), leadership, communication skills and promotion of entrepreneurship across India. It is known as a premier institution promoting ethical leadership, entrepreneurship and social inclusion as its fundamental principle.&nbsp; The Boston Training Academy (BTA) is a cutting- edge technology solutions provider, operating via a global network of reseller partners. Originating from a high performance, mission-critical server and storage solutions background, Boston now offers training and consultancy to make technology easily available to everyone BTA offers structured and highly customizable courses backed by world-class infrastructure, tools and techniques and delivered by global experts. BTA also offers further consulting services for Artificial Intelligence, Data Science and broader technology related topics. </p> </div> </div> </div></div></div> <div class="enroll-wrap"> <div class="quantity hidden"> </div> <!-- check with auth for free course --> <a href="javascript:void(0)" style="width:100%;" data-search-type="standard"><button type="submit" name="add-to-cart" courseid="85" class="single_add_to_cart_button button alt buy_now" style="width: 100%;font-size: 16px; padding-top: 18px; padding-bottom: 18px; background-color:#ffbd33; text-transform: uppercase;font-weight: 400;letter-spacing: 1px;" >Subscribe Now</button></a> </div> <aside id="g5plus-course-related-2" class="widget widget-course woocommerce"> <h4 class="widget-title"><span>Related Course</span></h4> <div class="widget-content"> <div class="product-listing woocommerce clearfix columns-4"> <div class="course-item-wrap"> <div class="course-thumb"> <img src="https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/courseimage/1923afb314f9e0e6d7c74dcc3c3d619f.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2&X-Amz-Signature=8068e60a1dab50c23ffe0c1e52600614f1d3e365023c4f4f416c913b99167d03" alt="CSC Bal Vidyalaya Educator Foundation Training " width="200" /> </div> <div class="course-info"> <a class="fs-14 fw-medium course-title p-color-hover" href="https://uatdigipaathshala.cscacademy.org/lmscourses/coursedetails/16">CSC Bal Vidyalaya Educator Foundation Training </a> <span><i class="fa fa-user p-color pd-right-10"></i>By : CSC Academy</span> <span><i class="fa fa-calendar p-color pd-right-10"></i>Duration : 30 Days</span> <span > <a href="https://uatdigipaathshala.cscacademy.org/lmscourses/coursedetails/16" class="bt bt-xs bt-bg bt-secondary">Learn Now</a> </span> </div> </div> </div> </div> </aside> </div></div> </div> </div> </main> </div> <!-- Send data for enrollment through API --> <script> $.noConflict(); jQuery(document).ready(function($){ $(".enroll_now").click(function(evt){ var CourseId = $(this).attr("courseid"); $.ajax({//Make the Ajax Request beforeSend:function(){ $('#loader').show(); }, type: "POST", url: "https://uatdigipaathshala.cscacademy.org/admin/lmscourses/enrollstd", data:"courseId="+CourseId, success: function(data){//html = the server response html code $('#loadingmessage').hide(); //store data $error = JSON.parse(data).error; $message = JSON.parse(data).message; //show modal box $("#showenrollmentModal").modal('show'); if($error =='1') { $('#showenrolledalert').html('<div style="text-align: center;">'+$message+'<br><br><a href="https://uatdigipaathshala.cscacademy.org/student"><button type="button" class="btn-sm btn-primary">Login Now</button></a></div>'); } else { $('#showenrolledalert').html('<div style="text-align: center;">'+$message+'<br><br><a href="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/mycourses"><button type="button" class="btn-sm btn-primary">My Course</button></a></div>'); } }, error:function(){ alert("Internal Error Server Not found!");} }); }); // Check restricted course for restricted categories $(".restricted_std").click(function(evt){ var CourseId = $(this).attr("courseid"); $.ajax({//Make the Ajax Request beforeSend:function(){ $('#loader').show(); }, type: "POST", url: "https://uatdigipaathshala.cscacademy.org/admin/lmscourses/restrictedstd", data:"courseId="+CourseId, success: function(data){//html = the server response html code $('#loadingmessage').hide(); //store data $error = JSON.parse(data).error; $message = JSON.parse(data).message; //show modal box $("#showenrollmentModal").modal('show'); if($error =='1') { $('#showenrolledalert').html('<div style="text-align: center;">'+$message+'<br><br><a href="https://uatdigipaathshala.cscacademy.org/student"><button type="button" class="btn-sm btn-primary">Login Now</button></a></div>'); } else { $('#showenrolledalert').html('<div style="text-align: center;">'+$message+'<br><br><a href="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/mycourses"><button type="button" class="btn-sm btn-primary">My Course</button></a></div>'); } }, error:function(){ alert("Internal Error Server Not found!");} }); }); // SHOW BUY NOW POP UP $(".buy_now").click(function(evt){ var CourseId = $(this).attr("courseid"); $.ajax({//Make the Ajax Request beforeSend:function(){ $('#loadingmessage').show(); }, type: "POST", url: "https://uatdigipaathshala.cscacademy.org/admin/lmscourses/bUyNowstd", data:"courseId="+CourseId, success: function(data){//html = the server response html code $('#loadingmessage').hide(); //store data $error = JSON.parse(data).error; $message = JSON.parse(data).message; if($error =='1') { //show modal box $("#showenrollmentModal").modal('show'); $('#showenrolledalert').html('<div style="text-align: center;">'+$message+'<br><br><a href="https://uatdigipaathshala.cscacademy.org/student"><button type="button" class="btn-sm btn-primary">Login Now</button></a></div>'); } else if($error =='5' || $error =='6' || $error =='7') { $Courseid = JSON.parse(data).CourseId; //check if course CCA Course to upload 10th certificate before proceeding payment. if($Courseid == '2') { $("#uploadcertificateModal").modal('show'); $("#UploadCourseIds").val($Courseid); $('#uploadmessage').html('Please Upload 10th certificate first!!'); } else if($Courseid == '74' || $Courseid == '77') { $("#uploadcertificateModal").modal('show'); $("#UploadCourseIds").val($Courseid); $('#uploadmessage').html('Please Upload 12th certificate first!!'); } else { //show payment gateways window if($error =='5') { $("#pgModal").modal('show'); $("#PGCourseIds").val($Courseid); } else if($error =='7') { $("#hdfcModal").modal('show'); $("#HDFCCourseIds").val($Courseid); } else if($error =='6') { $("#buynowModal").modal('show'); $("#CourseIds").val($Courseid); } else { alert('Something went wrong into PG!!'); return false(); } } } else { //show modal box $("#showenrollmentModal").modal('show'); $('#showenrolledalert').html('<div style="text-align: center;">'+$message+'<br><br><a href="https://uatdigipaathshala.cscacademy.org/admin/lmscourses/mycourses"><button type="button" class="btn-sm btn-primary">My Course</button></a></div>'); } }, error:function(){ alert("Internal Error Server Not found!");} }); }); // Upload 10th certificate through ajax $("#upload10certificateform").on('submit',(function(e) { //check file size first!! var file_size = $('#10certificate')[0].files[0].size; if(file_size>2097152) { alert("File size is greater than 2MB, please upload again!!"); return false; } e.preventDefault(); $.ajax({ beforeSend:function(){ $("#uploadcertificateModal").modal('hide'); $('#loadingmessage').show(); }, url: "https://uatdigipaathshala.cscacademy.org/admin/lmscourses/upload10certificate", type: "POST", data: new FormData(this), contentType: false, cache: false, processData:false, success: function(data) { if(JSON.parse(data).error =='4') { $("#uploadcertificateModal").modal('hide'); $("#buynowModal").modal('show'); $("#CourseIds").val($Courseid); $("#UploadCertificateFile").val(JSON.parse(data).UploadCertificateFile); } else { alert(JSON.parse(data).message); } }, error: function(e) { $("#err").html(e).fadeIn(); } }); })); //check CSCID is associated with cscacademy centre or not $("#paynowcscid").click(function(evt){ var cscID = $('#cscID').val(); var courseid = "85"; var vedic_math_medium = "<pre class="cake-error"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr67efab4f3c7b1-trace').style.display = (document.getElementById('cakeErr67efab4f3c7b1-trace').style.display == 'none' ? '' : 'none');"><b>Notice</b> (8)</a>: Undefined variable: auth_user [<b>APP/View/Lmscourses/coursedetails.ctp</b>, line <b>774</b>]<div id="cakeErr67efab4f3c7b1-trace" class="cake-stack-trace" style="display: none;"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr67efab4f3c7b1-code').style.display = (document.getElementById('cakeErr67efab4f3c7b1-code').style.display == 'none' ? '' : 'none')">Code</a> <a href="javascript:void(0);" onclick="document.getElementById('cakeErr67efab4f3c7b1-context').style.display = (document.getElementById('cakeErr67efab4f3c7b1-context').style.display == 'none' ? '' : 'none')">Context</a><pre id="cakeErr67efab4f3c7b1-code" class="cake-code-dump" style="display: none;"><code><span style="color: #000000"> ob_start();</span></code> <code><span style="color: #000000"></span></code> <span class="code-highlight"><code><span style="color: #000000"> include $___viewFn;</span></code></span></pre><pre id="cakeErr67efab4f3c7b1-context" class="cake-context" style="display: none;">$___viewFn = '/data/uat/app/View/Lmscourses/coursedetails.ctp' $___dataForView = array( 'record' => array( [maximum depth reached] ), 'lmstopics' => array( [maximum depth reached] ), 'relatedcourses' => array( [maximum depth reached] ), 'check_exist' => false, 'languages' => array([maximum depth reached]), 'LastLogin' => array([maximum depth reached]), 's3' => object(Aws\S3\S3Client) {}, 'inputDefaults' => array( [maximum depth reached] ), 'csrfToken' => '6a24002bd597101fd9a60b7eb5250eadb0437194266019a21f1c33d4a70f7eb1' ) $record = array( 'Lmsuser' => array( [maximum depth reached] ), 'Lmscourse' => array( [maximum depth reached] ) ) $lmstopics = array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ), (int) 2 => array( [maximum depth reached] ), (int) 3 => array( [maximum depth reached] ), (int) 4 => array( [maximum depth reached] ), (int) 5 => array( [maximum depth reached] ), (int) 6 => array( [maximum depth reached] ), (int) 7 => array( [maximum depth reached] ), (int) 8 => array( [maximum depth reached] ) ) $relatedcourses = array( (int) 0 => array( [maximum depth reached] ) ) $check_exist = false $languages = array() $LastLogin = array() $s3 = object(Aws\S3\S3Client) {} $inputDefaults = array( 'inputDefaults' => array( [maximum depth reached] ) ) $csrfToken = '6a24002bd597101fd9a60b7eb5250eadb0437194266019a21f1c33d4a70f7eb1' $cmd = object(Aws\Command) {} $request = object(GuzzleHttp\Psr7\Request) {} $presignedUrl = 'https://csc-edu.s3.ap-south-1.amazonaws.com/lmscourse/courseimage/1923afb314f9e0e6d7c74dcc3c3d619f.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXRD2RIGVRXSHFNHS%2F20250404%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250404T095007Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2&X-Amz-Signature=8068e60a1dab50c23ffe0c1e52600614f1d3e365023c4f4f416c913b99167d03' $count = (int) 9 $count2 = (int) 41 $count3 = (int) 0 $lmstopic = array( 'Lmstopic' => array( [maximum depth reached] ), 'children' => array( [maximum depth reached] ) ) $children = array( 'Lmstopic' => array( [maximum depth reached] ), 'children' => array([maximum depth reached]) ) $relatedcourse = array( 'Lmscourse' => array( [maximum depth reached] ) )</pre><pre class="stack-trace">include - APP/View/Lmscourses/coursedetails.ctp, line 774 View::_evaluate() - CORE/Cake/View/View.php, line 915 View::_render() - CORE/Cake/View/View.php, line 879 View::render() - CORE/Cake/View/View.php, line 470 Controller::render() - CORE/Cake/Controller/Controller.php, line 959 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 110 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 85 [main] - APP/webroot/index.php, line 96</pre></div></pre>"; var csrfToken = "6a24002bd597101fd9a60b7eb5250eadb0437194266019a21f1c33d4a70f7eb1"; // alert(courseid); $.ajax({//Make the Ajax Request beforeSend:function(){ $("#buynowModal").modal('hide'); $('#loadingmessage').show(); }, type: "POST", url: "https://uatdigipaathshala.cscacademy.org/admin/users/checkCscacademyonboarding", // data:"cscID="+cscID+"course_id="+courseid, data:{cscID:cscID,courseid:courseid,vedic_math_medium:vedic_math_medium,csrfToken:csrfToken}, success: function(data){//html = the server response html code $('#loadingmessage').hide(); if(JSON.parse(data).count =='1') { document.paymentproceed.submit(); } else if(JSON.parse(data).count =='2') { document.paymentproceed.submit(); } else if(JSON.parse(data).count =='3') { alert('Oops!! Seats are full please try in another batch.'); } else if(JSON.parse(data).count =='4') { alert('Oops!! Payments are closed now for this course.'); } else if(JSON.parse(data).count =='5') { document.paymentproceed.submit(); } else if(JSON.parse(data).count =='6') { alert('Kindly register with Spoken Tutorial(Plan 1- All Courses) to Enroll students in This Course'); } else { $("#buynowModal").modal('show'); alert('This course is not active for this VLE!!'); } }, error:function(){ alert("Internal Error Server Not found!");} }); }); $("#pgmethod").click(function(evt){ var pgmethod = $('input[name="payment_gateway"]:checked').val(); if(pgmethod ==2) { $("#pgModal").modal('hide'); $("#buynowModal").modal('show'); $("#CourseIds").val($Courseid); } else if(pgmethod ==3) { $("#pgModal").modal('hide'); $("#hdfcModal").modal('show'); $("#HDFCCourseIds").val($Courseid); } else { alert('Error due to network!!'); return false(); } }); }); </script> ' $scripts_for_layout = '' $title_for_layout = 'Lmscourses'include - APP/View/Layouts/lms_inner_layout.ctp, line 395 View::_evaluate() - CORE/Cake/View/View.php, line 915 View::_render() - CORE/Cake/View/View.php, line 879 View::renderLayout() - CORE/Cake/View/View.php, line 534 View::render() - CORE/Cake/View/View.php, line 478 Controller::render() - CORE/Cake/Controller/Controller.php, line 959 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 110 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 85 [main] - APP/webroot/index.php, line 96
Admission started for Batch 1. The course is designed to provide how to execute core SQL commands to define, select, manipulate, control access, aggregate and join data and data tables. Understand when and how to use subqueries, several window functions, as well as partitions to complete complex tasks. Clean data, optimize SQL queries, and write select advanced JOINs to enhance analysis performance. Explain which cases you would want to use particular SQL commands, and apply the results from queries to address business problems.
CSC Academy is a publicly invested learning institution that provides access to professional e-learning for learners of diverse backgrounds and educational needs. The Academy is committed to teaching, delivering of specialized courses/ training programmes and ensuring ubiquitous reach of training services and community development programmes including social justice (health, housing, education, financial services, etc.), leadership, communication skills and promotion of entrepreneurship across India. It is known as a premier institution promoting ethical leadership, entrepreneurship and social inclusion as its fundamental principle. The Boston Training Academy (BTA) is a cutting- edge technology solutions provider, operating via a global network of reseller partners. Originating from a high performance, mission-critical server and storage solutions background, Boston now offers training and consultancy to make technology easily available to everyone BTA offers structured and highly customizable courses backed by world-class infrastructure, tools and techniques and delivered by global experts. BTA also offers further consulting services for Artificial Intelligence, Data Science and broader technology related topics.