Posts Tagged ‘data’
September 14, 2009 - 9:12 pm
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…)
Tags: 2005, 2008, beginner, clause, code, columns, criteria, data, databases, easy, entity, fields, Full, information, inner, introduction, Joes, Joins., learn, left, lessons, lingo, Outer, queries, query, records, Right, Rows, select, Server, simple, sql, statement, t-sql, table, terms, training, tutorial Posted in sql statement |
September 9, 2009 - 1:30 am
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…)
Tags: 2005, 2008, beginner, clause, code, criteria, data, databases, demonstration, easy, how-to, information, introduction, Joes, learn, lessons, Like, operators, queries, query, records, select, Server, simple, sql, statement, t-sql, table, training, tutorial, Wildcards Posted in sql statement |
August 25, 2009 - 11:17 am
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…)
Tags: 2005, 2008, beginner, clause, code, columns, criteria, data, databases, easy, entity, fields, information, introduction, Joes, learn, lessons, lingo, queries, query, records, Rows, select, Server, simple, sql, statement, t-sql, table, terms, training, tutorial Posted in sql statement |
August 16, 2009 - 4:18 am
www.Joes2Pros.com How to use exact criteria matches in a basic single table query in SQL server 2005 and 2008.
Duration : 0:7:59
(more…)
Tags: 2005, 2008, beginner, Beginners, clause, code, criteria, data, databases, demonstration, easy, how-to, information, introduction, Joes, learn, lessons, queries, query, records, select, Server, simple, sql, statement, t-sql, table, training, tutorial Posted in sql statement |
August 6, 2009 - 11:14 pm
www.Joes2Pros.com… Learn how to use basic inner joins to see two tables in one results set..
Duration : 0:8:37
(more…)
Tags: 2005, 2008, beginner, clause, code, columns, criteria, data, databases, easy, entity, fields, information, inner, introduction, Joes, Joins., learn, lessons, lingo, queries, query, records, Rows, select, Server, simple, sql, statement, t-sql, table, terms, training, tutorial Posted in join statement |
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…)
Tags: (TSQL), 2008, and, data, delete, insert, records, select, Server, sql, Transact, Update, using Posted in delete statement |