Solvex Dominicana Leaders in Cloud Services and Software Development

Administering Microsoft® SQL Server® 2014 Databases

The course focuses on teaching them how to use the SQL Server 2014 product features and the tools related to maintaining a database.

Description

Provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching how to use the features and tools of the SQL Server 2014 product related to maintaining a database.

Minimum 3 participants to enable the course.

Content

Database Administration Overview
Introduction to the SQL Server Platform
Database Management Tools and Techniques

Lab : Using SQL Server Administrative Tools

Planning SQL Server Installation
Installing SQL Server 2014
Post-Installation Configuration

Lab : Installing SQL Server 2014

Introduction to Data Storage with SQL Server
Managing Storage for System Databases
Managing Storage for User Databases
Moving Database Files
Configuring the Buffer Pool Extension

Lab : Managing Database Storage

Understanding SQL Server Recovery Models
Planning a Backup Strategy
Backing up Databases and Transaction Logs
Using Backup Options
Ensuring Backup Reliability

Lab : Backing Up SQL Server Databases

Understanding the Restore Process
Restoring Databases
Advanced Restore Scenarios
Working with Point-in-Time Recovery

Lab : Restoring SQL Server Databases

Introduction to Transferring Data
Importing and Exporting Table Data
Copying or Moving a Database

Lab : Importing and Exporting Data

Introduction to Monitoring SQL Server
Dynamic Management Views and Functions
Performance Monitor

Lab : Monitoring SQL Server 2014

Tracing SQL Server Workload Activity
Using Traces

Lab : Tracing SQL Server Workload Activity

Introduction to SQL Server Security
Managing Server-Level Security
Managing Database-Level Principals
Managing Database Permissions

Lab : Managing SQL Server Security

Auditing Data Access in SQL Server
Implementing SQL Server Audit
Implementing SQL Server Audit

Lab : Auditing Data Access and Encrypting Data

Ensuring Database Integrity
Maintaining Indexes
Automating Routine Database Maintenance

Lab : Performing Ongoing Database Maintenance

Automating SQL Server Management
Implementing SQL Server Agent Jobs
Managing SQL Server Agent Jobs
Managing Job Step Security Contexts
Managing Jobs on Multiple Servers

Lab : Automating SQL Server Management

Monitoring SQL Server Errors
Configuring Database Mail
Configuring Operators, Alerts, and Notifications

Lab : Monitoring SQL Server by Using Alerts and Notifications

done Requirements

Basic knowledge of the Microsoft Windows operating system and its core functionality.
Working knowledge of Transact-SQL.
Working knowledge of relational databases.
Some experience with database design.

supervisor_account Capacity

10 Students

access_time Length

36 Hours

verified_user Achievements

Participation certificate

Administering Microsoft® SQL Server® 2014 Databases

Description

Content

done Requirements

supervisor_account Capacity

access_time Length

verified_user Achievements

Book this course

About Us

Software Factory

Cloud & IT Services

Resources

Data & AI

Courses

Follow Us

Dominican Republic

United States

Guatemala

Administering Microsoft® SQL Server® 2014 Databases

Description

Content

Module 1: Introduction to SQL Server 2014 Database expand_more

Module 2: Installing and Configuring SQL Server expand_more

Module 3: Working with Databases expand_more

Module 4: Planning and Implementing a Backup expand_more

Module 5: Restoring SQL Server 2014 expand_more

Module 6: Importing and Exporting Data expand_more

Module 7: Monitoring SQL Server expand_more

Module 8: Tracing SQL Server Activity expand_more

Module 9: Managing SQL Server Security expand_more

Module 10: Auditing Data Access and Encrypting Data expand_more

Module 11: Performing Ongoing Database Maintenance expand_more

Module 12: Automating SQL Server 2014 Management expand_more

Module 13: Monitoring SQL Server 2014 by Using Alerts and Notifications expand_more

done Requirements

supervisor_account Capacity

access_time Length

verified_user Achievements

timer Book this course

Data & AI

Courses

Book this course