Deze normaal 5 daagse trainingen wordt uitgevoerd in 4 verlengde klassikale trainingsdagen verspreid over 2 weken.
Data
· 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.
Module 1: Authenticating and Authorizing Users This module covers SQL Server security models, logins, and users.Lessons
After completing this module, you will be able to:
Module 2: Assigning Server and Database Roles This module covers fixed server roles, user-defined server roles, fixed database roles, and user-defined database roles.Lessons
After completing this module, you will be able to:
Module 3: Authorizing Users to Access Resources This module covers permissions and the assignment of permissions.Lessons
After completing this module, you will be able to:
Module 4: Protecting Data with Encryption and Auditing This module covers SQL Server Audit.Lessons
After completing this module, you will be able to:
Module 5: SQL Server Recovery Models This module describes the concept of the transaction log and SQL Server recovery models. It also introduces the different backup strategies available with SQL Server.Lessons
After completing this module, you will be able to:
Module 6: Backup of SQL Server Databases This module describes SQL Server Backup and the backup types Lessons
After completing this module, you will be able to:
Module 7: Restoring SQL Server Databases This module describes the restoration of databases.Lessons
After completing this module, you will be able to:
Module 8: Automating SQL Server Management This module describes how to use SQL Server Agent for automation. It also explains the benefits of using master and target servers to centralize the administration of automation.Lessons
After completing this module, you will be able to:
Module 9: Configuring Security for SQL Server Agent This module describes the considerations for SQL Server Agent security, including proxy accounts and credentials.Lessons
After completing this module, you will be able to:
Module 10: Monitoring SQL Server with Alerts and Notifications This module covers the configuration of database mail, alerts and notifications.Lessons
After completing this module, you will be able to:
Module 11: Introduction to Managing SQL Server by using PowerShell This module introduces PowerShell for SQL Server.Lessons
After completing this module, you will be able to:
Module 12: Tracing Access to SQL Server This module describes how to use SQL Profiler and SQL Trace stored procedures to capture information about SQL Server. The module also describes how to use Distributed Replay to capture trace information from multiple servers, and how to monitor locking. Lessons
After completing this module, you will be able to:
Module 13: Monitoring SQL Server This module explains how to use Distributed Management Views to monitor SQL Server. It also describes configuration of data collection and the SQL Server Utility.Lessons
After completing this module, you will be able to:
Module 14: Troubleshooting SQL Server This module explains the SQL Server troubleshooting methodology and discusses the most common issues that can arise when working with SQL Server systems.Lessons
After completing this module, you will be able to:
Module 15: Importing and Exporting Data This module covers the use of the import/export wizards and explains how they relate to SSIS. The module also introduces BCP and BULK INSERT.Lessons
After completing this module, you will be able to:
|
Bedrijfsnaam | |
Adres | |
Postcode en plaats | |
Telefoon | |
Contactpersoon | |
Emailadres contactpersoon | |
Factuur adres | |
Contactpersoon facturatie | |
Eventueel inkoopnummer |
Opleidingsprogramma | Prijs | Startdatum |
MTS20764 | € 2.095,00 | __ - ___ - _____ |
Standaard levert @The Academy de cursusboeken digitaal (DMOC).
Voor
aanvang
van de cursus ontvangt u een code waarmee u het digitale
lesboek
kunt activeren. U krijgt de keuze om het boek online te
lezen
of te
downloaden op 3 verschillende devices zodat u altijd
direct de
beschikking heeft over het boek. Neem uw eigen “device” mee om het lesmateriaal te kunnen gebruiken tijdens de klassikale training. | ||
Ik wil deze training graag op afstand virtueel bijwonen | Kruis hier aan |
Naam cursist | |
Email adres cursist |
Naam | Handtekening | Datum |
__ - ___ - _____ |