IT Training Videos From LearnItFirst.com

SSIS 2005 Training Video: Part2-Setting and Getting Variables Usi ng the Script Task and Visual Basic (VSA)

Part2-Setting and Getting Variables Using the Script Task and Visual Basic (VSA) - view details
Ever wonder where the box to display your variables is placed or where in the Project Explorer they are located? Well, in this second video in the section you will take a look at how to gain access to your variables using the Script Task in Microsoft Visual Studio, as it is not easily done from the script task editor interface.

Highlights from this video:Viewing/Filtering system variables vs user variablesUsing Dts.VariablesSome annoyances in SSIS with variablesScript task editorDTS Script Task Runtime ErrorAutoSaving script changesCString or ToString for displaying message boxes containing variablesReadOnly variables and ReadWrite variablesBehavioral changes in SSIS from DTS and much more Source: http://www.learnitfirst.com/Course/153/Video/1334/Setting-and-Getting-Variables-Using-Script-Tasks.aspx Course: http://www.learnitfirst.com/Course/153/SSIS-2005.aspx Skill Level: 200 (Beginner - Intermediate) Length: 11:45 (11.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: variables, variable, script task, user defined variables, system variables, dts.variables

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.

Exchange 2007 Training Video: Assign SSL Certificate to OWA, POP3 , IMAP, and SMTP

Assign SSL Certificate to OWA, POP3, IMAP, and SMTP - view details
A commercial SSL certificate can be used throughout your Exchange server to provide authentication information and is also used to negoitate encryption between two points. In this video tutorial, Grant will show you how to assign your SSL certificate to services such as OWA, POP3, IMAP, and SMTP.

Highlights from this video:Where is my SSL Certificate available?
How IMAP and POP3 use the SSL certificate
Using the SSL certificate in Hub Transport
Enabling your certifcate in the SMTP service
and much more Source: http://www.learnitfirst.com/Course/222/Video/1469/Assign-SSL-Certificate-to-OWA-POP3-IMAP-and-SMTP.aspx Course: http://www.learnitfirst.com/Course/222/Exchange-2007.aspx Skill Level: 300 (Intermediate) Length: 09:30 (9.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: imap,pop3,smtp,owa, ssl, certificate, hub transport

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.

SQL Server 2005/2008 Queries Training Video: Subqueries and Opera tors - Know the Rules!

Subqueries and Operators - Know the Rules! - view details
This video will cover a few more of the rules that you need to know when working with subqueries. It is easy to forget about these rules, and they generally won't give you a syntax error, so it can be hard to know when you made an error. 

Highlights from this video:Subquery rules
Remembering rules from previous chapters
What do relational operators require?
when can you use relational operators with subqueries?
and much more Source: http://www.learnitfirst.com/Course/160/Video/2386/Subqueries-and-Operators.aspx Course: http://www.learnitfirst.com/Course/160/SQL-Queries-2008.aspx Skill Level: 300 (Intermediate) Length: 13:15 (32.4MB) 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, operators, rules, relational operators

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 Programming and Queries Training Video: Part 1 - An Ov erview of the AdventureWorks Database

Part 1 - An Overview of the AdventureWorks Database - view details
AdventureWorks - the "new standard" for sample databases out of Redmond. Author Scott Whigham is certainly a fan of this new database for certain things but also feels reservations about the complexity of AdventureWorks when it comes to using it as your primary training database. Nevertheless, this video (part 1), walks you through the layout of AdventureWorks, how the schemas are used, and shows some of the "primary" relationships between the important tables and views. This video provides a good starting point for working with AdventureWorks and understanding how the tables are related. Source: http://www.learnitfirst.com/Course/150/Video/367/Overview-of-AdventureWorks-Database.aspx Course: http://www.learnitfirst.com/Course/150/SQL-2005-Programming.aspx Skill Level: 100 (Beginner) Length: 17:24 (12.4MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: adventureworks install, sample database, sql server sample database, sql server adventure works, oltp, beginner, beginning, for beginners, introduction, step by step

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.

C# Training Video: Pt. 1 - Installation and Configuration of the SQL Server 2005 Sample Applications for SQL, Reporting Services, C#, VB, a nd SSIS

Pt. 1 - Installation and Configuration of the SQL Server 2005 Sample Applications for SQL, Reporting Services, C#, VB, and SSIS - view details
This video (part one in this section) helps you install and, most importantly, configure the sample applications. It provides an overview of some of the common/best samples as well as discussions on when to use each. Source: http://www.learnitfirst.com/Course/189/Video/1105/Install-and-Configure-SQL-Server-2005-Samples.aspx Course: http://www.learnitfirst.com/Course/189/C-Sharp-2005.aspx Skill Level: 300 (Intermediate) Length: 9:30 (9.51MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: sql server sample applications, sample databases, integrated samples

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.

C# Training Video: Pt. 1 - An Introduction to CAPTCHAs and the Va rious Options

Pt. 1 - An Introduction to CAPTCHAs and the Various Options - view details
In this first video in the section, Scott will give you a basic introduction to CAPTCHAs, a piece for internet sites that is used to prevent multiple,automated types of spam by issuing distorted images and text that can only be solved by humans.Also in this video Scott will discuss with you some of the providers of CAPTCHA coding, mainly reCAPTCHA . Continued in the rest of�� this video section will be the different types of CAPTCHAs, how to customize for CAPTCHAs for your own website, and showing you how easy it is to work with them!

Highlights from this video:About the nature of CAPTCHAsreCAPTCHA Web Service and much more Source: http://www.learnitfirst.com/Course/189/Video/1342/Intro-to-CAPTCHAs-and-the-Various-Options.aspx Course: http://www.learnitfirst.com/Course/189/C-Sharp-2005.aspx Skill Level: 100 (Beginner) Length: 11:00 (14.0MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: CAPTCHA, reCAPTCHA, captcha, , introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

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.