LabVIEW with SQL and MySQL: Data Logging and Industry app.

Name: LabVIEW with SQL and MySQL: Data Logging and Industry app.
Rating: 4.0 (12 reviews)

A Practical Guide to Building Data-Centric Automation Systems with LabVIEW and MySQL

Created byDr. Salim Khan

Last updated 1/2026

English

What you'll learn

Understand the fundamentals of integrating LabVIEW with relational databases
Set up and configure a MySQL database for industrial data logging
Acquire real-time data from sensors or simulated inputs in LabVIEW
Insert, retrieve, and update data in MySQL using SQL queries within LabVIEW
Design real-time dashboards, graphs, and control panels for industrial systems
Apply best practices for data structure, performance tuning, and error handling

Course content

5 sections • 15 lectures • 3h 22m total length

Introduction12:07
Explore data-driven laboratory automation with LabVIEW's graphical programming, front panel and block diagram design. Learn to use wires, data types, controls, indicators, and loops to build and debug programs.
Install LabVIEW19:17
Learn to install LabVIEW on Windows, macOS, or Linux, select the 32-bit core with essential toolboxes, and manage both NI and third-party toolboxes using the NI package manager.

Introduction to Mathematical Expressions19:00
Master the LabVIEW numeric palette to build mathematical expressions with add, subtract, multiply, divide, absolute value, rounding, and compound functions for complex numbers, scaling, and data manipulation.
Introduction to Logical Expressions8:43
Explore basic boolean logic in LabVIEW by building and testing and, or, xor, and not gates with pushbuttons and indicators, and review truth tables and binary conversion concepts.
Introduction Comparison Block15:03
Learn to use LabVIEW's comparison palette to evaluate data with operators such as equal, greater than, and in range. Apply select, max/min, and waveform comparisons in practical data workflows.
Introduction to LabVIEW Structures18:16
Master LabVIEW structures by exploring for loops, while loops, finite execution, indexing and auto-indexing, nested loops, case structures, sequences, formula nodes, and local and global variables.

Database Management System10:24
Distinguish relational SQL databases from NoSQL models and learn how data becomes information and knowledge within a DBMS, including schema, DDL, storage management, and MySQL.
SQL using APEX Oracle13:26
Use Oracle apex to create a free workspace, set up a sample database, and practice sql queries like select, from, distinct, and where to explore employees and departments.
SQL using APEX Oracle Hands-on14:10
Learn to use Apex Oracle to run SQL queries, explore department and employee datasets, practice select from multiple tables, use where and distinct, and export CSV or Excel reports.
SQL using APEX Oracle Lec-28:35
Master sql queries with not equal to, less than, and less than or equal to operators to filter employees by job, salary, commission, and department, and learn selecting specific columns.
SQL using APEX Oracle Lec-315:16
Explore how to craft Oracle SQL queries to filter employees by job, salary, and department using or, in, not in, between, and is null or is not null checks.

My SQL Part-116:59
Learn to set up a Microsoft Eskil server management studio, create a database and table, insert and query data, and link the server as a data source.
My SQL Part-212:32
Create a USB 6001 database and a table with time, pressure, voltage, current, and flow using Microsoft SQL Server Management Studio, then feed real-time LabVIEW data into SQL queries.
Create Table8:25
Create a MySQL table from LabVIEW by setting up a class database, configuring the server connection, and inserting sample data with a loop and random numbers.
Retrieve Data9:48
Retrieve data from a live server using the database toolkit; create a database ABC with a table for serial number, name, and marks, then insert and retrieve records.

Requirements

Basic proficiency in LabVIEW (loops, data types, subVIs, front panels)
Understanding of relational database concepts (tables, records, SQL basics)
NI LabVIEW (any version 2016 or later) installed with Database Connectivity Toolkit or equivalent
MySQL Server and MySQL Workbench installed (Windows preferred for compatibility)

Description

In the era of smart manufacturing and industrial digitalization, the ability to acquire, store, and analyze real-time data is critical for operational efficiency and intelligent decision-making. This course, Data-Driven Industry Applications with LabVIEW and MySQL, is designed to bridge the gap between hardware-level data acquisition and enterprise-level data management. It focuses on integrating NI LabVIEW, the industry-standard platform for measurement and automation, with MySQL, a powerful open-source relational database system.

You will learn how to configure LabVIEW to communicate with industrial devices and sensors, acquire real-time data, and systematically log it into a structured MySQL database. Through hands-on examples, you'll also develop SQL query skills to retrieve, update, and analyze data directly from LabVIEW using ODBC connections. Whether you're building a smart energy meter, a production line monitor, or a condition-based maintenance system, this course equips you with the tools and techniques to build reliable, scalable, and intelligent data-driven applications. Perfect for engineers, researchers, students, and industry professionals, this course will transform how you manage and visualize industrial data in real time.

Why Learn MySQL

Consistently ranked the most in-demand skill in recent employer surveys, SQL is a fantastic way to increase your income and boost your professional development. So many companies today use MySQL, including Twitter, Uber, Airbnb, Dropbox, Github, Kickstarter, Udemy, Slack, and many others. Unsure about the difference between SQL and MySQL? MySQL is the most popular open-source SQL database out there, so it’s an excellent choice to begin your learning journey. We’ll talk a lot more about the difference between SQL and MySQL in the course, but 95% of what you learn about MySQL in this course will apply to other databases such as Postgres, Oracle, and Microsoft SQL Server.

Who this course is for:

People who want to develop programs in LabVIEW with the highest levels of quality based on good practices and development standards with LabVIEW and who seek to achieve work or business with the best technology companies in the world.

LabVIEW with SQL and MySQL: Data Logging and Industry app.

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 31min

Basics of LabVIEW4 lectures • 1hr 1min

Introduction to DBMS5 lectures • 1hr 2min

My SQL using LabVIEW4 lectures • 48min

Quiz0

Requirements

Description

Who this course is for: