MS SQL Server Implementation and Maintenance 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. Microsoft SQL Server's primary query languages are T-SQL and ANSI SQL.
This course help you prepare for your MCTS SQL Server 2008 Implementation and Maintenance certification or improve your SQL Server 2008 knowledge. The MCTS certifications by Microsoft are product-specific foundation certifications for a wide variety of Microsoft products. It provides students with product knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database

After completing this course, students will be able to:
  • Install and configuring SQL Server 2005
  • Manage databases and files
  • Work with views
  • Use stored procedures, triggers and functions
  • Manage transactions and locks
  • Perform disaster recovery
  • Manage security
  • Monitor SQL Server
  • Transfer data
  • Automate administrative tasks
  • Maintain high availability
  • Understand the replication procedures
  • Perform performance tuning

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