Introduction to DevOps

Introduction to DevOps...

DevOps is a combination of Development (Software Development) and Operations (Software Productions/IT Operations...)
---------------------------------
1) What is DevOps?

> DevOps is not a technology or tool, it is a concept of behavior, and It is an 
  extension of Agile Methodology...

> The DevOps is a set of practices designed to overcome the gap between 
  development, QA and Operations by effective communication and collaboration,  incorporating continuous integration process with automated deployment. 

> DevOps helps to increase an organization's speed to deliver applications and 
  services. It allows organizations to serve their customers better and compete 
  more strongly in the market.

> There are four basic continuous processes in DevOps:

Continuous Integration
Continuous Delivery
Continuous Testing
Continuous Monitoring
---------------------------------
2) Relationship Between Agile and DevOps

> Agile Development is an umbrella term for several iterative and incremental 
  software development methodologies. 

> The most popular agile methodologies include Extreme Programming (XP), Scrum, Crystal, Lean Development, and Feature-Driven Development (FDD).

> On the other hand, DevOps is about a culture where development, and operations collaborate to give maximum throughput and high-end outcomes. 

> Similar to Agile, there are ways through which DevOps can be implemented such as deep communication and automated deployment. 

> Agile is all about software development while DevOps deals with software 
  development and operations.

Note: Therefore one thing is clear that DevOps is an extension of Agile 
      methodology and it is always fruitful to integrate these two rather than 
      replacing with one another.
---------------------------------
3) DevOps Lifecycle

> DevOps is deep integration between development and operations. Understanding DevOps is not possible without knowing DevOps lifecycle.

Here is a brief information about the Continuous DevOps life-cycle:

i. Development

> In this DevOps stage the development of software takes place constantly. In this phase, the entire development process is separated into small development cycles.  This benefits DevOps team to speed up software development and delivery process.

ii. Testing

> QA team use tools like Selenium to identify and fix bugs in the new piece of code.

iii. Integration

> In this stage, new functionality is integrated with the prevailing code, and 
  testing takes place. Continuous development is only possible due to continuous integration and testing.

iv. Deployment

> In this phase, the deployment process takes place continuously. It is performed in such a manner that any changes made any time in the code, should not affect the functioning of high traffic application.

v. Monitoring

> In this phase, operation team will take care of the inappropriate system behavior or bugs which are found in production.
---------------------------------
DevOps Tutorial For Beginners
4) Software Tools for DevOps

> As DevOps is the collaboration of Development, QA and Operations, it is obvious that a single tool cannot be adequate for all the needs. So there are multiple tools required in each stage to perform all the operations successfully.

Popular Tool for DevOps Automation:

> Git : Version Control System tool
> Jenkins : Continuous Integration tool
> Selenium : Continuous Testing tool
> Puppet, Chef, Ansible : Configuration Management and Deployment tools
> Nagios : Continuous Monitoring tool
> Docker : Containerization tool

How do all these tools work together?
> This flow may vary from organization to organization as per the requirement.

i. Developers develop the code and this source code is managed by Version Control System tools like Git etc.

ii. Developers send this code to the Git repository and any changes made in the 
  code is committed to this Repository.

iii. Jenkins pulls this code from the repository using the Git plugin and build it 
     using tools like Ant or Maven.

iv. Configuration management tools like puppet deploys & provisions testing 
    environment and then Jenkins releases this code on the test environment on 
    which testing is done using tools like selenium.

v. Once the code is tested, Jenkins send it for deployment on the production server (even production server is provisioned & maintained by tools like puppet).

vi. After deployment It is continuously monitored by tools like Nagios.

vii. Docker containers provides testing environment to test the build features.
---------------------------------
5) DevOps and Software Testing

> Software Testing is one of the Process in four basic processes of DevOps...
---------------------------------

Static and Dynamic Testing

Static and Dynamic Testing

Static Testing and Dynamic Testing, these are come under the Software Testing...
Software Testing Tutorial
What is Software Testing?

> Software Testing is a process of executing a program or application with the 
  intent of finding the Defects.

Process:  Testing is a process rather than a single activity.
-----------------------------------
> It can also be stated as the Verification and Validation of Software Application
  with respect to its requirements...

Verification: Verifying weather the Software is correctly implementing or not?

