From the course: Learning SQL Server 2017
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Understand SQL data types - SQL Server Tutorial
From the course: Learning SQL Server 2017
Understand SQL data types
- [Instructor] 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, and you can think of the records as nouns, the people, places, or things in the database. Columns in the table are called fields, and they'll store the attributes about each of our records. Each column in the table can be thought of as the adjectives, the descriptors that define the unique components of each record. Here is 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 in the table will define their attributes, such as their name, their birthday, their favorite color, and so on. All of the tables in your SQL Server…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.