MCSA: SQL Server 2014 Training Course Course

 
Category:

Description

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

<