---
title: "Lesson 1: Creating Database Objects | Microsoft Docs"
ms.custom: ""
ms.date: "03/14/2017"
ms.prod: "sql-server-2016"
ms.reviewer: ""
ms.suite: ""
ms.technology: 
  - "database-engine"
ms.tgt_pltfrm: ""
ms.topic: "article"
applies_to: 
  - "SQL Server 2016"
ms.assetid: 9fb8656b-0e4e-4ada-b404-4db4d3eea995
caps.latest.revision: 20
author: "BYHAM"
ms.author: "rickbyh"
manager: "jhubbard"
---
# Lesson 1: Creating Database Objects
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 [!INCLUDE[tsql](../includes/tsql-md.md)], it does not use or describe the many options that are available for these statements.  
  
[!INCLUDE[tsql](../includes/tsql-md.md)] statements can be written and submitted to the [!INCLUDE[ssDE](../includes/ssde-md.md)] in the following ways:  
  
-   By using [!INCLUDE[ssManStudioFull](../includes/ssmanstudiofull-md.md)]. This tutorial assumes that you are using [!INCLUDE[ssManStudio](../includes/ssmanstudio-md.md)], but you can also use [!INCLUDE[ssManStudio](../includes/ssmanstudio-md.md)] Express, which is available as a free download from the [Microsoft Download Center](http://go.microsoft.com/fwlink/?linkid=67359).  
  
-   By using the [sqlcmd utility](../tools/sqlcmd-utility.md).  
  
-   By connecting from an application that you create.  
  
The code executes on the [!INCLUDE[ssDE](../includes/ssde-md.md)] in the same way and with the same permissions, regardless of how you submit the code statements.  
  
To run [!INCLUDE[tsql](../includes/tsql-md.md)] statements in [!INCLUDE[ssManStudio](../includes/ssmanstudio-md.md)], open [!INCLUDE[ssManStudio](../includes/ssmanstudio-md.md)] and connect to an instance of the [!INCLUDE[ssDEnoversion](../includes/ssdenoversion-md.md)].  
  
This lesson contains the following topics:  
  
-   [Creating a Database (Tutorial)](../t-sql/lesson-1-1-creating-a-database.md)  
  
-   [Creating a Table (Tutorial)](../t-sql/lesson-1-2-creating-a-table.md)  
  
-   [Inserting and Updating Data in a Table (Tutorial)](../t-sql/lesson-1-3-inserting-and-updating-data-in-a-table.md)  
  
-   [Reading the Data in a Table (Tutorial)](../t-sql/lesson-1-4-reading-the-data-in-a-table.md)  
  
-   [Summary: Creating Database Objects](../t-sql/lesson-1-5-summary-creating-database-objects.md)  
  
## Next Task in Lesson  
[Creating a Database (Tutorial)](../t-sql/lesson-1-1-creating-a-database.md)