SQL Server 2005 & VB.NET

posted by Galih Raditya
Mar 12

Dalam training ini akan dipelajari konsep dan dasar penggunaan SQL Server 2005.

Dengan training ini diharapkan peserta mampu memahami konsep dasar dari penggunaannya, memahami fungsi SQL Server 2005 dan mampu membuat database SQL Server 2005.

CONTENT:

1. Installing SQL Server 2005

1.1 Performing an Installation

1.2 Managing SQL Server

1.3 Managing Databases and Files

1.4 Planning databases

1.5 Creating databases

1.6 Managing databases

2. Creating and Managing Databases

2.1 Creating a Database

2.2 Managing Filegroups

2.3 Viewing Metadata

2.4 Disaster Recovery

2.5 Planning a Backup Strategy

2.6 Backing Up User Databases

2.7 Restoring User Databases

2.8 Recovering Data from Database Snapshots

2.9 System Database and Disaster Recovery

3. Securing SQL Server

3.1 Creating Logins

4. Implementing a Disaster Recovery Strategy

4.1 Implementing a Backup Strategy

4.2 Restoring Databases

4.3 Rebuild The Master Database

4.4 Managing Security

4.5 Overview of SQL Server Security

4.6 Securing the Server Scope

4.7 Securing the Database Scope

4.8 Managing Keys and Certificates in SQL Server

4.9 Creating and Managing Users

4.10 Using a Certificate to Encrypt Data

4.11 Monitoring SQL Server

4.12 Viewing Current Activity

4.13 Using System Monitor

4.14 Using SQL Server Profiler

4.15 Using DDL Triggers

4.16 Using Event Notifications.

5. Monitoring SQL Server

5.1 Monitoring SQL Server Performance

5.2 Tracing SQL Server Activity

5.3 Implementing DDL Trigger

5.4 Transferring Data

5.5 Overview of Data Transfer

5.6 Introduction to SQL Server Integration Services

5.7 Using SQL Server Integration Services

 

Harga Kursus : 2.000.000 ( 24 jam Belajar / 12 Kali pertemuan )

1 Kelas Minimal 3 Peserta

Fasilitas : modul dan Sertifikat

 

 


Leave a Reply