This video is from our "SQL Server Programming (SQL Server 2005/2000): Transact SQL" course
Visit the course home page for full details (such as the videos in the course, free videos for the course, and more)

Video: Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys

Skill level: 200 (Beginner - Intermediate)
Run Time: 14:25
Instructor: Scott Whigham

Description:

This video focuses on common SQL developer/DBA terms regarding indexes and constraints and helps you get comfortable with the SQL lexicon. The work "key" is used over and over in SQL - Primary Key, Foreign Key, Alternate key, and more - yet many developers rarely go beyond the primary key and foreign key. This makes it difficult to develop robust systems. For more on the types of keys available and their usage, watch this video from SQL consultant Scott Whigham.

Download and watch this video

NOTE: You will need the TSCC codec installed to view video

Instructor
Related Videos
Related Courses
Other Videos in this Chapter

Scott Whigham

Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive video training libraries focusing on technical training. Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott designed the architecture (websites, class libraries, and database) for the LearnItFirst.com websites and, most re... (Scott's full bio can be found here)

Video titleSkill

Subqueries, Nested Queries, and Derived Tables - An Introduction to Advanced SQL Constructs	300	Download
When to Use HAVING Instead of WHERE - Aggregates, GROUP BY, and the HAVING Clause	300	Download
JOINs - An Overview of the Five Types of JOINs (Cross, Outer, and Inner)	200	Download
Rapid Database Development Using Database Diagrams (SQL Server 2000)	100	Download
JOINs and UNIONs - How Do I Know When to Use a JOIN or a UNION?	300	Download

CourseRun TimeSkill Level

148 - SQL Server 2000 Database Administration	200-500	20+ hrs
152 - SQL Server 2005 Database Administration	200-500	30+ hrs
157 - SQL Server 2008 Database Administration	200-500	45+ hrs
154 - SQL Server 2005 Reporting Services	200-500	17+ hrs
153 - SQL Server 2005 Integration Services	200-500	31+ hrs

Chapter 2: The T-SQL Language - An Introduction to Common Terms, Tools, and Techniques

1	Database Diagrams - An Introduction
2	An Overview of the AdventureWorksDW Database
3	An Overview of the Northwind Database
4	COLLATE and How Queries and Table Data Work with Case-Sensitive and Accent-Sensitive Data
5	Model Database - An Overview of How to Use It and When to Use It (SQL Server 2005)
6	TempDb Database - An Overview of How it Works and When to Use It
	Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys
8	Resultsets, Recordsets, and the Client Server model (SQL Server 2000)
9	Scalar, System, Built-In and Niladic Functions - What They Are and How to Use Them (SQL Server 2000)
10	SQL Standards - ISO, ANSI, and Transact-SQL's Implementation of the Various Standards
11	SQL Server Internals - The Steps SQL Server Goes Through to Run a Command
12	Part 1 - An Overview of the AdventureWorks Database
13	Part 2 - An Overview of the AdventureWorks Database - Database Diagrams and DDL Triggers
14	Pt. 1 - An Intro to Schemas In SQL Server 2005 and SQL Server 2008
15	Pt. 2 - Default Schemas and How SQL Server Performs Naming Resolution
16	Pt. 3 - Best Practices for Using Schemas and How to Transfer Objects to New Schema

NOTE: This video is part of our SQL Server Programming (SQL Server 2005/2000): Transact SQL course.
This video is from Chapter 2: The T-SQL Language - An Introduction to Common Terms, Tools, and Techniques

Login

Video: Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys

Description:

Scott Whigham