• Course
  • Vendor

In this course, you will learn the skills required to maintain a Microsoft SQL Server 2012 or 2014 database by focusing on data storage, backup and restoration, importing and exporting data, security, database maintenance and the SQL Server Agent.

  • Course Start Date: 2019-07-29
  • Time: 08:30:00 - 16:30:00
  • Duration: 5 days 08:30 AM - 04:30 PM
  • Location: Virtual
  • Delivery Methods(s): Virtual Instructor Led

Course Outline

Pre-Requisites

Basic knowledge of Microsoft Windows operations systems and its core functionality Working knowledge of Transact-SQL and relational databases Experience with database design

Lessons

In this course, you will learn the skills required to maintain a Microsoft SQL Server 2012 or 2014 database by focusing on data storage, backup and restoration, importing and exporting data, security, database maintenance and the SQL Server Agent.

This course incorporates material from the Official Microsoft Learning Product 20462: Administering Microsoft SQL Server. It covers the skills and knowledge measured by Exam 70-462 and along with on-the-job experience, helps you prepare for the exam.

Our Microsoft Training Exclusives*
  • Six months of anytime access to your course labs and lab environment
  • Six months of 24/7 access to mentoring via chat, email, and phone
  • Six months of on-demand access to indexed, searchable recordings of your Virtual Classroom or Virtual Classroom Fit class
  • Six months of unlimited retakes of your class

* Terms and conditions may apply

Did You Know?

This class is available in our Virtual Classroom -- live online training that combines premium skills development technologies and expert instructors, content, and exercises to ensure superior training, regardless of your location.

What You'll Learn
  • Core database administration tasks and tools
  • Install and configure SQL Server 2014
  • Configure SQL Server databases and storage
  • Plan and implement a backup strategy
  • Restore databases from backups
  • Import and export data
  • Monitor SQL Server
  • Trace SQL Server activity
  • Manage SQL Server security
  • Audit data access and encrypt data
  • Perform ongoing database maintenance
  • Automate SQL Server maintenance with SQL Server Agent jobs
  • Configure database mail, alerts, and notifications
Who Needs to Attend
  • Database professionals who administer and maintain SQL Server databases including database maintenance
  • Database professionals who work in environments where databases play a key role in their primary job responsibilities or develop applications that deliver content from SQL Server databases
Follow-On Courses
  • Implementing a Data Warehouse with Microsoft SQL Server (M20463)
  • Implementing Data Models and Reports with Microsoft SQL Server (M20466)
  • Designing a Data Solution with Microsoft SQL Server (M20465)
Certification Programs and Certificate Tracks

This course is part of the following programs or tracks:

  • MCSA: SQL Server 2012
  • MCSA: Windows Server 2012
Course Outline
1. Introduction to SQL Server 2014 Database Administration
  • Database Administration Overview
  • Introduction to the SQL Server Platform
  • Database Management Tools and Techniques
2. Installing and Configuring SQL Server 2014
  • Plan SQL Server Installation
  • Install SQL Server 2014 and Post-Installation Configuration
3. Work with Databases and Storage
  • Introduction to Data Storage with SQL Server
  • Manage Storage for System Databases and User Databases
  • Move Database Files
  • Configure the Buffer Pool Extension
4. Plan and Implement a Backup Strategy
  • SQL Server Recovery Models
  • Plan a Backup Strategy
  • Backup Databases and Transaction Logs
  • Backup Options and Backup Reliability
5. Restore SQL Server 2014 Databases
  • Restore Process and Databases Restoration
  • Advanced Restore Scenarios
  • Point-in-Tim Recovery
6. Import and Export Data
  • Transferring Data
  • Import and Export Table Data
  • Copy or Move a Database
7. Monitor SQL Server 2014
  • Introduction to Monitoring SQL Server
  • Dynamic Management Views and Functions
  • Performance Monitor
8. Tracing SQL Server Activity
  • Trace SQL Server Workload Activity and Use Traces
9. Manage SQL Server Security
  • Introduction to SQL Server Security
  • Manage Server-Level Security and Database-Level Principals
  • Manage Database Permissions
10. Audit Data Access and Encrypt Data
  • Audit Data Access in SQL Server
  • Implement SQL Server Audit
  • Encrypt Databases
