Posts

Showing posts with the label DevOps learning tips

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

How Does DevOps Speeds up Delivery

Image
The DevOps is basically a Software development system and most popular in Cloud computing. On-device software and storage may not be pass just yet, but it’s getting there, as more and more computing processes are taking place in the cloud. How Does DevOps Speeds up Delivery Many companies are also preferring distributed computing, which allows multiple computers to network with one another to solve a task (and, unlike the cloud, gives companies control over the actual hardware involved). Many of the skills involved with cloud computing and distributed computing are related, so the two are often grouped together: Skills to learn include SQL for database management, programming languages like Ruby, JavaScript, and Python for building cloud-based applications, and DevOps (a software development system popular in the cloud computing field). Specific in-demand programs include Microsoft Azure and Amazon Web Services. Also Read: 2017 Fast Growing IT Skills For instance, Agile, Scrum, C