0
1
00:00:05,420 --> 00:00:10,790
So we have our course database created and the tables loaded with data.
1

2
00:00:10,790 --> 00:00:13,520
So I'm just going to close these query windows here.
2

3
00:00:13,520 --> 00:00:16,040
And it's time to write our first query.
3

4
00:00:16,040 --> 00:00:19,040
So I'm going to hit the new query window.
4

5
00:00:19,040 --> 00:00:23,030
And looking at our database we have several tables here.
5

6
00:00:23,030 --> 00:00:29,780
And if we just want to view all the contents of a table using SQL language, we're just going to type
6

7
00:00:29,780 --> 00:00:32,570
select star from.
7

8
00:00:32,870 --> 00:00:36,500
And we can just drag the name of the table here if we want.
8

9
00:00:36,500 --> 00:00:40,280
Or we could just type it and then we're going to hit execute.
9

10
00:00:40,280 --> 00:00:44,450
And we will see all of the data in our table.
10

11
00:00:47,720 --> 00:00:53,150
In the next assignment, you'll write your first SQL query in SQL Server Management Studio.
11

12
00:00:53,180 --> 00:00:54,320
I'll see you there.