Kurs: 20462 Administering Microsoft SQL Server 2014 Databases


Klasserom5 dagerDeltidKursEngelsk
Start Sted Språk
13.02.17 Sørkedalsveien 8, Oslo Engelsk
03.04.17 Sørkedalsveien 8, Oslo Engelsk



Kursinstruktør

Ernst Rijk

Ernst has been working in IT since 2000 as a database administrator, database developer and trainer, specialized in Microsoft SQL Server. Since 2007 he has been partner in designing, implementing and maintaining SQL Server Infrastructures for mainly mid-size and large companies. Ernst also deliver basic- and advanced training for Microsoft Partners for Learning Solutions throughout the world. He also has been working on SQL Server hands-on labs, as a proctor on Microsoft TechEd’s, as a community member and working on a project-basis for Microsoft.  

 

Kursinnhold

About this Course
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.

Audience Profile
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

At Course Completion
After completing this course, students will be able to:

•Plan and install SQL Server.

•Describe system databases, the physical structure of databases, and the most common configuration options related to them.

•Explain the concept of the transaction log and the SQL Server recovery models and implement different backup strategies that are available with SQL Server.

•Back up SQL Server databases.

•Restore SQL Server databases.

•Import and export data by using wizards, the bulk copy utility, and data-tier applications.

•Work with SQL Server security models, logins, users, and contained databases.

•Work with server roles and database roles.

•Use permissions to secure resources.

•Use SQL Server audit and Transparent Data Encryption.

•Work with SQL Server Agent to configure and execute jobs.

•Implement SQL Server Agent security, proxy accounts, and credentials.

•Configure database mail, alerts, and notifications.

•Create database maintenance plans.

•Use SQL Server Profiler, SQL Trace, and Distributed Relay.

•Use Distributed Management Views and configure data collection.

Kurset fører til eksamen 70-462



Forkunnskaper


Student Prerequisites

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.
Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills:
  • 20461C: Querying Microsoft SQL Server 2014


 

Påmelding
20462 Administering Microsoft SQL Server 2014 Databases hos Bouvet Norge
Start her
100% sikkert skjema
Tar ett minutt å fullføre
Hurtig respons

KAMPANJE!!!
Felt som er merket med * må fylles ut
Ønsket valuta *
Dato og sted *
Kursdeltakere
Hvor mange? (Gavekort)
Kampanjekoden er korrekt og rabatt er lagt til.
Fant ingen kampanje. Skrev du kampanjekoden riktig?
Kampanjekode er korrekt, men kampanjen gir ikke bedre pris enn nåværende kampanje.
Deltaker {{$index+1}}
Filen ble lastet opp
Filen ble fjernet
Laster opp... {{item.upload_progress}}%
{{ file.file.name }} Fjern
{{total_price | fprice}} kr {{currency}}
{{total_price-total_with_discount | fprice}} kr {{currency}}
{{total_with_discount | fprice}} kr {{currency}}
{{total_vat | fprice}} kr {{currency}}
X

MVA per produkt:

{{arr[1]}}
Betalingsmåte *
Number: 1+2 *
Vennligst rett opp følgende og forsøk igjen
{{errors_msg}}
Sender...
Vent til opplasting av fil er ferdig

Dette skjemaet er 100% sikkert.
Bouvet Norge AS vil snart kontakte deg og bekrefte!



 

Åpen deltakerdiskusjon om kurset eller emnet

Del gjerne din erfaring eller tanker om dette kurset eller temaet med andre!



Anbefalinger fra andre brukere