Administering Microsoft SQL Server Databases

by Best Practice Training Limited Claim Listing

Administering Microsoft SQL Server 2014 Databases is a five day course which provides essential skills and knowledge to the participants for maintaining Microsoft SQL Server 2014 database. This course mainly focuses on teaching delegates ways to use SQL Server 2014 features

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Best Practice Training Limited Logo

img Duration

Enquire Now

Course Details

Course Introduction

Administering Microsoft SQL Server 2014 Databases is a five day course which provides essential skills and knowledge to the participants for maintaining Microsoft SQL Server 2014 database. This course mainly focuses on teaching delegates ways to use SQL Server 2014 features and tools to maintain a database.

 

Overveiw

This training makes a delegate to learn the skills required to maintain a Microsoft SQL Server 2012 or 2014 database by concentrating on data storage, backup and restoration, importing and exporting data, security, database maintenance and the SQL Server Agent. Enhance your Microsoft SQL Skills today with Best Practice Training

 

Course Content

SQL Server 2014 Database Administration introduction

  •  Introduction of Database Administration

  •  Overview to SQL Server platform

  •  Tools and techniques for database management

  •  Use SQL Server Management studio

  •  Use Sqlcmd Utility

  •  Use Windows PowerShell with SQL Server

Install and Configure SQL Server 2014

  •  Prepare to Install SQL Server

  •  Install SQL Server

  •  Perform Post-Installation Configuration

Working with Databases and Storage

  •  Introduction to Data storage with the help of SQL Server

  •  Managing system databases storage

  •  Manage user databases storage

  •  Moving database files

  •  Configure buffer proof extension

  •  Configure Tempdb storage

  •  Create and attach a database

Planning and Implementing a Backup Strategy

  •  Understand SQL Server recovery Models

  •  Back up strategy planning

  •  Backing up databases and Transaction logs

  •  Use Backup options

  •  Ensure backup reliability

  •  Perform a Partial Backup

Restore SQL Server 2014 Databases

  •  Understand restore process

  •  Restore databases

  •  Advanced restore scenarios

  •  Work with Point in time recovery

  •  Restore database backup

  •  Restore database, differential and Transaction Log Backups

  •  Perform piecemeal restore

Importing and Exporting Data

  •  Introduction to Transferring Data

  •  Import and Export Table Data

  •  Copy or move a database

  •  Learn to use SQL Server Import and Export Wizard

  •  Use the BCP Utility

  •  Use BULK INSERT Statement and OPENROWSET Function

Monitoring SQL Server 2014

  •  Monitoring SQL Server introduction

  •  Dynamic Management Functions and Views

  •  Monitor performance

  •  Collect Baseline Metrics

  •  Monitor workload

Tracing SQL Server Activity

  •  Learn to use traces

  •  Trace SQL Server Workload Activity

  •  Using SQL trace

  •  Capture trace in SQL Server profiler

  •  Generate database tuning

Managing SQL Server Security

  •  SQL Server Security introduction

  •  Manage Server-Level Security

  •  Manage principles at Database level

  •  Manage Database Permissions

  •  Manage Database Level security

  •  Testing Database Access

Auditing Data Access and Encrypting Data

  •  Audit Data Access in SQL Server

  •  Implement SQL Server Audit

  •  Encrypt databases

Performing On-going Database Maintenance

  •  Ensure Database Integrity

  •  Indexes maintenance

  •  Automatic Routine Database Maintenance

  •  Manage Database Integrity and Index Fragmentation

  •  Implement a Maintenance Plan

Automating SQL Server 2014 Management

  •  SQL Server Management automation

  •  SQL Server Agent jobs implementation

  •  Manage SQL Server Agent jobs

  •  Manage job step security contexts

  •  Manage jobs on Multiple Servers

  •  Create and schedule a Job

  •  Job step security contexts configuring

Monitoring SQL Server 2014 by Using Alerts and Notifications

  •  Monitor SQL Server Errors

  •  Database mail configuring

  •  Configure operators, Alerts and Notifications

  •  Configure Database Mail

  •  Operators and Notifications implementation

  •  Implement alerts

 

Prerequisites

  • Delegate must possess basic knowledge of Microsoft windows Operating system and its core functions.

  • Operational knowledge of Transact SQL and Relational databases.

  • Basic experience of database design.

 

Target Audience

Intended audience for this course is professionals who are into administering and maintaining SQL Server databases. In this delegates perform database administration along with maintenance as their responsibility in a working environment where databases play a major role in their core job.

 

Delegates Will Learn How To

  • Participants will learn Planning and Installing SQL Server.

  • Easily defining system databases, physical structure of databases and most common configuration options associated to them.

  • Explaining transaction log concepts and SQL Server Recovery models.

  • Implementing different backup strategies which are available with SQL server.

  • Backup and Restoring SQL server databases.

  • Importing as well as Exporting data using Wizards, Bulk Copy Utility and Data Tier Applications.

  • Ability to work with SQL Server Security models, Users, Logins and contained databases.

  • Working with various server roles and database roles.

  • Permissions to secure resources.

  • Using SQL Server agent for configuration and executing jobs.

  • Implementing SQL Server agent security, proxy accounts and credentials.

  • Configuring database mail, alerts and notifications easily.

  • Creating database maintenance plans.

  • Using SQL Server profiler, SQL trace and Distributed relay.

  • Using Distributed management views and data collection configuration.

  • Southampton Branch

    Wessex House, Upper Market Street, Southampton

Check out more SQL Server courses in UK

Firebrand Logo

Oracle OCA Java SE 8 Programmer

On this accelerated 3-day OCA Java SE 8 programming course, you'll be introduced to object orientated programming using the Java language.

by Firebrand [Claim Listing ]
London IT Training (LIT) Logo

Oracle Certified Professional (Mysql 8. 0 Database Administrator Training)

Oracle offered another course named ‘Oracle Certified Professional, MySQL 8.0 Database Administrator’ that enables Database Administrators, including other Database Professionals, to enhance and optimize their organization’s investment in MySQL.

by London IT Training (LIT)
London IT Training (LIT) Logo

HBASE Training

HBase is a non-relational database that allows you to read and write massive datasets in real-time. It lets you store a large amount of data in a table format.

by London IT Training (LIT)
Global Business Advisors (Corporate Training Providers) Logo

Advance EDRMS

Electronic Data and Record Management System.

by Global Business Advisors (Corporate Training Providers)
  • Price
  • Start Date
  • Duration
City Lit Logo

Introduction To SQL And Microsoft SQL Server

Using the free version of Microsoft SQL Server, one of the top 3 Relational Database Management Systems used by 98 of the Fortune 100 companies we will cover all the necessary skills to build, maintain and interrogate a relational database system.

by City Lit [Claim Listing ]
  • Price
  • Start Date
  • Duration

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy