Posts

Showing posts with the label smart cities

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

Smart Cities: 16 Top Job Roles You need to Know

Image
Why IOT skill you need: There are currently 18.2 billion connections to the internet throughout the world, and this will increase to 50 billion by 2020. The amount of data being transmitted via these connections has grown from 3ZB (3,000,000,000,000,000,000,000 bytes) in 2010 to 10ZB (10,000,000,000,000,000,000,000 bytes) this year, and it is predicted to reach 40ZB (40,000,000,000,000,000,000,000 bytes) by 2020. New Type of Skills Internet of everything has the potential to reach $19 trillion of value by 2022, and it "has the potential to grow global corporate profits by 21% in 2022".It's exponentially increasing. In a smart city, "every single sector has to get technology fluent and it has to get digital fluent to drive long-term prosperity,". This is an issue that both the public and private sectors need to get behind and to transform how they think and how to get people ready for the jobs to solve these problems. "We need new types of skills , ne