Microsoft SQL Courses | Administering Server Databases

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.

Administering Microsoft SQL Server Databases

Overview
Course Content

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.

Training Solutions at Your Convenience

Our objective has always been to address and resolve the problems of our learners in an efficient manner and improve their learning prospects. We are accustomed in providing training courses as per our learner’s convenience. We love every opportunity to use our experience to resolve difficulties confronted by learners.

Administering Microsoft SQL Server Databases Training Calender

Filters

Explore Now

Choose Mode of Training

Classroom

Online Instructor-led

Online Self-Paced

Onsite

Administering Microsoft SQL Server Databases

---- OR ----

Reach Us at +44 161 884 3134 or info@bestpracticetraining.com for more information.

Administering Microsoft SQL Server Databases

---- OR ----

Reach Us at +44 161 884 3134 or info@bestpracticetraining.com for more information.

Administering Microsoft SQL Server Databases

40 Hours (on average)

90 Days Access

40 Hours (on average)

Course Price

£2745
add-ons Price

£0
Sub-Total

£2745

Upon purchase you will receive a password via the email you used to purchase the course.

You will then be able to login to our online learning platform with your email and password.

You will have access to the platform for 90 days from the date of purchase.

ONSITE ENQUIRY?

Fill up the form below and we will get back to you!

Video Conferencing

We provide the best web conferencing platform(s) to facilitate our learners to enhance their communication with the instructor.

Digital Whiteboards

Our courses include the real-time demonstration of figures, diagrams and other interactive material through digital whiteboards.

Instant Messaging

During the Virtual Classroom session, learners can raise their queries through instant messaging and follow up on their doubts.

Participation Controls

Through participating effectively in training, individuals can easily discuss their views, mute their surroundings and virtually "raise" their hands.

Features of Our Virtual Classroom Courses

How to Choose and Attend Your Ideal Course?

FIND COURSES

We provide 400+ courses covering broader aspects of personal and professional development training needed by any individual. You can choose any course as per your need or requirement. Our courses are designed to fulfil the current organisational and job marketplace requirements.

Select the Course

Choose the course you want to attend to fulfil your desired goals.

Attend the Course

Attend the training with your prefered method at your convenience.

Get Certification

Upon finishing the course, you will get the completion certificate validating your learning.

Administering Microsoft SQL Server Databases

£ 2745 £ 2695

Benefits of Attending Our Online Courses

We provide a variety of certification programmes or courses for individuals to master a skill set and pursue a full-time career in management, IT, or other domains through the online method to provide them with the convenience of learning. Our dedicated staff works tirelessly to assure the availability of courses with eminence quality that's not found anywhere with benefits like:

Learn a New Skill From Onsite Training

Adaptable Courses

We provide onsite courses modified according to our client's organisational needs.

Cost-Effective Learning

Onsite training helps you to reduce travelling and venue expenses.

Learn in Familiar Surroundings

Training at your convenient place can be ideal for learning new skills.

Team Building Opportunity

Attending onsite training with your team can help to improve your team dynamics tremendously.

Best Practice Training provides specially designed training courses in 410+ locations spanning over 30+ countries globally. All our locations have state of the art facilities for the learners. Some of the Popular Locations are: