Give Us A Call +2711 882 8853

MCSA: SQL Server 2014 Training Course Course

Quick Look Course Summery: MCSA: SQL Server 2014 Training Course Course
  • Next Public Course Date: 19/07/2019

  • Length:3 day

  • Price: 1 Person R ex vat3 Person R 0 ex vat10 Person R 0 ex vat

  • Certification Type: Certificate of Attendence

  • Locations & Venues: Call Centre Training Courses are held in JHB, Cape Town, Durban, Port Elizabeth

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

Get Free & personalised Training Advice

Enjoy incredible savings the more delegates you send. See for yourself...

BOTi COURSE COST CALCULATOR

Simply Select a date to see cost

 
m banner