IT Training Videos From LearnItFirst.com

SQL Server 2008 DBA Training Video: What are Bulk Operations in S QL Server?

What are Bulk Operations in SQL Server? - view details
We will continue our discussion on recovery models by discussing the Bulk Logged recovery model and start working with bulk operations in SQL Server 2008.

Highlights from this video:About the Bulk Logged recovery model
What is a bulk operation?
Fully logged and minimally logged bulk operations
The "Gotcha" of the Bulk Logged recovery model
and much more Source: http://www.learnitfirst.com/Course/157/Video/1815/Bulk-Operations.aspx Course: http://www.learnitfirst.com/Course/157/SQL-Server-2008-DBA.aspx Skill Level: 200 (Beginner - Intermediate) Length: 10:15 (16.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: bulk logged, recovery model, bulk operation, logged, 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.

SQL Server 2005/2008 Queries Training Video: How to Nest Aggregat es Using Derived Tables

How to Nest Aggregates Using Derived Tables - view details
In this video Scott will show you how to use the derived tables in order to do nested aggregates. This is a very common and useful way to use derived tables.

Highlights from this video:Examples of using derived tables to nest aggregates
Easy way
but is it the best way?
Nested aggregates
derived tables
and much more Source: http://www.learnitfirst.com/Course/160/Video/2404/How-to-Nest-Aggregates-Using-Derived-Tables.aspx Course: http://www.learnitfirst.com/Course/160/SQL-Queries-2008.aspx Skill Level: 500 (Advanced) Length: 13:45 (33.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, derived tables, nested aggregates

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 2005/2008 Queries Training Video: An Introduction to t he Ranking and Window Functions

An Introduction to the Ranking and Window Functions - view details
The last topic covered in chapter three will be ranking functions and window functions. In this video Scott will give an in depth overview of both ranking and window functions.

Highlights from this video:Window functions
segment of the result setpartition
Ranking function
ranks rows according to the function/window
OVER clause
Four ranking functions
ROW_UNDER, RANK, DENSE_RANK, NTILE
and much more Source: http://www.learnitfirst.com/Course/160/Video/2309/Ranking-and-Window-Functions-Intro.aspx Course: http://www.learnitfirst.com/Course/160/SQL-Queries-2008.aspx Skill Level: 300 (Intermediate) Length: 15:30 (45.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, ranking functions, window functions, partition, over clause, row_under, rank, dense_rank, ntile

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.

SSIS 2008 Training Video: SSIS Development Tip: Using Data Viewer s to Help You Visualize What Is Happening

SSIS Development Tip: Using Data Viewers to Help You Visualize What Is Happening - view details
This video will cover the data viewer in SSIS to help you visualize what is happening. This technique is useful for debugging, and will generally make your life much easier.

Highlights from this video:What is the data viewer used for?
Configuring the data viewer
Viewing data in the data viewer
Using the data viewer for validation warnings
and much more Source: http://www.learnitfirst.com/Course/158/Video/2081/Using-Data-Viewers.aspx Course: http://www.learnitfirst.com/Course/158/SSIS-2008.aspx Skill Level: 400 (Intermediate - Advanced) Length: 08:15 (13.2MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: SSIS, 2008, data viewers, debug, tips

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: Schema Scoped Permissions

Schema Scoped Permissions - view details
We've previously discussed server-scoped and database-scoped permissions and it's now time for us to discuss the schema-scoped permissions. In this video you will learn what schema-scoped permissions apply to and what schema-scoped permissions can be applied to.

Highlights from this video:What are schemas?
About schema-scoped permissions and what you can assign permissions to
Schemas as database-level securables
DBA functionality with roles and schemas

and much more Source: http://www.learnitfirst.com/Course/157/Video/1797/Schema-Scoped-Permissions.aspx Course: http://www.learnitfirst.com/Course/157/SQL-Server-2008-DBA.aspx Skill Level: 300 (Intermediate) Length: 9:00 (15.0MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: schema, permission, roles, sql server, 2008, securable, roles

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 Reporting Services Training Video: How to Do Band ed Rows with Report Parameters

