What are SQL Programming Basics? (Part 2 of 8)

=============================

▶ Check out the full blog post over at

=============================

The world of data is constantly changing and evolving every second. This has, in turn, created new growth and challenges for companies around the world.

Manufacturing sites and large facilities can generate a large amount of process data that is stored in databases, which are used as data sources for reports.

At some point in time in your Automation career, sooner than later, you will be required to develop, manage and/or interface to a database of some type.

In this video, you will learn about relational databases and about the language of SQL.
In subsequent videos we will apply what we have learned in this training video, to view a sample database and program a few SQL queries to read and write to the database that will provide specific organized data.

There are many types of database structures. One of the most popular database management systems is called Relational Database Management System or RDBMS, because of the simplicity of operation and ease of use.

Data is generally stored in tables and they are usually manipulated through the use of Structured Query Language or SQL.

Some systems that use relational database management includes
– Oracle
– IBM
– Microsoft SQL Server
– MySQL
among many others.

An important tool for automation is to historically log data to a historian database, often a SQL database.

The process or manufacturing historian software will collect data using several sample methods that are based on
– Time-interval
– Event-based
– On-scan or based on an expression algorithm.

Typically in a historian, tag names identify the source of numerical or string type data derived from process automation controllers.

Whether you choose to analyze a tank level, tank temperature, tank pressure or even a control valve, the user can evaluate its operation, efficiency, profitability, and setbacks of production.

One example of what might be recorded in a data historian include:
Analog values such as
– Temperature
– Pressure
– Flow rates
– Levels
– Weights

Within a relational database, there are tables.
Each table will be identified by a unique name and the name will be used by the database to find the table behind the scenes.
All you need to know as a user is the table name in order to use it.

This ease of interaction is what placed the relational database model to gain wide acceptance.
The most common SQL databases in manufacturing are Microsoft SQL Server and MySQL.

In our example we will be using MySQL, it’s an open and free database that many OEMs are using.

SQL is used to communicate with a database. It is the standard language for relational database management systems.

We create SQL statements to perform tasks such as update data on a database or retrieve data from a database.

The standard SQL statements such as
– Select
– Insert
– Update
– Delete
– Create
– Drop
can be used to accomplish just about everything that you’ll need to do with a database.

The select statement is used to query the database and retrieve selected data that match the criteria that you specify.

The column names that follow the SELECT keyword, determine which columns will be returned in the results.

The table name, that follows the keyword “FROM”, specifies the table that will be queried to retrieve the desired results.

It is worth mentioning that we can select as many column names that we'd like, or we can use a "*", to select all columns.

=============================

Review the MySQL minimum hardware requirement web page here:

Download the MySQL Installer:

Download the sample database SQL file from here:

=============================

Missed our most recent videos? Watch them here:

=============================

To stay up to date with our last videos and more lessons, make sure to subscribe to this YouTube channel:

=============================

TWEET THIS VIDEO

=============================

#RealPars #SQL #MySQL

[nishaddhumal]

First of all I would like to thank you sir for giving the details information through this channel. Each and every topic is very clearly explained and that too in very interactive manner. Looking forward for many more such kind of videos.

[MaNemUmar]

Very happy to see databases being touched upon! I recently started working at a Mine Site using Ignition for their plant wide SCADA and do sometimes have to modify/troubleshoot any SQL we use for our asset management/diagnostics related purposes. The more advanced videos later on should help me out a ton !

[beerguy]

Great, timely, and current topics. As companies look to automate operational efficiency data management is key!! Great job. Look forward to the rest!

[Denial]

Thanks a lot! What a coincidence! Me and my colleague had to figure out how to move an SQL database of GE Cimplicity project from an old server to a new one. And you put out a video about sql, cool

[trancongnguyen]

Thank you so much for this video, I have been looking around recently

[edgarngujo]

i see realpars, , i click 👍, , So thankful for RP's team effort to share their IT's expertise and wisdom.

[robertovelazquez]

Very useful information. Thanks a lot.

[riadhtn]

At the right time ! Just started to work on this :)

[aadilferoze]

Truly great stuff, very important for Automation Engineers in today's world!

[koushickdon]

I want to learn more about SQL. Kindly upload more videos frequently.

[tiberiumelinte]

This is exactly what I need for my school project

[sattara]

Thank you for this vedio, I wanna know more about SQL training, please.

[DSNCB]

I needed this... I've gotten solid on hardware at my job but when asked about metadata and sql database etc it's like their speaking Chinese

[lkatgiaiphapdieukhien]

Maybe next time you need to explain from Data Historian, how can the data flow to SCADA and MES (via OPA) and finally ERP. THat would be much more useful. THanks

[hectorenriquesantandermeza]

Thank you Real Pars! So, it is very important for an Automation Engineer to have high SQL programming skills?

[javaec]

Hello, first of all i would to thank you sir for this work i have a request i wanna to know how do you make this animation (that by POWER POINT OR anothor application )

[jenishthumar]

Please make some videos on servo motion controllers.

[khalidmabrouk]

IS IT POSSIBLE TO CONNECT PLC TO SQL WITHOUT SCRIPT?