{"id":6423,"date":"2026-02-17T10:57:43","date_gmt":"2026-02-17T10:57:43","guid":{"rendered":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/?page_id=6423"},"modified":"2026-02-17T11:13:16","modified_gmt":"2026-02-17T11:13:16","slug":"advance-training","status":"publish","type":"page","link":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/short-duration-programs\/advance-training\/","title":{"rendered":"Advance Training"},"content":{"rendered":"\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

SQL \u2013 Advance Training<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t
\n\t\t\t\t\t
\n\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Event Name:<\/strong> SQL \u2013 Advance Training<\/p>

Event Date:\u00a0<\/strong> March 29th -April 29th 2025<\/p>

Faculty Coordinators:<\/strong> Dr Neetu Kamra<\/p>

Event Timings:<\/strong>10am -12pm<\/p>

Number of Participants:<\/strong> 34<\/p>

Venue:<\/strong>Online<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Objectives<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
  • To provide participants with a strong foundational and practical understanding of Structured Query Language (SQL)<\/li>
  • To enhance data handling, querying, and database management skills<\/li>
  • To enable learners to apply SQL concepts effectively in real-world scenarios<\/li>
  • To develop analytical thinking and problem-solving abilities using SQL<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t

    Detailed Report<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t
    \n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    Week 1: SQL Fundamentals and Core Concepts<\/strong><\/p>

    The first week of the SQL Advance Training focused on building a strong foundation in databases and SQL fundamentals. Participants were introduced to the concept of databases, the importance of SQL, and its real-world applications across various industries. The sessions covered database structure, including tables, rows, and columns. Basic SQL commands such as SELECT, INSERT, UPDATE, and DELETE were explained with hands-on demonstrations. Participants learned how to filter and sort data using WHERE, ORDER BY, and LIMIT clauses. Aggregate functions such as COUNT, SUM, and AVG were introduced along with GROUP BY and HAVING clauses. Business-oriented examples and practical exercises helped participants understand how SQL is used for data analysis and reporting.<\/p>

    Week 2: Advanced SQL Techniques and Practical Application<\/strong><\/p>

    The second week focused on advanced SQL concepts and practical implementation. Participants gained in-depth knowledge of table relationships and various types of joins, including INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN. Subqueries were introduced to help learners solve complex data retrieval problems. Sessions on constraints such as Primary Key, Foreign Key, Unique, Not Null, and Check constraints emphasized the importance of data integrity. SQL functions and operators related to strings, numbers, and dates were demonstrated. The training included hands-on case studies using real datasets, enabling participants to apply their learning practically. The program concluded with revision sessions, doubt clearing, query optimization techniques, and final discussions.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t

    Learning Outcomes<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t
    \n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t
    • Strong understanding of SQL fundamentals and advanced concepts<\/li>
    • Ability to write efficient and optimized SQL queries<\/li>
    • Enhanced analytical and data-handling skills<\/li>
    • Practical exposure to real-world datasets and business use cases<\/li>
    • Improved confidence in database management and querying<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t

      Conclusion<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t
      \n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t\t\t

      The two-week SQL Advance Training program under the EEP was successfully conducted and received enthusiastic participation from professionals, faculty, and students. The sessions offered a balanced mix of conceptual learning, practical exposure, and industry-relevant applications. The training significantly enhanced participants\u2019 competence in SQL and prepared them to apply database skills effectively in academic and professional environments.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t

      \n\t\t\t\t\t
      \n\t\t
      \n\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t\t\t
      \"1\"<\/figure><\/div>
      \"2\"<\/figure><\/div>
      \"3\"<\/figure><\/div>\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t
      \n\t\t\t\t\t\t<\/path><\/svg>\t\t\t\t\t<\/div>\n\t\t\t\t\t
      \n\t\t\t\t\t\t<\/path><\/svg>\t\t\t\t\t<\/div>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

      SQL \u2013 Advance Training Event Name: SQL \u2013 Advance Training Event Date:\u00a0 March 29th -April 29th 2025 Faculty Coordinators: Dr Neetu Kamra Event Timings:10am -12pm Number of Participants: 34 Venue:Online Objectives To provide participants with a strong foundational and practical understanding of Structured Query Language (SQL) To enhance data handling, querying, and database management skills […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":2239,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-6423","page","type-page","status-publish","hentry"],"yoast_head":"\r\nAdvance Training - Executive Education Program<\/title>\r\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Advance Training\" \/>\r\n<meta property=\"og:description\" content=\"SQL \u2013 Advance Training Event Name: SQL \u2013 Advance Training Event Date:\u00a0 March 29th -April 29th 2025 Faculty Coordinators: Dr Neetu Kamra Event Timings:10am -12pm Number of Participants: 34 Venue:Online Objectives To provide participants with a strong foundational and practical understanding of Structured Query Language (SQL) To enhance data handling, querying, and database management skills […]\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/short-duration-programs\/advance-training\/\" \/>\r\n<meta property=\"og:site_name\" content=\"Executive Education Program\" \/>\r\n<meta property=\"article:modified_time\" content=\"2026-02-17T11:13:16+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/wp-content\/uploads\/2026\/02\/1-12.jpg\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/short-duration-programs\/advance-training\/\",\"url\":\"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/short-duration-programs\/advance-training\/\",\"name\":\"Advance Training - Executive Education Program\",\"isPartOf\":{\"@id\":\"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/short-duration-programs\/advance-training\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/short-duration-programs\/advance-training\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/wp-content\/uploads\/2026\/02\/1-12.jpg\",\"datePublished\":\"2026-02-17T10:57:43+00:00\",\"dateModified\":\"2026-02-17T11:13:16+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/short-duration-programs\/advance-training\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/short-duration-programs\/advance-training\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/short-duration-programs\/advance-training\/#primaryimage\",\"url\":\"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/wp-content\/uploads\/2026\/02\/1-12.jpg\",\"contentUrl\":\"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/wp-content\/uploads\/2026\/02\/1-12.jpg\",\"width\":800,\"height\":601},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/short-duration-programs\/advance-training\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Short Duration Programs\",\"item\":\"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/short-duration-programs\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Advance Training\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/#website\",\"url\":\"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/\",\"name\":\"Executive Education Program\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\r\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Advance Training - Executive Education Program","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Advance Training","og_description":"SQL \u2013 Advance Training Event Name: SQL \u2013 Advance Training Event Date:\u00a0 March 29th -April 29th 2025 Faculty Coordinators: Dr Neetu Kamra Event Timings:10am -12pm Number of Participants: 34 Venue:Online Objectives To provide participants with a strong foundational and practical understanding of Structured Query Language (SQL) To enhance data handling, querying, and database management skills […]","og_url":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/short-duration-programs\/advance-training\/","og_site_name":"Executive Education Program","article_modified_time":"2026-02-17T11:13:16+00:00","og_image":[{"url":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/wp-content\/uploads\/2026\/02\/1-12.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/short-duration-programs\/advance-training\/","url":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/short-duration-programs\/advance-training\/","name":"Advance Training - Executive Education Program","isPartOf":{"@id":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/short-duration-programs\/advance-training\/#primaryimage"},"image":{"@id":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/short-duration-programs\/advance-training\/#primaryimage"},"thumbnailUrl":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/wp-content\/uploads\/2026\/02\/1-12.jpg","datePublished":"2026-02-17T10:57:43+00:00","dateModified":"2026-02-17T11:13:16+00:00","breadcrumb":{"@id":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/short-duration-programs\/advance-training\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/short-duration-programs\/advance-training\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/short-duration-programs\/advance-training\/#primaryimage","url":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/wp-content\/uploads\/2026\/02\/1-12.jpg","contentUrl":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/wp-content\/uploads\/2026\/02\/1-12.jpg","width":800,"height":601},{"@type":"BreadcrumbList","@id":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/short-duration-programs\/advance-training\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/"},{"@type":"ListItem","position":2,"name":"Short Duration Programs","item":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/short-duration-programs\/"},{"@type":"ListItem","position":3,"name":"Advance Training"}]},{"@type":"WebSite","@id":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/#website","url":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/","name":"Executive Education Program","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/wp-json\/wp\/v2\/pages\/6423","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/wp-json\/wp\/v2\/comments?post=6423"}],"version-history":[{"count":7,"href":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/wp-json\/wp\/v2\/pages\/6423\/revisions"}],"predecessor-version":[{"id":6436,"href":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/wp-json\/wp\/v2\/pages\/6423\/revisions\/6436"}],"up":[{"embeddable":true,"href":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/wp-json\/wp\/v2\/pages\/2239"}],"wp:attachment":[{"href":"https:\/\/www.lloydbusinessschool.edu.in\/Executive-Education-Program\/wp-json\/wp\/v2\/media?parent=6423"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}