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

PL/SQL Sample code and error handling mechanism

SAMPLE PL/SQL CREATE TABLE dummy ( dummy_value VARCHAR2(1)); DECLARE -- Define local variable. my_string VARCHAR2(1) := ' '; my_number NUMBER; BEGIN -- Select a white space into a local variable. SELECT ' ' INTO my_string FROM dummy; -- Attempt to assign a single white space to a number. my_number := TO_NUMBER(my_string); EXCEPTION WHEN no_data_found THEN dbms_output.put_line('SELECT-INTO'||CHR(10)||SQLERRM); END; / Output and Error: The program returns the following output, which illustrates formatting user- defined exceptions.  The CHR(10) inserts a line return and provides a clean break between the program's SQLCODE and SQLERRM messages: RAISE my_error SQLCODE [1]  SQLERRM [User-Defined Exception]

Social Media and Mobile Technology for Health care

Image
(People also click these jobs to  know skill set  and to apply  even from your phone!!) The ubiquity of mobile phone accessibility around the world is increasing. Worldwide the number of mobile phones in use grew from fewer than 1 billion in 2000 to around 6 billion in 2012. Recent estimates conclude that over 75% of the world' s population have access to a mobile phone (World Bank, 2012). Globally, there has been a rapid rise in the use of smart phones by consumers with over 1 billion Smart Phones subscribers (Approximately 30% of smartphone users are likely to use wellness apps by 2015, (Bjornland, Goh, Haanæs, Kainu, & Kennedy, 2012) with more than 30 billion mobile applications being downloaded in 2011 (World Bank, 2012). Along with this increase in penetration, there has been a significant increase in the development and deployment of mobile software applications across multiple computing platforms (e.g. smart phones, tablets and laptops). The most pop

Networking in IoT age for big opportunities (1 of 3)

Networking is common in the age of IOT. The basics I want to say are networking means connecting objects together. The networking is possible with wires and without cables. The without cables you can say as wireless. How Computers Connected Computers are connected by using fiber cables. Each computer is connected by cable to a central switch, which connects to the rest of the network   The advantage of wireless networking is no cables required. In a wireless network, most cables and switches are moot. Radio transmitters and receivers take the place of cables. Networking software must be installed. This drives networking functioning. Benefits of network To share resources Sharing information Sharing applications

Differences: Data Center Vs. Telecom Networking

Image
Data Center Networking Data Center (DC)-based services are emerging as a relevant source of network capacity demand for service providers and telecom operators. Cloud computing services, Content Distribution Networks (CDNs), and, generally, networked applications have a huge impact on the telecom operator infrastructure. New trends The Cloud computing paradigm provides a new model for service delivery where computing resources can be provided on-demand across the network. This elasticity permits the sharing of resources among users, thus reducing costs and maximizing utilization while posing a challenge towards an efficient cloud-aware network. The computing resources can be provided on-demand depending on the user requests. Such resources can be allocated on distinct servers into a data center, or through data centers distributed in the network. Under this new model, the users access their assigned resources, as well as the applications and services using them, through telecom o

Cloud Storage as a Service Basics (2 of 3)

The really awesome point is cloud storage. Yes, you are storing data in cloud. But you need to understand here few good things about it.   What is cloud storage... Cloud storage involves exactly what the name suggests—storing your data with a cloud service provider rather than on a local system. As with other cloud services, you access the data stored on the cloud via an Internet link. Even though data is stored and accessed remotely, you can maintain data both locally and on the cloud as a measure of safety and redundancy.  Cloud storage has a number of advantages over traditional data storage : The benefits.. If you store your data on a cloud, you can get at it from any location that has Internet access.  This makes it especially appealing to road warriors.  Workers don’t need to use the same computer to access data nor do they have to carry around physical storage devices.  Also, if your organization has branch offices, they can all access the data from the cloud p

How to achieve Virtualization in cloud computing real ideas

In order to run applications on a Cloud, one needs a flexible middleware that eases the development and the deployment process. Middleware Approach to Deploy Application on Cloud GridGain provides a middleware that aims to develop and run applications on both public and private Clouds without any changes in the application code.  It is also possible to write dedicated applications based on the map/reduce programming model. Although GridGain provides a mechanism to seamlessly deploy applications on a grid or a Cloud, it does not support the deployment of the infrastructure itself. It does, however, provide protocols to discover running GridGain nodes and organize them into topologies (Local Grid, Global Grid, etc.) to run applications on only a subset of all nodes. Elastic Grid infrastructure provides dynamic allocation, deployment, and management of Java applications through the Cloud.  It also offers a Cloud virtualization layer that abstracts specific Cloud computing provide

Big data: Quiz-1 Hadoop Top Interview Questions

Image
In this post, I have given a Quiz on Big data with answers. This is part-1 set of questions for your quick reference. Photo credit: Srini Q.1) How Hadoop achieve scaling in terms of storage? A.By increasing the hard disk capacity of the machine B.By increasing the RAM capacity of the machine C.By increasing both the hard disk and RAM capacity of the machine D.By increasing the hard disk capacity of the machine and by adding more machine Q.2) How fault tolerance with respect to data is achieved in Hadoop? A.By breaking the data into smaller blocks and distributing these smaller blocks into several machines B.By adding extra nodes. C.By breaking the data into smaller blocks and copying each block several times, and distributing these replicas across several machines. By doing this Hadoop makes sure even if the machines are failed the replica is present in some other machine D.None of these Q.3) In what all parameters Hadoop scales up? A. Storage only B. Performan