SQL SERVER INTEGRATION SERVICES
Training Mode: offline
SQL Server Architecture SQL Server Version’s and Editions SQL server Installation and Configuration
SQL Server DBA Online Training Concepts :
SQL Server Architecture
SQL Server Version’s and Editions
SQL server Installation and Configuration
Pages and extents
Sql server services
Sql server protocols
Security-Login and User,Principals,Securables,Managing Permissions
Isolation Levels and Concurrency
Locking and Blocking-Types of locks and Types of reads
Service accounts for SQL server
GUI Templates-object explorer,solution explorer,template explorer,registered servers
Command line tools-BCP,SQLCMD
Creating and Configuring Database
Altering Databases and Their Options-Using ALTER command,Controlling Access,Controling DB state.
DAC-Dedicated Adminstrator Connection
CMS-Central Management Server
Data Compression and Backup Compression
Using ALTER Authorization Command
Schemas-Creating and working with schemas
DBCC-And their parameters
Indexes-Types of Indexes,working and Maintaining indexes,resolving indexfragmentation,fill factor
SQL Server Top New Features
DMV’s-Types of Dynamic Management Views and working with them.
PBM-Policy Based Management
Performance data collector
SQL Server profiler
Types of Sql Server Backups and their important options.
Types of Restores and its related options
Orphan Users-Fixing orphan users
Basics of Windows Clustering
Overview of real time Third party Monitoring tools-Ex:-Idera DM,Lite speed.
Overview of real time Ticketing tool-Ex:-Altiris,Remedey.
As per your requirement course we wil schedule the timings.Our support is 24×7. The one solution to beat hectic schedule and travelling time and achieve these goals is by joining online courses. Most experienced and specialized instructors are going to be assigned to you.