Posts

Showing posts from February, 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

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

Case Study On Cloud Computing

Image
The concept of cloud computing is in use for many years, but in recent years has it become a highlighted and come in picture. In the year 1990s, cloud computing was developed by major IT providers such as Sun, Microsoft, Google, and Amazon. Cloud computing Different products came into use for different levels of users. The most popular services for end users include web-based email systems (SaaS), e.g. AOL, Gmail, Hotmail, and Yahoo! Mail, and office applications such as Google Docs, Microsoft MS Office Online, Cloud-canvas.com, and Write.fm, etc. Developers can run their programs on the cloud (PaaS) like Google AppEngine , Windows Azure, and Force.com. Companies or organizations store or backup their large data on remote servers (IaaS), for example, Rackspace, Microsoft Azure, Animoto, Jungle Disk and Amazon's EC2 or S3 servers. In 2011, the Primary Research Group (PRG) published a report of its recently conducted survey on library use of cloud computing (Primary Resear

Cloud Storage the real Points You Need to Read Now

Image
There are hundreds of different cloud storage systems, and some are very specific in what they do. Some are niche-oriented and store just email or digital pictures, while others store any type of data. Some providers are small, while others are huge and fill an entire warehouse. In this post, you will know about: Storage in Cloud The inside details of Cloud New things in Cloud Storage Storage of CLOUD One of Google’s data centers in Oregon is the size of a football field and houses thousands of servers.  The inside details of  Cloud Storage At the most rudimentary level, a cloud storage system just needs one data server connected to the Internet.  A subscriber copies files to the server over the Internet, which then records the data.  When a client wants to retrieve the data, he or she accesses the data server with a web-based interface, and the server then either sends the files back to the client or allows the client to access and manipulate the data

Cloud Computing Vs Virtualization Real Differences

Image
Servicing of computing resources you can say as Cloud computing. They charge for some amount each service used by an user. On the other hand, making multiple machines virtually by using same hardware is called virtualization. Sell all the real differences. Public Vs Private Vs Hybrid Cloud Public Cloud:  Available to the public is called the PUBLIC cloud.  Private Cloud : Available to the particular Business/Company is called PRIVATE Cloud.  Hybrid Cloud: Combination of Public and Private Clouds. Cloud Services Related: How Industries will Change due to Cloud Computin g Cloud Services Cloud services (remote data and computation) are exposed as simple and user-friendly web services. For example, Microsoft's ADO.NET (originally called Astoria) provides the tools to expose any data object from a collection, stored in a database or other form, as a URI to an encoded form using a standard such as JSON or ATOM representation Google's AppEngine provides a way

Top Paid Software Jobs

There are eight Software jobs. Those are hot in demand at the same time they pay more package for you. it’s normal for your job hunt to take a few months these days. -From What color is your parachute 1. Business Intelligence Architect The primary responsibility of the business intelligence architect is data standards and procedures; warehousing; design and development of logical and physical data models and databases; distributed data management; information management functions. The business intelligence architect designs, develops and enforces standards and architecture for installing, configuring and using business intelligence applications for the purpose of directing and managing the organization. The role usually requires a bachelor's degree and at least some experience in a BI role. Salary:$81,200 2. ASIC Design Engineer The role produces application-specific integrated circuit (ASIC) designs and modifications by identifying design objectives and issues; rese

Apache Yarn to Manage Resources a Solution

Apache Hadoop is one of the most popular tools for big data processing. It has been successfully deployed in production by many companies for several years.  Though Hadoop is considered a reliable, scalable, and cost-effective solution, it is constantly being improved by a large community of developers. As a result, the 2.0 version offers several revolutionary features, including Yet Another Resource Negotiator (YARN), HDFS Federation, and a highly available NameNode, which make the Hadoop cluster much more efficient, powerful, and reliable.  Apache Yarn Apache Hadoop 2.0 includes YARN, which separates the resource management and processing components. The YARN-based architecture is not constrained to MapReduce. New developmens in Hadoop 2.0 Architecture with YARN:  ResourceManager instead of a cluster manager  ApplicationMaster instead of a dedicated and short-lived JobTracker  NodeManager instead of TaskTracker  A distributed application instead of a MapReduce job  Ba

Career Opportunities in Mobile App Development

Image
Mobile application development one of the hot skills in the digital age. The use of mobile phones and the internet create many job opportunities in the area of mobile application development. The following skill set is required to enter into mobile application development. Mobile Development Career Paths Applications development in multiple platforms. User interfaces design for mobile apps. Marketing for apps which already developed. 1.  Development Career The opportunities are more to develop mobile applications. There are a lot of creative opportunities you can find in this career path.  You will get a chance to develop applications for Android, IoS, and Windows. Nowadays the apps are intelligent and smart. The smartness means those should have user-friendly to the end-users. 2.  User Interface Design The UX or user experience for mobile apps very much needed to be a successful app. The popularity of an app directly related to how well it is designed. Be