 | Feed RSS |  |  Da oggi è possibile seguire il Website tramite il servizio RSS. Clicca sull'immagine per ricevere gli aggiornamenti. E' richiesto Internet Explorer 7 o in alternativa un Feed Reader. |
|  |
ss |  |
|  |
.
> Microsoft Area Sistemi
  MOC 10775: Administering Microsoft SQL Server 2012 Databases | |
Descrizione: Questo corso di cinque giorni con istruttore fornisce agli studenti le conoscenze e le competenze necessarie per mantenere un Microsoft SQL Server 2012 database. Il corso si concentra su come utilizzare le caratteristiche di SQL Server 2012 e gli strumenti relativi al mantenimento di un database. Questo corso è propedeutico alla preparazione dell'esame 70-462.
Sintesi del Contenuto:
Module 1: Introduction to SQL Server 2012 and its Toolset
- Introduction to the SQL Server Platform
- Working with SQL Server Tools
- Configuring SQL Server Services
Module 2: Preparing Systems for SQL Server 2012
- Overview of SQL Server Architecture
- Planning Server Resource Requirements
- Pre-installation Testing for SQL Server
Module 3: Installing and Configuring SQL Server 2012
- Preparing to Install SQL Server
- Installing SQL Server
- Upgrading and Automating Installation
Module 4: Working with Databases
- Overview of SQL Server Databases
- Working with Files and Filegroups
- Moving Database Files
Module 5: Understanding SQL Server 2012 Recovery Models
- Backup Strategies
- Understanding SQL Server Transaction Logging
- Planning a SQL Server Backup Strategy
Module 6: Backup of SQL Server 2012 Databases
- Backing up Databases and Transaction Logs
- Managing Database Backups
- Working with Backup Options
Module 7: Restoring SQL Server 2012 DatabasesThis module describes the restoration of databases.
- Understanding the Restore Process
- Restoring Databases
- Working with Point-in-time recovery
- Restoring System Databases and Individual Files
Module 8: Importing and Exporting Data
- Transferring Data To/From SQL Server
- Importing & Exporting Table Data
- Inserting Data in Bulk
Module 9: Authenticating and Authorizing Users
- Authenticating Connections to SQL Server
- Authorizing Logins to Access Databases
- Authorization Across Servers
Module 10: Assigning Server and Database Roles
- Working with Server Roles
- Working with Fixed Database Roles
- Creating User-defined Database Roles
Module 11: Authorizing Users to Access Resources
- Authorizing User Access to Objects
- Authorizing Users to Execute Code
- Configuring Permissions at the Schema Level
Module 12: Auditing SQL Server EnvironmentsThis module covers SQL Server Audit.Lessons
- Options for Auditing Data Access in SQL
- Implementing SQL Server Audit
- Managing SQL Server Audit
Module 13: Automating SQL Server 2012 Management
- Automating SQL Server Management
- Working with SQL Server Agent
- Managing SQL Server Agent Jobs
Module 14: Configuring Security for SQL Server Agent
- Understanding SQL Server Agent Security
- Configuring Credentials
- Configuring Proxy Accounts
Module 15: Monitoring SQL Server 2012 with Alerts and Notifications
- Configuration of Database Mail
- Monitoring SQL Server Errors
- Configuring Operators, Alerts and Notifications
Module 16: Performing Ongoing Database Maintenance
- Ensuring Database Integrity
- Maintaining Indexes
- Automating Routine Database Maintenance
Module 17: Tracing Access to SQL Server 2012
- Capturing Activity using SQL Server Profiler
- Improving Performance with the Database Engine Tuning Advisor
- Working with Tracing Options
Module 18: Monitoring SQL Server 2012
- Monitoring Activity
- Capturing and Managing Performance Data
- Analyzing Collected Performance Data
Module 19: Managing Multiple Servers
- Working with Multiple Servers
- Virtualizing SQL Server
- Deploying and Upgrading Data-Tier Applications
Module 20: Troubleshooting Common SQL Server 2012 Administrative Issues
- SQL Server Troubleshooting Methodology
- Resolving Service-related Issues
- Resolving Concurrency Issues
- Resolving Login and Connectivity Issues
Durata: 5gg. dalle ore 9:00 alle ore 17:00
Costo: € 1.190 +IVA. Comprensivo Materiale didattico Ufficiale MOC (Microsoft Official Courseware); Attestato Ufficiale MOC (Microsoft Officiale Curriculum); 2 coffee break al giorno.
Prossima edizione: Su richiesta.
|
|