IT Training Videos From LearnItFirst.com

SQL Server 2008 Analysis Services Training Video: Creating DEFAUL T Constraints

Creating DEFAULT Constraints - view details
This video provides a demonstration of using default constraints. The example will include the constraint syntax, what to use defaults for, and much more.

Highlights from this video:
Review of the constraint design pattern
Overriding the default value
and much more Source: http://www.learnitfirst.com/Course/161/Video/2914/DEFAULT-Constraints.aspx Course: http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx Skill Level: 300 (Intermediate) Length: 7:00 (17.1MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: default, constraint, null

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: Analysis Services Tasks: Processing Cub es and the Data Mining Query Task

Analysis Services Tasks: Processing Cubes and the Data Mining Query Task - view details
This is the final video that covers Analysis Services Tasks. The focus of this video will be on Processing Cubes and the Data Mining Query Task.

Highlights from this video:What happens when you process the cube?
Monitoring the process cube task
What does the data mining query task do?
What is the purpose of the data mining query task?
and much more Source: http://www.learnitfirst.com/Course/158/Video/2072/Processing-Cubes-and-Data-Mining-Query-Task.aspx Course: http://www.learnitfirst.com/Course/158/SSIS-2008.aspx Skill Level: 400 (Intermediate - Advanced) Length: 09:30 (16.1MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: SSIS, 2008, SSAS, analysis services, processing cubes, data mining query task, overview

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: How the Exercis es Are Designed to Help You

How the Exercises Are Designed to Help You - view details
Why is doing the exercises in this course so important? Trainer Scott Whigham explains how active participation can help you absorb and retain the material presented in the course. The exercises are specifically designed to reinforce the information that you see and hear in these videos.     

Highlights from this video:How are exercises organized and placed throughout the course?
Augmenting the learning process
What if an exercise is too difficult?How to use the PDF files with the exercises
and much more Source: http://www.learnitfirst.com/Course/161/Video/2854/Exercises-Help.aspx Course: http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx Skill Level: 100 (Beginner) Length: 4:30 (10.2MB) 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, 2005, t-sql, conversion, IF, table, permanent, objects, function, data, transaction, locking, ddl, dml, trigger, action, xml, clr, program, geospatial, encryption, clob, blob

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 Reporting Services Training Video: Subreports and Nested Reports

Subreports and Nested Reports - view details
You will used subreports and nested reports all the time. In this video Scott will overview using subreports and nested reports, and show you how these will help increase your reports usability.

Highlights from this video:Increased usability
Creating a subreport
include another report within your report
Subreport properties
and much more Source: http://www.learnitfirst.com/Course/162/Video/2543/Subreports-and-Nested-Reports.aspx Course: http://www.learnitfirst.com/Course/162/SSRS-2008.aspx Skill Level: 400 (Intermediate - Advanced) Length: 11:30 (40.0MB) 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, subreports, nested reports, usability

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 2005/2008 Queries Training Video: How to Decide Betwee n a JOIN and a Subquery

How to Decide Between a JOIN and a Subquery - view details
How do you determine whether you should be writing a JOIN or a subquery? In this video Scott will show you how to decide which method to use, as well as how to rewrite a JOIN as a subquery, and a subquery as a JOIN.

Highlights from this video:Subquery vs. JOIN
Decision process
Pre-requisites for this video
knowledge of JOINS
Examples
walk through the decision processsubquery or JOIN?
and much more Source: http://www.learnitfirst.com/Course/160/Video/2388/Decide-Between-JOIN-and-Subquery.aspx Course: http://www.learnitfirst.com/Course/160/SQL-Queries-2008.aspx Skill Level: 300 (Intermediate) Length: 12:45 (31.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, queries, subqueries, join

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 2008 Analysis Services Training Video: Chapter Intro a nd the Challenges LOBs Present

Chapter Intro and the Challenges LOBs Present - view details
Here, Trainer Scott Whigham starts with a quick overview of what's covered in this chapter, and explains where you are in the course. You'll learn about two special requirements for CLOBs and BLOBs: storage needs and query techniques. Using some examples, Scott demonstrates each of these requirements in detail and begins a discussion of full-text indexes and full-text search (FTS) that will be continued in the next video.