Validation: Validating weather the Software is correctly working or not?
-------------------------------------------------
> Verification is done at the starting of the development process. It is also 
called as Static Testing. 

> Static Testing can be done without executing the Software, It includes 
Informal reviews, Technical reviews, walk-throughs, and inspections, etc. to 
evaluate the documents like requirements, design docs, code, plans etc...

> And Static Testing can be conducted using Manual reviews and static analysis or Automated Analysis like Static Test techniques by developers...
----------------------------------------
> Validation is done at the end of the development process and takes place after Verification is completed.

> It also called as Dynamic Testing, Dynamic Testing can be conducted by executing the Software using Black box and White box Test Design Techniques, and It can be conducted in different levels of Testing, Unit Testing, Integration Testing,  and System Testing using Manual Testing and Automated Testing.

> And Dynamic Testing can be done by using White box and Black box test techniques  by Developers and Testers (Indipendent Testers)

Fimnal Verification/Static Testing is focues on Defect Prevention, and Validation
or Dynamic Testing is focuses on Defect Detection.
--------------------------------------------------------

SQL Tutorial 10: SQL Functions

SQL Tutorial For Beginners
SQL Tutorial 10: SQL Functions

1) What is a Function?

A Function is a predefined formula which takes one or more arguments as input,
then process the input, and returns an output.
------------------------------
2) Different types of SQL Functions....

> SQL has many built-in functions for performing calculations on data, SQL Functions
may vary from one Database Management System to another,
Database Management Systems,
Oracle,
MS SQL Server,
MySQL,
SyBase etc...
---------------------
Note: In this session we are going to discuss MS SQL Server Functions...

SQL Server has different types of Functions

i) String Functions - These Functions are only work on String type data

ii) Numeric Functions - These Functions are only work on Numeric data type

iii) Date Functions - These Functions are only work on Date data type

iv) Coversion Functions etc...
-------------------------------------------------
i) SQL String Functions

1) Concat

Concatenates two or more strings together

Example:
Select Concat ('gcreddy', '.com');
Output: gcreddy.com
-------------------------------------------------
2) Len

Returns the length of the specified String

Example:
Select LEN ('gcreddy.com');
Output: 11
-------------------------------------------------
3) Left

Extracts a Substring from a String (Starting from left)

Example:
Select Left('SQL Tutorial', 3);
Output: SQL
-------------------------------------------------
4) Right

Extracts a Subsisting from a String (Starting from right)

Example:
Select Right ('SQL Tutorial', 3);
Output: ial
-------------------------------------------------
5) Lower 

Converts a string to lower case

Example:
Select Lower('SQL');
Select Lower('sql');
Select Lower('SqL');
Select Lower('SQL123');
Output:
sql
sql
sql
sql123
-------------------------------------------------
6) Upper

Converts a string to upper case

example:
Select Upper('SQL');
Select Upper('sql');
Select Upper('SqL');
Select Upper('SQL123');
Output:
SQL
SQL
SQL
SQL123
-------------------------------------------------
7) LTrim

Removes leading spaces from a string 

Example:
Select ('        GCREDDY');
Select LTRIM('        GCREDDY');
Output:
      GCREDDY
GCREDDY
-------------------------------------------------
8) RTrim

Removes trailing spaces from a string

Example:
Select Rtrim('SQL Tutorial                    ');
Output: SQL Tutorial
-------------------------------------------------
9) SubString

Extracts s substring from a string

Example:
Select SubString('SQL Tutorial', 1, 3);--SQL
Select SubString('SQL Tutorial', 5, 3);--Tut
Select SubString('SQL Tutorial', 3, 3);--L T
Output:
SQL
Tut
L T
-------------------------------------------------
10) Replace

Replaces a sequence of characters in a string with another set of characters

Example:
Select REPLACE('SQL Tutorial', 'SQL', 'Java');--Java Tutorial
Output: 
Java Tutorial
-------------------------------------------------

SQL Tutorial 9: SQL Joins


SQL Tutorial 9: SQL Joins

The SQL Joins clause is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two tables by using values common to each.

Consider the following two tables -

Table 1 - CUSTOMERS with ID, NAME, AGE, and CITY Fields...
Table 2 - ORDERS Table with ID, Year, and Amount Fields...

Combine these two tables and create a Result table with ID, NAME, and Amount Fields

