Free SQL Server Video Tutorial - Pt. 1 - An Intro to Schemas In S QL Server 2005 and SQL Server 2008

This Free MSSQL Programming and Query Writing Video comes from LearnItFirst, one of the web's largest IT training videos companies.

Pt. 1 - An Intro to Schemas In SQL Server 2005 and SQL Server 2008

Description of this free video:

One of the challenging things anyone coming into SQL Server faces is trying to figure out which version of the word 'schema' someone is using at any given time. Example: 'You need to put the Person schema in the People schema inside your database schema' is a perfectly legitimate instruction but the word schema means three different things in that sentence!

So which 'version' of the word schema does this video talk about? The second version.

:)

Okay, okay - this video talks about the container-type of schema (#1 was an Xml schema Collection and #3 was a Database Schema).

Highlights from this video:

• What are schemas? What are containers?
• How are schemas used?
• Should I use schemas?
• What about schemas like db_owner, db_ddladmin, et al - is it safe to remove those?
• Where should I put my schemas?
• I'm upgrading from SQL Server 2000 to 2005/2008 - what is different between users, object owners, and schemas?

and much more

Related Links:

• SQL Server Programming (SQL Server 2005/2000): Transact SQL training
• Free Training Videos
• Free SQL Server videos