Materi training ini membahas tentang pengetahuan dan teknik-teknik untuk mengimplementasikan SQL Server 2008 dan menggunakan fitur-fitur, tools, transact SQL dan object-object database lainnya yang berhubungan dengan aktivitas sebagai database developer

Durasi : 5 hari

• SQL Server 2008 Overview and Installation
  • Hardware Requirements
  • Installation
  • Security

• SQL Server Management Studio
  • SSMS Options
  • Query Editor

• Database Design and Creation
  • Defining a Database
  • Prebuilt Databases
  • Database System Type
  • Building Relationships
  • Normalization

• Security and Compliance
  • Server Logins and Database Users
  • Roles
  • Schemas

• Defining Tables
  • SQL Server Data Types
  • Image and Large Text Storage
  • Creating Table
  • Primary Key
  • Relationship

• Creating Indexes
  
  • Creating Index
  • Drop Index
  • Alter Index

• Database Backups, Recovery, and Maintenance
  • Transaction Logs
  • Backing Up the Data
  • Restoring a Database
  • Creating a Database Maintenance Plan
  • Setting Up Database Mail

• Working with the Data
  • Select, Insert, Update and Delete Data
  • DBCC CHECKIDENT
  • Constraint
  • Transaction
  • Truncate Table

• Building a View
  • Using Views for Security
  • Encrypting View Definitions
  • Creating View
  • Indexing View

• Stored Procedures and Functions
  • Creating Stored Procedure
  • Stored Procedure Executing Methods
  • Flow Control
  • User Defined Functions

• T-SQL Essentials
  • Joining Tables
  • Variables
  • Aggregations
  • Grouping Data
  • Error Handling

• Advanced T-SQL
  • Subqueries
  • Apply Operator
  • Common Table Expressions
  • Pivot Data
  • Ranking Functions
  • Using PowerShell

• Triggers
  • Creating Trigger
  • DML Trigger
  • DDL Trigger