Courses Offered


Follow us on

Twitter    Facebook    LinkedIn     Youtube

Demo Schedules

New Demo Schedules

Demo sessions for the month of April 2010




MAKE A PAYMENT

Enter the Amount to Pay & Click the button

$.00


TESTIMONIALS


Thank you for all the support to our team and project. Your training helped  a lot to move forward quickly. Thanks a lot

Manager, McKesson










Greetings!
SAP class was simply excellent! Thank you! You were just too good!!!
I'm glad I attended your training classes. It seems pretty simple and  interesting now. I want to start practicing on it. After I'm done with, may be I'll ask for any help I need. Your teaching techniques are easy to understand, help to build more confidence to work on real time projects.

Regards,
Mani










Hi H2K Infosys Team,
Thank you for providing me training. After I took training from you and worked on few projects as per your guidance and Now I settled as software QA analyst. When I joined your training, I am new to IT field, at present I am IT pro and  helping my co workers who have been working from a while. I owe a lot to H2K Infosys. I pray god every day to grow H2K Infosys. Good Luck.

Mathew










To be frank I was very satisfied with your training for what I have paid, And Thats why I keep telling my friends about your training center ,when they ask me ,I will do so in the present and in future also. Since I liked your training class I tell my friends and I want them also to be benefited like me. And one more thing is that u give us chances to attend the classes n number of times which is hard to find in other training centers, through that way we learn different things and concepts, through different teaching staffs. At times u also gives importance to our decisions and conveniences which is really great. Whoever asks me for sure I will say your training center only at present and in future also. I have heard many of training centers through my friends and I feel urs is good in some way or the other. Good work.

Thank you,
Sridevi










Again I'm really pleased with the course, told someone in my company how great it is; and now she's interested in taking the course as well.

Thank you,
Lak








COURSES > SQL Server DBA

SQL Server








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 Server2008

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