Database Reference
In-Depth Information
8
Essential SQL Server
Concepts
In This Chapter
Understanding SQL Server
Setting up databases
Working with tables and views
Understanding SQL Server security
Importing and exporting data
SQL Server is an enterprise-grade database platform designed to handle large datasets and intensive
data processing. Microsoft has positioned SQL Server at the center of its BI Stack, enabling it with
powerful features and add-ons specifically designed for business intelligence and analytics. It is criti-
cal for you to be familiar with SQL Server if you deal with datasets that are too large for standard
desktop tools to handle. The data stored inside SQL Server can be integrated in a variety of front-end
tools such as Excel, Access, and advanced reporting and dashboarding tools.
SQL Server Components
SQL Server is an extensive platform with dozens of components. In this section we focus on two of
those components:
➤ SQL Server Relational Database Engine
➤ SQL Server Management Studio
157
 
Search WWH ::




Custom Search