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?
No. This course is delivered as a practical, facilitator-led skills programme and delegates receive a BOTI certificate of attendance. If you need a credit-bearing outcome for B-BBEE skills development, SETA grant or learnership purposes, ask us about our accredited qualifications, skills programmes and unit standards.
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?
Spend on this course still counts as skills development expenditure for B-BBEE purposes, but it does not count as accredited training spend, and the Codes limit how much non-accredited training can contribute. Please confirm the treatment with your skills development facilitator or B-BBEE verification agency.
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.