Steps: 
//Create a Database
Create Database gcreddyDB;
------------------------
Use Database;

//Create a Table in the Database,
Create Table Customers
(
ID int,
Name char(40),
Age int;
City char(30);
);
------------------------
//Insert Data...
Insert Into Customers(Id, Name, Age, City) 
values(1, 'Ramesh', 32, 'Hyderabad'),
(2, 'Prasad', 25, 'Delhi'),
(3, 'Venkat', 23, 'Mumbai'),
(4, 'Ramya', 25, 'Chennai');
------------------------
//Create another table
Create Table Orders
(
OrderNo int,
Item char(30),
Amount int;
);
------------------------
//Insert Data...
Insert Into Customers(OrderNo, Item, Amount) 
values(2, 'TV', 5000),
(3, 'Fridge', 4000),
(4, 'AC', 23, 6000);
------------------------
Table 1 - Customers Table
ID
Name
Age
City
1
Ramesh
32
Hyderabad
2
Prasad
25
Delhi
3
Venkat
23
Chennai
4
Ramya
25
Mumbai

Table 2 - ORDERS Table
OrderNo
Item
Amount
2
TV
5000
3
Fridge
6000
4
AC
8000
SQL Tutorial For Beginners
Display Tables one by one,

Select * from Customers;
Select * from Orders;

Now, let us join these two tables in our SELECT statement as shown below.

SQL> SELECT ID, NAME, AGE, AMOUNT
   FROM CUSTOMERS, ORDERS
   WHERE  CUSTOMERS.ID = ORDERS.OrderNo;
This would produce the following result.
ID
Name
Item
Amount
2
Prasad
TV
5000
3
Venkat
Fridge
6000
4
Ramya
AC
8000

Note: Here, it is noticeable that the join is performed in the WHERE clause. Several operators can be used to join tables, such as =, <, >, <>, <=, >=, !=, BETWEEN,  LIKE, and NOT; they can all be used to join tables. However, the most common    operator is the equal to symbol.
------------------------------------------------------------------------
SQL Step by Step Tutorial

1) Introduction to SQL
(http://www.gcreddy.com/2016/07/introduction-to-sql.html)

2) SQL Overview
(http://www.gcreddy.com/2016/08/sql-overview.html)

3) MS SQL Server Installation
(http://www.gcreddy.com/2016/09/sql-environment-setup.html)

4) Database Fundamentals and SQL Language Elements
(http://www.gcreddy.com/2016/11/database-fundamentals-and-sql-language.html)

5) SQL Data Definition Language
(http://www.gcreddy.com/2016/11/sql-data-definition-language.html)

6) SQL Data Manipulation Language
(http://www.gcreddy.com/2017/06/sql-tutorial-6-data-manipulation.html)

7) SQL Operators
(http://www.gcreddy.com/2017/06/sql-operators.html)

8) the SQL Select Query...
(https://youtu.be/kid__0MNRps)

Subscribe to Free Software Testing Video Channel

G C Reddy YouTube Channel
Subscribe to G C Reddy Software Testing Video Channel (Get Regular Updates)

Software Testing Videos (Manual Testing, Selenium, UFT/QTP, Live Project, Java, SQL, Python, VBScript, and FAQ)

1) Selenium Step by Step Videos

2) Selenium Latest Videos

3) Selenium Quick Videos

4) Manual Testing Videos

5) UFT/QTP Videos

6) Java Videos

7) SQL Videos

8) Python Videos

9) Career Guidance

10) Introductions 

12) Selenium Live Project

13) VBScript for UFT/QTP

14) Software Testing Interview Questions

15) Software Testing Practical

16) Selenium Detailed Videos

17) Health and Fitness Videos
--------------------------------------------------------------------------------------
G C Reddy YouTube Channel main focus on Software Testing (Manual Testing and Automated Testing using selenium, and UFT/QTP), Software Testing related or supported technologies like SQL (for Database Testing), VBScript, Java and Python Programming (For Automated Testing), and Software Projects...
--------------------------------------------------------------------------------------
Also Read:

2) UFT/QTP Videos and Class Notes


3) SQL Videos and Class Notes


4) Java Videos and Class Notes


5) Python Videos and Class Notes


6) Software Testing Resumes

Software Testing Jobs September 29

