Introduction to SQL Server Database Administration

Introduction to SQL Server Database Administration

The contents include: Exactly what is a DBMS, Security Management, Introducing SQL Server Manager System (SSMS), Administrative Tasks, Adding a new user, Changing a password,Re-enabling a locked out account, Granting/Denying Access to a DB, Granting/Denying Access to a Table, Creating a New Database, Deleting a Database, Creating a Table, Quick Tutorial on Data Types, Deleting a Table, Setting the Primary Key, Backing Up the Database, Restoring a Full Backup,Database Indexes Tutorial, Data Encryption.

Author(s): Tribal Data Workshop,CRITFC, Portland, Oregon

59 Pages