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

Data Security - Safetly Storing Data In Cloud

Image
What exactly is the cloud? It is basically the collection of computers on the internet that companies are using to offer their services.  One cloud service that is being offered is a revolutionary storage method for your data. From music files to pictures to sensitive documents, the cloud invisibly backs up your files and folders  and alleviates the potentially endless and costly search for extra storage space. An alternative to buying an external hard drive or deleting old files to make room for new ones, cloud storage is convenient and cost-effective. It works by storing your files on a server out in the internet somewhere rather than on your local hard drive.  (For a more technical discussion of cloud computing basics, read more  here .)  This allows  you to back up, sync, and access your data across multiple devices as long as they have internet capability. Read more

Data Analytics Engineers - Salaries

Image
#Data Analytics Engineers - Salaries and career options: Some key skills which are very crucial for an employee these days are the ability to communicate disruptive ideas, multi-disciplinary skills with appropriate depth of specialisation, learnability and resilience," said Prithvi Shergill, chief human resources officer, HCL Technologies, the country's fifth-largest technology company. So, an engineer with 2-3 years' experience working in data analytics can expect a salary of Rs 4-6 lakh in India and $70-80,000 in the US or Europe.  But without big data skills, the same engineer can earn only Rs 3-5 lakh, according to Anurag Gupta, chief operating officer at Magna Infotech, an IT staffing firm. Experience of 5-6 years in data analytics can help an engineer command a salary of up to Rs 10-12 lakh in the domestic market, according to Kamal Karanth, India MD of staffing firm Kelly Services. Firms like IPsoft, Happiest Minds and Mu Sigma, operating in automati

Top course contents to learn in Cloud computing

Image
Top 20 modules or contents must to learn wherever you take course on cloud computing. The list fully analyzed from various sources and finalized. Module 1 Fundamental Cloud Computing: Concepts, terminology, technologies, benefits,  challenges, SLAs and business cost metrics associated with cloud computing are covered, along with SaaS, IaaS, PaaS delivery models, common cloud deployment models, and cloud characteristics. Module 2: Cloud Technology Concepts Cloud Technology Concepts: This course covers a range of topics related to cloud computing mechanisms, cloud security threats and controls, and essential cloud technologies. Also addressed are testing, cloud storage, industry standards, and emerging technologies and trends. Module 3: Cloud Technology Lab Cloud Technology Lab: A hands-on lab during which participants apply practices, mechanisms, and technologies to design cloud-based service architectures in order to solve a set of complex problems. Module 4: Fundamen

SMAC - $1 Trillion Industry By 2020

Image
At least 5-6 lakh people will soon be employed in the space, according to Ganesh Natarajan, CEO, Zensar Technologies The size of the overall SMAC industry globally will be close to $1 trillion by 2020. From the Indian software exporters’ point of view, it will be $15 billion within the next three years, and over $ 225 Billion by 2020. Translating that to people it would mean at least 5-6 lakh people employed in this space by that time. Zensar Technologies has a Digital Enterprise group focusing on digital transformation solutions, where we work with clients in the US, Europe and India to understand what applications can be taken to the Cloud, which is almost 30 per cent of the SMAC opportunity. The second area is Social Listening involving analysis of information on the social media. Zensar provides a service that will enable our clients, especially those who are interacting with consumers directly and often, like insurance companies, retail banks, etc. on how to improve

SMAC-Persistent Systems

Image
The global leader in software product and technology services, today announced it has entered into a definitive agreement to acquire privately-held  CloudSquads , an innovative consultancy that has created social communities for over  70 global companies . CloudSquads deploys, integrates and runs social communities on all leading  social customer platforms .  Terms of the agreement were not disclosed and are subject to certain closing conditions which are expected to be completed in the coming financial quarter. According to  Forrester  Research Senior Analyst, Kim Celestre in her July 9, 2013 blog post entitled Just Published: The Forrester WAVE: Social Depth Platforms, Q3 2013, “Social media has transformed the way that buyers discover, explore, and engage with a brand. As a result, many marketers have invested in establishing a presence on popular social networks like Facebook and Twitter yet are struggling with how to convert interactions on these social networks to a purchase.

Bank ATM Analytics - SAP Hana

Image
Problem: ATM(Automated Teller Machine) has become an integral part of our society. Recent estimates developed by ATMIA place the number of ATMs in use currently at over 2.2 million, or 1 ATM per around over 3000 people in the world. If we think of very specific banks than a recent information in wikipedia states that SBI Group (State Bank Of India) has around 45000+ ATM. So we see the numbers are huge. But there is a very big problem and i would like to use a typical example from India to illustrate this. Here, many times the ATM runs out of currency notes of specific denomination as lets say Rs 100. The end consumer is left with the option of either accepting currency of higher denomination or seek a different ATM. Here we also have a charge applied by the bank if a consumer withdraws money from a ATM of a bank different from the one in which he holds his account. Now this is a major inconvenience for the end consumer and also a loss for the bank as their reputation is effecte

Data Analytics Key Role of NOSQL

Traditional database theory dictates that you design the data set before entering any data. A data lake, also called an enterprise data lake or enterprise data hub, turns that model on its head, says Chris Curran, principal and chief technologist in PricewaterhouseCoopers’ U.S. advisory practice.  “It says we’ll take these data sources and dump them all into a big Hadoop repository, and we won’t try to design a data model beforehand,” he says. Instead, it provides tools for people to analyze the data, along with a high-level definition of what data exists in the lake. “People build the views into the data as they go along. It’s a very incremental, organic model for building a large-scale database,” Curran says. On the downside, the people who use it must be highly skilled Speed of NOSQL Alternatives to traditional SQL-based relational databases, called NoSQL (short for “Not Only SQL”) databases, are rapidly gaining popularity as tools for use in specific kinds of analytic applica