Highlights from this video:What's included in this chapterWhere you are in the context of the course
Chapter pre-requisites
The special requirements for CLOBs and BLOBs since they're largeStorage needsSpecial query techniquesDemonstrations using example dataAn estimator tool: the SQL Server DataSizerWhat is the purpose of full-text indexes and the full-text search (FTS)?
and much more Source: http://www.learnitfirst.com/Course/161/Video/3096/Chapter-Intro.aspx Course: http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx Skill Level: 100 (Beginner) Length: 11:15 (23.3MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: introduction, blob data, clob data, full-text indexing, full-text search, fts, filestream, lob storage needs, lob query techniques, sql server datasizer tool, proximity search

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 - How to Author and Deploy Reports

Pt. 5 - How to Author and Deploy Reports - view details
Now that you've seen the basics - the architecture, the terms, the definitions - it's time to create and deploy reports. This video shows you the basics of report authorship (including which tools you can use to create a report) as well as how deployment works.

Highlights from this video:What does an .RDL file look like?Understanding the basics of report deploymentPreviewing reports vs. deploying reportsand much more Source: http://www.learnitfirst.com/Course/189/Video/1173/Author-and-Deploy-Reports-in-SSRS.aspx Course: http://www.learnitfirst.com/Course/189/C-Sharp-2005.aspx Skill Level: 100 (Beginner) Length: 14:30 (13.0MB) 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, 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.

SharePoint 2007 Training Video: How to Restore a SharePoint List (and how to Create a SharePoint List)

How to Restore a SharePoint List (and how to Create a SharePoint List) - view details
Part of any SharePoint administrator/content-manager's job is keeping the site up to date. Part of this requires you to delete lists and list items periodically. This video shows you how to create lists in SharePoint as well as how to perform list maintenance.

Highlights from this video:How to create listsHow to delete/remove listsHow to clean up the Quick Launch bar after deleting a listRestoring a SharePoint list that was removed and much more Source: http://www.learnitfirst.com/Course/225/Video/1085/Create-and-Restore-SharePoint-List.aspx Course: http://www.learnitfirst.com/Course/225/SharePoint-2007.aspx Skill Level: 400 (Intermediate - Advanced) Length: 5:30 (6.63MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: backup, backing up, disaster recovery, restoring, restored, lists, items

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 2008 Analysis Services Training Video: The Basics of E xecution Plans and SHOWPLAN

The Basics of Execution Plans and SHOWPLAN - view details
Many of the ideas in this video will be revisited in chapters 5 and 11, so expect mostly basics here - details will come in later videos. Using the query from the last video, trainer Scott Whigham discusses execution plans. How can you uncover the steps SQL Server went through to arrive at the results? What is SHOWPLAN?

Highlights from this video:What does the execution plan tell us?
How can you look at the execution plan?
Estimated Execution Plan vs. Actual Execution Plan
How does SQL Server choose indexes?
Analyzing and understanding graphical execution plansDetermining costs of the components of executionUsing SHOWPLAN

and much more Source: http://www.learnitfirst.com/Course/161/Video/2931/Execution-Plans.aspx Course: http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx Skill Level: 200 (Beginner - Intermediate) Length: 21:15 (51.0MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: showplan, sql server steps, execution plan, estimated, acutal, graphical, index, cost

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: Tips on Bulk Lo ading Data, Part 1

Tips on Bulk Loading Data, Part 1 - view details
This video focuses on loading data from external sources, specifically text files. The ETL (Extract, Transform, Load) process is very common. SSIS' built-in tasks are often used for bulk transfer, but what if you need more than the built-in tasks, or don't even have access to SSIS? Here, and continued in part 2 of this video, you'll learn a valuable step-by-step approach to optimizing bulk loading operations.

Highlights from this video:Why loading tables from external text files can be time consuming
Bulk loading without SSIS
What is a minimally logged transaction?
Example of traditional loggingExample of minimally logged XACTs
Why is minimal logging during bulk loads important?
Optimizing bulk loading operationsThe eight steps

and much more Source: http://www.learnitfirst.com/Course/161/Video/3072/Bulk-Loading-P1.aspx Course: http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx Skill Level: 400 (Intermediate - Advanced) Length: 14:45 (29.3MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: extract, transform, load, tables, external source, text file, optimize bulk loading, pattern, ssis, logged transaction, traditional logging, minimal logging, bulk logged, nonclustered index, recovery model

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.