Trusted Training Partners

Quick Look Course Summary:MCSA: SQL Server 2014 Training Course Course
  • Next Public Course Date:

  • Length: 3 day(s)

  • Price (at your venue): 1 Person R 16,700.00 EX VAT 3 Person R 11,644.28 EX VAT 10 Person R 7,836.00 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

    After completion of this course (Sql Training, Sql Courses Cape Town, T Sql Courses, Sql Database Training, Sql Training Cape Town, Basic Sql Training), students will understand the SQL Server platform, be able to configure SQL Server services and install SQL Server 2014. Students will also be able to understand the role and function of SQL Server and create, configure and alter databases. The course also covers the use of the import/export wizards and explains how they relate to SSIS. It also introduces BCP and BULK INSERT and many more features.

    MCSA: SQL Server 2014 Training Course Course :Course Outline

    1. Installing SQL Server 2014
    Introduction to the SQL Server Platform
    SQL Server Services and Configuration Options
    Considerations for Installing SQL Server
    Performing Pre-installation Stress Tests
    Installing a SQL Server Instance
    Performing 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
    Creating a Storage Pool
    Adjusting tempdb Configuration
    Creating and Configuring a Database
    Attaching a Database
    Using Buffer Pool Extension

    3. SQL Server 2014 Recovery Models
    Backup Strategies
    Understanding SQL Server Transaction Logging
    Planning a SQL Server Backup Strategy
    Understanding SQL Server Recovery Models
    Planning a Backup Strategy
    Configuring Recovery Models
    Reviewing Recovery Models and Strategy

    4. Backup of SQL Server 2014 Databases
    Backing up Databases and Transaction Logs
    Managing Database Backups
    Working with Backup Options
    Investigating Backup Compression
    Performing Transaction Log Backups
    Performing Differential Backups
    Performing Copy-Only Backups
    Performing File group Backups

    5. Restoring SQL Server 2014 Databases
    Understanding the Restore Process
    Restoring Databases
    Working with Point-in-Time Recovery
    Restoring System Databases and Individual Files
    Determining a Restore Strategy
    Using STANDBY Mode

    6. Importing and Exporting Data
    Transferring Data To/From SQL Server
    Importing and Exporting Table Data
    Inserting Data in Bulk
    Deploying and Upgrading Data-tier Applications
    Importing an Excel Spreadsheet
    Importing a CSV File
    Creating and Testing an Extraction Package
    Creating and Deploying a Data-tier Application
    Comparing Loading Performance

    7. Authenticating and Authorizing Users
    Authenticating Connections to SQL Server
    Authorizing Logins to Access Databases
    Authorization Across Servers
    Partially Contained Databases
    Creating Logins
    Correcting an Application Login Issue
    Creating Database Users
    Correcting Access to a Restored Database

    MCSA: SQL Server 2014 Training Course (Sql Training, Sql Courses Cape Town, T Sql Courses, Sql Database Training, Sql Training Cape Town, Basic Sql Training): Course Duration

    3 day/s

    Who should attend: MCSA: SQL Server 2014 Training Course (Sql Training, Sql Courses Cape Town, T Sql Courses, Sql Database Training, Sql Training Cape Town, Basic Sql Training)

    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

    Realize incredible savings by sending more delegates

    Do you want to save costs by doing training at your premises?

    Save costs by providing own laptop

    Region *

    Please Contact Us Now - We Will Respond in 15 Minutes


      Accredited Courses

      Additional Courses

      Leadership & Management Courses

      Software & IT Courses

      Top Rated