IT Training Videos From LearnItFirst.com

SQL Server 2005/2008 Queries Training Video: A Tale of Three COUNTs

A Tale of Three COUNTs - view details
The COUNT function has three different syntaxes that do two different things. In this video Scott will cover the different syntaxes of the COUNT function and what question each syntax answers.

Highlights from this video:COUNT(*)number of rows that match the WHERE and JOIN condition
COUNT(<expression>)number of rows that had a non-null expression
COUNT(DISTINCT <expression>)
number of rows that had a non-null expression
and much more Source: http://www.learnitfirst.com/Course/160/Video/2363/A-Tale-of-Three-COUNTs.aspx Course: http://www.learnitfirst.com/Course/160/SQL-Queries-2008.aspx Skill Level: 200 (Beginner - Intermediate) Length: 08:45 (22.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, aggreages, counts, where, join, expression, null, non-null

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 2005 Training Video: Pt. 4 - Writing Script Tasks in SSIS to Use the Office PIAs

Pt. 4 - Writing Script Tasks in SSIS to Use the Office PIAs - view details
In part 3, you installed the Office Primary Interop Assemblies into the global assembly cache but, unfortunately for us, that's not enough to allow us to use them in SSIS! To use the Interop assemblies in your Script Tasks in SSIS, you have another step to do and this video shows you:
The final step to configure SSIS to work with the Office Interop assembliesThe basics of the Microsoft.Office.Interop.Excel class and how to manipulate your Excel worksheet through codeA walk through of a complex PIA-based package
NOTE: This video and the remaining videos in this section require knowledge of:Visual Basic .NET Microsoft Excel 2003, Excel 2007, Excel XPA Basic Understanding of COM InteropWorking Knowledge of the .NET FrameworkHow to Build Data Flow TasksHow to Create and Assign Values to SSIS variablesCreating Basic SSIS packages Source: http://www.learnitfirst.com/Course/153/Video/770/Writing-Script-Tasks-to-Use-the-Office-PIAs.aspx Course: http://www.learnitfirst.com/Course/153/SSIS-2005.aspx Skill Level: 500 (Advanced) Length: 18:30 (18.2MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: primary interop assembly, primary interop assemblies, Microsoft.Office, Microsoft.Office.Interop, Microsoft.Office.Interop.Excel

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.

SSRS 2005 Training Video: Pt. 2 - How to Create your First Report With the Report Server Project Wizard

Pt. 2 - How to Create your First Report With the Report Server Project Wizard - view details
This second video in the section will start with the Query Builder and continue through the end Report Wizard and then start in the Report Designer.Highlights: Report types and table designsAbout Deployment and deployment locationChanging properties in Report DesignerUsing the Toolboxand much more! Source: http://www.learnitfirst.com/Course/154/Video/970/Create-First-Report-with-Report-Server-Project-Wizard-Pt2.aspx Course: http://www.learnitfirst.com/Course/154/SSRS-2005.aspx Skill Level: 200 (Beginner - Intermediate) Length: 8:16 (7.11MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: report, query builder, report designer, build report, create report, report types, deploy, first report,

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

C# Training Video: Pt. 2 - Understanding the Properties, the Tool box, and Design Time Programming

Pt. 2 - Understanding the Properties, the Toolbox, and Design Time Programming - view details
This video will take your web application further by introducing you to the Toolbox, Properties, and Design Time Programming. Your instructor Scott will walk you through the various aspects of these and what they can do for your web application.
Highlights:How to use Properties to edit variables
Where is my Toolbox?
What tags do��I need running inside of a form?
Functions of an asp label�� Source: http://www.learnitfirst.com/Course/189/Video/675/Understanding-the-Properties-Toolbox-and-Design-Time-Programming.aspx Course: http://www.learnitfirst.com/Course/189/C-Sharp-2005.aspx Skill Level: 200 (Beginner - Intermediate) Length: 10:00 (8.22MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: props

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

Visual Basic .NET Training Video: Pt. 1 - Identifying and Creatin g Server Controls

Pt. 1 - Identifying and Creating Server Controls - view details
This great first video will walk you through the steps of creating and identifying server codes, which are useable across web applications and can save you extra work
Highlights:User��codes vs��server codes
Examples of server codes
How to properly build server controls and class libraries Source: http://www.learnitfirst.com/Course/199/Video/802/Identify-and-Create-Server-Controls.aspx Course: http://www.learnitfirst.com/Course/199/VB-2005.aspx Skill Level: 300 (Intermediate) Length: 14:45 (12.6MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: server side, class library

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.