MS SQL Server Database Training

Microsoft SQL Server is a relational database server from Microsoft. The primary function is to store and retrieve data as requested by other software applications, such as SAP.
This hands-on course provides you with the skills you need to install SQL Server, create and modify storage structures, manage security, and back up and recover databases.

After completing this course, students will be able to:
  • Verify SQL Server component Installation
  • Prepare systems for SQL Server 2008 R2
  • Install and configure SQL Server 2008 R2
  • Work with databases
  • Use SQL Server 2008 R2 Recovery Models
  • Perform backup SQL Server 2008 R2 databases
  • Perform restore SQL Server 2008 R2
  • Perform import and export on data
  • Perform authentication and authorization of users
  • Assign server and database roles
  • Authorize users to access resources
  • Audit SQL Server environments
  • Automate SQL Server 2008 R2 management
  • Configure security for SQL Server Agent
  • Monitor SQL Server 2008 R2 with alerts and notifications
  • Perform ongoing database maintenance
  • Trace access to SQL Server 2008
  • Monitor SQL Server 2008 R2
  • Manage multiple servers
  • Secure the server through logins and permissions management
  • Perform routine maintenance to correct database corruption and fragmentation
  • Build databases and upgrade from prior versions
  • Automate administrative activities with SQL Server Agent multistep jobs
  • Identify problems and monitor server health
  • Troubleshoot Common SQL Server 2008 R2 administrative issues

Mode of delivery: Fully instructor-led classroom or online training