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

5 Best Features and Development Model for Agile

In Agile development model each sprint has phases of requirements, design, development and testing. In the development phase, development team concentrates on new features to be developed and unit testing around it. But it misses on the regression of existing working functionality.

This leads to defect seepage from Development phase to Test phase. Consequence of it is late defect identification, reporting, fixing and re-verification of the defect. This defect cycle continues till it is fixed.

Drawback of Agile

The drawback of this approach is project teams put in extra effort of identifying defects and reporting. Late identification of defects also leads to risk of schedule slippage.

Here in this article is a mechanism proposed to minimize defect leakage from development phase to testing phase in agile software development life cycle by moving the regressed automated scripts from testing phase to development phase.

  1. The advantages of this approach of agile software development are:
  2. Early identification of defects in already working functionality.
  3. Development teams can use the regressed automation pieces as and when required to ensure that their new code is not introducing bugs in already existing functionality.
  4. Earlier identification of any requirement or design misses.
  5. It would save effort invested in reporting and documentation of the bug.
  6. Would help in restricting schedule slippages due to bugs being identified in later stages.
  7. It would further remove chances of test phase misses of bugs in already working functionality.
 Brief overview of Agile Software development Life Cycle:

In agile software development life cycle the product or solution is first divided into features which need to be developed. If there are new features identified in the midst of complete product release it again gets planned across sprints.

Agile Sprint duration is decided based on feature to be developed. Every sprint goes through the phases of Requirement, Design, Development and Testing phase.

In the requirements phase, software requirements are framed.

In the Design phase, design of the product / solution to be done is come up with. Here test team understands the requirements and comes up with a test strategy / plan to proceed with testing of the piece being developed.

In the Development phase, Developers are actively involved in writing source for solutions to be provided and then in unit testing of the functionalities developed. Here the test team is involved in writing test cases for functionalities being developed.

In the Test phase, Manual testing happens on the basis of test cases written. Automation testing for the test cases automated is also done. Here the development team is involved in fixing the bugs reported and test team re-verifies it.

 Development Model flow chart (ref: IBM)
Identified Gap:

While identifying the test cases to be automated, the first choices are those test cases which need to be run in each regression run. In SDLC mode of development as new features keep being added, test cases are added to automation suite. This keeps increasing the regression automation bed.

As the new suites are added to automation bed they mature only after multiple runs in that sprint. After sprint is over the automated regression suite is also stable to be used without any hiccups.

Using an agile mode of development, means the functionality developed in the last sprint would be integrated with the new functionality developed. This leads to changes in modules developed in previous sprints, which may result in bugs in the already developed functionality.

As the current models tie automation testing in the test phase, bugs introduced in previously working functionality get tracked in Test phase. This leads to a cycle of identification of bugs, reporting, fixing and re-verification of it.

Related: Agile vs Waterfall Model

Why Companies need Agile model?

Agile development methodology provides opportunities to assess the direction of a project throughout the development lifecycle. This is achieved through regular cadences of work, known as sprints or iterations, at the end of which teams must present a potentially shippable product increment.

By focusing on the repetition of abbreviated work cycles as well as the functional product they yield, agile methodology is described as “iterative” and “incremental.” In waterfall, development teams only have one chance to get each aspect of a project right. In an agile paradigm, every aspect of development — requirements, design, etc. — is continually revisited throughout the lifecycle. When a team stops and re-evaluates the direction of a project every two weeks, there’s always time to steer it in another direction.

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