IT Training Videos From LearnItFirst.com

SQL Server 2005/2008 Queries Training Video: WHERE: Using BETWEEN and NOT BETWEEN

WHERE: Using BETWEEN and NOT BETWEEN - view details
Another useful operator in SQL Server is BETWEEN. In this video Scott will cover the BETWEEN statement, and show you some real world examples of when you would use this statement.

Highlights from this video:Test for ranges
Collapsing a range using BETWEEN
inclusiveused for numerics and dates
and much more Source: http://www.learnitfirst.com/Course/160/Video/2261/Using-BETWEEN-and-NOT-BETWEEN.aspx Course: http://www.learnitfirst.com/Course/160/SQL-Queries-2008.aspx Skill Level: 200 (Beginner - Intermediate) Length: 04:15 (11.6MB) 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, between, range, inclusive, numerics, dates

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.

SharePoint 2007 Training Video: How to Configure an Antivirus Sol ution for SharePoint Services 3.0 Using Microsoft ForeFront

How to Configure an Antivirus Solution for SharePoint Services 3.0 Using Microsoft ForeFront - view details
Should a virus ever wind up on your database, you'll need to turn to Microsoft ForeFront. This video will show you how to customize and configure your antivirus settings, such as when to perform scans, the antivirus timeout, and also how many threads the antivirus gets.

Highlights:How to do a local, full installation of ForeFrontIntegrating Antivirus scan enginesManaging ForeFront Security Source: http://www.learnitfirst.com/Course/225/Video/855/Configure-Antivirus-Solution-for-SharePoint.aspx Course: http://www.learnitfirst.com/Course/225/SharePoint-2007.aspx Skill Level: 400 (Intermediate - Advanced) Length: 10:40 (7.21MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: microsoft forefront, antivirus,virus, configure antivirus, setup antivirus, install forefront

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: Chapter Introduction: What Is Included

Chapter Introduction: What Is Included - view details
Chapter 5 marks the little farther than halfway point for the course. Starting with this chapter we will begin covering more advanced and detailed scenarios based on the basics we covered in the previous chapters. In this chapter you will learn about variables, expressions, and package configurations and also see some more "real world" scenarios. This video will give you an overview of and introduction to chapter 5.

Highlights from this video:Why is this chapter important?
Making your SSIS packages dynamic
How do variables work in SSIS?
Using SSIS expressionsChanging package settings at runtime
and much more Source: http://www.learnitfirst.com/Course/158/Video/2116/Chapter-Intro-What-Is-Included.aspx Course: http://www.learnitfirst.com/Course/158/SSIS-2008.aspx Skill Level: 100 (Beginner) Length: 5:15 (9.29MB) 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, SSIS 2008, dynamic packages, variables, system variable, user variables, expressions, package settings

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 Reporting Services Training Video: Things to Know : Page Size, Margins, and Pagination

Things to Know: Page Size, Margins, and Pagination - view details
In this video Scott will go over some basic things you need to know about rendering reports. This video will focus on page size, pagination, and margins.

Highlights from this video:What is pagination?
Report viewer control
dynamic environment
Report properties
page width and orientation
most consistent and easiest
Page width and orientation
non-standard way
and much more Source: http://www.learnitfirst.com/Course/162/Video/2501/Page-Size-Margins-and-Pagination.aspx Course: http://www.learnitfirst.com/Course/162/SSRS-2008.aspx Skill Level: 200 (Beginner - Intermediate) Length: 14:00 (51.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 2008, ssrs, reports, page size, margins, pagination

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

SQL Server 2008 DBA Training Video: Creating SQL Server Authentic ation Logins and Working with Policies

Creating SQL Server Authentication Logins and Working with Policies - view details
Continuing in this video is our discussion on logins and authentication. We will specifically cover the SQL Server Authentication logins and demonstrate how to change your authentication mode as well as explore security for login passwords.

Highlights from this video:
What are SQL Server Authentication logins and how do they differ from Windows Authentication?
About SQL Server logins and password policies
Logins for specific situations
Logins mapped to asymmetric key or credentialHow to change your authentication mode
and much more Source: http://www.learnitfirst.com/Course/157/Video/1680/Create-SQL-Server-Authentication-Logins-and-Working-with-Policies.aspx Course: http://www.learnitfirst.com/Course/157/SQL-Server-2008-DBA.aspx Skill Level: 200 (Beginner - Intermediate) Length: 09:15 (18.0MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: login, password, security, sql, server, 2008, sql authentication, authentication mode,

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.

