Empregos Online

Introdução:
Este curso de 5 dias fornece aos formandos as competências técnicas necessárias para administrar o Microsoft SQL Server 2012.

Horário:
Laboral e Pós-Laboral

Conteúdos Programáticos:
- Plan and install SQL Server.
- Describes the system databases, the physical structure of databases and the most common configuration options related to them.
- Explain the concept of the transaction log and SQL Server recovery models and implement different backup strategies available with SQL Server.
- Create SQL Server Backups.
- Restore SQL Server databases.
- Use the import/export wizards and explain how they relate to SSIS.
- Work with SQL Server security models, logins and users.
- Work with fixed server roles, user-defined server roles, fixed database roles and user-defined database roles.
- Work with permissions and the assignment of permissions.
- Work with SQL Server Audit.
- Work with SQL Server Agent, jobs and job history.
- Implement SQL Server agent security, proxy accounts and credentials.
- Configure database mail, alerts and notifications.
- Create database maintenance plans.
- Work with SQL Profiler and SQL Trace stored procedures.
- Introduce DMVs and the configuration of data collection.
- Work with Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications.
- Troubleshoot SQL Server databases

Data:
16 a 20 de Julho (L) 02 a 13 de Julho (PL)

Duração total do curso:
30 Horas

Preço:
1.620 Euros + Iva

Oferta:
_ Facilidades de pagamento _25% de Desconto _Exame de Certificação Incluído _Isenção do IVA a particulares

Local:
Lisboa (Distrito de Lisboa)
Porto (Distrito do Porto)