Give Us A Call +2711 882 8853

Administering SQL Server Databases 2012 Course

Quick Look Course Summery: Administering SQL Server Databases 2012 Course
  • Next Public Course Date: 06/09/2019

  • Length:3 day

  • Price: 1 Person R ex vat3 Person R 0 ex vat10 Person R 0 ex vat

  • Certification Type: Certificate of Attendence

  • Locations & Venues: Call Centre Training Courses are held in JHB, Cape Town, Durban, Port Elizabeth

Administering SQL Server Databases 2012 Course: Introduction

This course introduces participants to the SQL Server platform. Participants will learn about SQL editions, the basics of network listeners and services and service accounts. The course covers creating databases and moving databases between servers. Other topics include the SQL Server Backup and several types of backup options and fixed server roles, user-defined server roles and both fixed and user-defined database roles.

Administering SQL Server Databases 2012 Course :Course Outline

1. Introduction to SQL Server and Toolset Introduction to the SQL Server Platform Introduction to the SQL Server Tools Configuring SQL Server Services 2. Preparing Systems for SQL Server 2012 An Overview of SQL Server Architecture Planning Server Resource Requirements Pre-installation Testing for SQL Server 3. Installing and Configuring SQL Server 2012 Preparing to Install SQL Server Installing SQL Server Upgrading and Automating Installation 4. Working with Databases An Overview of SQL Server Databases Creating Databases Files and File groups Moving Database Files 5. SQL Server 2012 Recovery Models Understanding SQL Server Transaction Logging Recovery Strategies Planning a SQL Server Recovery Strategy 6. Backup of SQL Server 2012 Databases Managing Database Backups Backup Options Backing up Databases and Transaction Logs 7. Restoring SQL Server 2012 Databases Understanding the Process of Restoring Databases Restoring Databases Understanding Point-In-Time Recovery Restoring System Databases and Individual Files 8. Importing and Exporting Data Using the Import and Export Wizard The Relation to SSIS Transferring Data To/From SQL Server Inserting Data in Bulk 9. Authenticating and Authorising Users Authenticating Connections to SQL Server Authorising Logins to Access Databases Authorisation Across Servers 10. Assigning Server and Database Roles Fixed Server Roles User Defined Server Roles Fixed Database Roles User Defined Database Roles

Administering SQL Server Databases 2012 Course: Course Duration

3 day/s

Who should attend: Administering SQL Server Databases 2012 Course

This course is intended for programmers, SQL Server. **Quote does not include Any Exam Fees (if applicable) IMPORTANT ACTION: Do Not Wait To Improve Your Skills.   Book Now By Completing Online Booking Form / Customised Proposal or Obtain Approval For Your Already Received Customised Proposal

Get Free & personalised Training Advice

Enjoy incredible savings the more delegates you send. See for yourself...


Simply Select a date to see cost

m banner