Visual Basic .NET Training Video: Pt. 1 - Creating Our First Cons ole Application Using Visual Basic and .NET

Pt. 1 - Creating Our First Console Application Using Visual Basic and .NET - view details
This first video tutorial in the section on Console Applications will walk you through the process of creating the very useful console applications in Visual Basic and how to run them.Highlights:Setting assembly information Visual Basic configuration : Debug vs Release Accessing your program directory How to run your console application via cmd prompt Source: http://www.learnitfirst.com/Course/199/Video/830/Create-First-Console-Application-Using-Visual-Basic-and-NET.aspx Course: http://www.learnitfirst.com/Course/199/VB-2005.aspx Skill Level: 200 (Beginner - Intermediate) Length: 10:31 (7.86MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: beginner, console application, easy, visual basic

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.

SQL Server 2008 DBA Training Video: Create a SQL Server Job to Ba ckup Your Databases, Part 1

Create a SQL Server Job to Backup Your Databases, Part 1 - view details
These next couple of videos are just about jobs and each video will cover a specific scenario. In this video we will create and schedule a job to backup your databases.

Highlights from this video:Job categories and creating a new category
How to create a new job
Choosing a job step type
Setting up a new job schedule

and much more Source: http://www.learnitfirst.com/Course/157/Video/1880/Pt1-Create-Job-to-Backup-Databases.aspx Course: http://www.learnitfirst.com/Course/157/SQL-Server-2008-DBA.aspx Skill Level: 200 (Beginner - Intermediate) Length: 11:45 (17.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: job, job step, sql server, 2008,create,backup,

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 DBA Training Video: How to Take Backups in SQL Se rver Management Studio (SSMS)

How to Take Backups in SQL Server Management Studio (SSMS) - view details
In this video we will demonstrate how to use the graphical tools (SSMS - SQL Server Management Studio) to perform backups of your databases.

Highlights from this video:'Back up database' options in SSMS
Append or overwrite existing backup set?
Multiple backups of a backup file

and much more Source: http://www.learnitfirst.com/Course/157/Video/1826/Take-Backups-in-SSMS.aspx Course: http://www.learnitfirst.com/Course/157/SQL-Server-2008-DBA.aspx Skill Level: 200 (Beginner - Intermediate) Length: 18:00 (27.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: backup, ssms, sql server, database, 2008, walkthrough, demo

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 Analysis Services Training Video: Installing SSAS 2008 on a First Time Installation, Part 2

Installing SSAS 2008 on a First Time Installation, Part 2 - view details
In this video Scott will finish up the first time installation of SSAS 2008 that he started in the previous video.

Highlights from this video:Server configuration
collation
Database engine configuration
Analysis services configuration
Installation rules
and much more Source: http://www.learnitfirst.com/Course/165/Video/2631/SSAS-First-Time-Installation-Pt2.aspx Course: http://www.learnitfirst.com/Course/165/SSAS-2008.aspx Skill Level: 200 (Beginner - Intermediate) Length: 13:30 (35.8MB) 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, analysis services, ssas, r2, installation

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.

Visual Basic .NET Training Video: Pt. 2 - Using the Logical And, Or, and Not Operators, Parentheses, and Else If

Pt. 2 - Using the Logical And, Or, and Not Operators, Parentheses, and Else If - view details
This second video in the section on If statements in Visual Basic 2005 will cover additional��branching within your If statements and the multiple conditions (And,Or,Not) you can use when writing expressions, and also using parenthesis to write even more complex expressions.Highlights:How to combine conditions using IfConditional requirements��of And, OrAbout ElseIf statements, Else statements������ Source: http://www.learnitfirst.com/Course/199/Video/1042/Using-Logical-And-Or-and-Not-Operators-Parentheses-and-Else-If.aspx Course: http://www.learnitfirst.com/Course/199/VB-2005.aspx Skill Level: 200 (Beginner - Intermediate) Length: 10:45 (7.42MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: And, Or, Not Operators, Parentheses, Else If, statements,else, and ,or,not

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.