Billing Statement

I declare Code Sin #1: poorly formatted code. Look, the video’s uner 90 seconds long…watch it. Your successors, your coworkers — your CHILDREN, will thank you.

Duration : 0:1:26

(more…)

How does SQL see a SELECT statement? Which part gets evaluated first? Why should I care? Find out here, find out fast!

1 - From
2 - Where
3 - Group by
4 - Having
5 - Select
6 - Order by

Duration : 0:2:5

(more…)

This instructional video will continue comparing Views, Functions, and Stored Procedures in SQL and present you with the correct option for your task at hand

Highlights:
• Dimensional modeling approach in View
• Multi-statement functions

Duration : 0:8:28

(more…)

Common data scenarios require developers to write and maintain logic to determine whether to insert, update or delete information (sometimes called upsert) such as:
IF FOUND
THEN UPDATE
ELSE
INSERT
SQL Server 2008 provides the new MERGE statement within the SQL language to enable developers to provide this functionality with a single statement. This allows for code reduction and easier maintainability.

Duration : 0:3:28

(more…)

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

(more…)