Kõik koolitused ühest kohast!

tk
Tagasi

Administering a SQL Database Infrastructure – MOC#20764

This instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

Program:

  • Module 1: SQL Server Security
  • Module 2: Assigning Server and Database Roles
  • Module 3: Authorizing Users to Access Resources
  • Module 4: Protecting Data with Encryption and Auditing
  • Module 5: Recovery Models and Backup Strategies
  • Module 6: Backing Up SQL Server Databases
  • Module 7: Restoring SQL Server 2016 Databases
  • Module 8: Automating SQL Server Management
  • Module 9: Configuring Security for SQL Server Agent
  • Module 10: Monitoring SQL Server with Alerts and Notifications
  • Module 11: Introduction to Managing SQL Server by using PowerShell
  • Module 12: Tracing Access to SQL Server with Extended events
  • Module 13: Monitoring SQL Server
  • Module 14: Troubleshooting SQL Server
  • Module 15: Importing and Exporting Data

After completing this course, students will be able to:

  • After completing this course, students will be able to:
  • Authenticate and authorize users
  • Assign server and database roles
  • Authorize users to access resources
  • Protect data with encryption and auditing
  • Describe recovery models and backup strategies
  • Backup SQL Server databases
  • Restore SQL Server databases
  • Automate database management
  • Configure security for the SQL Server agent
  • Manage alerts and notifications
  • Managing SQL Server using PowerShell
  • Trace access to SQL Server
  • Monitor a SQL Server infrastructure
  • Troubleshoot a SQL Server infrastructure
  • Import and export data

Learning methods: Practical exercise, independent work.
Assesment methods: Execution of independent work.
Assesment form: Independent practical tasks on relevant topics.

Amir_1

Koolitaja:
Amir Zare Pashaei, lektor/konsultant/MCT. Valdkond: Veebi- ja tarkvaraarendus (HTML5, CSS3, PHP, Java, Python, JavaScript, Typescript, C#.NET, C++, ASP.NET, Visual Basic, MySQL, SQL Server, NodeJS, Angular 4, Android, iOS, macOS).
See the web portfolio of lecturer here: Amir Zare Pashaei

Price includes

  • Coffee breaks and lunch in restaurant “Lusikas”
  • Free Microsoft certification exam within the period of 6 months after finishing the course

Küsin koolituse kohta lisainfot

Koolitusfirma tutvustus

BCS Koolitus on Eesti juhtiv IKT valdkonna koolitus-, projektijuhtimis- ja konsultatsiooniettevõte. Loen koolitusfirma kohta veel...

Osalen koolitusel

Administering a SQL Database Infrastructure – MOC#20764