lesson-1-creating-database-objects.md

---

title: "Lesson 1: Creating Database Objects | Microsoft Docs" ms.custom: "" ms.date: "03/14/2017" ms.prod: sql ms.reviewer: "" ms.suite: "sql" ms.technology: t-sql ms.tgt_pltfrm: "" ms.topic: conceptual applies_to:

• "SQL Server 2016" ms.assetid: 9fb8656b-0e4e-4ada-b404-4db4d3eea995 author: MikeRayMSFT ms.author: mikeray manager: craigg monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"

---

Lesson 1: Creating Database Objects

[!INCLUDEtsql-appliesto-ss2008-all-md] This lesson shows you how to create a database, create a table in the database, and then access and change the data in the table. Because this lesson is an introduction to using [!INCLUDEtsql], it does not use or describe the many options that are available for these statements.

[!INCLUDEtsql] statements can be written and submitted to the [!INCLUDEssDE] in the following ways:

• By using [!INCLUDEssManStudioFull]. This tutorial assumes that you are using [!INCLUDEssManStudio], but you can also use [!INCLUDEssManStudio] Express, which is available as a free download from the Microsoft Download Center.

• By using the sqlcmd utility.

• By connecting from an application that you create.

The code executes on the [!INCLUDEssDE] in the same way and with the same permissions, regardless of how you submit the code statements.

To run [!INCLUDEtsql] statements in [!INCLUDEssManStudio], open [!INCLUDEssManStudio] and connect to an instance of the [!INCLUDEssDEnoversion].

This lesson contains the following topics:

• Creating a Database (Tutorial)

• Creating a Table (Tutorial)

• Inserting and Updating Data in a Table (Tutorial)

• Reading the Data in a Table (Tutorial)

• Summary: Creating Database Objects

Next Task in Lesson

Creating a Database (Tutorial)