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

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

Predictive Analytics - A Case Study

Nishad Sharma, a Delhi-based entrepreneur, is a typical online shopper who keeps a tab on the various sales and promotional deals run by e-commerce companies from time to time. On the cool Delhi evening of February 4, he opened online fashion company Myntra's app on his smartphone to see if there were any deals on trousers. That day, Myntra was running its Rush Hour sale in which customers could avail up to 50 per cent discount on select products. After filtering his search, Sharma decided to add a pair of UCB trousers to his shopping cart. Predictive Analytics But then he changed his mind. Perhaps he could get a better deal if he logged on into a sale on a weekend. To his surprise, Sharma received a mail from Myntra next morning, telling him what he presumably lost by abandoning his cart the previous day. The same product was now available at a 100 per cent mark-up. To close the sale, the company sent another mail to Sharma a couple of days later, offering a smaller discount of 20

The AI Quick Tutorial Put You on Edge

Image
Artificial intelligence (AI) means different things to different people. Some believe that AI is synonymous with any form of intelligence achieved by nonliving systems; they maintain that it is not important if this intelligent behavior is not arrived at via the same mechanisms on which humans rely. For others, AI systems must be able to mimic human intelligence. How Humans Accomplish Intelligence. No one would argue with the premise that to study AI or to implement AI systems , it is helpful if we first understand how humans accomplish intelligent behavior; that is, we must understand activities that are deemed intelligent in an intellectual, scientific, psychological, and technical sense. For example, if we want to build a robot capable of walking like a human, then we must first understand the process of walking from each of those perspectives; people, however, do not accomplish locomotion by constantly stating and following a prescribed set of formal rules that explain how to t

Robotics These Skills You Need

Image
Robotics is a combination of multiple skills. Out of those many skills similar to B.Tech Electronics skill sets. I am sharing for your quick reference the complete skillset. PROGRAMMING Mat lab - Familiarity with command-line and external functions using MATLAB library; import/export of data; graphing/plotting functions & data; rudimentary animation Python, C / C++ familiarity ROS- Robot Operating System (ROS) - Optional (Good to know) Program Constructs- Sequencing, Selection, Iteration & Recursion Data Organization- Arrays, Lists, Pointers COMPUTERS Tools Productivity: SW (MS Office - Excel / Word / PowerPoint / Project) Operating Systems Windows or Apple-OS - use of personal laptop computer Linux or Ubuntu MATHEMATICS Linear Algebra Inversion, Eigenvalues, Null-Space Linear Differential Eq. Matrix-Algebra & -Manipulation Basic Calculus Derivatives, Gradients, Chain Rule Numerical Integration Basic Computational Implementation, e.g. Runge-Kutta 4 Fourier Analysis Newtonia

5 Ideas to Spark Your Career Growth Quickly

Image
Lot of job prospects are available for cloud computing skill sets. Every analyst firm, from Gartner to IDC to Forrester and many others have released relative numbers claiming that cloud computing will grow revenues in the gazillions over the next five to ten years, creating millions of direct programmer jobs and many new jobs we don't even know about yet. The future of cloud computing It is surely lead the market, since all the digital technologies using cloud computing. So, the prospects are bright. Huge opportunities ahead for cloud computing engineers According to research sponsored by Microsoft, and conducted by IDC in 2012, spending on public and private IT cloud services will generate nearly 14 million jobs worldwide from 2011 to 2015.  And according to the 2012 Gartner CIO Agenda Report, the top three priorities for that year were analytics and business intelligence, mobile technologies, and cloud computing. Read more:   Learn Cloud Regardless of the indu

Cloud Case Study Part-2

Image
Present case study is in Health Care:   Practo Technologies was formed in year 2008. The vision of the company was to make medical information digitally accessible to patients and doctors. With all these features at pleasing price, solutions providers like Practo aimed to create the most efficient healthcare experience for people in India and gradually around the world. The aim was to improve the patient experience for finding and meeting a doctor.   Traditionally the healthcare records were created manually and stored on shelves. Managing of records stored in files traditionally was of not much use. With the evolution of technology, there has been a paradigm shift in the manner the healthcare industry functions.   The medical records are electronically stored and managed. With the acceptance of cloud computing the healthcare patient data is stored at a remote server location on the internet.   The following companies offering CLOUD based health care

Cloud integration two top key methods people follow

Image
ITaaS is the most recent entrant to the IT landscape. It is an efficient delivery method. With the meteoric and mesmerizing rise of service orientation principles, every single IT element is being viewed and visualized as a service that sets the tone for the service era. Two top methods for Cloud integration 1 - Integration as a service (IaaS) It is a budding and distinctive capability of clouds that help in fulfilling internal as well as external business integration requirements. Increasingly, business applications are deployed in clouds to reap the manifold business and technical benefits of using clouds. On the other hand, innumerable mission-critical applications and data sources still remain locally stationed and sustained primarily due to the expressed security concerns associated with hosting them in clouds. The question here is how to create seamless data flow between hosted and on-premise applications so that they work together. The IaaS overcomes these challenge

Analytics on Fly - Read It

Image
The basis for real-time analytics is to have all resources at disposal in the moment they are called for . So far, special materialized data structures, called cubes, have been created to efficiently serve analytical reports. Such cubes are based on a fixed number of dimensions along which analytical reports can define their result sets. Consequently, only a particular set of reports can be served by one cube. If other dimensions are needed, a new cube has to be created or existing ones have to be extended. In the worst case, a linear increase in the number of dimensions of a cube can result in an exponential growth of its storage requirements. Extending a cube can result in a deteriorating performance of those reports already using it. The decision to extend a cube or build a new one has to be considered carefully.  In any case, a wide variety of cubes may be built during the lifetime of a system to serve reporting, thus increasing storage requirements and also maint