MICROSOFT SQL SERVER DBA ONLINE REAL TIME TRAINING

MICROSOFT SQL SERVER DBA ONLINE REAL TIME TRAINING

 

Invite friends

Contact Us

Page Views : 57

About The Event

Hi Everyone,

We Will provide MICROSOFT SOFT SQL SERVER  DBA online real time training which includes all real time scenarios with practical.

 

Classes start from 26-Nov-2016

Timings: 8 AM- 9:30 AM OR 6:30 PM - 8 PM IST

Course Duration :45-60 Days

We also provide fast track based on your requirement.

More details E-mail us:venkat.thej@gmail.com ,+918550874077

 

List of topics to be covered:

===================
 
  • History of Microsoft SQL Server
 
  • MS SQL server Versions
 
  • Installations and Hotfix
     
SQL Server Installation
 
SQL server up-gradation 
 
Service pack(SP) 
 
Cumulative Updates(CU)
 
 Etc..
 
  • Databases:
 
Creating Databases
 
Backup and Restoring Databases 
 
Move Physical file path(Data & Log files)
 
Change Database Collations
 
Fixed orphan users
 
Database Migrations
 
Database mail configurations
 
  • SQL Agent 
 
 
Creating Jobs
  
Job Migrations
 
Creating  jobs through maintenance plan 
 
Etc..
 
  •  Creating Linked server 
 
  • High availability with failover and failed back
 
Log shipping 
 
Mirroring 
 
Replications
 
Clustering  
 
Always On 
 
 
Most common real time issues and troubleshooting
====================================
 
User unable to connect to SQL Server
 
Job Failures
 
Backup failed to complete
 
Unable to restore the backup files
 
Services Failed to start
 
TempDB Full
 
Log File Full
 
Disk Space issues
 
Permission issues
 
Database issues
 
SQL Server stopped
 
Maintenance plan issues
 
Agent Down.
 
Locks and Deadlocks
 
Linked Servers
 
Etc..