Request A Demo

Please enter your details below.

41144

Demo Schedules

DOTNET demo on

Mon, Jan 16th @ 8pm EST.

JAVA Demo on

Mon, Jan 18th @ 6.30pm EST.

QA batch Weekdays on

Mon, 20th Jan @ 8pm EST.

BA Batch starts on

Jan 23rd, Mon @ 8pm EST.

ISTQB Certification batch on

Mon, 9th Jan @ 8.30pm EST.

ETL Testing 1st class on

Sat, Aug 13th @ 12 pm EST

View all demos

Quick Contacts

US: (770) 777 1269
UK: (020) 3371 7615
India: (+91) 90325 96412

Email: training@h2kinfosys.com


H2K Infosys, LLC
300 Prospects Place
Alpharetta, GA - 30005

United Sates of America

View locations for more details

Make A Payment

Google Checkout

Enter the Course Name

Enter the Amount to Pay

H2K Infosys

H2K Infosys | SQL Server DBA Online Course Details

Details:

SQL Server 2008 Overview and INstallation

  • Overview of SQL Server
  • Installation Requirements (Hardware and Software)
  • Installation Walkthrough (Step-by-Step)
  • Overvoew of SQL Server Management Studio (SSMS)

Creating and Managing Databases

  • Creating Databases
  • Database
  • File Groups
  • Database Options
  • Managing database

Creating and Managing Tables and iimplementing Data Integrity

  • Creating Tables
  • Defining Table Location
  • Modifying Tables
  • Dropping Tables
  • Data Types
  • Defining Constraints
  • Partitioned Table
  • Data Compression (New Feature in SQL Server 2008

Data Manipulation and Data Correlation

  • Select/Update/Delete
  • Sub Queries
  • Joins
  • Union/UnionAll/Intersect

SQL Sever Built in Functions

  • Mathematical Functions
  • String Functions
  • Date Functions
  • Convert Functions
  • Aggregate Functions

Creating and Maanaging Views

  • Create View
  • Alter View
  • Drop View
  • Check and Encryption Options

Introduction to T-SQL Programming

  • Variable Declaration
  • Temp Table Concepts
  • Variable Table Concepts
  • Loops

Creating and Modifying Procedures and Cursors

  • Creating Procedures
  • Parameter Types
  • Modifying Procedures
  • Using Temp Tables, Variabke Tabkes and cursirs in Procedures
  • How to use Dynamic SQL Statements in Procedures.
  • Error Handling

Creating and Modifying user defned Functions

  • Creating/Modifying Scalar functions
  • Creating/Modifying table functions

Creating and Modifying Triggers

  • Table Triggers
  • DDL Triggers

Working with distributed Data

  • Creating Linked Servers
  • How to use DML Statements against to the remote servers
  • How to use remote Procedure execution in SQL Servers

SQL Server Security

  • Authentication Methods
  • Server level Security
  • Database Level Security
  • Object Permissions

Creating and Managing Indexes

  • Clustered Index
  • Non Clustered Index
  • Unique index
  • Composite Indexes
  • Fill Factor /Pad Index

Backup/Recovery

  • Recovery Models
  • Backup Types
  • Full Database backup
  • Differential Backup
  • Transactional Log Backup
  • Restore Databases
  • Restore transaction Logs
  • Point of Recovery
  • Backup Compression (New Feature in SQL Server 2008)

Database Mail

SQl Server Scheduling and Notification

  • Managing jobs
  • Managing Alerts

Monitoring and Troubleshooting SQL Server Performance

  • Identify and Resolve Blocking lssues
  • SQL Server trace
  • QUERY Execution Plan Analysis
  • DB Tuning Adviser
  • Performance Monitor
  • Setting Maintenance plans

SQL Server Clustering (High availabilty Solutions) Concept

Database Mirroring

Replication

Migrate or UPgrade to SQL Server 2008

Log shipping

Resource Governor (new Feature in SQL Server 2008

SQL Server Intedration Services (SSIS)

SQL Server Reporting Serveices (SSRS)

Database Design Concepts and Design TOOl (ERWin Tool)

  • Normalion
  • De-Normalization