Course Maintaining a Microsoft SQL Server 2008 Database

Duration (days): 3
Price (CZK): 12000

Maintaining a Microsoft SQL Server 2008 Database topics:

• Introduction to SQL Server Platform
• Working with SQL Server Tools
• Configuring SQL Server Services
• Overview of SQL Server 2008 R2 Architecture
• Planning Server Resoucre Requirements
• Pre-installation Testing for SQL Server 2008 R2
• Preparing to Install SQL Server 2008 R2
• Installling SQL Server 2008 R2
• Upgrading and Automating Installation
• Overview of SQL Server Databases
• Working with Files and Filegroups
• Moving Database Files
• Backup Strategies
• Understanding SQL Server Transaction Logging
• Planning a SQL Server Backup Strategy
• Backing up Databases and Transaction Logs
• Managing Database Backups
• Working with Backup Options
• Understanding the Restore Process
• Restoring Databases
• Working with Point-in-time Recovery
• Restoring System Databases and Individual Files
• Transferring Data To/From SQL Server 2008 R2
• Importing and Exporting Table Data
• Inserting Data in Bulk
• Authenticating Connections to SQL Server
• Authorizing Logins to Access Databases
• Authorization Across Servers
• Working with Server Roles
• Working with Fixed Database Roles
• Creating User-defined Database Roles
• Authorizing User Access to Objects
• Authorizing Users to Execute Code
• Configuring Permissions at the Schema Level
• Options for Auditing Data Access in SQL Server
• Implementing SQL Server Audit
• Managing SQL Server Audit
• Automating SQL Server Management
• Working with SQL Server Agent
• Managing SQL Server Agent Jobs
• Understanding SQL Server Agent Security
• Configuring Credentials
• Configuring Proxy Accounts
• Configuration of Database Mail
• Monitoring SQL Server Errors
• Configuring Operators, Alerts and Notifications
• Ensuring Database Integrity
• Maintaining Indexes
• Automating Routine Database Maintenance
• Capturing Activity using SQL Server Profiler
• Improving Performance with the Database Engine Tuning Advisor
• Working with Tracing Options
• Monitoring Activity
• Capturing and Managing Performance Data
• Analyzing Collected Performance Data
• Working with Multiple Servers
• Virtualizing SQL Server
• Deploying and Upgrading Data-Tier Applications
• SQL Server Troubleshooting Methodology
• Resolving Service-related Issues
• Resolving Concurrency Issues
• Resolving Login and Connectivity Issues

All course schedules I will make suitable according your individual requirements.
If course topics are not suitable for you then contact me contact and we will come to topics meet your individual bussiness needs