© Kathi Kellenberger, Lee Everest 2021
K. Kellenberger, L. EverestBeginning T-SQLhttps://doi.org/10.1007/978-1-4842-6606-9_2

2. Exploring Database Concepts

Kathi Kellenberger1   and Lee Everest2
(1)
Edwardsville, IL, USA
(2)
Euless, TX, USA
 

This chapter will explain just what SQL Server is, what a database is and describe the objects that make up those databases. You will learn how data is stored in a database, and you’ll learn about objects, called indexes, that help SQL Server return the results of your queries quickly.

What Is SQL Server?

SQL Server is Microsoft’s relational database management system (RDBMS). An RDBMS stores data in tables according to the relational model. The relational model is beyond the scope of this book, but you can learn more ...

Get Beginning T-SQL: A Step-by-Step Approach now with O’Reilly online learning.

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