• 100 Queen St W, Brampton, ON L6X 1A4, Canada
  • +1-800-961-0337
For more details, please call us on +1800-961-0337 or email us on info@microteklearning.com

20462: Administering Microsoft SQL Server 2014 Databases Course Overview

This five-day teacher drove course furnishes understudies with the information and aptitudes to keep up a Microsoft SQL Server 2014 database. The course concentrates on showing people how to utilize SQL Server 2014 item elements and instruments identified with keeping up a database. 

Note: This course is intended for clients who are keen on learning SQL Server 2012 or SQL Server 2014. It covers the new components in SQL Server 2014, yet in addition the vital abilities over the SQL Server information stage. 

20462: Administering Microsoft SQL Server 2014 Databases Audience Profile 

The essential gathering of people for this course is people who regulate and keep up SQL Server databases. These people perform database organization and support as their essential zone of obligation, or work in conditions where databases assume a key part in their essential employment. 

The auxiliary group of onlookers for this course is people who create applications that convey content from SQL Server databases. 

20462: Administering Microsoft SQL Server 2014 Databases At Course Completion

Subsequent to finishing 20462: Administering Microsoft SQL Server 2014 Databases course, understudies will have the capacity to: 

  • Depict center database organization undertakings and apparatuses. 
  • Introduce and design SQL Server 2014. 
  • Design SQL Server databases and capacity. 
  • Plan and execute a reinforcement methodology. 
  • Reestablish databases from reinforcements. 
  • Import and fare information. Screen SQL Server. 
  • Follow SQL Server action. 
  • Oversee SQL Server security. 
  • Review information get to and scramble information. 
  • Perform continuous database support. 
  • Mechanize SQL Server support with SQL Server Agent Jobs. 
  • Arrange Database Mail, cautions and notices. 

20462: Administering Microsoft SQL Server 2014 Databases Course Outline 

1 - Introduction to SQL Server 2014 Database Administration 

  • Database Administration Overview 
  • Prologue to the SQL Server Platform 
  • Database Management Tools and Techniques 
  • Lab : Using SQL Server Administrative Tools 
  • Utilizing SQL Server Management Studio 
  • Utilizing the sqlcmd Utility 
  • Utilizing Windows PowerShell with SQL Server 

2 - Installing and Configuring SQL Server 2014 

  • Arranging SQL Server Installation 
  • Introducing SQL Server 2014 
  • Post-Installation Configuration 
  • Lab : Installing SQL Server 2014 
  • Planning to Install SQL Server 
  • Introducing SQL Server 
  • Performing Post-Installation Configuration 

3 - Working with Databases and Storage 

  • Prologue to Data Storage with SQL Server 
  • Overseeing Storage for System Databases 
  • Overseeing Storage for User Databases 
  • Moving Database Files 
  • Designing the Buffer Pool Extension 
  • Lab : Managing Database Storage 
  • Designing tempdb Storage 
  • Making Databases 
  • Joining a Database 

4 - Planning and Implementing a Backup Strategy 

  • Understanding SQL Server Recovery Models 
  • Arranging a Backup Strategy 
  • Moving down Databases and Transaction Logs 
  • Utilizing Backup Options 
  • Guaranteeing Backup Reliability 
  • Lab : Backing Up SQL Server Databases 
  • Moving down Database 
  • Performing Database, Differential, and Transaction Log Backups 
  • Playing out a Partial Backup 

5 - Restoring SQL Server 2014 Databases 

  • Understanding the Restore Process 
  • Reestablishing Databases 
  • Progressed Restore Scenarios 
  • Working with Point-in-Time Recovery 
  • Lab : Restoring SQL Server Databases 
  • Reestablishing a Database Backup 
  • Reestablishing Database, Differential, and Transaction Log Backups 
  • Playing out a Piecemeal Restore 

6 - Importing and Exporting Data 

  • Prologue to Transferring Data 
  • Bringing in and Exporting Table Data 
  • Duplicating or Moving a Database 
  • Lab : Importing and Exporting Data 
  • Utilizing the SQL Server Import and Export Wizard 
  • Utilizing the bcp Utility 
  • Utilizing the BULK INSERT Statement 
  • Utilizing the OPENROWSET Function 

7 - Monitoring SQL Server 2014 

  • Prologue to Monitoring SQL Server 
  • Dynamic Management Views and Functions 
  • Execution Monitor 
  • Lab : Monitoring SQL Server 2014 
  • Gathering Baseline Metrics 
  • Checking a Workload 

8 - Tracing SQL Server Activity 

  • Following SQL Server Workload Activity 
  • Utilizing Traces 
  • Lab : Tracing SQL Server Workload Activity 
  • Catching a Trace in SQL Server Profiler 
  • Creating Database Tuning Recommendations 
  • Utilizing SQL Trace 

9 - Managing SQL Server Security 

  • Prologue to SQL Server Security 
  • Overseeing Server-Level Security 
  • Overseeing Database-Level Principals 
  • Overseeing Database Permissions 
  • Lab : Managing SQL Server Security 
  • Overseeing Server-Level Security 
  • Overseeing Database-Level Security 
  • Testing Database Access 

10 - Auditing Data Access and Encrypting Data 

  • Evaluating Data Access in SQL Server 
  • Actualizing SQL Server Audit 
  • Scrambling Databases 
  • Lab : Auditing Data Access and Encrypting Data 
  • Actualizing Auditing 
  • Actualizing Transparent Database Encryption 

11 - Performing Ongoing Database Maintenance 

  • Guaranteeing Database Integrity 
  • Looking after Indexes 
  • Computerizing Routine Database Maintenance 
  • Lab : Performing Ongoing Database Maintenance 
  • Overseeing Database Integrity 
  • Overseeing Index Fragmentation 
  • Actualizing a Maintenance Plan 

12 - Automating SQL Server 2014 Management 

  • Computerizing SQL Server Management 
  • Actualizing SQL Server Agent Jobs 
  • Overseeing SQL Server Agent Jobs 
  • Overseeing Job Step Security Contexts 
  • Overseeing Jobs on Multiple Servers 
  • Lab : Automating SQL Server Management 
  • Making a Job 
  • Planning a Job 
  • Arranging Job Step Security Contexts 

13 - Monitoring SQL Server 2014 by Using Alerts and Notifications 

  • Checking SQL Server Errors 
  • Arranging Database Mail 
  • Arranging Operators, Alerts, and Notifications 
  • Lab : Monitoring SQL Server by Using Alerts and Notifications 
  • Arranging Database Mail 
  • Actualizing Operators and Notifications 
  • Actualizing Alerts

This course requires you meet the accompanying essentials: 

  • Essential learning of the Microsoft Windows working framework and its center usefulness. 
  • Working learning of Transact-SQL. 
  • Working learning of social databases. 
  • Some involvement with database outline.