Visa utbildning.se som: Mobil

Administering Microsoft SQL Server 2014 Databases (20462)

Learning Tree International AB
Kort om utbildningen
5 dagar
30 950 SEK exkl. moms
Nästa tillfälle: 2019-06-10 09:00 - Distans
Alexandria, Distans / Online, London, New York, Ottawa, Stockholm - Visa alla  
Engelska
Onlineutbildning
Kommande starter
New York
2019-06-10 09:00  
30 950 SEK
2019-12-09 09:00  
30 950 SEK
Distans
2019-06-10 09:00  
30 950 SEK
2019-06-24 09:00  
30 950 SEK
London
2019-06-24 09:00  
30 950 SEK
2019-09-16 09:00  
30 950 SEK

Beskrivning av: Administering Microsoft SQL Server 2014 Databases (20462)

PowerShell utbildning

 

Maintain and Administer Microsoft SQL Server 2014 Databases

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.

Note:This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

This is a Microsoft Official Course (MOC) delivered by a Learning Tree expert instructor.

 

You Will Learn How To

  • Describe 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.

Målgrupp

Requirements:

  • This course requires that you meet the following prerequisites:
    • 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.

Exam Information:

  • This course helps you prepare for theMicrosoft 70-462 certification exam,Administering Microsoft SQL Server 2012/2014 Databases.

Kursinnehåll

Module 1: Introduction to SQL Server 2014 Database Administration

This module introduces the Microsoft SQL Server 2014 platform. It describes the components, editions, and versions of SQL Server 2014, and the tasks that a database administrator commonly performs for a SQL Server instance.

Module 2: Installing and Configuring SQL Server 2014

This module explains how to assess resource requirements for SQL Server 2014 and how to install it..

Module 3: Working with Databases and Storage

This module describes how data is stored in databases, how to create databases, how to manage database files, and how to move them. Other tasks related to storage, include managing the tempdb database and using fast storage devices to extend the SQL Server buffer pool cache, are also discussed.

Module 4: Planning and Implementing a Backup Strategy

In this module, you will consider how to create a backup strategy that is aligned with organizational needs, and learn how to perform the backup operations required by that strategy.

Module 5: Restoring SQL Server 2014 Databases

In this module, you will see how to restore user and system databases and how to implement point-in-time recovery.

Module 6: Importing and Exporting Data

In this module, you will briefly explore tools and techniques so that you can import and export data to and from SQL Server.

Module 7: Monitoring SQL Server 2014

This module explains how to use three of the most commonly used tools: Activity Monitor, dynamic management views and functions (DMVs and DMFs), and Performance Monitor.

Module 8: Tracing SQL Server Activity

This module describes how to use SQL Server Profiler and SQL Trace stored procedures to capture information about SQL Server, and how to use that information to troubleshoot and optimize SQL Server workloads.

Module 9: Managing SQL Server Security

In this module, you will be learn about the core concepts on which the SQL Server security architecture is based, and how to manage security at the server and database levels.

Module 10: Auditing Data Access and Encrypting Data

This module describes the available options for auditing in SQL Server, how to use and manage the SQL Server audit feature, and how to implement encryption.

Module 11: Performing Ongoing Database Maintenance

This module describes common database maintenance tasks that a DBA must perform, and demonstrates how to automate these tasks using maintenance plans.

Module 12: Automating SQL Server 2014 Management

This module describes how to use SQL Server Agent to automate jobs, how to configure security contexts for jobs, and how to implement multi-server jobs.

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

This module covers the configuration of database mail, alerts, and notifications.

Investering

I kurspriset inkluderas:

Coaching av läraren efter kursen

När du kommer tillbaka till jobbet kan du boka tid för kostnadsfri coachning för att få vägledning i hur du använder dina nya kunskaper i ditt dagliga arbete.

Computing Sandbox efter kursen

Efter kursen får du access till en virtuell dator som innehåller den programvaran som används under utbildningen. Här kan du göra om övningsuppgifter, skriva/testa kod och labba i en felsäker miljö.

Learning Trees kunskapstest

Learning Trees kunskapstest som erbjuds i slutet av kurserna ingår i kurspriset. För certifieringstest från tredje part (ex. ITIL) tillkommer en avgift.

Intresseanmälan

Fyll i formuläret för att få mer information om Administering Microsoft SQL Server 2014 Databases (20462), direkt från arrangören. Det är gratis och inte bindande!

Learning Tree International AB

Learning Tree International AB

Learning Tree International

Learning Tree är ett internationellt utbildningsföretag med över 40 års erfarenhet av att leverera utbildning till yrkesverksamma IT-proffs, projektledare, verksamhetsutvecklare och chefer. Vi erbjuder allt från enstaka kurser till globala utbildningsprogram, och vi hjälper våra kunder att införa hållbara processer som fungerar idag och förbereder...


Läs mer om Learning Tree International AB och visa alla utbildningar.

Kontaktuppgifter till Learning Tree International AB

Learning Tree International AB

Lindhagensgatan 126
112 51 Stockholm

 Visa telefonnummer

Recensioner
Kursrecensioner
Bli den första att recensera Administering Microsoft SQL Server 2014 Databases (20462)!

Arrangörsrecensioner
(4,5)
Baseras på 1063 recensioner
Alla recensioner för arrangören