Posts Tagged ‘select’

SQL Outer Joins Joes2Pros (Using a Left,Right, and full Join)

September 14, 2009 - 9:12 pm 1 Comment

From chapter 3.2 of T-SQL 2008 Joes 2 Pros (www.joes2pros.com). Learn how to find matches and exceptions with outer joins.

Duration : 0:4:54

(more…)

SQL Query Wildcard Criteria (Using wildcards for pattern matching)

September 9, 2009 - 1:30 am No Comments

From chapter 2.2 of T-SQL 2008 Joes 2 Pros (www.joes2pros.com). How to use range and pattern matches in a basic single table query in SQL server 2005 and 2008. Full Video is a free download at www.Joes2Pros.com along with a PDF book sample.

Duration : 0:8:58

(more…)

NHTSA Hearing: Agassi Opening

September 9, 2009 - 1:30 am 3 Comments

Shai Agassi’s opening statement during a recent Select Committee on Energy Independence and Global Warming hearing entitled, “$4 Gasoline and Fuel Economy: Auto Industry at a Crossroads”

Duration : 0:4:58

(more…)

Developing Countries Hearing: Closing Statements

September 3, 2009 - 4:18 am No Comments

The witnesses’ closing statements during the Select Committee on Energy Independence and Global Warming hearing, “Fighting Climate Change in the Developing Countries” on March 4, 2009

chairman ed edward markey select committee independence global warming developing countries

Duration : 0:8:45

(more…)

Code Sins: Formatting

August 31, 2009 - 6:16 am No Comments

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…)

Introduction to SQL (Beginning Database Training) “Geek Speak” Joes2Pros ch1.2

August 25, 2009 - 11:17 am 1 Comment

From chapter 1 of T-SQL 2008 Joes 2 Pros (www.joes2pros.com). Learn the basic terms or Geek Speak used by SQL Server database professionals.

Duration : 0:4:46

(more…)

Crystal Reports Tutorial Creating Cross-Tab Reports Business Objects Training Lesson 13.8

August 22, 2009 - 5:14 am No Comments

Learn how to create cross-tab reports in Crystal Reports by Business Objects at www.teachUcomp.com. A clip from Mastering Crystal Reports Made Easy v. 11 (XI). http://www.teachucomp.com/tutorcrmain.htm - the most comprehensive Crystal Reports tutorial available. Visit us today!

Duration : 0:9:47

(more…)

TSQL: Select Statement Evaluation Order

August 22, 2009 - 5:14 am No Comments

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…)

Crystal Reports Tutorial The Template Expert Business Objects Training Lesson 5.7

August 19, 2009 - 7:05 am No Comments

Learn how to use the Template Expert in Crystal Reports by Business Objects at www.teachUcomp.com. A clip from Mastering Crystal Reports Made Easy v. 11 (XI). http://www.teachucomp.com/tutorcrmain.htm - the most comprehensive Crystal Reports tutorial available. Visit us today!

Duration : 0:3:16

(more…)

NHTSA Hearing: Holm Opening

August 19, 2009 - 7:04 am 1 Comment

Torben Holm, consultant for DONG Energy A/S, gives his opening statement to the Select Committee on Energy Independence and Global Warming during the recent hearing entitled, “$4 Gasoline and Fuel Economy: Auto Industry at a Crossroads”

Duration : 0:6:2

(more…)