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

Big Data: Top Hadoop Interview Questions (3 of 5)

Image
1) What are daemons in Hadoop? #Big Data: Top Hadoop Interview Questions: In reality running Hadoop means, running daemons of resident programs in multiple servers of your network. This kind of architecture is called fully configured cluster. 2) How daemons run in Hadoop architecture? Some daemons run in only one server, and others run in more than one server 3) What are the 5 daemons of Hadoop? -Name node -Secondary name node -Data Node -Job tracker -Task tracker 4) How many levels do we classify Hadoop broadly? Broadly we can classify as, it is combination of distributed storage and distributed computation. Also, as Master/Slave architecture 5) Who is the master of HDFS? Name node is the master of HDFS 6) What are the functions of Name node? -Master of HDFS -Directs slave node i.e., Data nodes -Book keeping for HDFS -Monitor overall health of HDFS 7) What is data node? Each slave machine will have Data node daemon.It performs grunt work of distr

Cloud Storage as a Service Basics(1 of 3)

Image
Cloud storage is a model of networked enterprise storage where data is stored in virtualized pools of storage which are generally hosted by third parties. Hosting companies operate large data centers, and customers that require their data to be hosted buy or lease storage capacity from these hosting companies. The data center operators virtualize the resources according to customer requirements and expose them as storage pools, which the customers can use to store data. Physically, the resource may span multiple servers and multiple locations. The safety of the data depends upon the hosting companies and on the applications that leverage the cloud storage. Cloud storage is based on highly virtualized infrastructure and has the same characteristics as cloud computing in terms of agility, scalability, elasticity, and multi-tenancy. It is available both off-premises and on-premises.  While it is difficult to declare a canonical definition of cloud storage architecture, object sto

Big Data:Top Hadoop Interview Questions (2 of 5)

Image
Frequently asked Hadoop interview questions. 1. What is Hadoop? Hadoop is a framework that allows users the power of distributed computing. 2.What is the difference between SQL and Hadoop? SQL is allowed to work with structured data. But SQL is most suitable for legacy technologies. Hadoop is suitable for unstructured data. And, it is well suited for modern technologis. Hadoop 3. What is Hadoop framework? It is distributed network of commodity servers(A server can contain multiple clusters, and a cluster can have multiple nodes) 4. What are 4 properties of Hadoop? Accessible-Hadoop runs on large clusters of commodity machines Robust-An assumption that low commodity machines cause many machine failures. But it handles these tactfully.  Scalable-Hadoop scales linearly to handle larger data by adding more nodes to the cluster.  Simple-Hadoop allows users to quickly write efficient parallel code 5. What kind of data Hadoop needs? Traditional RDBMS having relational

Big Data:Top Hadoop Interview Questions (1 of 5)

Image
Looking out for Hadoop Interview Questions that are frequently asked by employers? Here is the first list of Hadoop Interview Questions which  covers HDFS… 1. What is BIG DATA? Big Data is nothing but an assortment of such a huge and complex data that it becomes very tedious to capture, store, process, retrieve and analyze it with the help of on-hand database management tools or traditional data processing techniques. 2. Can you give some examples of Big Data? There are many real life examples of Big Data! Facebook is generating 500+ terabytes of data per day, NYSE (New York Stock Exchange) generates about 1 terabyte of new trade data per day, a jet airline collects 10 terabytes of censor data for every 30 minutes of flying time. All these are day to day examples of  Big Data! 3. Can you give a detailed overview about the Big Data being generated by Facebook? As of December 31, 2012, there are 1.06 billion monthly active users on facebook and 680 million mobile user

How to talk Airtel Customer Care Executive Directly

Image
Call 121 Then select : 1-6-9 Thanks for reading.

Top Skills You need for Automation Career

Image
According to KPMG -Process automation provides a means to integrate people in a software development organization with the development process and the tools supporting that development.  Successful career you need these Skills. What you will achieve by Automation By automating processes, you can boost your efficiency and help ensure standardized handling of repetitive workflow steps. Organiz ation’s benefits are translation projects that can be realized in a shorter time for less money. Skill set you need: Programming Languages (C++/Java/Scala), OOPs Concepts - MUST Unix/Linux - MUST Automation INDIA Jobs  |  USA Automation developer Jobs Automation Development/Scripting Experience - MUST XML/Xpath - Optional Perl/Python/Shell Scripting - Optional SQL/Sybase/Mongo DB - Optional Web Services - SOAP or REST API - Optional Additional Skills: Puppet/Chef/CFEngine experience  Experience with system packaging tools; e.g. RPM  SQL database programmi

New Directions for Digital Products (1 of 2)

Image
We already crossed Agriculture, Industrial, Information age. Now we are in digitization age. Many companies investing huge money in digitization. Mphasis - is betting on the digitization of Financial institutions Tech Mahindra - started research on Heath care digitization Infosys - focusing on Automation and artificial intelligence TCS - focussing on Machine learning WIPRO - is focusing on Big data and Hadoop What is digitization What we mean by digital. Digital data is distinguished from analog data in that the datum is represented in discrete, discontinuous values, rather than the continuous, wavelike values of analog. Thus, the digitization of data refers to the conversion of information into binary code, allowing for more efficient transmission and storage of data. A key differentiator of our current age from prior human history is that, as of the last decade, we not only convert data to a digital format, but we also create data in a digital format. Thus, we now h