Posts

Showing posts with the label iot developer

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

Best Skills You Need to Become an IoT Developer

Image
The Internet of things is a new subject. In this area lot of development is going on. Recently, AWS ( Amazon web services ) developed a platform for the Internet of things. I want to share with you the best skills you need to become an IoT developer. Skills You Need to Become an IoT developer This is a big Question for IT freshers or experienced IT professionals what technologies they need to learn to start a career in this line.  As a general rule, I have found the following are general requirements for the Internet of things ( See Internet of things jobs here ). Java + multiple programming languages (Objective-C, C++), and interest in technologies such as Ruby, Scala, Clojure, Groovy, etc. Experience in javascript libraries in any combination of the following areas: jQuery, AngularJS, Backbone.js, Ember.js, Node.js, GWT Development experience in open source projects, especially large scale projects a plus. Experience developing at-home projects used by a medium to large size au