techiners.in: 2015

THE SCRUM FRAMEWORK - PART 2

Hey Guys, this is the second post in continuation with previous one THE SCRUM FRAMEWORK. If you are reading this post first time, I strongly recommend to go through the previous post: The Scrum Framework, for better understanding of this post. As we promised in our previous post, in this post we will discuss the following points related to SCRUM Framework:

SCRUM EVENTS

THE SPRINT

CANCELLING A SPRINT

SPRINT PLANNING

SPRINT GOAL

DAILY SCRUM

So, lets begin our journey to The Scrum Framework. . .

THE SCRUM FRAMEWORK

THE SCRUM FRAMEWORK IN 30 SECONDS

After reading this post we must be able to understand what exactly is SCRUM framework? and what it is used for? When and where to use SCRUM?

WHO CREATED SCRUM?

Jeff Sutherland Created the SCRUM Process in 1993 and used the term SCRUM for comparing high-performing, cross-functional teams similar to that in a RUGBY Game.

What is a SCRUM?

SCRUM is a term used for a team that forms a ring of people with their hands interlocked around each others shoulders and the team march forwards to pull the ball towards their side. It's a term used to describe a circle formed in a RUGBY Game by the players.

SCRUM is the leading agile development methodology, used by Fortune 500 companies around the world. SCRUM is an Agile Framework for completing complex projects. SCRUM was originally formalized for software development projects, but it works well for any complex, innovative scope of work. The possibilities are endless. The SCRUM Framework is deceptively simple.

It is lightweight, Simple to understand, Difficult to master. Actually, SCRUM is not a process or a technique for building products; rather,

TVF- THE VIRAL FEVER

Before I begin with the Web Series, Let me introduce about TVF. What is TVF? TVF-ONE : India's Premium Online Entertainment Network, owned and operated by 'The Viral Fever Group'. TVF-ONE is India's first and biggest Organized OnlineTV, where you can watch regular shows and content, created especially for the young audience, across genres like Humor/Drama/Trends etc. on its channels 'TVF-Qtiyapa' & 'TVF-RecycleBin'. The Viral Fever or (TVF), Founded by Arunabh Kumar, is a new age Media Brand, driven by the spirit of "Lights...Camera...Experiment !" with businesses in Branded Content, Live Events, TV Shows, Production Services and Youth Entertainment.

WHAT WE WILL WE LEARN IN THIS POST?

After reading this post we must be able to fetch one or all record from the table conditionally. We will fetch one record based on the condition mentioned in where clause or all records when a particular value is to be retrieved. i.e., we can either select one record of our choice or all records when we choose some particular value. This is useful when we need to fetch single record or to display all records to the user. Either show selected record or all records.

HOW WE ARE GOING TO ACHIEVE THIS?

We will use most common, simple select statement and some variables along with Boolean Logic. Why Boolean Logic? Because we won't use case or if else statement.

Lets begin our excursion...

Unlike Split() function in C#, we don't have any pre-defined in SQL, that splits the string containing the delimiter. While during development, it is sometimes required the functionality of split function similar to that of C# in SQL too.

After a very long time, techiners back again with a new post that will explain the process of creating a function that split the string containing the delimiter, which accepts two parameters- one string and other delimiter.

The first parameter is the string that contains the delimiter and needs to be split across it.

So without much ado, lets start...