More advanced formula uses including the “IF” statement. For example, “IF someone earned over $200 then charge them $20… otherwise charge them $40.” This is a very powerful tip.
Duration : 0:4:51
Sonia Sotomayor Asked If “Race/Gender” Are Factors In Her Judging Cases - 07/14/09 [Question By Republican Senator Jon Kyl]
Duration : 0:6:27
http://www.learningsqlserver2008.com/
If you want to be good at working with databases, strong knowledge of TSQL is a must. In this important video, we start off with a little background and the database we will use AdventureWorks2008. We start off with the SELECT statement which is used to return data. The basic syntax is discuss with an e.g. from Person and SalesOrderHeader table. We move onto the INSERT statement using the Person table in the database. The next two statements are UPDATE and DELETE which are very powerful. Using a where clause is extremely important here. We show you how to change data in Person table. (Running time is 32 mins)
Duration : 0:9:17
