IT Training Videos From LearnItFirst.com

Course PDFs Available for SQL 2005 Video Training Courses

Over at LearnItFirst.com, the web's best training video site (in our opinion), we've just released a whole slew of companion PDFs for our SQL Server 2005 training courses:

• SQL Server 2005 training videos
• SQL Server DBA training videos
• Integration Services training videos
• Reporting Services training videos

These new SQL Server training PDFs feature a listing of every SQL Server 2005 video tutorial in each course along with a checkbox that helps you track which videos you have watched.

SQL Server Programming and Queries Training Video: 09 - Best Prac tices, Writing CASE Statements, and Final Thoughts

09 - Best Practices, Writing CASE Statements, and Final Thoughts - view details
Originally when Scott Whigham (author of this site) recorded thissection , this video was supposed to be the last video... Source: http://www.learnitfirst.com/Course/150/Video/780/Best-Practices-and-Writing-CASE-Statements.aspx Course: http://www.learnitfirst.com/Course/150/SQL-2005-Programming.aspx Skill Level: 400 (Intermediate - Advanced) Length: 6:15 (6.02MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: CASE, Searched case, boolean case, selector case

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.

Exchange 2007 Training Video: Part 5 - Final Steps to Complete ou r Exchange 2007 Migration

Part 5 - Final Steps to Complete our Exchange 2007 Migration - view details
The last steps to complete our Exchange 2003 to Exchange 2007 migration are primarily cleanup steps. Are you using recipient policies? You need to watch this video. What about Recipient Update Services? Will this affect your Exchange migration? How can you change it?

Highlights from this video:Installing the Windows Support ToolsUsing ADSIEdit to diagnose and troubleshoot problemsUsing Active Directory Sites and ServicesMessage queues, Storage groups, and mailbox cleanupUninstalling Exchange 2003! and much more Source: http://www.learnitfirst.com/Course/222/Video/1282/Completing-the-Exchange-2007-Migration.aspx Course: http://www.learnitfirst.com/Course/222/Exchange-2007.aspx Skill Level: 300 (Intermediate) Length: 13:00 (18.9MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: upgrade, migration, Exchange 2007, Exchange 2003

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 2008 Analysis Services Training Video: IDENTITY Column s and Inserts

IDENTITY Columns and Inserts - view details
Scott demonstrates working with IDENTITY columns in this video, pointing out some traps to watch for along the way. How should you handle a primary key or unique constraint violation?

Highlights from this video:Sending conflicting instructions to SQL Server on putting values into a column
Can you change the values of an IDENTITY column?
Successfully inserting specific valuesWhy use surrogate key values?
IDENTITY_INSERT
and much more Source: http://www.learnitfirst.com/Course/161/Video/2985/Identity-Columns-Inserts.aspx Course: http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx Skill Level: 300 (Intermediate) Length: 11:30 (25.6MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: identity, insert, column, primary key, unique constraint, violiation, value, surrogate

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.

C# Training Video: Pt. 5 - Our First Console Application in Visual Studio

Pt. 5 - Our First Console Application in Visual Studio - view details
This video will give you a first look at the deployment process of a console application and also show you what is necessary for a debug/release build.
Highlights:What is the deployment strategy?
Structure of .pdb files
How to release a build via configuration change�� Source: http://www.learnitfirst.com/Course/189/Video/672/Writing-Your-First-Console-Application-in-Visual-Studio-Pt5.aspx Course: http://www.learnitfirst.com/Course/189/C-Sharp-2005.aspx Skill Level: 300 (Intermediate) Length: 52:52 (7.44MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: dos, command prompt, command line, services

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. 9 - sp_start_job Options and Security: Cre dentials, Proxy Accounts and More

Pt. 9 - sp_start_job Options and Security: Credentials, Proxy Accounts and More - view details
This is one of Scott's favorites - how to run an SSIS job from a remote
machine using a stored procedure called sp_start_job. In this video,
Scott talks about how to execute packages remotely using T-SQL as well
as discussions on executing remote jobs using .NET. This video talks
about scheduling SSIS jobs, credentials, proxy accounts, and more -
this is a very 'deep' video.

Highlights from this video:What are SQL credentials?How can I force execution of the SSIS package with a certain account?What are proxies and proxy accounts in SQL?Should I run my SSIS package as the SQL Agent Service Account or is there a better, more secure way?How to assign parameter values when you execute/call a SQL job for SSISand much more Source: http://www.learnitfirst.com/Course/189/Video/1257/sp-start-job-Options-Credentials-and-Proxy-Accounts.aspx Course: http://www.learnitfirst.com/Course/189/C-Sharp-2005.aspx Skill Level: 500 (Advanced) Length: 9:30 (10.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: sql server proxy account, job credentials

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.

SQL Server 2008 DBA Training Video: Deprecated and Discontinued I tems in SQL Server 2008

