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

5 AWS Tricky Interview Questions

Image
Below are the top tricky questions asked in AWS interviews 1) How do you store objects in Reduced Redundancy Storage in S3? Specify REDUCED_REDUNDANCY tags in the HTML code. Specify REDUCED_MIRRORING on a PUT request using an optional header. Specify LOW_REPLICATION on a PUT request using an optional header. Specify LOW_REPLICATION on a GET request for objects. Specify REDUCED_REDUNDANCY on a PUT request using an optional header. 2) Which is required to log on to the AWS management console on a mobile device? SSO alias SiteMinder Gateway address IAM token AWS account 3) How do you receive notifications based on the value of a metric being above or below a stated threshold in Amazon CloudWatch? Set Amazon SmartAlert. Log on through the Amazon console. Create an Amazon CloudWatch threshold dashboard. Create an Amazon CloudWatch alarm. Create a DescribeAlarmHistory API. 4) Scenario-You are testing Oracle, SQL Server, and Mongo DB databases in your AWS account to determine which database t

How Linux is Most Popular Operating System

Image
#Why-linux is most popular-operating system Today more than 97 percent of the world's supercomputers (including the complete top 10), more than 80 percent of all smartphones, many millions of desktop computers, around 70 percent of all web servers, a large chunk of tablet computers, and several appliances (dvdplayers, washing machines, dsl modems, routers, self-driving cars, space station laptops...) run Linux.  Linux is by far the most commonly used operating system in the world.  Linux kernel version 4.0 was released in April 2015. Its source code grew by several hundred thousand lines (compared to version 3.19 from February 2015) thanks to contributions of thousands of developers paid by hundreds of commercial companies including Red Hat, Intel, Samsung, Broadcom, Texas Instruments, IBM, Novell, Qualcomm, Nokia, Oracle, Google, AMD and even Microsoft. What is Linux Distribution A Linux distribution is a collection of (usually open source) software on top of a Linux ke

15 Top AI Business Applications

Image
I have shared the top 15 business areas where you can apply artificial intelligence. Real-time Artificial Intelligence Business Applications 1: Medicine Including interpretation of medical images, diagnosis, expert systems to aid GPs, monitoring and control in intensive care units, design of prosthetics, design of drugs. The IntellipathTM pathology diagnosis system has been deployed in hundreds of hospitals worldwide. AI is being increasingly used to provide solutions regarding vector-borne diseases like malaria. 2: Robotics Including vision, motor control, learning, planning, linguistic communication, cooperative behavior. Robots are usually trusted with jobs that are deemed dangerous and sometimes impossible for a human being. Today, many industries use them for jobs that are to be performed with utmost efficiency and without the slightest possible chance of lapse in concentration. 3: Engineering Fault diagnosis, intelligent control systems, intelligent manufacturing systems,

IoT Project in auto industry real guidelines you need to implement

Image
IoT enabling traffic management and control: Cars should be able to organise themselves in order to avoid traffic jams and to optimise drive energy usage. 1# Why IoT in auto industry This may be done in coordination and cooperation with the infrastructure of a smart city’s traffic control and management system. Additionally dynamic road pricing and parking tax can be important elements of such a system. Further mutual communications between the vehicles and with the infrastructure enable new methods for considerably increasing traffic safety, thus contributing to the reduction in the number of traffic accidents. IOT implementation #2 New Opportunities IoT enabling new transport scenarios (multi-modal transport): In such scenarios, e.g. automotive OEMs see themselves as mobility providers rather than manufacturers of vehicles. The user will be offered an optimal solution for transportation from Ato B, based on all available and suitable transport means. Thus, based

Best Acronyms for Different IT Skills

You don’t need to be an IT expert to recruit and hire great technology candidates. Use Dice’s Technical Skills Glossary as your handy reference for easy-to-understand definitions on popular IT skills. Read more here.

Protocols: Top 6 Key Parts

Image
In telecommunications, a protocol is a system of rules that allow two or more entities of a communications system to transmit information. The medium can be any kind of entity.

How to Identify Data Relevant for Data Science Analytics

Your government, your web server, your business partners, even your body. While we aren’t drowning in a sea of data, we’re finding that almost everything can (or has) been instrumented. We frequently combine publishing industry data from Nielsen Book Scan with our own sales data, publicly available Amazon data, and even job data to see what’s happening in the publishing industry. Data is everywhere Sites like Infochimps and Factual provide access to many large datasets, including climate data, MySpace activity streams, and game logs from sporting events. Factual enlists users to update and improve its datasets, which cover topics as diverse as endocrinologists to hiking trails. How the data is growing Much of the data we currently work with is the direct consequence of Web 2.0, and of Moore’s Law applied to data. The Web has people spending more time online and leaving a trail of data wherever they go. Mobile applications leave an even richer data trail since many of them a