How to Do Banded Rows with Report Parameters - view details
In this video Scott will show you how to use a report parameter, the previous videos on parameters all covered query parameters. Scott will walk you through how to do banded rows using report parameters?

Highlights from this video:What are banded rows?
color specific rows
Banded column vs. banded row
Expression for background color
Highlight a cell or change a cell based on a report parameter
and much more Source: http://www.learnitfirst.com/Course/162/Video/2536/Banded-Rows-with-Report-Parameters.aspx Course: http://www.learnitfirst.com/Course/162/SSRS-2008.aspx Skill Level: 400 (Intermediate - Advanced) Length: 15:15 (51.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 2008, ssrs, reporting services, parameters, banded rows, report parameter

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.

SharePoint 2007 Training Video: How to Build a Web Application Th at Allows Anonymous Access

How to Build a Web Application That Allows Anonymous Access - view details
This video will go into depth about how to set-up a new SharePoint web application and site collection while configuring it to allow anonymous access without a login. Also included is how you can choose your load bearing URL,�� how to create site collection, how to add new host record and ISP address, customizing advanced permissions.

Highlights:How to build a web application using a templateCustomizing advanced permissions and securirtyHow to build domain names Source: http://www.learnitfirst.com/Course/225/Video/843/Building-a-Web-Application-that-Allows-Anonymous-Access-to-SharePoint.aspx Course: http://www.learnitfirst.com/Course/225/SharePoint-2007.aspx Skill Level: 200 (Beginner - Intermediate) Length: 16:30 (13.9MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: build web application, domain names, permissions, security, customizing, template, access

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 DBA Training Video: Lecture on What Are Instances and When Are They Appropriate

Lecture on What Are Instances and When Are They Appropriate - view details
This video will take a formal look at SQL Server instances. In this video the author will discuss when to use instances, what purpose they serve, and clear up some licensing questions about them. The author's presentation is included with your download.

Highlights from this video:
What is an instance?
Default instance, Named instancesCommon instance setup
What are single instances appropriate for?
When to use multiple instances
Mixed versions, Mixed editions, Mixed releasesNamed instance rules
Instance licensing in 2008 compared to 2005and much more Source: http://www.learnitfirst.com/Course/157/Video/1606/What-Are-SQL-Server-Instances.aspx Course: http://www.learnitfirst.com/Course/157/SQL-Server-2008-DBA.aspx Skill Level: 100 (Beginner) Length: 09:45 (23.0MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: instance, install, named, default, 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 Analysis Services Training Video: Creating and Ma naging Table Variables

Creating and Managing Table Variables - view details
Table variables have the same syntax and logic as permanent tables, but the scope is different. Where are variables stored? What does GO do? This video focuses on why the scope difference is so important, and when you should use table variables.

Highlights from this video:Table variable syntaxVariable scope
Is it faster to write to a hard drive or to memory?
Inserting into a table variable
and much more Source: http://www.learnitfirst.com/Course/161/Video/2925/Table-Variables.aspx Course: http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx Skill Level: 300 (Intermediate) Length: 8:15 (18.7MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: table, variable, permanent, temporary, scope

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 the SELECT Statement Works in MDX

How the SELECT Statement Works in MDX - view details
Here, you will see a deeper look at MDX concepts, with explanations of specific terms, and will consider two example questions to help solidify these new ideas. Scott also reviews some concepts that are important to understand before getting into syntax. He presents the term "tuple" (along with some perspective on the pronunciation of "tuple"), which will be expanded on in later videos.

Highlights from this video:Writing a SELECT statement
More differences between MDX and SQLRetrieving data
Re-visiting the visualization of data
What is a tuple?
and much more Source: http://www.learnitfirst.com/Course/165/Video/2805/Select-Statement-MDX.aspx Course: http://www.learnitfirst.com/Course/165/SSAS-2008.aspx Skill Level: 400 (Intermediate - Advanced) Length: 13: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: sql server 2008, analysis services, ssas, ssis, multidimensional expressions, tuples, slices, sections

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.