In this video, database expert Adam Wilbert demonstrates how to create a data table. Column names use a standardized naming convention and data types are tailored to the requirements of the data being stored. By establishing an auto-incrementing identity field, SQL Server 2016 can manage the issuance of primary keys for each record.
- [Voiceover] In order to store data in a database,…we need to create a table.…The structure of a table is critical in creating a database…that is easy to navigate…and retrieve information from later.…To create a new table in our custom database,…I'll expand the Databases node…inside of our Sequel Server instance,…and then we'll find the new database.…I'll open it up, and we'll expand the Tables section here.…On the Tables folder,…I'll right click and choose the first option, Table.…This will activate a second window…where we can define the columns…that will make up the structure for our table.…We simply need to give each column a name,…define the type of data that will appear in it,…and define whether we want to make this…a required piece of information or not.…
If we place a checkmark in this box under Allow Nulls,…we'll define an optional column that can be left blank…when entering the data.…So let's create a table that stores information…about some customers.…The first column is going to be an identification column.…
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