CHAPTER 3

image

Database Basics

In this chapter, we are going to look at databases: what they are, the types available to us, and how we manage them. We’ll also take a look at some basic server settings, including security.

What Is a Database?

Think of a database as a container, with different compartments. Have you ever seen a neatly partitioned lunchbox? It might have a section for your sandwiches, a section for your salad, and a section for a tasty chocolate bar. Databases are very similar, except they don’t have anything as tasty as a chocolate bar! Databases instead contain database objects. Some of the more common objects you will find in a database ...

Get Introducing SQL Server 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.