Lesson 2. Introducing SQL Server

In this lesson, you learn what SQL Server is, and the tools we’ll be using to work with it.

What Is SQL Server?

In the previous lesson, you learned about databases and SQL. As explained, it is the database software (DBMS or Database Management System) that actually does all the work of storing, retrieving, managing, and manipulating data. SQL Server is a DBMS—that is, it is database software.

SQL Server has been around for a long time and is in use at millions of installations worldwide. Why do so many organizations and developers use SQL Server? Here are some of the reasons:

Image Performance—SQL Server is fast (make ...

Get Sams Teach Yourself Microsoft® SQL Server T-SQL in 10 Minutes, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.