Posts

Showing posts from November, 2014

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

Social Media Jobs You need to look in

Image
Social media has transformed the way people socialize, network and stay in touch. Social Media Jobs Social media is more than liking or retweeting a post; it's a new, cutting-edge marketing medium with unlimited potential. According to Constant Contact's Small Businesses: Then and Now Survey conducted in May 2013, social media marketing has exploded, with 87 percent of small businesses using social media as a marketing tool today. Since social media marketing requires a combination of analytical skills, good communication and performing extensive research, you can bet business, communications and English-related degrees are good candidates for 2014 social media job openings. Explore the new frontier of marketing with these six up-and-coming social media positions: Search engine optimization (SEO) specialist Social media strategist Online community manager Social media marketing manager Social media marketing coordinator Blogger or social media copywriter

Cloud Security rules top book to read it now

Image
The Cloud Security Rules explains the different aspects of cloud security to business leaders, CxO's, IT-managers and decision makers. The security principles are the same as before while the implementation and the risks involved are dramatically changed. The book is co-authored by some of the most recognized security specialists and bloggers in the world. The authors are gathered from USA, Europe and Africa, sharing their great knowledge of implementing and securing the cloud. This book is made to help it easier for you to choose the right cloud supplier as well as setting up and running your critical services in the cloud. 1. Questions you will find answers about include Do I have to accept that standard SLA? What should an SLA include? What standards should I be paying attention to, if any? How do I treat mobile workers, and how do they fit into the cloud? Do I really need to care about logging? 2. Other Stuff You Will Learn Many more! Since the cloud co

6 Worth-it Cloud Security Courses

Image
Cloud security is critical to run cloud-applications. I have shared few courses useful for cloud security. To get a job you need good training. Security courses are currently hot in the market. Cloud Security Hands-On Trainin g: This course provides a solid foundation in cloud security, and includes a full day of hands-on labs to apply the principles in practice. We cover all the material needed to pass the Cloud Security Alliance Certificate of Cloud Security Knowledge (CCSK) exam, but add a pragmatic approach to immediate kick start your cloud security projects. For Black Hat we also add expanded material to show you how to take cloud security to the next level by leveraging DevOps techniques and the characteristics of the cloud. Cloud Security Fundamentals : An overview of security issues within each of these models will be covered with an in-depth discussion of the risks involved. This cloud security training course will go in-depth on architecture and infrastruc

Top IT Skills 2015

Image
IT spending for security technologies will increase 46% in 2015, with cloud computing increasing 42% and business analytics investments up 38%. Enterprise investments in storage will increase 36%, and for wireless and mobile, 35%. IT spending for security technologies will increase 46% in 2015, with cloud computing increasing 42% and business analytics investments up 38%. Cloud computing initiatives are the most important project for the majority of IT departments today (16%) and are expected to cause the most disruption in the future. IDG predicts the majority of cloud computing’s disruption will be focused on improving service and generating new revenue streams. These and other key take-aways are from recent IDG Enterprise research titled Computerworld Forecast Study 2015. The goal of the study was to determine IT priorities for 2015 in areas such as spending, staffing and technology.  Computerworld spoke with 194 respondents, 55% of which are from the executive IT roles. 1

Tech Mahindra Launched Big data platform

Image
Tech Mahindra has announced the launch of Usage Based Insurance (UBI), a big data and predictive analysis driven platform for auto insurers. It allows them to adjust premiums according to actual usage patterns of individual drivers instead of industry averages. UBI Platform The platform is flexible to fit to the growing needs of global insurance enterprises, where the market is expected to grow $100 billion plus by the end of the decade. The solution utilizes the capabilities of Tech Mahindra and AT and T in the areas of multi-vertical, engineering and infrastructure capabilities. As a result of this, the global insurers can reduce their claim costs by up to 20%,while reducing eligible insured driver premiums up to 40%. This Usage Based Insurance solution is hosted on the seamless AT&T cloud and served through AT and T's global Machine-to-Machine (M2M) capabilities. What is usage based insurance This technology is already being used successfully for both car a

Cloud Security the real challenges you need to look in

Image
You may curious that cloud computing will solve all your problems. In reality, there is security problem. That is- data security problem. I am just explaining my thoughts on data security in cloud. Really many security professional need in future. Data is crucial to any organization. When data leaks into public, organization may collapse and loose its business. Try to understand where we lack on data security.

The best career skills need for Social media platform

Image
#How-to-apply-social-media-analytics-for-all-it-developers Listening -  This one is still very much true, and perhaps even more so. The best social media pros listen the most actively and most aggressively. Pattern Recognition -  This is getting more and more critical as the data and complexity of social continues to ratchet up. Are these posts on our Facebook page a crisis in the making, or just noise? Where are the real-time marketing opportunities?  Instantly identifying patterns and being able to capitalize upon them  are some of the skills that separate good social practitioners from great ones. Visual Thinking -  This is perhaps the biggest change in the past year or two. Being a great writer was formerly a key characteristic of many social pros, as being able to coherently write in 140 characters isn’t as easy as it appears. Today, with every social network embracing visuals and multi-media,  being able to represent the brand visually is absolutely critical.  This i

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