Trusted Training Partners
Home / Non-Accredited / Software & IT Non-Accredited / MCSA: SQL Server 2014 Training Course
Quick Look Course Summary:MCSA: SQL Server 2014 Training 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:Accredited
-
Locations & Venues: Off-site or in-house. We train in all major city centres throughout South Africa.
Get Free & personalised
Training Advice
MCSA: SQL Server 2014 Training Course
Course Introduction
This comprehensive training course will provide you with a solid understanding of the SQL Server platform. By the end of the course, you will be able to configure SQL Server services, install SQL Server 2014, and understand its role and functions. You will also learn to create, configure, and alter databases, use import/export wizards, and understand SSIS, BCP, BULK INSERT, and many more features.
Course Outline
1. Installing SQL Server 2014
- Introduction to the SQL Server Platform
- SQL Server Services and Configuration Options
- Installation Considerations
- Pre-installation Stress Tests
- Installing a SQL Server Instance
- Post-Installation Checks
2. Working with Databases
- Overview of SQL Server Databases
- Creating Databases
- Using Database Files and File Groups
- Moving Database Files
- Buffer Pool Extension
- Creating and Configuring Databases
- Storage Pool Creation
- Adjusting tempdb Configuration
- Attaching Databases
3. SQL Server 2014 Recovery Models
- Backup Strategies
- SQL Server Transaction Logging
- Backup Strategy Planning
- Understanding and Configuring Recovery Models
4. Backup of SQL Server 2014 Databases
- Backing Up Databases and Transaction Logs
- Managing Database Backups
- Backup Options and Compression
- Transaction Log, Differential, Copy-Only, and File Group Backups
5. Restoring SQL Server 2014 Databases
- Restore Process Overview
- Database Restoration
- Point-in-Time Recovery
- Restoring System Databases and Individual Files
- Restore Strategy and STANDBY Mode
6. Importing and Exporting Data
- Data Transfer Techniques
- Importing and Exporting Table Data
- Bulk Data Insertion
- Data-Tier Application Deployment and Upgrades
- Importing Excel Spreadsheets and CSV Files
- Extraction Package Creation and Testing
7. Authenticating and Authorizing Users
- SQL Server Connection Authentication
- Authorizing Database Access
- Server-wide Authorization
- Partially Contained Databases
- Creating and Correcting Logins and Database Users
Course Duration
This intensive course runs for 3 days.
Testimonials
“I am definitely applying the training information into my daily job. The training was extremely informative and conducted in a very relaxed environment.” – Delegate from a major South African motor company
Who Should Attend
This course is designed for programmers and SQL Server professionals looking to enhance their skills and knowledge of SQL Server 2014.
Enroll in the MCSA: SQL Server 2014 Training Course today and gain the expertise you need to excel in SQL Server management and development!
Contact Us Now!
Please Phone Us Now To Speak to One of Our Friendly Consultants to Provide This Course around your schedule:
Tel:011-882-8853
Please Fill in the Form – We Will Get Back to You Within 15 minutes
Please Email Us Now – We Will Get Back to You Within 15 minutes
[email protected]
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.