From the course: Learning Microsoft SQL Server 2016

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Understand SQL data types

Understand SQL data types - SQL Server Tutorial

From the course: Learning Microsoft SQL Server 2016

Start my 1-month free trial

Understand SQL data types

- [Voiceover] Before we can start storing information in our database, we need to understand a little bit about how tables are structured and the types of data that can be stored. Tables are made up of vertical columns and horizontal rows. Each row in the table will store information about a single item that we want to keep track of. These are called records. You can think of records as nouns, the people, places, or things in the database. Columns in the table are called fields, and they'll store attributes about each of our records. Each column in the table can be thought of as an adjective, the descriptors that define the unique components of each record. Here's an example. Let's suppose that we have a table to store information about our customers. Each row in the table will represent a single customer. Each column will define their attributes, such as their Name, Birthday, Favorite Color, and so on. All of the tables in your SQL Sever databases will follow this basic structure. So…

Contents