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 Transact-SQL, it does not use or describe the many options that are available for these statements.

Transact-SQL statements can be written and submitted to the Database Engine in the following ways:

• By using SQL Server Management Studio. This tutorial assumes that you are using Management Studio, but you can also use Management Studio 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 Database Engine in the same way and with the same permissions, regardless of how you submit the code statements.

To run Transact-SQL statements in Management Studio, open Management Studio and connect to an instance of the SQL Server Database Engine. If you are unfamiliar with Management Studio, review the first two tasks in the Tutorials.

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)