IT Training Videos From LearnItFirst.com

SQL Server 2005/2008 Queries Training Video: ORDER BY: The Basics of the ORDER BY Clause

ORDER BY: The Basics of the ORDER BY Clause - view details
In this video Scott will cover the basics of SORT. SORT and the ORDER BY clause are fairly simple concepts but there are two slightly complicated aspects to these concepts that Scott will go over in this video.

Highlights from this video:ORDER Byalways the last clausewhat can I order by?ascending or descending order
Multiple sorts
Can I sort on an alias?only in ORDER BY
and much more Source: http://www.learnitfirst.com/Course/160/Video/2255/ORDER-BY.aspx Course: http://www.learnitfirst.com/Course/160/SQL-Queries-2008.aspx Skill Level: 100 (Beginner) Length: 09:30 (23.7MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: introduction, step by step, beginner, beginning, for dummies, sql server, sort, order by, multiple sorts, alias

This video comes from the SQL Server 2005/2008 Queries online training course, Writing Queries for SQL Server (2005/2008 Edition). And be sure to check out even more SQL Server 2008/2005 Query Writing training videos.

SQL Server 2008 Analysis Services Training Video: Mapping a Dimen sion Table/Query to an Analysis Services Dimension

Mapping a Dimension Table/Query to an Analysis Services Dimension - view details
In this video Scott will show you how to map the relationship between the relational data warehouse table and the dimension that will be in Analysis Services.

Highlights from this video:Creating a dimension
What do users interact with?
cubes and perspectives
Database dimension
Cube dimension
Creating SSAS dimensions
Naming conventions
and much more Source: http://www.learnitfirst.com/Course/165/Video/2688/Mapping-Dimension-Tables.aspx Course: http://www.learnitfirst.com/Course/165/SSAS-2008.aspx Skill Level: 300 (Intermediate) Length: 12:30 (38.1MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: sql server 2008, analysis services, ssas, mapping, dimension table, dimensions, cubes, perspectives

This video comes from the SQL Server 2008 Analysis Services online training course, SQL Server 2008/R2 Analysis Services. And be sure to check out even more SQL Server Analysis Services training videos.

SQL Server Programming and Queries Training Video: Pt. 1 - What O utput Parameters Are and When to Use Them

Pt. 1 - What Output Parameters Are and When to Use Them - view details
This video is a great introduction to using OUTPUT parameters. Modern SQL programmers use output parameters in so many stored procedures that it's tough to be a decent SQL developer without a solid understanding of how they work. This video section walks you through what OUTPUT parameters are, how they work, and gives you several business cases for how to use them effectively. Please note that this video needs to be downloaded with Part 2 of this section since the demo/discussion is completed in Part 2.

NOTE: This video section was shot using SQL Server 2005 but the concepts are the same for all versions of SQL Server.

Highlights from this video:
When to Use Output Parameters
Output Parameter or Result Set?
Passing Data Between Stored Procedures
Master-Detail Inserts with IDENTITY values
@@IDENTITY or SCOPE_IDENTITY?
OUT or OUTPUT?
Source: http://www.learnitfirst.com/Course/150/Video/512/Intro-to-Output-Parameters.aspx Course: http://www.learnitfirst.com/Course/150/SQL-2005-Programming.aspx Skill Level: 200 (Beginner - Intermediate) Length: 9:56 (7.14MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: output, out params, sql parameters, sqlparameter, parameterdirection.output

This video comes from the SQL Server Programming and Queries online training course, SQL Server Programming (SQL Server 2005/2000): Transact SQL. And be sure to check out even more MSSQL Programming and Query Writing training videos.

SSIS 2005 Training Video: Part 7 - Tasks: Data Mining Query, Data Profiling, and Execute DTS Package

Part 7 - Tasks: Data Mining Query, Data Profiling, and Execute DTS Package - view details
The Data Mining Query Task, the Data Profiling Task, and the Execute DTS Package Task are the three tasks that will be discussed in this video tutorial.

Highlights from this video:
What is the Data Mining Query Task?
Data Profiling Task in SQL Server 2008
What does it allow me to do?
Example usage
Demo of working with taskExecute DTS 2000 Task Backwards-compatibiltyand much more Source: http://www.learnitfirst.com/Course/153/Video/1571/Data-Mining-Query-Data-Profiling-and-Execute-DTS-Package.aspx Course: http://www.learnitfirst.com/Course/153/SSIS-2005.aspx Skill Level: 100 (Beginner) Length: 12:30 (25.0MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: toolbox, bids, bi, business intelligence, studio, project, designer, data mining, data profiling, dts, package, task, introduction, step by step, beginner, beginning, for dummies

This video comes from the SSIS 2005 online training course, SQL Server 2005 Integration Services. And be sure to check out even more SQL 2005 Integration Services training videos.

SSIS 2008 Training Video: How to Assign the Filename of a Bulk In sert Task at Runtime Using Expressions

How to Assign the Filename of a Bulk Insert Task at Runtime Using Expressions - view details
How do you mix SSIS expressions with variables so you can customize your packages at runtime? This will allow your packages to become even more dynamic and usable. In this video Scott will show you how to assign the filename of a bulk insert task at runtime using expressions.
 
Highlights from this video:Bulk insert taskEditing the bulk insert task
Format files
Changing the value of a variable
Changing a destination table in an expression
Using the bulk insert task the the foreach loop container
and much more Source: http://www.learnitfirst.com/Course/158/Video/2134/Assign-Filename-Of-A-Bulk-Insert-Task-At-Runtime.aspx Course: http://www.learnitfirst.com/Course/158/SSIS-2008.aspx Skill Level: 300 (Intermediate) Length: 12:00 (19.8MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: SSIS 2008, bulk insert task, expressions assign filename at runtime

