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
  

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
  

Related Links:

• More videos like this
• More free IT Training Videos
• Free Exchange Server training

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?
  

Related Links:

• Writing Queries for SQL Server (2005/2008 Edition) training
• Free Training Videos
• Free Windows Server videos

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

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
  

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?

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
  

Related Links:

• SQL Server 2008/R2 Analysis Services training
• Free Training Videos
• Free SQL Server videos

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
  

Related Links:

• More videos like this
• More free IT Training Videos
• Free SQL Server videos