SQL Server Data Types: An Overview

This video is part of LearnItFirst’s Transact-SQL Programming: SQL Server 2008/R2 course. More information on this video and course is available here:

http://www.learnitfirst.com/Course161

There is a lot to cover in this video, so get comfortable! This is the first of several videos about data types. Here, Scott gives you a high-level overview of data types, beginning with the four main “buckets” that you can use to categorize them: numbers, strings, temporal, and other. Each of these “buckets” will be explained in detail, and will introduce some new terms as well.

Highlights from this video:

– How to categorize data types
– Integer-based and decimal-based data types
– Bits and bytes
– What is meant by “scale” and “precision”?
– What is “Unicode”?

and much more…