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]