Course details
Pre-requisites
Basic knowledge of relational database, some experience in database design and MS Windows operating system 7 and its core functionality.
Certificate Of Attendance:
Certificate Of Attendance will be awarded to students completing the course achieving minimum 75% attendance.
Who Should Take this course
This course is designed for Database Administrators who administer and maintain SQL Server databases
Training Methodology & Materials:
Course details
Pre-requisites
Basic knowledge of relational database, some experience in database design and MS Windows operating system 7 and its core functionality.
Certificate Of Attendance:
Certificate Of Attendance will be awarded to students completing the course achieving minimum 75% attendance.
Who Should Take this course
This course is designed for Database Administrators who administer and maintain SQL Server databases
Training Methodology & Materials:
Practical hands-on sessions, 75% lab-based and 25% theory-based
Additional and well-designed labs handouts are given to further enhance the understanding of courseware
Lesson 1:
- Identifying the SQL Server Platform and Tools
- Overview of SQL Server Features Create Filegroups and Partitions
Lesson 2:
- Deploying SQL Server Install SQL
- Server Migrate SQL Server From a Previous Version
Lesson 3:
- Configuring SQL Server Configure
- Server Properties Configure Memory and CPU Configure Database Mail
Lesson 4:
- Managing Databases in SQL Server 2012
- Create a Contained Database
- Configure Database Options
Lesson 5:
- Managing SQL Server Security
- Configure Server Security
- Create Server Roles Configure Database Security
Lesson 6:
- Implementing Advanced Security Settings Create Certificate-Based Logins
- Apply Auditing and Policy-Based Management Strategies
Lesson 7:
- Applying Encryption and Compression
- Apply Encryption on Databases
- Compress a Database Table
Lesson 8:
- Working with Indexes and Log Files
- Work with Full Text Indexes
- Configure Advanced Storage and Indexing ]
- Settings Configure Log Files
Lesson 9:
- Working with Backup and Restore
- Perform a Backup
- Restore a Database
- Import and Export Data
- Configure the SQL Server Agent
Lesson 10:
- Implementing High Availability
- Work with Clustering
- Work with Replication
- Work with Mirroring and AlwaysOn
- Work with Central Management Servers
Lesson 11:
- Optimizing Server Performance
- Manage Server Performance
- Optimize Indexes
Lesson 12:
- Troubleshooting Issues and Recovering Databases
- Troubleshoot Database Issues
- Perform a Database Recovery
Lesson 13:
- Performing Advanced Database Management Tasks
- Manage Database Infrastructure
- Configure SSI
Updated on 08 November, 2015 - Read Less