Lesson 1: Create & query database objects

Analytics Platform System (PDW)

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 doesn’t 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’re 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

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.

To complete this tutorial, you need SQL Server Management Studio and access to a SQL Server

instance.

Install

Management Studio.

If you don’t have a SQL Server instance, create one. To create one, select your platform from

the following links. If you choose SQL Authentication, use your SQL Server login credentials.

７

Note

The

learning path provides more in-depth

content, along with practical examples.