This course is designed for Fresher and professional with 2 years of Experience. This course will help the student to start the journey as SQL server DBA.
After completion of course Student can go for Database Administration Certification.
Requirement:
Student should have knowledge of Windows, Basic MS Office
Good to have: RDBMS concept , IT Experience , Excel , MS Access
Course Content
Day | Subject |
Day 1 | Introduction |
Day 2 | Database Concepts |
Day 3 | Managing Database object |
Day 4 | Overview of physical and logical database files |
Day 5 | Installation and configuration of SQL Server |
Day 6 | SQL Server Security Overview |
Day 7 | Database Maintenance and Protection |
Day 8 | Daily Maintenance, Monitoring and Automation |
Day 9 | Reliability & High Availability Options |
Day 10 | Testing and Evaluation |
Training Course:
Day 1 | Day 2 | Day 3 |
Introduction | Database Concepts | Managing Database object |
· Overview of Course | · MS SQL Server â??Overview | · Tables |
· Basic Window Administration | · SQL Server Architecture | · View |
| · SQL Server Services | · Index |
| · SQL Server Admin Tool | · Programmability object SP/Functions/Trigger/Constraints etc. |
| · T-SQL Overview | |
| · Introduction to database design | |
|
|
|
Day 4 | Day 5 | Day 6 |
Overview of physical and logical database files | Installation and configuration of SQL Server | SQL Server Security Overview |
· Designing Data Storage and RAID | · Prerequisite for Installation | · Login |
· Monitoring Disk storage and Administration | · Installation of Stand Alone Server | · Users |
· (Anything Left over from Day 3) | · Server Property | · Managing Logins/Users |
· Surface Area Configuration | · Server / Databases Roles | |
· Object level Permission | ||
· Security Best Practices | ||
· SQL Server Service Accounts | ||
· Server Objects / Linked Server /Endpoints /Backup Device/ Server Level triggers | ||
· Other Security options | ||
Day 7 | Day 8 | Day 9 |
Database Maintenance and Protection | Daily Maintenance, Monitoring and Automation | Reliability & Availability Options |
· Backup | · Regular Tasks | · Database Mirroring |
· Restore | · Monitor disk space usage | · Log shipping |
· Moving and copying Database. | · Monitor application performance | · High availability Database |
· Maintenance Plan | · Monitor physical and logical disk space | · Replication |
· Maintain indexes and data files | · Case Study - Healthcheck | |
· Review backup and recovery operations | ||
· Review security | ||
· Review SQL Server Logs and/or Windows logs | ||
· Verify the status of all jobs | ||
· Automation of DBA monitoring | ||
· Scripts | ||
· Trigger | ||
· Alerts / Operator | ||
Day 10 Testing and Evaluation |