Deprecated and Discontinued Items in SQL Server 2008 - view details
In this essential video tutorial, Scott Whigham will provide you with an overview of some of the items that have been deprecated and discontinued��in SQL Server 2008. The most widely used and most popular deprecated and discontinued items are listed and discussed. Also,��a .PDF file of Scott Whigham's presentation is included with your download!
Highlights from this video:Defining "deprecated"
Items that may not work in the futureDefining "discontinued"
Items that won't work right nowMost popular discontinued items and their replacements
Widely used deprecated items and their replacementsand much more Source: http://www.learnitfirst.com/Course/157/Video/1587/Discontinued-In-SQL-2008.aspx Course: http://www.learnitfirst.com/Course/157/SQL-Server-2008-DBA.aspx Skill Level: 100 (Beginner) Length: 07:15 (12.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: deprecated, discontinued, sql 2008, out of service,, introduction, step by step, beginner, beginning, for dummies

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.

SQL Server 2008/R2 Reporting Services Training Video: Exercise 01 : How to Use the Exercises in this Course

Exercise 01: How to Use the Exercises in this Course - view details
In this video you will see how the exercises in this course will work and create folders on your hard drive for the exercises and their solutions.

Highlights from this video:Overview of exercise videos
and much more Source: http://www.learnitfirst.com/Course/162/Video/2448/Exercise-How-To-Use-Exercises.aspx Course: http://www.learnitfirst.com/Course/162/SSRS-2008.aspx Skill Level: 100 (Beginner) Length: 06:15 (15.9MB) 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, reporting services, exercises

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

SQL Server 2008/R2 Reporting Services Training Video: Creating Yo ur First Gauge Reports

Creating Your First Gauge Reports - view details
In this video Scott will walk you through how to create a gauge and put it into your report. It is easy to learn the basics of gauges, but in order to become more advanced it's important that you work with gauges on your own.

Highlights from this video:Some tips on working with gauges
Creating a gauge
Insert Gauge
radial or linear?
Different gauge options
and much more Source: http://www.learnitfirst.com/Course/162/Video/2550/Creating-Gauge-Reports.aspx Course: http://www.learnitfirst.com/Course/162/SSRS-2008.aspx Skill Level: 300 (Intermediate) Length: 18:15 (72.3MB) 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, ssrs, reporting services, reports, gauge, radial, linear

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

SharePoint 2007 Training Video: How to Install SharePoint Service s 3.0 on a Domain Controller

How to Install SharePoint Services 3.0 on a Domain Controller - view details
In this video you will be learning how to install SharePoint Services on a domain controller, even though it is not recommended. Also you'll learn how to configure the application server for IIS, how to utilize the SMTP service, what measure to take when installing on a domain server, allowing ASP.NET to run, using the SharePoint Products and Technologies Configuraton Wizard, and how to check event logs.

Highlights:How to configure the application server for IISHow to turn on the SMTP serviceWhat measures to be taken when installing on a domain serverUsing the Configuration WizardHow to check the event logs for errors Source: http://www.learnitfirst.com/Course/225/Video/856/Install-SharePoint-Services-3-on-a-Domain-Controller.aspx Course: http://www.learnitfirst.com/Course/225/SharePoint-2007.aspx Skill Level: 400 (Intermediate - Advanced) Length: 14:30 (9.55MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: install sharepoint, domain controller, SMTP service, configure server IIS, domain server, installing,

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.

Exchange 2007 Training Video: Part 1 - Discussion on Cluster Cont inuous Replication

Part 1 - Discussion on Cluster Continuous Replication - view details
Offering server high availability and an automated failover process, Cluster Continuous Replication (CCR) is great for those of you who have numerous Exchange 2007 servers. With CCR we can eliminate the need for the storage array in the Storage Area Network, saving you a whole lot of money, by using a local disk. In this video section, your instructor Grant Moyle will walk you through the long process of installing Exchange 2007 in CCR configuration as well as��go over how the cluster actually works and the basic recipe needed to build the cluster. The subsequent videos in this section will build on this info and install the two cluster nodes, the Windows components of clustering, the Exchange components of clustering, and we'll end the section with a completed Exchange 2007 CCR configuration.
Highlights from this video:About working with��Cluster Continour Replication Prep-work and prerequisites for the cluster setup Examine existing network configuration Configuring a new local area connectionConfiguring Local Disk and Heartbeat Network Ideal configuration for your serversand much more Source: http://www.learnitfirst.com/Course/222/Video/1504/Discussion-on-Cluster-Continuous-Replication.aspx Course: http://www.learnitfirst.com/Course/222/Exchange-2007.aspx Skill Level: 300 (Intermediate) Length: 18:30 (14.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: ccr, cluster, continuous, replication, failover, server, node,

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.