Overview of SQL Server
Vu Tuyet Trinh

Hanoi University of Technology
1
MicrosoftMicrosoft
Introduction to SQL Server
Relational Database
Management System
SQL ServerClient
Results
Results
Client Application
OLAP
OLAP
OLTP
OLTP
Query
Query
P2-3
MicrosoftMicrosoft
SQL Server Goal
MicrosoftMicrosoft
Outline
Introduction to SQL Server

Relational Data Model

Exploring SQL Server Architecture

Data Access Architectures

CSCEDa ta ba se23
CSCESystem s21
DeptNameNo
Sub jec t
Bund ooraNorma n8507
Ba lwynMa ry8452
Bund ooraGlen3936
KewRob ert1108
SuburbNameId
Stud ent
Ta kes
298507
238507
231108
211108
SNOSID
CSCEVB29
Ma thsAlgeb ra18
CSCEDa ta ba se23
CSCESystems21
DeptNameNo
Sub jec t
Relational Database
Entities
Attributes
Relationship
MicrosoftMicrosoft
Basic Concepts of a Relational Database
Entities
Attributes

SNOSID
MicrosoftMicrosoft
Database Design: Main Ideas

Objective

Ensuring data completeness

Avoiding data redundancies

Facilitating data access

Solution

Normalization

Reducing redundancies and improving data modification
performance

Renormalizations is often done to enhance reporting performance
(at the expense of disk space and redundancy)

Referential Integrity

Maintains the logical relationships between database objects
MicrosoftMicrosoft
Example
MicrosoftMicrosoft
Outline
Introduction to SQL Server