SoftwareTesting Jobs September 29

1) Sr SQA Engineer

Location : Bangalore

Company Name :BMC Software

Experience : 5 - 7 Years

Job Description :
Minimum of 5-7 years of automationexperience 
Knowledge and hands-on with webtechnologies such as JavaScript, SOAP, REST, API testing 
Familiarity with automated frameworkssuch as ROBOT, Test NG, Selenium or others 

For More Details :
---------------------------------------
2) UFT Test Engineer

Location : Pune

Company Name : Capgemini

Experience : 8 - 13 Years

Job Description :
Test Automation lead with UFT and Selenium experience

For More Details :
---------------------------------------------
3) Test Automation 

Location : Bangalore, Noida

Company Name : Oracle India Pvt. Ltd.

Experience : 11 - 20 Years

Job Description :
Participate in scoping QA test efforts.
Write test cases and test specifications.
Write automation and perform automated and some manual testing.
 Provide accurate information to the team's manager for status reporting

For More Details :
---------------------------------------------------
4) Manual Testing Engineer

Location : Bangalore

Company Name : Nuware Systems LLP

3rd October - 6th October

Experience : 4 - 8 yrs

Job Description :
Should be strong in Database Testing
Work experience in Asset management, 
Capital Markets, trading, equities, portfolio management etc.
Should be strong in client-server, smart client.

Address :
Krishna Temple Road, Indiranagar, 
Bangalore - 560038 Contact: 080 67166300 
Direction: Behind MK Retail - 
CMH Road, Indiranagar 
(Opposite to Cake Walk)

For More Details :
--------------------------------------------------
5) Automation Tester

Location : Kolkata(Salt Lake)

Company Name : Pursuit Software Development Pvt. Ltd.
  
Experience : 2 - 6 yrs

Job Description :
Testing process, Testing Life Cycle, Bug Reporting, Selenium 
(Web Driver), Java, HTML, JavaScript, JIRA, Agile Methodology
Previous Experience in UI & UX Testing is must.

Contact : 09874198803

For More Details :
----------------------------------------------
6)  Senior Software Tester

Location : Hyderabad(Nagaram)

Company Name : Waterhealth India Pvt Ltd

Experience : 3 - 6 yrs

Job Description :
Understand and Analyze Business, functional, technical, User Interface requirements of 
the project and develop test cases, test strategy & test approach for the testing activities to be carried out.
Ensure testing standards, guidelines and testing methodology are followed as per the test approach and industry standards

Address :
H. No. 9-7, Survey No. 308/1
Nagaram, Keesara Mandal,
Hyderabad UrbanTelanganaHyderabad,
Telangana,India 500083

Contact : 91-40-27890307

For More Details :
-------------------------------------------------------
7) QA Engineer (manual Testing) 

Location : Bangalore

Company Name : ManpowerGroup Services India Private Limited

Experience : 2 to 5 Yrs

Job Description :
Strong working experience in Web / Mobile application testing. 
Should have experience in test case writing or test case designing.
Responsible for planning and executing functional and system 
level testing of products to test various features.
Experience in working on product scalability,
 performance and deployment test will be an additional advantage.
Strong understanding of the SDLC, STLC.

Contact : 8801727258

For More Details :
------------------------------------------------------------
8) QA Lead

Location : Noida

Company Name : Borderlessmind Technologies Private Ltd

Experience : 6 - 8 yrs

Job Description :
Web services and API testing using SOAP UI or POSTMAN or any other tool
Basic SQL query knowledge
Automation testing experience with Selenium. 
Meter.
CMMI process knowledge

Address :
A-5Sector - 57NoidaNOIDA,
Uttar Pradesh,India 201301

Contact : 91-120-4274742

For More Details :
---------------------------------------------------------
9) Automated Testing

Location : Chennai(Anna Industrial Estate)

Company Name : KONE Elevator India Pvt Ltd

Experience :  2 - 5 yrs

Job Description :
Good knowledge of syntax and semantics of python language
Familiar with Test driven development
Good Debugging skills in Embedded software and hardware

Adrress :
India Land Tech Park, Tower-B 
3rd FloorPlot No.14, 3rd Main Road
Ambattur Industrial Estate,
Tamilnadu,India 600058

Contact : 91--26889018

For More Details :
----------------------------------------------