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

Ideas to Choose Networking Career

Image
Below are key tips and advice from experts to opt in Networking as a career. Networking is basically admin kind of job. Surely, certification and best training help you progress in Networking career. Skills You Need for Networking Career Degree in Engineering CISCO certifications Practical Experience In addition to the above, one needs knowledge of protocols and specifications to survive in this career. References Certification and Career Options in Networking

Spark SQL Query how to write it in Ten steps

Image
Spark SQL example The post tells how to write SQL query in Spark and explained in ten steps.This example demonstrates how to use sqlContext.sql to create and load two tables and select rows from the tables into two DataFrames. The next steps use the DataFrame API to filter the rows for salaries greater than 150,000 from one of the tables and shows the resulting DataFrame. Then the two DataFrames are joined to create a third DataFrame. Finally the new DataFrame is saved to a Hive table. 1. At the command line, copy the Hue sample_07 and sample_08 CSV files to HDFS: $ hdfs dfs -put HUE_HOME/apps/beeswax/data/sample_07.csv /user/hdfs $ hdfs dfs -put HUE_HOME/apps/beeswax/data/sample_08.csv /user/hdfs where HUE_HOME defaultsto /opt/cloudera/parcels/CDH/lib/hue (parcel installation) or /usr/lib/hue (package installation). 2. Start spark-shell: $ spark-shell 3. Create Hive tables sample_07 and sample_08: scala> sqlContext.sql("CREATE TABLE sample_07 (code string

Hyperion: How to Learn as Alternative for Mainframe

Image
Oracle Hyperion is a reporting tool. Its applications are Capital management, Asset planning, Workforce planning and more. Photo Credit: Srini Books to Read on Hyperion The Oracle Hyperion Financial Reporting 11 covers all basics to learn financial reporting using Hyperion tool. The popular contents are Explore Grids and the Point of View Create Functions and Formulas Master Conditional Formatting and Conditional Suppression Create Dynamic Books and Batches Import Reporting Content into MS Office with Oracle Smart View

12 Top Tableau Small Projects for Practice

Image
Tableau is one of the best visualization tools. With Tableau Desktop you can connect to multiple data sources. Tableau Desktop is based on breakthrough technology from Stanford University that lets you drag & drop to analyze data. Best 12 Tableau Exercises: Small Projects for Practice. You can connect to data in a few clicks, then visualize and create interactive dashboards with a few more. We’ve done years of research to build a system that supports people’s natural ability to think visually.  Shift fluidly between views, following your natural train of thought. You’re not stuck in wizards or bogged down writing scripts.  You just create beautiful, rich data visualizations. It's so easy to use that any Excel user can learn it. Get more results for less effort. And it’s 10 –100x faster than existing solutions Keep Reading The 12 Exercises from Tableau Tableau Tutorial

5 Top SEO Optimization Books to Read Today

Image
👉   Maximize Your Social: A One-Stop Guide to Building a Social Media Strategy for Marketing and Business Success Have you been staring at a blank slate without any inspiration for your social media marketing? Do you struggle to find the time and keep up with a consistent social media schedule? If you’ve answered yes to any of these questions, then you’ve come to the right place. This actionable book will help you get organized as you build a regular schedule of relevant, engaging content that will build your social media following. Maybe you're a marketer, a social media manager, or a blogger who wants to cut out the noise by reading one book that will show you how to make the most of your time. You no longer have to wonder where your time is going! As the content marketers at CoSchedule, we’ve personally used every piece of advice in this book. It’s helped us get around 60K followers across our social platforms—and you can experience the same success.  👉   How To Get To The T

Why Learning Python is so useful?

Image
I have recently started learning Python. During my learning time, my friends have asked since you are interested in analytics why you need to learn Python . I explained the below reasons. This is one of the powerful languages after Java. Python is similar to many programming languages that people generally know about:  Python is very similar to JavaScript, Ruby , and PHP in many respects.  Most programmers have a working knowledge of these programming languages and this makes it easier for programmers to learn Python. The basic features of these languages such as the use of arrays, anonymous functions, etc., are also present in Python.    1. Python Machine Learning Libraries: The variety of machine learning libraries that are available in Python is large. One can choose between Scikitlearn, Keras, Theano, and Tensorflow. Many neural network libraries such as Keras, Theano, etc., are exclusively available in Python. So, if you want to do cutting edge machine learning work, you must kno

R Language basics for Beginners to Apply in Analytics

Image
In the early days, a key feature of R was that its syntax is very similar to S, making it easy for S-PLUS users to switch over. While the R’s syntax is nearly identical to that of S’s, R’s semantics, while superficially similar to S, are quite different. Steps to learn R Language In fact, R is technically much closer to the Scheme language than it is to the original S language when it comes to how R works under the hood. Today R runs on almost any standard computing platform and operating system. Its open-source nature means that anyone is free to adapt the software to whatever platform they choose. #R language basics Indeed, R has been reported to be running on modern tablets, phones, PDAs, and game consoles. One nice feature that R shares with many popular open-source projects is frequent releases. These days there is a major annual release, typically in October, where major new features are incorporated and released to the public. Throughout the year, smaller-scale bugfix release