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

4 Top Upcoming IoT Applications

New types of applications now part of Vehicle and the smart-house, in which appliances and services that provide notifications, security, energy-saving, automation, telecommunication, computers, and entertainment into a single ecosystem with a shared user interface.

4 Top Upcoming IoT Applications

Four Top IoT Applications

Developing technology in Europe right now—demonstrating, testing, and deploying products—it will be much nearer to implementing smart environments by 2022.
  • In the future, computation, storage, and communication services will lead. Those are:
  • Smart objects
  • The machines, platforms, and the surrounding space (e.g., with wireless/wired sensors, M2M devices, RFID tags, etc.) will create a highly decentralized pool of resources (up to the very edge of the “network”) interconnected by a dynamic network of networks.
  • The “communication language” will be based on interoperable protocols, operating in heterogeneous environments and platforms.
Sources
  1. European market potential for integrated internet of things and big data services

Comments

Popular posts from this blog

How to Fix datetime Import Error in Python Quickly

Explained Ideal Structure of Python Class

How to Check Kafka Available Brokers