IT Training Videos From LearnItFirst.com

SQL Server 2008 DBA Training Video: Database Permissions Demo, Part 3

Database Permissions Demo, Part 3 - view details
In our final demonstration video we will continue from where we left off in our second demonstration video, "Database Permissions Demo, Part 2", by talking about the Revoke permission.

Highlights from this video:How to revoke permissions
Effect of revoking a permission on our demo
Revoke as an eraser
Key points from the GDR permissions

and much more Source: http://www.learnitfirst.com/Course/157/Video/1801/Database-Permissions-Demo-Pt3.aspx Course: http://www.learnitfirst.com/Course/157/SQL-Server-2008-DBA.aspx Skill Level: 300 (Intermediate) Length: 4:30 (8.0MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: revoke, database, permission, demo, 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 2008 DBA Training Video: Securables, Permissions, and Principals

Securables, Permissions, and Principals - view details
In this video we will continue by talking about securables for logins. We will discuss the concept of how we assign permissions when dealing with the Grant, Deny or Revoke (GDR), as well as detail about the scope of securables.
Highlights from this video:What are securables?Securables and scope - Server, Database, and SchemaThree basic permissions of the scopeAlternative to db_creator roleand much more Source: http://www.learnitfirst.com/Course/157/Video/1774/Securables-Permissions-And-Principals.aspx Course: http://www.learnitfirst.com/Course/157/SQL-Server-2008-DBA.aspx Skill Level: 200 (Beginner - Intermediate) Length: 11:45 (19.9MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: sql 2008, securables,permission,principal,grant,revoke,deny,login

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.

SSIS 2005 Training Video: Pt. 2 - Writing .NET Assemblies and an Overview of Assembly Use

Pt. 2 - Writing .NET Assemblies and an Overview of Assembly Use - view details
This video walks you through creating your first properties and methods, talks about security of your assembly classes and methods/properties and walks you through creating your first .DLL to use in later SSIS packages. Source: http://www.learnitfirst.com/Course/153/Video/721/Writing-NET-Assemblies-and-Overview-of-Assembly-Use.aspx Course: http://www.learnitfirst.com/Course/153/SSIS-2005.aspx Skill Level: 300 (Intermediate) Length: 12:45 (10.1MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: classes, objects, properties

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.

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.

SSIS 2008 Training Video: Working with Files and Folders: The FTP Task

Working with Files and Folders: The FTP Task - view details
This video will cover working with files in folder in SSIS by using the FTP task. This video will overview the FTP task, as well as set up the demo that will carry through the next several videos.

Highlights from this video:Overview of the FTP task
Login information for sample FTP
What is the FTP used for?
Connection manager
Customizing the FTP task
and much more Source: http://www.learnitfirst.com/Course/158/Video/2078/The-FTP-Task.aspx Course: http://www.learnitfirst.com/Course/158/SSIS-2008.aspx Skill Level: 200 (Beginner - Intermediate) Length: 15:00 (23.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: SSIS, 2008, FTP 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 Reporting Services Training Video: Securing Repor ting Services: A Look at the Built-in Roles, Part 2

Securing Reporting Services: A Look at the Built-in Roles, Part 2 - view details
Continuing from the previous video, Scott will walk you through the rest of the roles that are built-in to SQL Server Reporting Services.

Highlights from this video:System administrator
System user
who can use this role?
Roles
Item-level tasks
Browser
Content Manager
My Reports
PublisherReport Builder

and much more Source: http://www.learnitfirst.com/Course/162/Video/2476/Built-In-Roles-Pt2.aspx Course: http://www.learnitfirst.com/Course/162/SSRS-2008.aspx Skill Level: 200 (Beginner - Intermediate) Length: 11:15 (36.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, ssrs, roles, built in roles, security, system admin, system user, browser, content manager, my reports, publisher, report builder

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: What SQL Is and Isn't

What SQL Is and Isn't - view details
So what exactly is SQL? In this video Scott will go into the details of what SQL is and isn't, including the official pronunciation, and the history behind SQL.

Highlights from this video:What does SQL stand for?
What is RDBMS?
What is a DBM?
The relational model
What do you need to know about the relational model?
Set theory
How does SQL differ from the relational model?and much more Source: http://www.learnitfirst.com/Course/160/Video/2224/What-Is-SQL.aspx Course: http://www.learnitfirst.com/Course/160/SQL-Queries-2008.aspx Skill Level: 100 (Beginner) Length: 13:45 (37.4MB) 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, 2005, queries, overview, RDBMS, DBM, relational model, set theory

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: Using the Package Migration Wizard to U pgrade Your DTS Packages to SSIS, Part 1

Using the Package Migration Wizard to Upgrade Your DTS Packages to SSIS, Part 1 - view details
In this set of two videos Scott will show you how to do a migration; taking a DTS package or set of packages, moving them to SSIS, and upgrading them to SSIS packages. This process involves multiple steps, and Scott will walk you through each one. Most companies will have a small amount of DTS packages that will be able to be moved fairly easily and quickly using the techniques demonstrated in this set of videos.

Highlights from this video:SQL Server 2000 Enterprise Manager
Visual Studio Integration Services ProjectPackage migration wizardmigrate dts 2000 package
DTSX file destination
Are the old SQL Server 2000 packages deleted?
Can changes be saved in SQL 2000 DTS?
What destination should I use?
Connection managersand much more Source: http://www.learnitfirst.com/Course/158/Video/2215/Pt1-Package-Migration-Wizard.aspx Course: http://www.learnitfirst.com/Course/158/SSIS-2008.aspx Skill Level: 200 (Beginner - Intermediate) Length: 13:15 (34.9MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: SSIS 2008, package migration wizard, dts package, ssis package, dtsx file, ole db destination, connection manager

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: Disaster Recovery: Restoring Your Entire SQL Server

Disaster Recovery: Restoring Your Entire SQL Server - view details
In this video we will take a more serious approach to restores by discussing the process of how to restore an entire server in the event that the disk system that holds your .mdf crashes and cannot be recovered.

Highlights from this video:

Example scenario
Importance of recent backupsWhat components do I need to recover my server?
How to rebuild your SQL Server

and much more Source: http://www.learnitfirst.com/Course/157/Video/1845/Disaster-Recovery-of-Entire-Server.aspx Course: http://www.learnitfirst.com/Course/157/SQL-Server-2008-DBA.aspx Skill Level: 300 (Intermediate) Length: 8:45 (15.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: disaster recovery,recovery,restore,restoring,sql server,2008,server,

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: Database Snapshots: What They Are and How to Use Them

Database Snapshots: What They Are and How to Use Them - view details
In our final video in this chapter we will lecture on the topic of database snapshots, a read-only copy of a live database.

Highlights from this video:What are database snapshots?
About database snapshots
Three purposes for database snapshots
Database snapshots and sparse files
Pros and cons of snapshots

and much more Source: http://www.learnitfirst.com/Course/157/Video/1932/Database-Snapshots-Intro.aspx Course: http://www.learnitfirst.com/Course/157/SQL-Server-2008-DBA.aspx Skill Level: 300 (Intermediate) Length: 16:00 (24.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: snapshot,database,intro,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.