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

Here are the benefits of blockchain technology. Less maintenance and its distributable nature made the blockchain technology hot in the market.  


Benefits
 
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)

  1. The distributed nature of ledger details.
  2. Distributed data available to all parties, and cannot tamper the data.
  3. Every transaction is Public. That means only people who have access can see the information.
  4. It stores all records permanently.
  5. One cannot edit or manipulate the data.
  6. Data-hacking is not possible since it is distributed.
  7. Unlike centralized processing, the Blockchain is much faster. And verification and completing a transaction are faster.
  8. Unlike centralized processing, it is less expensive. In the centralized system each server in the network charges some amount as a processing fee. Here you can eliminate intermediaries - so less expensive.
  9. The Centralized databases are expensive to carry transactions of low value. The fee to pay intermediaries is more.
  10. The Data in the Blockchain is not editable. In the case of Centralized databases, the Banks or Private Organizations can edit them.
  11. The maintenance of Blockchain is cheaper.

Disadvantages

  • Publish carefully. Once publishes you can't take back

References

Comments

Popular posts from this blog

How to Fix datetime Import Error in Python Quickly

Explained Ideal Structure of Python Class

How to Check Kafka Available Brokers