IT Training Videos From LearnItFirst.com

SharePoint 2007 Training Video: How to Add a New Site to a Site C ollection in SharePoint Services 3.0

How to Add a New Site to a Site Collection in SharePoint Services 3.0 - view details
This video will show you how to build a workspace, or site within a site collection, for a specific project that gives people who are a part of the project the ability to go in and work on it. You'll also learn which template to use, how to edit permissions, and learn the process of adding owners and members to the site.

Highlights: Adding project site to title bar, left navigation bar or across the top of the parent siteWhat is a site within the site collection?How to customize site settings Source: http://www.learnitfirst.com/Course/225/Video/866/Add-a-New-Site-to-a-Site-Collection-in-SharePoint-Services-3.aspx Course: http://www.learnitfirst.com/Course/225/SharePoint-2007.aspx Skill Level: 200 (Beginner - Intermediate) Length: 5:00 (5.53MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: build site, build workspace, edit permissions, add owners, members, add project, customize, site settings, site with site collection

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.

SQL Server Programming and Queries Training Video: 01 - An Introd uction to Datatype Conversion

01 - An Introduction to Datatype Conversion - view details
Datatype conversion is what we, as developers, have to deal with on a daily basis. No matter what the language, data type conversion is a daily event. This video helsp introduce the concept from a SQL Server-specific standpoint.

Highlights from this video:Overview of the various datatypes available in SQL ServerNumbersStringsDatesDifferences between various datatypesUsing 'SELECT 123' statements and how SQL Server implements such queriesHow SQL Server performs datatype conversions in expressions and much more Source: http://www.learnitfirst.com/Course/150/Video/772/Intro-to-Datatype-Conversion.aspx Course: http://www.learnitfirst.com/Course/150/SQL-2005-Programming.aspx Skill Level: 200 (Beginner - Intermediate) Length: 11:00 (7.26MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: data type conversion, cast, convert, cast and convert, numeric, decimal, varchar(max), nvarchar(max), float, real, int32, int64

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.

SQL Server 2008 Analysis Services Training Video: Operating Syste ms, SQL Server Versions, and Differences

Operating Systems, SQL Server Versions, and Differences - view details
This short video will cover the operating system that Scott is using. It's okay if his screen looks a little different than yours. These are just aesthetic differences, you will still get all the necessary information from this course no matter what operating system you are using.

Highlights from this video:Different operating systems
Don't worry about aesthetic differences
Don't focus on the wrong thing
look at the big picture
and much more Source: http://www.learnitfirst.com/Course/165/Video/2610/OS-and-SQL-Server-Versions.aspx Course: http://www.learnitfirst.com/Course/165/SSAS-2008.aspx Skill Level: 100 (Beginner) Length: 04:30 (10.9MB) 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 2008, ssas, analysis services, r2

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.

SSIS 2005 Training Video: Pt. 7 - How to Manage Triggers and Chec k Constraints During Bulk Operations

Pt. 7 - How to Manage Triggers and Check Constraints During Bulk Operations - view details
This 7th video of the 12 part section will walk you through the process of firing tirggers and check constraints in SQL server, as they do not run by default, and finish the discussion of BCP.

Highlights:Creating and modifying triggersUsing "hints" to manually fire triggersBuilding a check constraintSecurity requirements for using BCP/BULK INSERT Source: http://www.learnitfirst.com/Course/153/Video/1294/Manage-Triggers-and-Check-Constraints-During-Bulk-Operations.aspx Course: http://www.learnitfirst.com/Course/153/SSIS-2005.aspx Skill Level: 500 (Advanced) Length: 09:00 (8.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: triggers, create trigger, fire triggers, BCP, BULKINSERT, check constraints

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.

SQL Server Programming and Queries Training Video: 10 - Final, Fi nal Thoughts

10 - Final, Final Thoughts - view details
Which one of the following SQL expressions will produce the correct answer to the division of 23 by 22 (should be 1.045...)?SELECT 23/22SELECT CAST(23/22 AS DECIMAL)SELECT CAST(23/22 AS FLOAT)Answer? None of the above! Watch this video to find out the answer... Source: http://www.learnitfirst.com/Course/150/Video/781/Table-Design-Final-Thoughts.aspx Course: http://www.learnitfirst.com/Course/150/SQL-2005-Programming.aspx Skill Level: 400 (Intermediate - Advanced) Length: 7:11 (6.64MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: converting datatypes, data types, convert date to string, convert date to characters

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.