11. Perform Ongoing Database Maintenance
  • Ensure Database Integrity
  • Maintain Indexes
  • Automate Routine Database Maintenance
12. Automate SQL Server 2014 Management
  • Implement and Manage SQL Server Agent Jobs
  • Manage Job Step Security Contexts
  • Manage Job on Multiple Servers
13. Monitor SQL Server 2014 Using Alerts and Notifications
  • Monitor SQL Server Errors
  • Configure Database Mail
  • Configure Operators, Alerts, and Notifications
Labs
Lab 1: Use SQL Server Administrative Tools
  • SQL Server Management Studio and sqlcmd Utility
  • Windows PowerShell with SQL Server
Lab 2: Install SQL Server 2014
  • Prepare, Install, and Perform Post-Installation Configuration
Lab 3: Manage Database Storage
  • Configure tempdb Storage
  • Create and Attach a Database
Lab 4: Backup SQL Server Databases
  • Perform Database, Differential, Transaction Log, and Partial Backups
Lab 5: Restore SQL Server Database
  • Restore Database, Differential, and Transaction Log Backups
  • Piecemeal Restorations
Lab 6: Import and Export Data
  • SQL Server Import and Export Wizard
  • bcp Utility
  • BULK INSERT Statement and OPENROWSET Function
Lab 7: Monitor SQL Server 2014
  • Collect Baseline Metrics
  • Monitor a Workload
Lab 8: Trace SQL Server Workload Activity
  • Capture a Trace in SQL Server Profiler
  • Generate Database Tuning Recommendations
  • SQL Trace
Lab 9: Manage SQL Server Security
  • Manage Server-Level and Database-Level Security
  • Test Database Access
Lab 10: Audit Data Access and Encrypting Data
  • Implement and Manage SQL Server Audit
  • Implement Transparent Data Encryption
Lab 11: Perform Ongoing Database Maintenance
  • Manage Database Integrity and Index Fragmentation
  • Implement a Maintenance Plan
Lab 12: Automate SQL Server Management
  • Create and Schedule a Job
  • Configure Job Step Security Contexts
Lab 13: Monitor SQL Server Using Alerts and Notifications
  • Configure Database Mail
  • Implement Operators, Notifications, and Alerts

Cancellation Policy

We require 16 calendar days notice to reschedule or cancel any registration. Failure to provide the required notification will result in 100% charge of the course. If a student does not attend a scheduled course without prior notification it will result in full forfeiture of the funds and no reschedule will be allowed. Within the required notification period, only student substitutions will be permitted. Reschedules are permitted at anytime with 16 or more calendar days notice. Enrollments must be rescheduled within six months of the cancel date or funds on account will be forfeited.

Training Location

Online Classroom
your office

your city, your province
your country   

About Global Knowledge

x

Global Knowledge is the world's leading learning services and professional development solutions provider. We deliver learning solutions to support customers as they adapt to key business transformations and technological advancements that drive the way that organizations around the world differentiate themselves and thrive. Our learning programs, whether designed for a global organization or an individual professional, help businesses close skills gaps and foster an environment of continuous talent development.

Training Provider Rating

This vendor has an overall average rating of 4.39 out of 5 based on 424 reviews.

No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
Wasn’t as advanced as I thought it would be. There was an issue when the day my course was the first time they used a new platfo ... Read more
x

Wasn’t as advanced as I thought it would be. There was an issue when the day my course was the first time they used a new platform.. from adobe to something called zoom; I had to call support line cause it stated our instructor wasn’t present. Thankfully I called cause everyone online was in the adobe virtual classroom waiting for what looked like a teacher who didn’t show up for class (IT didn’t get anything resolved until 10mins after start time). I felt like he was really getting hung up on very basic knowledge for the first half of the course (talking about how to create tabs and drag formulas as an example). I completed files a few times before he was done explaining. There was a scheduled fire drill for them (roughly 30mins)that also cut into our time, which wasn’t deducted from the hour lunch break or the two, fifteen min breaks. I also really wish he touched base more on the automating workbook functions portion which we barely did. I'm happy there were/are those study guides (learning videos) and exams to take on my own time that I hope after I've had the class are still available for me to learn from.

No comment
No comment
No comment
No comment
It was difficult to practice on my PC while trying to watch the presentation online.
No comment
David was excellent!! I am very for having this course!!

Course Reviews

No Reviews Yet