Posts

Showing posts from January, 2016

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"

5 Things Mainframe Programmers Must Know About NetCOBOL

Image
NetCOBOL is an open platform COBOL development environment which takes advantage of the features of mainframe COBOL. It is ready for the latest technology and a state-of-the-art environment as well. NetCOBOL is a trademark or registered trademark of Fujitsu Limited. NetCOBOL NetCOBOL It is available in both 32 bit and 64 bit  Net COBOL claims compatibility with other COBOL Compilers like VS COBOL, OS/VS COBOL and Micro Focus COBOL.  Provides a debugger and complete integrated development environment(IDE) with COBOL.  Provides IP tools like Power COBOL (These tools help Developer to build Windows biased GUI Apps) and PowerBsort.  It supports databases like Microsoft SQL Server, Oracle, and Pervasive SQL.  Claims to support native SQL Calls “EXEC SQL” within Net COBOL.  It supports Betrive Files as well.  Support Both Modern IDE (Eclipse Plugins for Linux and VS IDE plug-in for Windows)  Linux Version of Net COBOL also supports JAVA, C, C++, and Python.  Windows Version

R Language Tutorial for Mainframe Programmers

Why R? It's free, open source, powerful and highly extensible. "You have a lot of prepackaged stuff that's already available, so you're standing on the shoulders of giants," Google's chief economist told The New York Times back in 2009. Free Resources on R Language Part 1: Introduction Part 2: Getting your data into R Part 3: Easy ways to do basic data analysis Part 4: Painless data visualization Part 5: Syntax quirks you'll want to know Part 6: Useful resources Details of R Language Because it's a programmable environment that uses command-line scripting, you can store a series of complex data-analysis steps in R. That lets you re-use your analysis work on similar data more easily than if you were using a point-and-click interface, notes Hadley Wickham, author of several popular R packages and chief scientist with RStudio. That also makes it easier for others to validate research results and check your work for errors -- an issue that

Top Niche Skills You Need for Big Data Career

Image
The following niche skills recruiter looking in Big Data Anaytics professionals: Creativity Analytical Skills Business Analysis Skills Business Intelligence Skills IT Technical Skills Related: Hot IT Skills in 2016

How to Select Programming Language for a Project

The choice of a programming language is often dictated by other real-world constraints such as cost, availability, training, and prior investment, or even emotional attachment. Since these aspects are highly variable, it seems a waste of time to consider them much for this comparison. Top Listed Programming Languages: - Python - Java - Perl -JavaScript - Tcl - SmallTalk -C++ Related: 30 High Paying IT Jobs

5 Best Features and Development Model for Agile

Image
In Agile development model each sprint has phases of requirements, design, development and testing. In the development phase, development team concentrates on new features to be developed and unit testing around it. But it misses on the regression of existing working functionality. This leads to defect seepage from Development phase to Test phase. Consequence of it is late defect identification, reporting, fixing and re-verification of the defect. This defect cycle continues till it is fixed. Drawback of Agile The drawback of this approach is project teams put in extra effort of identifying defects and reporting. Late identification of defects also leads to risk of schedule slippage. Here in this article is a mechanism proposed to minimize defect leakage from development phase to testing phase in agile software development life cycle by moving the regressed automated scripts from testing phase to development phase. Related: Agile+Developer+Jobs The advantages of this approac