Posts

Showing posts with the label advantges

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

Blockchain Technology: 11 Exclusive Benefits

Image
Here are the benefits of blockchain technology. Less maintenance and its distributable nature made the blockchain technology hot in the market.     The applications that used blockchain technology Viz: Banks, Share markets, Government Bodies, and Big Corporations.  What is Blockchain Blockchain stores each transaction in Blocks. No one can tamper or change the details. The people who are making a transaction in the Blockchain world both have the same copies. he parties involved cannot changes these records. So it is robust. Advantages of distributed ledger technology (Blockchain) The distributed nature of ledger details. Distributed data available to all parties, and cannot tamper the data. Every transaction is Public. That means only people who have access can see the information. It stores all records permanently. One cannot edit or manipulate the data. Data-hacking is not possible since it is distributed. Unlike centralized processing, the Blockchain is much faster. And verification