All Training

June 5, 2024

LOAC - Logistics Operations Applications Course

The Logistics Operations Applications Course (LOAC) course is intended to provide the logistician with an overview of DLA Logistics Operations and instructions on logistics applications. The logistician becomes familiar with the DLA mission and the resources available for logistics planning

June 18, 2024

MEDALS - Military Engineering Data Asset Locator System

The Military Engineering Data Asset Locator System (MEDALS) is a web-based indexing system that provides the ability to locate engineering drawings throughout the Department of Defense (DOD) community. MEDALS serves as the central index for DOD technical data. While MEDALS does not contain digital images of the technical drawings, it does provide the location of the images.

Feb. 3, 2025

SQL Advanced

This is a 2-day course. Day 1 is spent reviewing functions and clauses of SELECT statements covered in SQL BASIC. Day 2 is spent building queries learned in the BASIC class, and gradually adding more complex functions such as Scalar Functions, SUBQUERIES, TABLE JOINS – (Inner, Left Outer, Right Outer, Full Outer, and Cross), COUNT, UNION, and SUBSTRINGS. Exercises involve continuous query building. Attendees will be given 'customer request' scenarios and expected to build queries, the results of which should meet the needs of those customer requests. Discussion will follow each exercise. In preparation for the class, attendees should have access to the DB2 TEST region and DoD 4100.39-M Volume 12.

Feb. 3, 2025

SQL Basic

A three-day course that involves learning the basic language to query the FLIS DB2 database. Day 1 is spent learning (via many hand-on exercises) the relationship between the FLIS TIR (NSN), Volume 12, and the DB2 tables. Day 2 involves learning how to build basic SELECT statements and gradually adding several various clauses and query functions in their proper order to affect desired results. It also covers learning how to manipulate query result with continuous exercises. Day 3 is spent focusing on the versatility of the WHERE clause, Comparison Operators, and the CONCAT, BETWEEN, LIKE, IN, NOT IN, and DISTINCT functions. Constant query construction will be expected based on a variety of situational query requests. In preparation for the class, attendees should have access to the DB2 TEST region and DoD 4100.39-M Volume 12.

June 5, 2024

WebFLIS® - Federal Logistics Information System

The Federal Logistics Information System via the World Wide Web (WebFLIS®) provides read only access to cataloging and supplier information on more than 16 million active and inactive supply items used by the United States (U.S.) Government and North Atlantic Treaty Organization (NATO) allies. WebFLIS® is updated several times daily and provides historical, current, and future effective dated information.

June 5, 2024

WEBVLIPS - Web Visual Logistics Information Processing System

Web Visual Logistics Information Processing System (WEBVLIPS) is a web-based transaction tracking system for open transactions and completed transactions up to 60 days after closure. WEBVLIPS enables customers to track their requisitions or excesses through their entire life cycle. Data from all services, agencies, Inventory Control Points (ICP), depots and vendors is included.