Lesson 1. Understanding SQL

In this lesson, you learn about databases and SQL, prerequisites to learning T-SQL.

Database Basics

The fact that you are reading this book indicates that you, somehow, need to interact with databases. So before diving into SQL Server and its T-SQL implementation of the SQL language, it is important that you understand some basic concepts about databases and database technologies.

Whether you are aware of it or not, you use databases all the time. Each time you select a name from your email address book, you are using a database. If you conduct a search on an Internet search site, you are using a database. When you log into your network at work, you are validating your name and password against a database. Even when ...

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

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.