A Lengthy Overview of the SELECT Statement - Video Series 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:

Title Skill Length Download Pt. 1 - An Overview of the SELECT Statement: Clauses and Sequence   100 11 mins. Download Pt. 2 - Using the SELECT Statement With and Without a FROM Clause   100 15 mins. Download Pt. 3 - Writing WHERE Clauses and Filtering Your Data   100 14 mins. Download Pt. 4 - Complex WHERE Clauses Using AND, OR, and Parentheses   100 6 mins. Download Pt. 5 - When to Use GROUP BY, DISTINCT, and An Overview of Aggregates in SQL   100 8 mins. Download Pt. 6 - Using HAVING and GROUP BY   100 10 mins. Download Pt. 7 - Column Aliases, TOP, and ORDER BY   100 11 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Helpful Keyboard Shortcuts: "Windows key" + "F" brings up the Search window Did you know that the fixed server role "Database Creators (dbcreator)" can drop any database on the server? Ouch! Keyboard Shortcut for Query Analyzer: CTRL+SHIFT+L converts text to lowercase