This video comes from the SSIS 2008 online training course, SQL Server 2008 Integration Services. And be sure to check out even more SQL 2008 Integration Services training videos.

Visual Basic .NET Training Video: Pt. 1 - Creating Our First Cons ole Application Using Visual Basic and .NET

Pt. 1 - Creating Our First Console Application Using Visual Basic and .NET - view details
This first video tutorial in the section on Console Applications will walk you through the process of creating the very useful console applications in Visual Basic and how to run them.Highlights:Setting assembly information Visual Basic configuration : Debug vs Release Accessing your program directory How to run your console application via cmd prompt Source: http://www.learnitfirst.com/Course/199/Video/830/Create-First-Console-Application-Using-Visual-Basic-and-NET.aspx Course: http://www.learnitfirst.com/Course/199/VB-2005.aspx Skill Level: 200 (Beginner - Intermediate) Length: 10:31 (7.86MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: beginner, console application, easy, visual basic

This video comes from the Visual Basic .NET online training course, Visual Basic Programming with Visual Studio 2005. And be sure to check out even more Visual Basic Programming training videos.

SSIS 2008 Training Video: Using Variables in the Foreach Containe r: Looping Through Every Row in a Table/Result Set, Part 2

Using Variables in the Foreach Container: Looping Through Every Row in a Table/Result Set, Part 2 - view details
This second video covering using variables in the foreach container to loop through every row in a result set. This video will show what each index in the foreach container maps to in the SQL Server result set. Scott will also show you how to troubleshoot in the foreach container. How do you change variables from read-only to read-write? It's not intuitive and requires a deeper understanding of DTS packages.

Highlights from this video:Practical applications of the foreach container
Troubleshooting in the foreach container.
When should you use read-only variables?
Creating a read-only variableChanging a read-only variable to a read-write variable
and much more Source: http://www.learnitfirst.com/Course/158/Video/2125/Pt2-Looping-Through-Every-Row-In-A-Table-Set.aspx Course: http://www.learnitfirst.com/Course/158/SSIS-2008.aspx Skill Level: 300 (Intermediate) Length: 13:30 (25.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: SSIS 2008, variables, foreach container, looping, mapping, troubleshooting, read only variable, read write variable

This video comes from the SSIS 2008 online training course, SQL Server 2008 Integration Services. And be sure to check out even more SQL 2008 Integration Services training videos.

SQL Server 2005/2008 Queries Training Video: Common Table Express ions (CTEs): What They Are and How to Use Them

Common Table Expressions (CTEs): What They Are and How to Use Them - view details
In this video Scott will introduce Common Table Expressions, the final topic in chapter 6. Scott will cover the basics of CTEs and show you how to use them.
 
Highlights from this video:Two ways to use CTEs
replacement for derived tableto make recursion "easier"
When would you use CTEs?
and much more Source: http://www.learnitfirst.com/Course/160/Video/2411/Common-Table-Expressions.aspx Course: http://www.learnitfirst.com/Course/160/SQL-Queries-2008.aspx Skill Level: 500 (Advanced) Length: 10:15 (26.0MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: sql server, queries, subqueries, cte, derived table, recurions, common table expression

This video comes from the SQL Server 2005/2008 Queries online training course, Writing Queries for SQL Server (2005/2008 Edition). And be sure to check out even more SQL Server 2008/2005 Query Writing training videos.

SSIS 2008 Training Video: Get to Know the SSIS Lookup Transformat ion to Lookup Values in an Access 2007 DB, Part 2

Get to Know the SSIS Lookup Transformation to Lookup Values in an Access 2007 DB, Part 2 - view details
In this video Scott will wrap up how to use a lookup transformation in order to join data from SQL Server and Microsoft Access.

Highlights from this video:Lookup transformation
Lookup transformation editor
Cache modeDetermining the connection type
Cache connection manager
How should you handle rows with no matching entries?
and much more Source: http://www.learnitfirst.com/Course/158/Video/2094/Pt2-Lookup-Transformation-for-Access.aspx Course: http://www.learnitfirst.com/Course/158/SSIS-2008.aspx Skill Level: 400 (Intermediate - Advanced) Length: 19:45 (34.9MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: SSIS 2008, lookup transformation, lookup values, Access 2007, sql server 2008, caching, cache connection manager

This video comes from the SSIS 2008 online training course, SQL Server 2008 Integration Services. And be sure to check out even more SQL 2008 Integration Services training videos.

Exchange 2007 Training Video: Part 2 - Installing Exchange 2007 S ervice Pack 1

Part 2 - Installing Exchange 2007 Service Pack 1 - view details
Once you have installed all the pre-req components, you can then begin the install of Exchange 2007 Service Pack 1. In this second and final video in the section, Grant will walk you through the actual install of the service pack.

Highlights from this video:Readiness check..againHow long will it take to complete the install?Errors you might encounterUpdating Exchange Management tools and much more Source: http://www.learnitfirst.com/Course/222/Video/1364/Installing-Exchange-2007-SP1.aspx Course: http://www.learnitfirst.com/Course/222/Exchange-2007.aspx Skill Level: 200 (Beginner - Intermediate) Length: 08:30 (8.0MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: install exchange 2007 sp1, exchange 2007, exchange service pack, service pack 1

This video comes from the Exchange 2007 online training course, Exchange Server 2007 Administration. And be sure to check out even more MS Exchange 2007 training videos.