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

Java in Digital Applications Real Usage

Recently I found, some of my friends refreshing Java language skills. I asked them why.

They told me many digital applications need proficiency in Java skill.

Java is the top skill, and popular in customization of all the tools involved in digital applications. 

From the above conversation, I can say that at least core Java everyone should be proficient. In addition to that, Java once upon a time popular as web development language.Since Java is being used in all modern applications. 

Of course, there are many other popular languages. Those are Python and Scala.

 

Top List of  Java Applications
  1. Robotic process automation-Daily activities in any offices can be automated with Robotic process automation. Java is the language in this scenario to write backend scripts.
  2. Artificial Intelligence-Each AI application involves some sort of programming logic. Where it validates user input and sends back output. The backend logic often is written in Java.
  3. Full stack development-In this area, web development modernization, and maintenance jobs are more. So to work on these applications you need Java. Java is popular for the past two decades, and many applications already are written using it.
  4. Migration to cloud-The tools involved is CloudFormation need skills in Java. Since all the customizations need proficiency in basic Java.
  5. Blockchain-One of the top platforms. People are using for financial applications where transactions are prone to fraud The script to write in Blockchain needs Java skills.

Related

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