LearnItFirst.com Blog

Scott Whigham  //  I am a husband, father, guitar player, SQL geek, .NET enthusiast, and entrepreneur (founder of LearnItFirst.com)

Free SQL Server 2008 DBA Tutorial - Misc Bits: Backup Compression and Security

Free SQL Server 2008 DBA free video!

This MSSQL Server 2008 Free Training Video is brought to you by LearnItFirst. LearnItFirst.com has more than four hours of free I.T. training videos - LearnItFirst.com

Free Tutorial Video: Misc Bits: Backup Compression and Security

In this video we will discuss a couple miscellaneous bits and pieces about backups before we can start our restore process.We will specifically lecture on backup compression and backup security in this video.

Highlights from this video:

  • Securing your backups and best practices
  • New feature in SQL Server 2008: Backup Compression
  • Compression and backup speed

and much more Free SQL Server training video
May 2 / 9:47am

Free SQL Server 2005/2008 Queries Training Video - INNER JOIN: Wr iting Two Table INNER Joins, Part 1

Free SQL Server video tutorial This SQL Server 2005/2008 Queries Free Video Tutorial comes from LearnItFirst.com's online training videos library

Free Tutorial Video: INNER JOIN: Writing Two Table INNER Joins, Part 1

More info about this video:

In this video Scott will take the information presented in the previous videos about JOINs and use it in some real world examples.  This video will cover the INNER JOIN and writing two table INNER JOINs.

Highlights from this video:

  • Demo set up
  • What problem are we trying to solve?
  • Primary key
  • Parent and child relationship
  • Foreign key
    • mandatory vs optional
and much more Free SQL Server 2008/2005 Query Writing training video

Related Links:

Mar 26 / 10:09am

Free SQL Server 2005/2008 Queries Training Video - Course Introdu ction - What Is Covered in this Course?

Free Video: Course Introduction - What Is Covered in this Course?

This video will introduce Course 160, Writing Queries for SQL Server.  This video will go over what the course will cover, and what material you can expect to see in the course.

Highlights from this video:

  • Who should take this course?
  • Do I have to watch the videos in order?
  • Chapter list
  • What will each chapter cover?
and much more
Free training videos for SQL Server
Free SQL Server 2008/2005 Query Writing video
Mar 15 / 9:57am

Free SSIS 2008 Tutorial - SSIS Development Tip: How to Create a T rash Destination (i.e. a 'Fake' Destination)

Free Video Tutorial: SSIS Development Tip: How to Create a Trash Destination (i.e. a 'Fake' Destination)

This video will walk through the creation of a trash or 'fake' destination.  This is a technique used in development only, not in a production level package.  This video will cover some background information on trash destinations, including when and why they are helpful, as well as how to actually create the trash destination.

Highlights from this video:

  • What is a trash destination?
  • When is a trash destination used?
  • Setting up a trash destination
  • Why are trash destinations helpful when developing packages?
and much more
Free training videos for SQL Server Integration Services
Free SQL 2008 Integration Services video
Mar 3 / 2:26pm

Free SQL Server 2008 DBA Tutorial Video - Misc Bits: Backup Compr ession and Security

Free Training Video: Misc Bits: Backup Compression and Security

In this video we will discuss a couple miscellaneous bits and pieces about backups before we can start our restore process.We will specifically lecture on backup compression and backup security in this video.

Highlights from this video:

  • Securing your backups and best practices
  • New feature in SQL Server 2008: Backup Compression
  • Compression and backup speed

and much more
Free training videos for SQL Server
Free MSSQL Server 2008 video
Dec 16 / 6:47am

Free SQL Server 2005/2008 Queries Training Video - Course Introdu ction - What Is Covered in this Course?

Free SQL Server video!

This Free SQL Server Video Tutorial comes from LearnItFirst, one of the web's largest IT training videos companies.

Course Introduction - What Is Covered in this Course?

Description of this free video:

This video will introduce Course 160, Writing Queries for SQL Server.  This video will go over what the course will cover, and what material you can expect to see in the course.

Highlights from this video:

  • Who should take this course?
  • Do I have to watch the videos in order?
  • Chapter list
  • What will each chapter cover?
and much more Free SQL Server 2005/2008 Queries video tutorial

Related Links:

Nov 8 / 3:05pm

Free SQL Server 2008 Reporting Services Tutorial - Course Introdu ction - What Is Covered in this Course?

Free Video: Course Introduction - What Is Covered in this Course?

Reporting Services free training video

More info about this video:

The first video in this course will go over what is included in the SQL Server Reporting Services course, including the layout of the course.

Highlights from this video:

  • What level is this course taught at?
  • Who is this course for?
  • What will each chapter in the course cover?
  • SQL Server 2008 Reporting Services
  • SQL Server 2008 R2 Reporting Services
and much more Free SQL Server Reporting Services training
Nov 1 / 11:43am

Free SQL Server 2008 Analysis Services Tutorial - Course Introduc tion - What Is Covered in this Course?

Free SQL Server 2008 Analysis Services free video!

This Analysis Services Free Video is brought to you by LearnItFirst. LearnItFirst.com has more than four hours of free I.T. training videos - LearnItFirst.com

Free Tutorial Video: Course Introduction - What Is Covered in this Course?

In this video Scott will provide an introduction to and overview of the SQL Server 2008/R2 Analysis Services course.  This video will go over what each chapter in the course will cover.

Highlights from this video:

  • Chapter overview
  • How you should watch this course
  • Different tracks
  • Who is this course for?
and much more Free Analysis Services training video
Oct 29 / 1:53pm

Free SQL Server 2008 Analysis Services Tutorial Video - Sorting a nd Ordering Data

Free Analysis Services video!

This SQL Server 2008 Analysis Services Free Video Tutorial comes from LearnItFirst, one of the web's largest IT training videos companies.

Sorting and Ordering Data

Description of this free video:

Having covered the bulk of the MDX material you would need in a day-to-day basis, this video adds some additional ideas on sorting and ordering. Scott Whigham discusses the Order function, TopCount and BottomCount, and how to break hierarchies with the Order By.

Highlights from this video:

  • How does SSAS treat a sort on a user-defined hierarchy?
  • Sorting according to ascending and descending
  • Attribute hierarchy
  • Parents, children, and grandchildren
and much more
Free SQL Server 2008 Analysis Services video tutorial

Related Links:

Oct 26 / 9:14am

Free SQL Server 2008 Analysis Services Tutorial Video - Sorting a nd Ordering Data

Free Analysis Services video tutorial This Free SQL Server Analysis Services Video comes from LearnItFirst.com's online training videos library

Free Video: Sorting and Ordering Data

More info about this video:

Having covered the bulk of the MDX material you would need in a day-to-day basis, this video adds some additional ideas on sorting and ordering. Scott Whigham discusses the Order function, TopCount and BottomCount, and how to break hierarchies with the Order By.

Highlights from this video:

  • How does SSAS treat a sort on a user-defined hierarchy?
  • Sorting according to ascending and descending
  • Attribute hierarchy
  • Parents, children, and grandchildren
and much more
Free SQL Server Analysis Services training video

Related Links:

Oct 25 / 1:08pm