Trusted Training Partners
Home / Non-Accredited / Software & IT Non-Accredited / Administering SQL Server Databases 2012 Course
Quick Look Course Summary:Administering SQL Server Databases 2012 Course
-
Next Public Course Date:
-
Length: 3 day(s)
-
Price (at your venue): 1 Person R 17,953 EX VAT 3 Person R 12,518 EX VAT 10 Person R 8,424 EX VAT
-
Certification Type:ACREDDITED
-
Locations & Venues: Off-site or in-house. We train in all major city centres throughout South Africa.
Get Free & personalised
Training Advice
Administering SQL Server Databases 2012 Course
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.
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
Course Duration
3 day/s
Who should attend
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
Frequently Asked Questions
Is this course accredited?
BOTI offers a mix of SETA-accredited, internationally-certified (VMEdu) and non-accredited skills-programme courses. Please confirm a specific course's accreditation status with us when you enquire. All delegates receive a certificate of completion.
Can this course be delivered in-house at our premises?
Yes. Every BOTI course can be delivered on-site at your offices anywhere in South Africa, or at a scheduled public venue, and can be customised to your team and industry.
How do I book or get a quote?
Use the enquiry form on this page for a tailored quote, or call 011 882 8853 / email [email protected]. The course length and next public course date are shown in the Quick Look summary.
Can this training count towards our B-BBEE scorecard?
Yes - skills development training can contribute to your B-BBEE scorecard, and where learnerships apply you may also access SETA grants and the Section 12H tax allowance. Ask us how to structure it for maximum points.
Do you tailor the training to our industry?
Yes. Our training is built around your business, using practical, real-world examples relevant to your team and sector.