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

Netezza tool real usage speeds up data analytics

The IBM Netezza data warehouse appliance is easy-to-use and dramatically accelerates the entire analytic process. The programming interfaces and parallelization options make it straightforward to move a majority of analytics inside the appliance, regardless of whether they are being performed using tools from such vendors as IBM SPSS, SAS, or Revolution Analytics, or written in languages such as Java,Lua, Perl, Python, R or Fortran. Additionally, IBM Netezza data warehouse appliances are delivered with a built-in library of parallelized analytic functions, purpose-built for large data volumes, to kick-start and accelerate any analytic application development and deployment. The simplicity and ease of development is what truly sets IBM Netezza apart. It is the first appliance of its kind – packing the power and scalability of hundreds of processing cores in an architecture ideally suited for parallel analytics. Instead of a fragmented analytics infrastructure with multiple systems

Here are 5 Skills You need to Become SAS Data Analyst

Image
Want to know what will happen in the future? Find the most lucrative opportunities? Get insights into impending outcomes? No problem. With our SAS data mining software, you can: SAS Data Analyst. Simplify data preparation. Interact with your data quickly and intuitively using dynamic charts and graphs to understand key relationships. Quickly and easily create better models. Take the guesswork out of building models that are both stable and accurate using proven techniques and a drag-and-drop interface that's both easy-to-use and powerful. Put your best models into service. Fast. Spend less time and effort scoring new data using automated, interactive processes that work in both batch and real-time environments. The requirement varies from company to company. I am giving here the basic skills you need for a SAS data analyst Experience in SAS or R analytics Scripting languages of Python/JavaScript/VB Script SQL and PL/SQL Databases knowledge in Oracle, DB2, SQL Server Hadoop and Big

Information Architect Key Responsibilities

Gartner defines "enterprise information architecture" as that part of the enterprise architecture process. It is a set of requirements , principles and models — the current state, future state, and guidance necessary to flexibly share and exchange information assets to achieve effective enterprise change.  Enterprise information Architect also called EIA. Information Architecture  The transition from information that is isolated within applications to a flexible, comprehensive enterprise information architecture will require changes in technology, process, organizational structure and orientation.  In particular, EA practitioners comfortable with technical architecture must now devote time to understanding this emerging discipline.  Gartner projects that, EA teams will be forced by the business to spend as much time on information architecture as they currently spend on technical architecture.  Changes will also impact a range of disciplines across the organization and will

10 Hot IT Skills great demand Beyond 2020

The below are the highest demanding and high-paying IT jobs in 2016 Wireless Network Engineers can expect a 9.7 percent increase in pay, ranging from $108,750-$150,750, which is the highest increase in starting salary of all IT jobs in our guide! What’s going on here? The general push toward wireless offices and the growth of mobile application development, which requires testing mobile apps in a wireless environment, are just a few reasons for the increased starting pay.  CRM Business Analyst -2015 salary: $84,500-$116,750 -2016 salary (est): $87,500-$126,000 - Percent increase (est): 6.1%  Data Modeler - 2015 salary: $101,750-$145,250 - 2016 salary (est): $106,750-$155,500 - Percent increase (est): 6.2%  Business Intelligence Analyst -2015 Salary: $108,500-$153,000 -2016 Salary (est): $113,750-$164,000 -Percent increase (avg): 6.2%  Data Scientists and Big Data Engineers are both projected to see an 8.9 percent increase in starting pay over 2015, ranging from $109,000-$153,

Big data: Quiz-2 Hadoop Top Interview Questions

Image
I hope you enjoyed my previous post. This is second set of Questions exclusively for Big data engineers. Read QUIZ-1 . Q.1) You have submitted a job on an input file which has 400 input splits in HDFS. How many map tasks will run? A. At most 400. B. At least 400 C. Between 400 and 1200. D. Between 100 and 400. Ans: c QUESTION 2 What is not true about LocalJobRunner mode? Choose two A. It requires JobTracker up and running. B. It runs Mapper and Reducer in one single process C. It stores output in local file system D. It allows use of Distributed Cache. Ans: d,a Hadoop Jobs and Career QUESTION 3 What is the command you will use to run a driver named “SalesAnalyisis” whose compilped code is available in a jar file “SalesAnalytics.jar” with input data in directory “/sales/data” and output in a directory “/sales/analytics”? A. hadoopfs  –jar  SalesAnalytics.jar  SalesAnalysis  -input  /sales/data  -output /sales/analysis B. hadoopfs  jar  SalesAnalytics.jar

How Ruby On Rails Used for Web Development

Image
Since its debut in 2004, Ruby on Rails has rapidly become one of the most powerful and popular frameworks for building dynamic web applications. Everyone from scrappy startups to huge companies have used Rails: 3 7signals, GitHub, Shopify, Scribd, Twitter, LivingSocial, Groupon, Hulu, the Yellow Pages—the list of sites using Rails goes on and on . There are also many web development shops that specialize in Rails, such as ENTP, thoughtbot, Pivotal Labs, and Hashrocket, plus innumerable independent consultants, trainers, and contractors. (Career in Ruby On Rails ) What makes Rails so great? First of all, Ruby on Rails is 100 percent open-source, available under the permissive MIT License, and as a result it also costs nothing to download or use.  Rails also owes much of its success to its elegant and compact design; by exploiting the malleability of the underlying Ruby language, Rails effectively creates a domain-specific language for writing web applications. As a result, many

What is "Learning Algorithm" in Machine Learning

Image
#What is machine learning algorithm Just a basics on Machine Learning Alice has just begun taking a course on machine learning. She knows that at the end of the course, she will be expected to have “learned”all about this topic. A common way of gauging whether or not shehas learned is for her teacher, Bob, to give her a exam. She has done well at learning if she does well on the exam. But what makes a reasonable exam? If Bob spends the entire semester talking about machine learning, and then gives Alice an exam on History of Pottery, then Alice’s performance on this exam will not be representative of her learning. On the other hand, if the  (The general supervised approach to machine learning: a learning algorithm reads in training data and computes a learned function f . This function can then automatically label future text examples .) exam only asks questions that Bob has answered exactly during lectures, then this is also a bad test of Alice’s learning, especially if it