Posts

Showing posts from September, 2018

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

10 Tricky Apache-Storm Interview Questions

-
Image
The storm is a real-time computation system. It is a flagship software from Apache foundation. Has the capability to process in-stream data. You can integrate traditional databases easily in the Storm. The tricky and highly useful interview questions given in this post for your quick reference. Bench mark for Storm is a million tuples processed per second per node. Tricky Interview Questions 1) Real uses of Storm? A) You can use in real-time analytics, online machine learning, continuous computation, distributed RPC, ETL 2) What are different available layers on Storm? Flux SQL Streams API Trident   3)  The real use of SQL API on top of Storm? A) You can run SQL queries on stream data 4) Most popular integrations to Storm? HDFS Cassandra JDBC HIVE HBase 5) What are different possible Containers integration with Storm? YARN DOCKER MESOS 6) What is Local Mode? A) Running topologies in the Local server we can say as Local Mode. 7) Where all t
Post a Comment
Read more

Blockchain Smart Contract The Perfect Example

-
Image
The smart contract in Blockchain is a software application that works without human intervention. Here I have shared the Smart Contract backend process. Smart Contract Mechanism. 1. What is Smart Contract A smart contract is a protocol that can auto-execute, facilitate, verify, or enforce the negotiation of a contract. Agreement between two parties you can say as a contract. Incorporating the rules of the physical contract into the computing world, you can say as a smart contract Blockchain supports you to create smart contracts. Smart Contracts are self-executing programs that run on the blockchain and are capable of enforcing rules Using Blockchain as a platform and making an agreement or contract between more than two parties, you can say as Smart Contract. 2. Traditional Markets  3. Top Benefits of Smart Contract Currently, smart contracts are being used only in Crypto Currencies Now Smart Contracts being used in all financial transactions A smart contract ca
Post a Comment
Read more

Python Matrix Vs COBOL Arrays Top Differences

-
Image
Your most looking information where Python matrix and COBOL arrays differ, in this post, I am giving complete information. The Logic is different in both the languages. The way of definition and accessing element in an array or matrix is different. Python Matrix Vs COBOL Array. In reality both Array and Matrix are the same What are Arrays  Arrays are storing data structure to store data in one or more dimensional form. You can access the data for further processing in your application program. One Dimensional Array  In general, one dimensional array is a row of elements either numeric or Strings separated by commas. Here, each element is separated by comma. This is key concept. >>> a = ['Srini',25,33,42] Two Dimensional Arrays  In the case of Two dimensional array data stored in Tabular form and you can access whichever tuple you want. Real use of multi dimensional array is to give input in Tabular form and can access particular tuple as you want. >>>
Post a Comment
Read more