IT Training Videos From LearnItFirst.com

SharePoint 2007 Training Video: How to Create a Survey with Share Point Services 3.0

How to Create a Survey with SharePoint Services 3.0 - view details
In this video you will learn how to add a survey to your SharePoint site, how to add questions to your survey, how to use branching logic, how export data from survey, how to customize the way your survey looks, and how to set-up a required response survey.

Highlights:How to adjust the title of your surveyHow to customize the way your survey looks Customizing the set-up of your survey in WSS Source: http://www.learnitfirst.com/Course/225/Video/852/Create-a-Survey-with-SharePoint-Services-3.aspx Course: http://www.learnitfirst.com/Course/225/SharePoint-2007.aspx Skill Level: 200 (Beginner - Intermediate) Length: 11:20 (11.6MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: create survey ,add survey, customize, survey, branching logic, export survey data,

This video comes from the SharePoint 2007 online training course, Building Portals with SharePoint 2007. And be sure to check out even more SharePoint (MOSS/WSS) training videos.

SSIS 2008 Training Video: Why the Send Mail Task Is Almost Useless

Why the Send Mail Task Is Almost Useless - view details
This video will cover the send mail task in SSIS and will show you why this task is almost useless. The times when this task will be helpful are few and far between and require certain conditions to be met on your network.

Highlights from this video:How to use the send mail task
Problems with the send mail task
SMTP connection manager
Can you use passwords?
Windows AuthenticationWhen the send mail task can work for you
and much more Source: http://www.learnitfirst.com/Course/158/Video/2028/Why-Send-Mail-Task-Is-Almost-Useless.aspx Course: http://www.learnitfirst.com/Course/158/SSIS-2008.aspx Skill Level: 200 (Beginner - Intermediate) Length: 10:30 (26.0MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: SSIS, send mail task, email, smtp

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 2008 Analysis Services Training Video: Exercise 02: St ored Procedures with OUTPUT Parameters

Exercise 02: Stored Procedures with OUTPUT Parameters - view details
Exercise 2 will cover stored procedure input and output parameters. Be sure to grab the corresponding
.pdf file that came with this
video, titled Ch09_11_Exercise_02.pdf. When Scott prompts you, work
through the exercise. If you then want to see Scott walk you through the
solutions, come back to the video after the pause.

Highlights from this video:Creating a stored procedure that returns a result set
Input and output parameters
and much more Source: http://www.learnitfirst.com/Course/161/Video/3032/Exercise-OUTPUT.aspx Course: http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx Skill Level: 400 (Intermediate - Advanced) Length: 3:00 (10.4MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: exercise, stored procedure, result set, execute, input parameter, output parameter

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

SQL Server 2008 Analysis Services Training Video: Real World Code : Audit Trail Trigger to Store Previous Value in a New Column

Real World Code: Audit Trail Trigger to Store Previous Value in a New Column - view details
Here's a real world example of using an AFTER trigger. Looking at a simple scenario in which users must create new passwords that cannot be the same as their last passwords, Scott points out some tricks and potential complications with using the AFTER trigger.

Highlights from this video:An AFTER trigger in actionUsing a trigger to audit a changeCreating a new triggerHow many times does a trigger fire per batch? Why is this important?The T-SQL JOIN syntax
and much more Source: http://www.learnitfirst.com/Course/161/Video/3009/Audit-1.aspx Course: http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx Skill Level: 300 (Intermediate) Length: 11:30 (26.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: trigger, after, dml, primary key, table, virtual, join, fire, audit, change, syntax

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

SQL Server 2008 Analysis Services Training Video: How SQL Server Uses Indexes in Queries

How SQL Server Uses Indexes in Queries - view details
The visualizations in this video will help clarify all of these index-related concepts you've been learning in the last two videos, and introduce some new ones. You'll look at the format of a typical SQL Server page, an index page, and learn about reading a B-Tree. Scott demonstrates working with indexes using several examples, including an intentionally poorly designed table. What happens when you ask for a specific row or subset of rows over a table with no indexes?

Highlights from this video:A typical SQL Server page
Understanding a B-Tree
The row locator
What is a Seek?Figuring out what SQL's execution plan will be for a query based on the search argument
and much more Source: http://www.learnitfirst.com/Course/161/Video/2959/Indexes-Queries.aspx Course: http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx Skill Level: 200 (Beginner - Intermediate) Length: 16:00 (30.9MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: index, row locator, b tree, seek, search argument, sarg

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

SSIS 2008 Training Video: Incremental Updates: Options Available for Performing Incremental Updates with SSIS, Part 2

