Posts

Showing posts from March, 2015

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

Hadoop Skills Free Video Training

Are you interested in the world of Big data technologies, but find it a little cryptic and see the whole thing as a big puzzle. The hadoop free video training really useful to learn quickly. Are you looking to understand how Big Data impact large and small business and people like you and me? Do you feel many people talk about Big Data and Hadoop, and even do not know the basics like history of Hadoop, major players and vendors of Hadoop. Then this is the course just for you! This course builds a essential fundamental understanding of Big Data problems and Hadoop as a solution. This course takes you through: Understanding of Big Data problems with easy to understand examples. History and advent of Hadoop right from when Hadoop wasn’t even named Hadoop. What is Hadoop Magic which makes it so unique and powerful. Understanding the difference between Data science and data engineering, which is one of the big confusions in selecting a carrier or understanding a job role. And mos

Trending IT Skills Grab Opportunities

Image
Great demand for Mobile developers and Security professionals. Read my other article on "15 Rapidly Growing IT Jobs". Growing areas are in Internet of things and 3D printing. Then we need to know what is 3D printing? 3D printing is not necessarily transforming IT. It’s that it's a new technology that's transforming other industries like manufacturing and biomedical sectors," Laura McGarrity, vice president of digital marketing strategy for Mondo, told eWEEK. "It does create new job growth within the IT industry. Benefits to consumers include the ability to try and re-work prototypes before going to the market - consumers can expect products made for their specific needs. An excellent growth for Data related and Statistics jobs. Data and statistics are everywhere now, and there is high demand for scientists who can analyze the data," she said. "A data scientist needs to be able to manage data, create predictions, and communicate the res

Poor Data Quality New Job Roles in Data Quality

Image
Data quality is on rising and important to organizations today. Since in Experian research it has found that poor data quality causing losses to the companies. Experian research suggests companies in the UK, the US, Australia, and western Europe have poorer quality data this year than last. The credit information company’s 2015 Global Data Quality Research among 1,239 organizations found a dramatic lack of data quality “ownership”, and 29% of respondents were still cleaning their data by hand. The number of organizations that suspect inaccurate data has jumped from 86% in 2014 to 92%. Also, respondents reckoned 26% of their data to be wrong, up from 22% in 2014 and 17% in 2013. Some 23% of respondents said this meant lost sales, up from 19% in 2013. Boris Huard, managing director of Experian Data Quality, said: “Getting your data strategy right is vital if you want to be successful in this consumer-driven, digitalized age.  It is encouraging that companies are increasing

The story Hadoop data value less in cost than ETL

Image
Traditional data warehouse That isn’t to say that Hadoop can’t be used for structured data that is readily available in a raw format; because it can.In addition, when you consider where data should be stored, you need to understand how data is stored today and what features characterize your persistence options.  Consider your experience with storing data in a traditional data warehouse. Typically, this data goes through a lot of rigor to make it into the warehouse.  Builders and consumers of warehouses have it etched in their minds that the data they are looking at in their warehouses must shine with respect to quality; subsequently, it’s cleaned up via cleansing, enrichment, matching, glossary, metadata, master data management, modeling, and other services before it’s ready for analysis.  Obviously, this can be an expensive process. Because of that expense, it’s clear that the data that lands in the warehouse is deemed not just of high value, but it has a broad purpose: it

Distributed Computing Why it is Popular

Distributed information systems are becoming more popular as a result of improvements in computer hardware and software, and there is a commensurate rise in the use of the associated technologies. Why distributed computing so popular With the increasing desire for business-to-business (B2B) communication and integration, technologies such as Service-Oriented Computing (SOC), Semantic Web, Grid, Agents/Multi-agents, peer-to-peer, etc., are receiving a high level of interest nowadays. Due to the revolution in the internet, implementation of SOC B2B integration (e.g. e-commerce, e-government, and e-healthcare) is popular Where lacking Building Web Services comprehensively needs further improvement, for instance, Quality of Service (QoS). Detection of service availability to achieve self-healing in the invocation process Service reuse, how best to define atomic services Service composition Future computing Meanwhile, it should be noted that Web Services play only a parti

APPIAN, PEGA, Oracle BPM Tools-Career Options

Gartner recently broadened the definition of BPM, recasting it as a management practice that provides for governance of a business's process environment toward the goal of improving agility and operational performance. Business Process Management This more holistic view offers a structured approach for optimizing processes and takes into account the software tools discussed above as well as an organization's methods, policies, metrics, and management practices. According to Gartner, BPM is about becoming a process-managed organization, which requires the following disciplines (in addition to Information Technology. Appian BPM is a business process management solution that can help users to manage work automation, business processes and social collaboration across the enterprise for customers, employees, and systems. General Skills Need for a BPM developer BPMN  JavaScript  SQL  HTML  CSS  SOAP  Web services standards  XML  XPATH  XSLT  LDAP/AD