Administering SQL Server Database

Administering SQL Server Database

Durasi : 3 hari

 

 

Description:

The SQL Server administration training provides you with the knowledge and skills you need to administer SQL Server database servers effectively.

 

This training is for database administrators and developers, who want to administer SQL Server successfully.

 

All students will:

  • Install and configure Microsoft SQL Server
  • Understand the concept of Microsoft SQL Server
  • Implement and maintain indexes
  • Take database snapshots
  • Secure SQL Server
  • Back up and recover data

Prerequisites:

  • User know basic of database
  • User know basic T-SQL

 

Course Topic

Session 1: Getting Started

  • What is SQL Server
  • Install the SQL Server
  • Connect to the SQL Server
  • SQL Server Sample Database
  • Load Sample Database

 

Session 2: Basic

  • System databases and their purposes

 

Session 3: Managing Logins, Users, Permissions and Roles

  • Create Login
  • Create User
  • Grant permissions
  • Revoke permissions
  • Alter Login
  • Alter User
  • Drop Login
  • Drop User
  • CREATE ROLE
  • ALTER ROLE
  • DROP ROLE

 

Session 4: Blocking & Deadlock

  • Blocking
  • Deadlock

 

Session 5:Table Partitioning

  • Create a partitioned table
  • Partitioning an existing table

 

Session 6: Database snapshots & contained databases

  • Database Snapshot
  • Contained Databases

 

Session 7: Import / Export Data

  • Bulk Copy Data (BCP)
  • BULK INSERT

Session 8: Managing Indexes

  • Clustered indexes
  • Create nonclustered indexes
  • Rename indexes
  • Disable indexes
  • Enable indexes
  • Unique indexes
  • Drop indexes
  • Indexes with included columns
  • Filtered indexes

 

  • Indexes on computed columns

Session 9: Managing Triggers

  • Creating a trigger in SQL Server
  • Creating an INSTEAD OF trigger
  • Creating a DDL trigger
  • Disabling triggers
  • Enabling triggers
  • Viewing the definition of a trigger
  • Listing all triggers in SQL Server
  • Removing triggers

 

Session 10: Encryption

  • Environment set up
  • Create a database master key for column level SQL Server encryption
  • Create a self-signed certificate for Column level SQL Server encryption
  • Configure a symmetric key for column level SQL Server encryption
  • Data encryption
  • Decrypt column level SQL Server encryption data
  • Permissions required for decrypting data

 

Session 11: Backup & Restore

  • Recovery model
  • Backup types
  • Full backup
  • Differential Backup
  • Transaction Log Backup
Phone: (022) 4221130
Fax: (022) 4235692
Jl. Lengkong Kecil No. 73, Gedung Labora Lantai 2, Paledang, Kota Bandung, Jawa Barat 40261