Posts

Showing posts with the label top features

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
Post a Comment
Read more

AWS to Understand EC2 Security

-
Image
Amazon Elastic Computing Cloud, you can call it EC2. Here're EC2 top security features and shared frequently asked interview questions on EC2. Based on your requirement, you can increase or decrease computing power. Before you enable the Autoscaling feature, you need to know its impacts since it's the Administrator's responsibility. AWS to Understand EC2 Security AWS EC2 Making your existing hardware to the requirement always is not so easy. So EC2 service in AWS helps you to allocate computing power according to your needs.  AWS EC2 instance acts as your physical server. It has a memory. You can increase the instance size in terms of CPU, Memory, Storage, and GPU.  EC2 auto scaling is a property, where it automatically increase your computing power. Security Features in EC2 Virtual Private Cloud. The responsibility of Virtual Private Cloud is to safeguard each instance separately. That means, you cannot access other instances, which are already created by other organiz
1 comment
Read more

2 Top Tableau Unique Features

-
Image
Tableau is one of the most popular tools in data analysis. Learning the Tableau gives you so many options in data analysis career. You can download Tableau Software free version here . Get a complete understanding document on how Tableau works here . Read this post for advancing in your Tableau Career. Unique functionality in Tableau Tableau Software was founded on the idea that analysis and visualization should not be isolated activities but must be synergistically integrated into a visual analysis process. Visual analysis means specifically: 1). Data Exploration Visual analysis is designed to support analytical reasoning. The goal of the visual analysis is to answer important questions using data and facts. In order to support analysis, it is not enough to only access and report on the data. Analysis requires computational support throughout the process. Typical steps in the analysis include such operations as filtering to focus on items of interest sorting to rank
Post a Comment
Read more