Posts

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

IoT Goals You need before You Implement

The Internet of things is a concept connecting many objects together using powerful protocols as per user requirement. There, in your project, to implement of it you need some objectives are goals. I mean, why you need to develop IoT project. You should get some benefit out of it. Else, no use of spending money on IoT project.  Internet of Things (IoT) is a concept and a paradigm that considers pervasive presence in the environment of a variety of things/objects that through Internet of Things. Converging Technologies wireless and wired connections and unique addressing schemes are able to interact with each other and cooperate with other things/objects to create new applications/services and reach common goals. In this context the research and development challenges to create a smart world are enormous. Why IoT Goals You Need A world where the real, digital and the virtual are converging to create smart environments that make energy, transport, cities and many other

6 Most Popular IoT Protocols Currently Being Used

Image
The below is complete list of Protocols being used in Internet of things projects. CoAP: Constrained Application Protocol.  MQTT: Message Queue Telemetry Transport.  XMPP: Extensible Messaging and Presence Protocol.  RESTFUL Services: Representational State Transfer.  AMQP: Advanced Message Queuing Protocol  Websockets.  Related: Hot IT Skills by Udemy and Dice Conclusion The above list is advanced protocols being used in all machine to machine communication. Useful to know by IoT developers.

Internet of Things Top Communication Protocols

Image
The IoT envisions hundreds or thousands of end-devices with sensing, actuating, processing, and communication capabilities able to be connected to the Internet. These devices can be directly connected using cellular technologies such as 2G/3G/Long Term Evolution and beyond (5G) or they can be connected through a gateway, forming a local area network, to get connection to the Internet. --- The latter is the case where the end-devices usually form Machine to Machine (M2M) networks using various radio technologies, such as Zigbee (based on the IEEE 802.15.4 Standard), Wi-Fi (based on the IEEE 802.11 Standard), 6LowPAN over Zigbee (IPv6 over Low Power Personal Area Regardless the specific wireless technology used to deploy the M2M network, all the end-devices should make their data available to the Internet.  This can be achieved either by sending the information to a proprietary web server accessible from the Internet or by employing the cloud. #The role of protocols in IoT On

4 Upcoming New Protocols in Internet-of-things

Image
#4 Upcoming New Protocols in Internet-of-things: 4 New Protocols recently discussed in IoT conference: 6LoWPAN  for embedded device networking The  Constrained Access Protocol (CoAP) for low-power device communication. The  Time Synchronized Mesh Protocol (TSMP) for saving power in environments with limited wireless bandwidth. RPL, the IPv6 Routing Protocol for Low power and Lossy Networks, for defining and changing routes among devices. Another downside is the lack of Quality of Service (QoS). Making sure that messages are delivered is even more important in the IoT world than it was in the instant messaging world. If your alarm system doesn’t receive the message to turn itself on, then that vacation you’ve been planning could easily be ruined. What is CoAP CoAP is a simple request/response protocol (again, very similar to REST) that follows a traditional client/server model. Clients can make GET, PUT, POST, and DELETE requests to reso

5 Top Internet-of-things Quiz for Software Developers

Image
Internet-of-Things+Jobs+Skills A report from Business Indider- Here are a few of the key findings from the BI Intelligence report: The Internet of Things will be the largest device market in the world. We estimate that by 2019 it will be more than double the size of the smartphone, PC, tablet, connected car, and the wearable market combined. Related: Iot QUIZ from Courseera The IoT will result in $1.7 trillion in value added to the global economy in 2019. This includes hardware, software, installation costs, management services, and economic value added from realized IoT efficiencies. Device shipments will reach 6.7 billion in 2019 for a five-year CAGR of 61%. Revenue from hardware sales will be only $50 billion or 8% of the total revenue from IoT-specific efforts, as software makers and infrastructure companies will earn the lion's share. Related: Introduction to Internet of Things The enterprise sector will lead the IoT, accounting for 46% of device shipments

Old School Guide Data Analyst Responsibilities

Image
The results of your analysis may be super meaningful and obvious to you, but they won’t be to anyone else. That’s because you know what questions you were looking to answer when you set out to do the analysis in the first place. Your Role-You know exactly what data the dataset includes and excludes. Plus you wrote the queries that ultimately produced the visualization or report you’re looking at. That’s a lot of contexts that you need to share in order for other people to understand what the numbers mean. Sharing Results-When sharing the results of your analysis, write out the conclusions you are drawing from the data and what business actions you think should be taken as a result of the analysis (e.g. our conversion decreased with this latest release and we should rollback). Not only do other folks perhaps not have the context to interpret the data correctly, they probably don’t find it as fascinating as you do and may not have the time to derive meaning from the data. Communi

Here is a Quick Way to Know Current Working Directory in R

If R is not finding the file you are trying to read then it may be looking in the wrong folder/directory. If you are using the graphical interface you can change the working directory from the file menu. List of Files and Current Working Directory Related: JOBS in R Language If you are not sure what files are in the current working directory you can use the dir() command to list the files and the getwd() command to determine the current working directory: > dir () [1] "fixedWidth.dat" "simple.csv" "trees91.csv" "trees91.wk1" [5] "w1.dat" > getwd () [1] "/home/black/write/class/stat/stat383-13F/dat"