Before information can be stored in a database, tables will need to be constructed that are configured properly. Table columns will store a single kind of information, and the type of data will be explicitly defined. In this video, Adam outlines the common data types for storing text, numbers, dates, and other types of information in SQL Server 2016.
- View Offline
- [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 to create a table, we'll simply define…
This course introduces the most important features of SQL Server 2016, and is designed to act as the student's very first look at how the server operates. Adam Wilbert shows how to install a local copy of SQL Server; demonstrates the working environment, SQL Server Management Studio; and walks students through their first hour creating tables, defining relationships, and writing and running queries with Transact-SQL commands. Everything you need to accomplish to create your first database is covered in just 80 minutes. Start watching to get up and running with this professional-grade database management system.
- What is SQL Server?
- Configuring the server
- Creating a new database and data tables
- Joining tables with keys
- Creating a SELECT statement
- Writing an UPDATE statement
- Adding data with the INSERT statement