So we have our course database created and the tables loaded with data. 1
So I'm just going to close these query windows here. 2
And it's time to write our first query. 3
So I'm going to hit the new query window. 4
And looking at our database we have several tables here. 5
And if we just want to view all the contents of a table using SQL language, we're just going to type 6
select star from. 7
And we can just drag the name of the table here if we want. 8
Or we could just type it and then we're going to hit execute. 9
And we will see all of the data in our table. 10
In the next assignment, you'll write your first SQL query in SQL Server Management Studio. 11
I'll see you there.