Agile Methodology

Agile is a form of technology development that has grown in popularity in recent years. It was created by a group of technology experts/enthusiast with the goal of improving the delivery of technology. With Agile, it is easier to deliver what your client desires and fix your course in case you are developing the wrong tech. Agile is a mindset, as its name implies, it quick and fluid. Agile, as opposed to Waterfall, allows for quicker and more efficient delivery of products. Through agile you have deliverables called epics, that can be broken down to features and then further broken down to stories. A story is typically assigned to one or two individuals that need to deliver the story in about a sprint (two weeks typically). 

Key concepts:

     Epic

     Feature

     Story

     Sprint

     Scrum

     Waterfall

 

 

Excel

Index Match

The index Match method is a powerful function Excel offers. It allows the user to find a particular instance of a column in another table. It is preferable over the V-Look up since it does not limit the user to the first row.

Syntax =index(Array you want to display, Match(Item being looked for, Array where that item is found, 0))

Great resource below!

https://www.deskbright.com/excel/using-index-match/

SQL (Structured Query Language)

What is SQL? SQL is a database made up of various tables that relate to each other. For example. Imagine a sports league. A sports league has teams, players, stadiums, and a point system amongst various other aspects. To keep organized one could create a set of tables to differentiate the former. One table for just teams, their names, city, state, stadium name, and capacity. Another table could include the team and its players and coach. Another table could hold information on the stadium, capacity, location, etc. Lastly, another table could be used for information on players, the number of assists, goals, games played etc. These tables can then be linked together creating a relation database. Players relate to teams, teams relate to the stadium table and so on.

Now queries is the way we can get that information. We can find all the players with more than 25 goals, or stadiums with at least 55,000 seating capacity. There is a particular syntax to be used with queries to get the information you want.

Joins – A join is the merging of two tables to find. In SQL there are several different types of Joins these are (Left joins, inner joins, right joins, self-join, full join).

The most common join is the left join

INDEX MATCH SCREENSHOT.png
INDEX MATCH SCREENSHOT 2.png