{"id":231967,"date":"2026-07-24T10:28:55","date_gmt":"2026-07-24T08:28:55","guid":{"rendered":"https:\/\/epg.com\/?page_id=231967"},"modified":"2026-07-24T11:22:12","modified_gmt":"2026-07-24T09:22:12","slug":"it-management-courses-data-flow-and-sql-for-epg-one-wms","status":"publish","type":"page","link":"https:\/\/epg.com\/us\/epg-academy\/it-management-courses-data-flow-and-sql-for-epg-one-wms\/","title":{"rendered":"IT Management Courses \u2013 Data Flow and SQL for EPG ONE WMS"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"231967\" class=\"elementor elementor-231967\" data-elementor-post-type=\"page\">\n\t\t\t\t<div class=\"elementor-element elementor-element-fbb5639 e-con-full e-flex e-con e-parent\" data-id=\"fbb5639\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-d8f0dc5 e-con-full epgcontainer e-flex e-con e-child\" data-id=\"d8f0dc5\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;,&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-9010592 e-con-full e-flex e-con e-child\" data-id=\"9010592\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[],&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t<div class=\"elementor-element elementor-element-44b29b2 e-con-full e-flex e-con e-child\" data-id=\"44b29b2\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8db2fbb elementor-widget elementor-widget-heading\" data-id=\"8db2fbb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">IT Management Courses<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e8c9570 elementor-widget elementor-widget-heading\" data-id=\"e8c9570\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-default\">Data Flow &amp; SQL \u2013 Understanding System Data and Building Queries <\/h1>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-c04cafb e-con-full epgcontainer elementor-hidden-tablet elementor-hidden-mobile e-flex e-con e-child\" data-id=\"c04cafb\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[],&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t<div class=\"elementor-element elementor-element-8434c16 e-con-full e-flex e-con e-child\" data-id=\"8434c16\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4a42e46 elementor-widget elementor-widget-jet-breadcrumbs\" data-id=\"4a42e46\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"jet-breadcrumbs.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-jet-breadcrumbs jet-blocks\">\n\t\t<div class=\"jet-breadcrumbs\">\n\t\t<div class=\"jet-breadcrumbs__content\">\n\t\t<div class=\"jet-breadcrumbs__wrap\"><div class=\"jet-breadcrumbs__item\"><a href=\"https:\/\/epg.com\/us\/\" class=\"jet-breadcrumbs__item-link is-home\" rel=\"home\" title=\"Homepage\">Homepage<\/a><\/div>\n\t\t<\/div>\n\t\t<\/div>\n\t\t<\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-fd20b8f e-con-full e-flex e-con e-child\" data-id=\"fd20b8f\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-6d43345 e-con-full e-flex e-con e-child\" data-id=\"6d43345\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-b66b2d7 e-con-full e-flex e-con e-child\" data-id=\"b66b2d7\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-98d8f72 elementor-widget__width-initial elementor-widget-mobile__width-inherit elementor-widget-widescreen__width-inherit elementor-widget elementor-widget-text-editor\" data-id=\"98d8f72\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Learn how data flows through your EPG ONE WMS System and how to use SQL to access and analyze that data. This course explains key database concepts, typical data structures for EPG ONE WMS, and practical SQL queries so participants can better understand interfaces, support reporting, and perform basic root-cause analysis.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a116108 e-con-full e-flex e-con e-child\" data-id=\"a116108\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-cb395bd e-con-full e-flex e-con e-child\" data-id=\"cb395bd\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[],&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ee40cc2 elementor-widget__width-inherit elementor-widget elementor-widget-heading\" data-id=\"ee40cc2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Who This Course Is For:<\/p>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3995213 elementor-widget elementor-widget-text-editor\" data-id=\"3995213\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<ul><li>Key users and super users working with operational\/logistics systems (e.g. WMS, CnB, Timesquare)<\/li><li>IT-minded operations staff who need to understand data flow behind processes<\/li><li>Junior IT \/ support staff who analyze data and logs<\/li><li>Anyone who wants a structured introduction to data flow and SQL in a logistics enterprise context<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-38ded77 e-con-full e-flex e-con e-child\" data-id=\"38ded77\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[],&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t<div class=\"elementor-element elementor-element-e5019dc e-con-full e-flex e-con e-child\" data-id=\"e5019dc\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-68ba53d elementor-widget__width-inherit elementor-widget elementor-widget-heading\" data-id=\"68ba53d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">What You\u2019ll Learn<\/p>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5080b1f elementor-widget__width-inherit elementor-widget elementor-widget-heading\" data-id=\"5080b1f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">By the end of this course, you will be able to: <\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dddd956 elementor-widget elementor-widget-text-editor\" data-id=\"dddd956\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<ul><li>Describe how master data and transaction data flow between core systems (host, WMS)<\/li><li>Identify key tables and fields relevant to typical business questions (e.g. orders, stock, movements)<\/li><li>Do research on various inbound and outbound related topics<\/li><li>Follow best practices for safe querying in a productive environment (read-only access, performance awareness)<\/li><li>Make queries available as a reporting tool to other team members<\/li><\/ul>\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<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-fe10d7b e-con-full e-flex e-con e-child\" data-id=\"fe10d7b\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[],&quot;background_background&quot;:&quot;gradient&quot;}\">\n\t\t<div class=\"elementor-element elementor-element-bfa299e e-con-full e-flex e-con e-child\" data-id=\"bfa299e\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-8fa0656 e-con-full e-flex e-con e-child\" data-id=\"8fa0656\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-25bb5d1 elementor-widget elementor-widget-heading\" data-id=\"25bb5d1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Built for Smarter, Faster Shipping Operations<\/p>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3c31881 elementor-widget elementor-widget-heading\" data-id=\"3c31881\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Our Course Content<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-be0782b elementor-widget elementor-widget-heading\" data-id=\"be0782b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<span class=\"elementor-heading-title elementor-size-default\">Participants work through practical examples and guided exercises to apply each concept directly in the system. <\/span>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ba971c8 elementor-widget elementor-widget-button\" data-id=\"ba971c8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"#contact\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-icon\">\n\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-arrow-right\"><\/i>\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Talk to an Expert<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d42dee2 e-con-full e-flex e-con e-child\" data-id=\"d42dee2\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a479931 elementor-widget-mobile__width-initial elementor-widget__width-inherit e-n-tabs-mobile elementor-widget elementor-widget-n-tabs\" data-id=\"a479931\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"nested-tabs.default\">\n\t\t\t\t\t\t\t<div class=\"e-n-tabs\" data-widget-number=\"172464433\" aria-label=\"Tabs. Open items with Enter or Space, close with Escape and navigate using the Arrow keys.\">\n\t\t\t<div class=\"e-n-tabs-heading\" role=\"tablist\">\n\t\t\t\t\t<button id=\"e-n-tab-title-1724644331\" data-tab-title-id=\"e-n-tab-title-1724644331\" class=\"e-n-tab-title\" aria-selected=\"true\" data-tab-index=\"1\" role=\"tab\" tabindex=\"0\" aria-controls=\"e-n-tab-content-1724644331\" style=\"--n-tabs-title-order: 1;\">\n\t\t\t\t\t\t<span class=\"e-n-tab-title-text\">\n\t\t\t\tIntroduction to Data Flow &amp; System Landscape\t\t\t<\/span>\n\t\t<\/button>\n\t\t\t\t<button id=\"e-n-tab-title-1724644332\" data-tab-title-id=\"e-n-tab-title-1724644332\" class=\"e-n-tab-title\" aria-selected=\"false\" data-tab-index=\"2\" role=\"tab\" tabindex=\"-1\" aria-controls=\"e-n-tab-content-1724644332\" style=\"--n-tabs-title-order: 2;\">\n\t\t\t\t\t\t<span class=\"e-n-tab-title-text\">\n\t\t\t\tData bases for Master Data Research\t\t\t<\/span>\n\t\t<\/button>\n\t\t\t\t<button id=\"e-n-tab-title-1724644333\" data-tab-title-id=\"e-n-tab-title-1724644333\" class=\"e-n-tab-title\" aria-selected=\"false\" data-tab-index=\"3\" role=\"tab\" tabindex=\"-1\" aria-controls=\"e-n-tab-content-1724644333\" style=\"--n-tabs-title-order: 3;\">\n\t\t\t\t\t\t<span class=\"e-n-tab-title-text\">\n\t\t\t\tData Flow in Inbound Processes\t\t\t<\/span>\n\t\t<\/button>\n\t\t\t\t<button id=\"e-n-tab-title-1724644334\" data-tab-title-id=\"e-n-tab-title-1724644334\" class=\"e-n-tab-title\" aria-selected=\"false\" data-tab-index=\"4\" role=\"tab\" tabindex=\"-1\" aria-controls=\"e-n-tab-content-1724644334\" style=\"--n-tabs-title-order: 4;\">\n\t\t\t\t\t\t<span class=\"e-n-tab-title-text\">\n\t\t\t\tData flow in goods dispatch\t\t\t<\/span>\n\t\t<\/button>\n\t\t\t\t<button id=\"e-n-tab-title-1724644335\" data-tab-title-id=\"e-n-tab-title-1724644335\" class=\"e-n-tab-title\" aria-selected=\"false\" data-tab-index=\"5\" role=\"tab\" tabindex=\"-1\" aria-controls=\"e-n-tab-content-1724644335\" style=\"--n-tabs-title-order: 5;\">\n\t\t\t\t\t\t<span class=\"e-n-tab-title-text\">\n\t\t\t\tAdditional Data Flow Examples\t\t\t<\/span>\n\t\t<\/button>\n\t\t\t\t<button id=\"e-n-tab-title-1724644336\" data-tab-title-id=\"e-n-tab-title-1724644336\" class=\"e-n-tab-title\" aria-selected=\"false\" data-tab-index=\"6\" role=\"tab\" tabindex=\"-1\" aria-controls=\"e-n-tab-content-1724644336\" style=\"--n-tabs-title-order: 6;\">\n\t\t\t\t\t\t<span class=\"e-n-tab-title-text\">\n\t\t\t\tSQL for Troubleshooting &amp; Best Practices\t\t\t<\/span>\n\t\t<\/button>\n\t\t\t\t\t<\/div>\n\t\t\t<div class=\"e-n-tabs-content\">\n\t\t\t\t<div id=\"e-n-tab-content-1724644331\" role=\"tabpanel\" aria-labelledby=\"e-n-tab-title-1724644331\" data-tab-index=\"1\" style=\"--n-tabs-title-order: 1;\" class=\"e-active elementor-element elementor-element-14fc387 e-con-full e-flex e-con e-child\" data-id=\"14fc387\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-684a85f e-con-full e-flex e-con e-child\" data-id=\"684a85f\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;,&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-e2084b2 e-con-full e-flex e-con e-child\" data-id=\"e2084b2\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;gradient&quot;,&quot;jet_parallax_layout_list&quot;:[],&quot;position&quot;:&quot;absolute&quot;}\">\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-55cbf7c e-con-full glass e-flex e-con e-child\" data-id=\"55cbf7c\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b9d6fca elementor-widget elementor-widget-heading\" data-id=\"b9d6fca\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Module 1: Introduction to Data Flow &amp; System Landscape<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-55e0149 elementor-widget elementor-widget-text-editor\" data-id=\"55e0149\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<ul><li>Typical system landscape (host\/ERP, WMS, reporting)<\/li><li>Master data vs. transaction data: what they are and how they move<\/li><li>High-level data flows for core processes (inbound, outbound, billing, time recording)<\/li><li>Documentation of database and interface files<\/li><li>Structure of SQL statements<\/li><\/ul>\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<\/div>\n\t\t<div id=\"e-n-tab-content-1724644332\" role=\"tabpanel\" aria-labelledby=\"e-n-tab-title-1724644332\" data-tab-index=\"2\" style=\"--n-tabs-title-order: 2;\" class=\" elementor-element elementor-element-91dfd97 e-con-full e-flex e-con e-child\" data-id=\"91dfd97\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-79063b7 e-con-full e-flex e-con e-child\" data-id=\"79063b7\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;,&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-db65b62 e-con-full e-flex e-con e-child\" data-id=\"db65b62\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;gradient&quot;,&quot;jet_parallax_layout_list&quot;:[],&quot;position&quot;:&quot;absolute&quot;}\">\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a2b8b58 e-con-full glass e-flex e-con e-child\" data-id=\"a2b8b58\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-81814f9 elementor-widget elementor-widget-heading\" data-id=\"81814f9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Module 2: Data bases for Master Data Research<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-75fbd4d elementor-widget elementor-widget-text-editor\" data-id=\"75fbd4d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Using the data bases for items and storage locations to perform research tasks<\/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<\/div>\n\t\t<div id=\"e-n-tab-content-1724644333\" role=\"tabpanel\" aria-labelledby=\"e-n-tab-title-1724644333\" data-tab-index=\"3\" style=\"--n-tabs-title-order: 3;\" class=\" elementor-element elementor-element-b35ac48 e-con-full e-flex e-con e-child\" data-id=\"b35ac48\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-6d847ea e-con-full e-flex e-con e-child\" data-id=\"6d847ea\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;,&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-fc2f19a e-con-full e-flex e-con e-child\" data-id=\"fc2f19a\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;gradient&quot;,&quot;jet_parallax_layout_list&quot;:[],&quot;position&quot;:&quot;absolute&quot;}\">\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1a7df0d e-con-full glass e-flex e-con e-child\" data-id=\"1a7df0d\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-f70e15d elementor-widget elementor-widget-heading\" data-id=\"f70e15d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Module 3: Data Flow in Inbound Processes<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b53cf03 elementor-widget elementor-widget-text-editor\" data-id=\"b53cf03\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<ul><li>Data bases and data flow for inbound processes<\/li><li>Research tasks for inbound processes<\/li><li>Detailed analysis of open and confirmed transports, goods receipt data<\/li><li>Completing troubleshooting examples<\/li><\/ul>\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<\/div>\n\t\t<div id=\"e-n-tab-content-1724644334\" role=\"tabpanel\" aria-labelledby=\"e-n-tab-title-1724644334\" data-tab-index=\"4\" style=\"--n-tabs-title-order: 4;\" class=\" elementor-element elementor-element-b89b2df e-con-full e-flex e-con e-child\" data-id=\"b89b2df\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-10d9940 e-con-full e-flex e-con e-child\" data-id=\"10d9940\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;,&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-aab8cf1 e-con-full e-flex e-con e-child\" data-id=\"aab8cf1\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;gradient&quot;,&quot;jet_parallax_layout_list&quot;:[],&quot;position&quot;:&quot;absolute&quot;}\">\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b22ef53 e-con-full glass e-flex e-con e-child\" data-id=\"b22ef53\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d1bf297 elementor-widget elementor-widget-heading\" data-id=\"d1bf297\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Module 4: Data flow in goods dispatch<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b0eea72 elementor-widget elementor-widget-text-editor\" data-id=\"b0eea72\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<ul><li>Data bases and data flow in outbound processes<\/li><li>Editing work packages<\/li><li>Analyzing picking, packing and loading progress<\/li><li>Completing troubleshooting examples<\/li><\/ul>\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<\/div>\n\t\t<div id=\"e-n-tab-content-1724644335\" role=\"tabpanel\" aria-labelledby=\"e-n-tab-title-1724644335\" data-tab-index=\"5\" style=\"--n-tabs-title-order: 5;\" class=\" elementor-element elementor-element-9876fd9 e-con-full e-flex e-con e-child\" data-id=\"9876fd9\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-2543638 e-con-full e-flex e-con e-child\" data-id=\"2543638\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;,&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-730ecfc e-con-full e-flex e-con e-child\" data-id=\"730ecfc\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;gradient&quot;,&quot;jet_parallax_layout_list&quot;:[],&quot;position&quot;:&quot;absolute&quot;}\">\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-feb7e69 e-con-full glass e-flex e-con e-child\" data-id=\"feb7e69\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ad894fb elementor-widget elementor-widget-heading\" data-id=\"ad894fb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Module 5: Additional Data Flow Examples<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-522f7c8 elementor-widget elementor-widget-text-editor\" data-id=\"522f7c8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<ul><li>Creating SQL queries for stocktake research<\/li><li>Researching quality control and serial numbers<\/li><li>Working with variants, batches or lot numbers and BBD<\/li><\/ul>\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<\/div>\n\t\t<div id=\"e-n-tab-content-1724644336\" role=\"tabpanel\" aria-labelledby=\"e-n-tab-title-1724644336\" data-tab-index=\"6\" style=\"--n-tabs-title-order: 6;\" class=\" elementor-element elementor-element-431ccdf e-con-full e-flex e-con e-child\" data-id=\"431ccdf\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-480f659 e-con-full e-flex e-con e-child\" data-id=\"480f659\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;,&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-fb845d3 e-con-full e-flex e-con e-child\" data-id=\"fb845d3\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;gradient&quot;,&quot;jet_parallax_layout_list&quot;:[],&quot;position&quot;:&quot;absolute&quot;}\">\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e05fc24 e-con-full glass e-flex e-con e-child\" data-id=\"e05fc24\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-87be430 elementor-widget elementor-widget-heading\" data-id=\"87be430\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Module 6: SQL for Troubleshooting &amp; Best Practices<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-71aff7e elementor-widget elementor-widget-text-editor\" data-id=\"71aff7e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Using SQL to trace process steps and check status fields.<\/p><p>Examples:<\/p><ul><li>Finding why an order\/invoice\/time record did not progress<\/li><li>Checking key fields\/flags that drive system behavior<\/li><li>Safe querying: read-only access, limiting result sets, avoiding long-running queries<\/li><li>Tips for communicating findings to IT and using SQL results in support tickets<\/li><li>Working with the query manager to make reporting available to other team members<\/li><\/ul>\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<\/div>\n\t\t\t\t\t<\/div>\n\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<\/div>\n\t\t<div class=\"elementor-element elementor-element-377311c e-con-full epgcontainer e-flex e-con e-child\" data-id=\"377311c\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-183fed0 e-con-full e-flex e-con e-child\" data-id=\"183fed0\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-bbd151b elementor-widget__width-inherit elementor-widget elementor-widget-heading\" data-id=\"bbd151b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Course Format and Details <\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6d567e4 e-con-full e-grid e-con e-child\" data-id=\"6d567e4\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-d91331c e-con-full e-flex e-con e-child\" data-id=\"d91331c\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[],&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t<div class=\"elementor-element elementor-element-c9aa2b2 e-con-full e-flex e-con e-child\" data-id=\"c9aa2b2\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-174d3c5 elementor-view-default elementor-widget elementor-widget-icon\" data-id=\"174d3c5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<div class=\"elementor-icon\">\n\t\t\t<i aria-hidden=\"true\" class=\"fas fa-th-list\"><\/i>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e9fe81b elementor-widget elementor-widget-heading\" data-id=\"e9fe81b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Level<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e328f5a elementor-widget elementor-widget-text-editor\" data-id=\"e328f5a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\tBeginner \/ lower-intermediate (no prior SQL knowledge required)\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d72c0d1 e-con-full e-flex e-con e-child\" data-id=\"d72c0d1\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[],&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t<div class=\"elementor-element elementor-element-eafb5ac e-con-full e-flex e-con e-child\" data-id=\"eafb5ac\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8dc9956 elementor-view-default elementor-widget elementor-widget-icon\" data-id=\"8dc9956\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<div class=\"elementor-icon\">\n\t\t\t<i aria-hidden=\"true\" class=\"far fa-window-restore\"><\/i>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3fb2b97 elementor-widget elementor-widget-heading\" data-id=\"3fb2b97\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Format<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8209e1b elementor-widget elementor-widget-text-editor\" data-id=\"8209e1b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\tInstructor-led training with explanations and many hands-on SQL exercises\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-83d8463 e-con-full e-flex e-con e-child\" data-id=\"83d8463\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[],&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t<div class=\"elementor-element elementor-element-2b6995b e-con-full e-flex e-con e-child\" data-id=\"2b6995b\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3fafbf5 elementor-view-default elementor-widget elementor-widget-icon\" data-id=\"3fafbf5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<div class=\"elementor-icon\">\n\t\t\t<i aria-hidden=\"true\" class=\"fas fa-clock\"><\/i>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3ae3e6f elementor-widget elementor-widget-heading\" data-id=\"3ae3e6f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Duration<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d9db415 elementor-widget elementor-widget-text-editor\" data-id=\"d9db415\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t2 days\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1ba2bce e-con-full e-flex e-con e-child\" data-id=\"1ba2bce\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[],&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t<div class=\"elementor-element elementor-element-b4239ac e-con-full e-flex e-con e-child\" data-id=\"b4239ac\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2294f2e elementor-view-default elementor-widget elementor-widget-icon\" data-id=\"2294f2e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<div class=\"elementor-icon\">\n\t\t\t<i aria-hidden=\"true\" class=\"fas fa-map-pin\"><\/i>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-06608e6 elementor-widget elementor-widget-heading\" data-id=\"06608e6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Delivery<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-784cc87 elementor-widget elementor-widget-text-editor\" data-id=\"784cc87\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\tOn-site or virtual (with shared DB \/ training environment)\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1e4382b e-con-full e-flex e-con e-child\" data-id=\"1e4382b\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[],&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t<div class=\"elementor-element elementor-element-e6decc4 e-con-full e-flex e-con e-child\" data-id=\"e6decc4\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-683dfa0 elementor-view-default elementor-widget elementor-widget-icon\" data-id=\"683dfa0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<div class=\"elementor-icon\">\n\t\t\t<i aria-hidden=\"true\" class=\"fas fa-lightbulb\"><\/i>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5baa700 elementor-widget elementor-widget-heading\" data-id=\"5baa700\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Prerequisites<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f4a4b4a elementor-widget elementor-widget-text-editor\" data-id=\"f4a4b4a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<ul><li>Basic understanding of your operational\/logistics processes<\/li><li>Basic knowledge of SQL query language advised<\/li><\/ul>\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<\/div>\n\t\t<section class=\"elementor-element elementor-element-104839d e-con-full top-border-beam e-flex e-con e-child\" data-id=\"104839d\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-fb220b2 e-con-full e-grid e-con e-child\" data-id=\"fb220b2\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-958081e e-con-full e-flex e-con e-child\" data-id=\"958081e\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[],&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t<div class=\"elementor-element elementor-element-11e160a e-con-full e-flex e-con e-child\" data-id=\"11e160a\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;slideshow&quot;,&quot;jet_parallax_layout_list&quot;:[],&quot;background_slideshow_gallery&quot;:[{&quot;id&quot;:175607,&quot;url&quot;:&quot;https:\\\/\\\/epg.com\\\/wp-content\\\/smush-webp\\\/EPG_AURA-Observer_Webcam-View-1.jpg.webp&quot;},{&quot;id&quot;:175592,&quot;url&quot;:&quot;https:\\\/\\\/epg.com\\\/wp-content\\\/smush-webp\\\/EPG_AURA-Observer_Webcam-View-3.png.webp&quot;},{&quot;id&quot;:175577,&quot;url&quot;:&quot;https:\\\/\\\/epg.com\\\/wp-content\\\/smush-webp\\\/EPG_AURA-Observer_Webcam-View-2.png.webp&quot;}],&quot;background_slideshow_slide_duration&quot;:2500,&quot;background_slideshow_ken_burns&quot;:&quot;yes&quot;,&quot;background_slideshow_loop&quot;:&quot;yes&quot;,&quot;background_slideshow_slide_transition&quot;:&quot;fade&quot;,&quot;background_slideshow_transition_duration&quot;:500,&quot;background_slideshow_ken_burns_zoom_direction&quot;:&quot;in&quot;}\">\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-748ece1 e-con-full e-flex e-con e-child\" data-id=\"748ece1\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[],&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t<div class=\"elementor-element elementor-element-7333dc2 e-con-full e-flex e-con e-child\" data-id=\"7333dc2\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c093388 elementor-widget__width-inherit elementor-widget elementor-widget-heading\" data-id=\"c093388\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Why Take This Course <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f51a39a elementor-widget elementor-widget-text-editor\" data-id=\"f51a39a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<ul><li>Gain transparency into your operational data and flows between systems<\/li><li>Improve communication between business and IT by understanding \u201ctheir language\u201d (tables, fields, joins)<\/li><li>Speed up troubleshooting and analysis by answering many data questions yourself with SQL<\/li><li>Build a solid foundation for more advanced reporting, BI, and interface-related work<\/li><\/ul>\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<\/div>\n\t\t\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>IT Management Courses Data Flow &amp; SQL \u2013 Understanding System Data and Building Queries Homepage Learn how data flows through your EPG ONE WMS System and how to use SQL to access and analyze that data. This course explains key database concepts, typical data structures for EPG ONE WMS, and practical SQL queries so participants [&hellip;]<\/p>\n","protected":false},"author":20,"featured_media":0,"parent":93748,"menu_order":8,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_seopress_titles_title":"IT Management Courses | EPG Academy","_seopress_titles_desc":"","_seopress_robots_index":"","_seopress_robots_follow":"","_seopress_robots_imageindex":"","_seopress_robots_snippet":"","_seopress_robots_primary_cat":"","_seopress_robots_breadcrumbs":"","_seopress_robots_freeze_modified_date":"","_seopress_robots_custom_modified_date":"","_seopress_robots_canonical":"","_seopress_social_fb_title":"","_seopress_social_fb_desc":"","_seopress_social_fb_img":"","_seopress_social_fb_img_attachment_id":0,"_seopress_social_fb_img_width":0,"_seopress_social_fb_img_height":0,"_seopress_social_twitter_title":"","_seopress_social_twitter_desc":"","_seopress_social_twitter_img":"","_seopress_social_twitter_img_attachment_id":0,"_seopress_social_twitter_img_width":0,"_seopress_social_twitter_img_height":0,"_seopress_redirections_value":"","_seopress_redirections_enabled":"","_seopress_redirections_enabled_regex":"","_seopress_redirections_logged_status":"both","_seopress_redirections_param":"","_seopress_redirections_type":301,"_seopress_analysis_target_kw":"","content-type":"","footnotes":""},"class_list":["post-231967","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/epg.com\/us\/wp-json\/wp\/v2\/pages\/231967","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/epg.com\/us\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/epg.com\/us\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/epg.com\/us\/wp-json\/wp\/v2\/users\/20"}],"replies":[{"embeddable":true,"href":"https:\/\/epg.com\/us\/wp-json\/wp\/v2\/comments?post=231967"}],"version-history":[{"count":5,"href":"https:\/\/epg.com\/us\/wp-json\/wp\/v2\/pages\/231967\/revisions"}],"predecessor-version":[{"id":232044,"href":"https:\/\/epg.com\/us\/wp-json\/wp\/v2\/pages\/231967\/revisions\/232044"}],"up":[{"embeddable":true,"href":"https:\/\/epg.com\/us\/wp-json\/wp\/v2\/pages\/93748"}],"wp:attachment":[{"href":"https:\/\/epg.com\/us\/wp-json\/wp\/v2\/media?parent=231967"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}