Software Training for Oil & Gas ProfessionalsPPDC

Geared towards students already acquainted with SQL programming, this one-day course focuses on advancing their skills to encompass more sophisticated features and techniques. Specifically tailored for Microsoft SQL Server, the course delves into both traditional constructs and recent updates reflecting the language's evolution. Through an interactive format fostering open dialogue and inquiry, participants will deepen their understanding. Additionally, attendees will receive electronic resources including the course presentation, practice databases, and illustrative examples.

COST: $575

DATES

September 10
Time: 8:30 am – 5:30 pm
Location: JEB Jack E. Brown Conference Center    
Midland College Main Campus    
3600 N. Garfield, Midland, TX 79705

Registration

COURSE DETAILS

• ITSE 1043
• 8 Hours, 0.8 CEUs
• Minimum 3 students needed to run course 

This two-day online training, conducted through Microsoft Teams, will provide students with an introduction to the capabilities of ESRI ArcGIS Pro. Participants will gain familiarity with ArcGIS Pro, enhance their understanding of ESRI and GIS workflows, and become proficient in navigating the updated ribbon layouts while exploring essential tools. Through a series of exercises, students will learn to initiate new Pro projects, establish connections to external data sources, craft definition queries, generate custom labels, publish web maps, gain insights into geoprocessing, and more.

COST: $550

DATES

TBA

Registration

COURSE DETAILS

• ENGG 1011
• 16 Hours, 1.6 CEUs
• Minimum 4 students needed to run course

The ability to harness and interpret data has become a game-changer for oil and gas companies looking to increase production, decrease costs, or decrease risks. Accurately and quickly interpreting large volumes of data enables operators to identify causes of downtime, well damage, equipment failures, and cost overruns. Analyzing historical trends puts employees and stakeholders in a position to make decisions rooted in data instead of relying on gut instinct or “what we’ve always done before.”

Power BI is Microsoft’s business intelligence (BI) tool, which has become a leading choice for organizations in all sectors to connect to data, analyze historical trends, and make predictions about the future. Trusted reviewers like the Gartner Magic Quadrant identify Power BI as a Leader in the space, and market share surveys indicate it holds a leading market share position within the Oil & Gas sector specifically.

BI tools use graphical interfaces to make complex analyses possible for a wide range of professionals. Microsoft has leveraged the market dominance of Excel and SQL Server to build a tool that looks familiar to spreadsheet users, but with far more capabilities.

Presented by Zack Warren and Andrea Switzer with Velocity Insight, this course will give students the information they need to start down that path, equipping them with the knowledge and tools needed to perform the kinds of analyses that produce clean, reliable, safe, and affordable energy.

COST: $650

DATES

TBA

Registration

COURSE DETAILS

• ITSC 1091
• 8 Hours, 0.8 CEUs
• Minimum 5 students required to run course

Structured Query Language (SQL) underlies the relational databases that are at the core of most oil and gas software applications. Our introductory one-day course is tailored for students with minimal or no prior SQL experience, guiding them through the fundamentals of this robust and sophisticated language. Through interactive examples and hands-on exercises, participants will grasp both the theory and practical applications of SQL. Focused on Microsoft SQL Server, this course equips participants with electronic copies of the presentation, practice databases, and examples for continued learning and application beyond the classroom.

COST: $475

DATES

August 6
Time: 8:30 am – 5:30 pm
Location: JEB Jack E. Brown Conference Center
Midland College Main Campus
3600 N. Garfield, Midland, TX 79705

Registration

COURSE DETAILS

• ITSE 1043
• 8 Hours, 0.8 CEUs
• Minimum 3 students needed to run course

INTERESTED?

This hands-on course will introduce Python features relevant for oil and gas professionals. Participants will learn the fundamentals of Python syntax by using Python packages to import, manipulate, and visualize data. Attendees will complete a series of exercises via Google Colaboratory -- a cloud-based platform similar to Jupyter Notebooks. Exercises include importing Excel, CSV, and LAS files; connecting to SQL databases; performing calculations on data tables; creating histograms, scatter plots, bar charts, line plots, and maps; and exporting results for use in other softwares.

COST: $500

DATES

TBA

Registration

COURSE DETAILS

• ITSE 1003
• 16 Hours, 1.6 CEUs
• Minimum 5 students needed to run course

This hands-on course will introduce TIBCO Spotfire features relevant for oil and gas professionals. Participants will learn the fundamentals of importing data, creating visualizations, calculating custom properties, and exporting results by building a simple production database and interactive bubble map of the Niobrara Formation in the DJ Basin. By the end of the course, participants will be able to create: (1) Rate-Time and Cum-Time bar, scatter, and line charts; (2) summary tables by well, operator, township, and county; (3) IP and Cum Volume bubble maps with GOR indicators; and (5) rules-of-thumb for exporting quick, readable visualizations for Microsoft PowerPoint.

Requirements: Students need to bring a laptop with TIBCO Spotfire version 10.4+ installed. The software can be downloaded as a trial from TIBCO’s website. The license must be the analyst license not the consumer license.

COST: $500

DATES

TBA

Registration

COURSE DETAILS

• ITSW 1058
• 16 hours, 1.6 CEUs
• Minimum 5 students needed to run course

This hands-on course will introduce existing TIBCO Spotfire users to more advanced features relevant for oil and gas professionals. Participants will learn how to connect to SQL databases; create data connections and sources within their Spotfire library; scrub and extract data sets via data transformations and regular expressions; and use marking, filtering, text areas, hierarchies, and binned columns to create more dynamic visualizations. In addition, attendees will learn how to use TERR and Python data functions for enhanced mapping capabilities and simple decline curve analysis.

Pre-requisites: Participants must have prior experience in Spotfire or attended the TIBCO - Beginner Course.

Requirements: Students need to bring a laptop with TIBCO Spotfire version 10.4+ installed. The software can be downloaded as a trial from TIBCO’s website. The license must be the analyst license not the consumer license.

COST: $625

DATES

TBA

Registration

COURSE DETAILS

• ITSW 1058
• 16 Hours, 1.6 CEUs
• Minimum 5 students needed to run course