Posts

Showing posts from February, 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

5 AWS Tricky Interview Questions

Image
Below are the top tricky questions asked in AWS interviews 1) How do you store objects in Reduced Redundancy Storage in S3? Specify REDUCED_REDUNDANCY tags in the HTML code. Specify REDUCED_MIRRORING on a PUT request using an optional header. Specify LOW_REPLICATION on a PUT request using an optional header. Specify LOW_REPLICATION on a GET request for objects. Specify REDUCED_REDUNDANCY on a PUT request using an optional header. 2) Which is required to log on to the AWS management console on a mobile device? SSO alias SiteMinder Gateway address IAM token AWS account 3) How do you receive notifications based on the value of a metric being above or below a stated threshold in Amazon CloudWatch? Set Amazon SmartAlert. Log on through the Amazon console. Create an Amazon CloudWatch threshold dashboard. Create an Amazon CloudWatch alarm. Create a DescribeAlarmHistory API. 4) Scenario-You are testing Oracle, SQL Server, and Mongo DB databases in your AWS account to determine which database t

How Linux is Most Popular Operating System

Image
#Why-linux is most popular-operating system Today more than 97 percent of the world's supercomputers (including the complete top 10), more than 80 percent of all smartphones, many millions of desktop computers, around 70 percent of all web servers, a large chunk of tablet computers, and several appliances (dvdplayers, washing machines, dsl modems, routers, self-driving cars, space station laptops...) run Linux.  Linux is by far the most commonly used operating system in the world.  Linux kernel version 4.0 was released in April 2015. Its source code grew by several hundred thousand lines (compared to version 3.19 from February 2015) thanks to contributions of thousands of developers paid by hundreds of commercial companies including Red Hat, Intel, Samsung, Broadcom, Texas Instruments, IBM, Novell, Qualcomm, Nokia, Oracle, Google, AMD and even Microsoft. What is Linux Distribution A Linux distribution is a collection of (usually open source) software on top of a Linux ke

15 Top AI Business Applications

Image
I have shared the top 15 business areas where you can apply artificial intelligence. Real-time Artificial Intelligence Business Applications 1: Medicine Including interpretation of medical images, diagnosis, expert systems to aid GPs, monitoring and control in intensive care units, design of prosthetics, design of drugs. The IntellipathTM pathology diagnosis system has been deployed in hundreds of hospitals worldwide. AI is being increasingly used to provide solutions regarding vector-borne diseases like malaria. 2: Robotics Including vision, motor control, learning, planning, linguistic communication, cooperative behavior. Robots are usually trusted with jobs that are deemed dangerous and sometimes impossible for a human being. Today, many industries use them for jobs that are to be performed with utmost efficiency and without the slightest possible chance of lapse in concentration. 3: Engineering Fault diagnosis, intelligent control systems, intelligent manufacturing systems,

IoT Project in auto industry real guidelines you need to implement

Image
IoT enabling traffic management and control: Cars should be able to organise themselves in order to avoid traffic jams and to optimise drive energy usage. 1# Why IoT in auto industry This may be done in coordination and cooperation with the infrastructure of a smart city’s traffic control and management system. Additionally dynamic road pricing and parking tax can be important elements of such a system. Further mutual communications between the vehicles and with the infrastructure enable new methods for considerably increasing traffic safety, thus contributing to the reduction in the number of traffic accidents. IOT implementation #2 New Opportunities IoT enabling new transport scenarios (multi-modal transport): In such scenarios, e.g. automotive OEMs see themselves as mobility providers rather than manufacturers of vehicles. The user will be offered an optimal solution for transportation from Ato B, based on all available and suitable transport means. Thus, based

Best Acronyms for Different IT Skills

You don’t need to be an IT expert to recruit and hire great technology candidates. Use Dice’s Technical Skills Glossary as your handy reference for easy-to-understand definitions on popular IT skills. Read more here.

Protocols: Top 6 Key Parts

Image
In telecommunications, a protocol is a system of rules that allow two or more entities of a communications system to transmit information. The medium can be any kind of entity.

How to Identify Data Relevant for Data Science Analytics

Your government, your web server, your business partners, even your body. While we aren’t drowning in a sea of data, we’re finding that almost everything can (or has) been instrumented. We frequently combine publishing industry data from Nielsen Book Scan with our own sales data, publicly available Amazon data, and even job data to see what’s happening in the publishing industry. Data is everywhere Sites like Infochimps and Factual provide access to many large datasets, including climate data, MySpace activity streams, and game logs from sporting events. Factual enlists users to update and improve its datasets, which cover topics as diverse as endocrinologists to hiking trails. How the data is growing Much of the data we currently work with is the direct consequence of Web 2.0, and of Moore’s Law applied to data. The Web has people spending more time online and leaving a trail of data wherever they go. Mobile applications leave an even richer data trail since many of them a

The tricky interview questions on IoT to read now

Internet of things is a tricky subject. I have given in this post on tricky interview questions asked for IoT Jobs. I have given simple to understand way. Mobile networks already deliver connectivity to a broad range of devices, enabling the development of innovative new services and applications. Why IoT you need This new wave of connectivity is going beyond tablets and laptops; to connected cars and buildings; TVs and game consoles; smart meters and traffic control; with the prospect of intelligently connecting almost anything and anyone. This is what the GSMA refers to as the “Connected Life”. As the Connected Life evolves, the number of mobile connections worldwide is set to rise dramatically to reach 10.5 billion by 2020, while the total number of connected devices across all access technologies could reach 25.6 billion1 . These devices will bridge the physical and digital worlds, enabling a new category of services that improve the quality of life and productivity of i

4 Top Upcoming IoT Applications

Image
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. 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 European market potential for integrated internet of thin