Page 61 - DCAP508_DATABASE_ADMINISTRATION

Sartaj Singh, Lovely Professional University
Unit 5: SQL Server Databases

Unit 5: SQL Server Databases Notes

CONTENTS
Objectives
Introduction
5.1 System Databases
5.1.1 Modifying System Data

5.1.2 Viewing System Database Data
5.2 User Databases
5.3 Database Planning
5.4 Creating Databases
5.5 Tables
5.5.1 Designing Tables
5.5.2 Creating and Modifying a Table

5.6 Constraints
5.6.1 Classes of Constraints
5.6.2 Column and Table Constraints
5.7 Database Diagrams
5.7.1 Creating Database Diagrams
5.8 Views
5.9 Synonyms
5.9.1 Syntax for Creating Synonym
5.9.2 Arguments

5.9.3 Permissions
5.10 Programming Objects
5.10.1 Creating Procedures
5.10.2 Functions
5.10.3 Triggers
5.11 Summary
5.12 Keywords

5.13 Review Questions
5.14 Further Readings
Objectives

After studying this unit, you will be able to:
Understand meaning of databases

Describes the system databases used in SQL Server

LOVELY PROFESSIONAL UNIVERSITY 55