Posts

Showing posts with the label industrial iot

Featured Post

SQL Interview Success: Unlocking the Top 5 Frequently Asked Queries

Image
 Here are the five top commonly asked SQL queries in the interviews. These you can expect in Data Analyst, or, Data Engineer interviews. Top SQL Queries for Interviews 01. Joins The commonly asked question pertains to providing two tables, determining the number of rows that will return on various join types, and the resultant. Table1 -------- id ---- 1 1 2 3 Table2 -------- id ---- 1 3 1 NULL Output ------- Inner join --------------- 5 rows will return The result will be: =============== 1  1 1   1 1   1 1    1 3    3 02. Substring and Concat Here, we need to write an SQL query to make the upper case of the first letter and the small case of the remaining letter. Table1 ------ ename ===== raJu venKat kRIshna Solution: ========== SELECT CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name, 2))) AS capitalized_name FROM Table1; 03. Case statement SQL Query ========= SELECT Code1, Code2,      CASE         WHEN Code1 = 'A' AND Code2 = 'AA' THEN "A" | "A

Industrial IoT what GE says to improve Productivity

Image
GE is once a top company in Heavy Engineering. This is to say items related to Thermal Power plants, Turbines, and maintenance. GE had always believed that since it knew the materials and the physics of its jet engines and medical scanners, no one could best it in understanding those machines. GE Industrial Internet  The aim is it should not share its data to third parties.    GE sets up its own IoT center.    GE is in IoT mood.    GE can improve operational efficiency by studying data from its machines like situated India and Russia. This is just an example.  GE is Targetting for Predictive Maintenace Improves industrial productivity Based on criticality productivity will zoom if maintenance carried in-time.