Posts Tagged ‘tutorial’

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

Microsoft Excel #06: Using “IF” in Formulas

September 6, 2009 - 1:13 am 25 Comments

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

(more…)

SQLite Insert or Ignore

September 6, 2009 - 1:13 am 2 Comments

This video shows how to use the “insert or ignore” SQL statement in SQLite in order to avoid error messages for duplicate keys. For more information on SQLite, see

http://www.squidoo.com/sqlitehammer
http://www.squidoo.com/sqliteprogramming
http://www.squidoo.com/sqlitetutorial
http://www.squidoo.com/sqlitedatabasedesign

Duration : 0:4:11

(more…)

The If Statement

September 3, 2009 - 4:18 am 25 Comments

this tutorial is going to show u how to use the if statement. watch and learn my young padawan :) ok so i hope you like this tutorial.

- SilverMagics

Duration : 0:4:40

(more…)

PHP Tutorial - 4 - If Else Statements

August 28, 2009 - 6:14 am 14 Comments

Go to http://thenewboston.com/ if you need any help or have any questions. I will answer them all there!

Duration : 0:4:6

(more…)

C++ Tutorial - 3 - Declaration Statements and Variables

August 28, 2009 - 6:14 am 25 Comments

Part 4 - http://www.youtube.com/watch?v=zu05hFPimYs

Make sure to Subscribe to my Channel for all my latest videos!!!

support my website too by registering at http://thenewboston.com

Duration : 0:4:5

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

Delphi Programming Tutorial #21 - SQL Part Three

August 25, 2009 - 11:17 am 4 Comments

In this guide on SQL we look at the update and delete statements

Duration : 0:5:52

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