MOC#20764:  Administering a SQL Database Infrastructure

IT spetsialistile

About this course

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.

At course completion

  • 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

See the web portfolio of lecturer here: Amir Zare Pashaei


Investeering: 990,00€ + km
Lektor: Amir Zare Pashaei, MCT
Päevade arv: 4
Tundide arv: 36 akadeemilist tundi

Programm:
  • 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

Learning methods: Practical exercise, independent work.

Assesment methods: Execution of independent work.

Assesment form: Independent practical tasks on relevant topics.

Price includes coffee breaks and lunhces in  restoran "Lusikas".





Registreeri koolitusele Küsi lisa
Sulge