© 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 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.