SQL

What is ELK

What is ELK (Elastic search, Logstash, Kibana) ? ELK stack is a combination of 3 open-source products as below, Elasticsearch, a search and analytics engine. Logstash, that index the data to Elasticsearch. Logstash has a config file that has input,filter and output section. Config file looks like json file. Kibana, a visualization tool which provides …

What is ELK Read More »

DevOps vs DevSecOps vs NetOps

What is DevOps vs DevSecOps vs NetOps ? DevOps is the practice of using set of tools, processes and practices to get good agility in software implementation to customers. It combines Dev (software development ) and Ops (information operations). DevOps shortens the development lifecycles and provides Continous Integration & Delivery. DevSecOps is when security features are …

DevOps vs DevSecOps vs NetOps Read More »

Jenkins job vs pipeline

What is Jenkins jobs and Jenkins pipeline ? Jenkins jobs and Jenkins pipeline are essentially same, however pipeline is more staged flow of jobs. For Jenkins pipeline, Jenkinsfile is used.What is Jenkinsfile?Jenkinsfile is a text file placed in the root project directory. The Jenkinsfile has multiple stages like build, unit test, sonar test, functional,  regression, …

Jenkins job vs pipeline Read More »

Top 20 sql interview questions and answers

Top 20 sql interview questions and answers What is DDL, DML, DCL, TCL in SQL ? DDL refers to Data Definition language. DDL is used to create/modify the structure of Database. e.g. CREATE, ALTER, DROP statement.. DML refers to Data Manipulation language. DML is used to retrieve, modify, delete, insert and update data in database. e.g. …

Top 20 sql interview questions and answers Read More »

Summary of SQL

What are the SQL MAX() and MIN() Functions? The MAX() function returns the largest value in the selected column. The MIN() function returns the smallest value in the selected column. SELECT MAX(Weight) AS LargestWeight FROM CricketBats ; SELECT MIN(Weight) AS SmallestWeight FROM CricketBats ; What are the SQL AVG(), COUNT() and SUM() Functions The SQL …

Summary of SQL Read More »

What is AND, OR and NOT Operators in SQL

AND, OR, and NOT operators are combined with the WHERE clause to get the desired filtered results.   e.g SELECT * FROM Users WHERE State =’illinois’ AND City=’Chicago’;   e.g SELECT * FROM Users WHERE City=’Chicago’ OR City=’New York’;   e.g SELECT * FROM Users WHERE NOT State =’Chicago’;

What is SQL WHERE Clause

SQL WHERE clause is used to filter records and its added as below SELECT States FROM Users where Usersgroup = ‘1’; Selenium Tutorial  Karate framework Selenium features Selenium features – what are the main features of selenium. Selenium IDE How to Validate the XPATH is correct in Selenium automation How to take snapshot of browser …

What is SQL WHERE Clause Read More »

What is difference between select and select distinct

What is the difference between select  and select distinct SELECT DISTINCT statement is used for returning only distinct (different) values from a column. SELECT statement is used for returning all the values in the table column. E.g SELECT States FROM Customers;E.g SELECT DISTINCT States FROM Customers; Summary of SQL – Please click here