Summary

In today's lesson, you learned what SQL is and how it relates to the SQL Server database that you will be using. In addition, you wrote your first SQL query using the new SQL Server tool, Query Analyzer. The Query Analyzer is used to enter, execute, and modify SQL code. Finally, you took a brief look at the new Enterprise Manager that comes with Microsoft SQL Server. You saw how to use these tools to view table information and the columns that they contain. In tomorrow's lesson, you will learn how to modify the SELECT statement you used today in order to filter and sort the data that you are requesting from the database.