Hi All,
This is regading SQL Server DBA training,one of my friend has started teaching.Please find the below details.
[Complete course manual is in progress of preparation and will be share by friday EOD]
Batch-2: SQL Server DBA
Duration: 30-40 Days [Full techinical+ Real time issue in office laptop+interview handle]
Daily :2-3 Hours
Please contact yendluriseshagirirao@gmail.com
9742607127
Course Topics
Basic-Topics: [1st WEEK]
SQL Server Over view
SQL Server installations [2000, 2005, 2008, 2008R2, 2012].
SQL Server management studio content overall Explanation.
Database Creation.
File & File Groups.
Database files architecture.
a. Data file.
b. Log file.
c. New data file.
Security.
A. Server Roles.
B. Database Roles.
C. Object level Roles.
Database backup-Recovery Models.
Backup Types
Backup configuration by using job\ maintaince plans [Theory\practical]
Database mail configuration \operators\notification.
Real -Time sessions: [Week End Plan]
ITIL processes –Incident ,change, problem management
Ticketing tool
Monitoring tool
Escalation matrix.
Issue handling
Customer discussion over a call & chat window
Weekend maintaince tasks [What kind of activities]
Email communication \flow.
Real time issues explanations on office laptop
Real Time Terminologies: [Week End Plan]
DR Testing
BCP Plan
Integrity testing
RACI Matrix
RCA Plan
High Availability: [2nd +3rd Week]
Performance Tunning: [4 week]
Blockings
Dead locks
Indexes
Fragmentation
Isolation levels
All the best
This is regading SQL Server DBA training,one of my friend has started teaching.Please find the below details.
[Complete course manual is in progress of preparation and will be share by friday EOD]
Batch-2: SQL Server DBA
Duration: 30-40 Days [Full techinical+ Real time issue in office laptop+interview handle]
Daily :2-3 Hours
Please contact yendluriseshagirirao@gmail.com
9742607127
Course Topics
Basic-Topics: [1st WEEK]
SQL Server Over view
SQL Server installations [2000, 2005, 2008, 2008R2, 2012].
SQL Server management studio content overall Explanation.
Database Creation.
File & File Groups.
Database files architecture.
a. Data file.
b. Log file.
c. New data file.
Security.
A. Server Roles.
B. Database Roles.
C. Object level Roles.
Database backup-Recovery Models.
Backup Types
Backup configuration by using job\ maintaince plans [Theory\practical]
Database mail configuration \operators\notification.
Real -Time sessions: [Week End Plan]
ITIL processes –Incident ,change, problem management
Ticketing tool
Monitoring tool
Escalation matrix.
Issue handling
Customer discussion over a call & chat window
Weekend maintaince tasks [What kind of activities]
Email communication \flow.
Real time issues explanations on office laptop
Real Time Terminologies: [Week End Plan]
DR Testing
BCP Plan
Integrity testing
RACI Matrix
RCA Plan
High Availability: [2nd +3rd Week]
Performance Tunning: [4 week]
Blockings
Dead locks
Indexes
Fragmentation
Isolation levels
All the best
careersvalleyinfo is known to be a reputed consulting firm for SQL SERVER related Courses with top talented database professionals and software engineers coming from some of the most established and most successful software development and technology consulting firms around the globe for providing a tailored-made solutions to their clients at the very best of their knowledge and liable time
http://www.sqlservermasters.com/