Incremental Updates: Options Available for Performing Incremental Updates with SSIS, Part 2 - view details
In the previous video Scott gave a brief overview of the different options available for performing incremental updates with SSIS. In this video Scott will cover the three main techniques for performing incremental loads with SSIS in depth, as well as how to actually accomplish an incremental load.

Highlights from this video:Status columnexample (I, U, D. or N)
writing a query that will show rows that need to be added
LastModified or ModifiedDatafilter for source rowsHow do you deal with deletes?
Change Data Capture (CDC)when using SQL 2008 as a sourcefilter on changes since last syncHow to accomplish an incremental loadseries of execute SQL tasksdata flow task with conditional split
and much more Source: http://www.learnitfirst.com/Course/158/Video/2161/Pt2-Options-For-Incremental-Updates.aspx Course: http://www.learnitfirst.com/Course/158/SSIS-2008.aspx Skill Level: 500 (Advanced) Length: 10:30 (31.7MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: SSIS 2008, incremental updates, incremental loads, options, status column, lastmodified, modifieddata, change data capture, CDC, execute sql task, data flow task, conditional split

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.

SSIS 2008 Training Video: Importing Data Using the Wizards: How t o Import Microsoft Access Tables, Part 1

Importing Data Using the Wizards: How to Import Microsoft Access Tables, Part 1 - view details
This video and the two following will show you how to create your first packages in SSIS using the Wizards. This video will show you how to do Microsoft Access Integration. 

Highlights from this video:Setting up the demo
How to get a sample databaseGetting data out of Access into SQL Server
and much more Source: http://www.learnitfirst.com/Course/158/Video/2003/Pt1-Import-Microsoft-Access-Tables.aspx Course: http://www.learnitfirst.com/Course/158/SSIS-2008.aspx Skill Level: 200 (Beginner - Intermediate) Length: 11:00 (18.2MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: SSIS, microsoft acces, import, sql server 2008, integration

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 2008 DBA Training Video: Database Snapshots: What They Are and How to Use Them

Database Snapshots: What They Are and How to Use Them - view details
In our final video in this chapter we will lecture on the topic of database snapshots, a read-only copy of a live database.

Highlights from this video:What are database snapshots?
About database snapshots
Three purposes for database snapshots
Database snapshots and sparse files
Pros and cons of snapshots

and much more Source: http://www.learnitfirst.com/Course/157/Video/1932/Database-Snapshots-Intro.aspx Course: http://www.learnitfirst.com/Course/157/SQL-Server-2008-DBA.aspx Skill Level: 300 (Intermediate) Length: 16:00 (24.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: snapshot,database,intro,sql server,2008

This video comes from the SQL Server 2008 DBA online training course, SQL Server 2008 Database Administration. And be sure to check out even more MSSQL Server 2008 training videos.

Exchange 2007 Training Video: How to Configure Anti-SPAM On a Hub Transport Server

How to Configure Anti-SPAM On a Hub Transport Server - view details
Are you in need of some help in configuring your Anti-SPAM capabilities on your Hub Transport Server? In this great video tutorial, Grant Moyle will help you to do so, as well as detail the various anti-SPAM features.

Highlights from this video:About anti-SPAM capabilitiesContent FilteringIP Allow ListIP Allow List ProvidersIP Block ListIP Block List ProvidersRecipient FilteringSender FilteringSender IDSender ReputationCustomizing feature propertiesFiltering and defining SCL, Spam Confidence Level, thresholdsand more! Source: http://www.learnitfirst.com/Course/222/Video/1203/Configure-Anti-SPAM-on-a-Hub-Transport-Server.aspx Course: http://www.learnitfirst.com/Course/222/Exchange-2007.aspx Skill Level: 300 (Intermediate) Length: 14:15 (9.0MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: Configure Anti-SPAM , antispam, anti spam

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: Simple Subqueries in the SELECT Column List and CASE

Simple Subqueries in the SELECT Column List and CASE - view details
Up until now you have only seen using simple subqueries in the WHERE clause. In this video Scott will introduce using simple subqueries in the SELECT column list and the CASE clause.

Highlights from this video:SELECT column list
simple subquery
CASE clause
simple subquery
Examples of using each
and much more Source: http://www.learnitfirst.com/Course/160/Video/2390/Simple-Subqueries-and-SELECT-and-CASE.aspx Course: http://www.learnitfirst.com/Course/160/SQL-Queries-2008.aspx Skill Level: 300 (Intermediate) Length: 12:30 (30.7MB) 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, simple subquery, select column list, case

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.