Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Tutorials · Integration Services Training
   
Transact SQL Training Videos
Transact SQL Videos in Series Home  Subscriber Videos  

A Lengthy Overview of the SELECT Statement (Video Series)

Video Image Video Category: SELECT, INSERT, UPDATE and DELETE - Data Manipulation Language

Skill Level: 100 (Beginner)

Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008
This lengthy 7-part series is all about working with the Data Manipulation Language (DML) SELECT statement.Covered in this video are also some simple main sequences of SQL focusing on the statements, requirements and their various uses.

Highlights:
  • Returns from a SELECT statement
  • Introduction to the SELECT, FROM, JOIN, WHERE, GROUP BY, HAVING, ORDER BY statements
  • Basic definition for result sets
  • Intro to the AND / OR clauses
  • Proper utilization of parenthesis () when writing queries
  • Proper use of DISTINCT vs Improper use of GROUP BY
  • When and why to use the HAVING clause
  • Simplistic and complex TOP clause examples

Videos in this Series:


Miscellaneous Bits & Pieces:
osql.exe is a command-line tool that you can use to run your SQL scripts and queries; think of it as the DOS-version of Query Analyzer
Helpful Keyboard Shortcuts: "CTRL" + "F4" closes the active pane/worksheet/tab within an application but does not close the application
The two types of cluster configurations are Active/Passive and Active/Active

Other Websites We Offer
LearnVBProgramming.com
Don't Forget!
Become a Guru
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
11/20/2008 4:47:30 PM