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 |
View this Course
Certified
You have 
