In promozione

Prerequisiti

Per partecipare accedere al corso è necessario che i partecipanti siano in possesso dei seguenti prerequisiti:

  • Conoscenza di base degli ambienti Microsoft Windows e delle loro principali funzionalità;
  • Esperienza di lavoro con il linguaggio Transact-SQL;
  • Esperienza di lavoro con database relazionali;
  • Esperienza, anche minimale, nel disegno di database.

È consigliato aver frequentato il corso “MOC10774 - Querying Microsoft SQL Server 2012”, oppure conoscenze equivalenti

Obiettivi

Al termine del corso i partecipanti saranno in grado di:

  • Installare SQL Server
  • Descrivere il sistema di database, la struttura fisica e le principali opzioni di configurazione
  • Spiegare il concetto di transaction log e di recovery model e implementare diversi tipi di strategia di backup;
  • Creare backup
  • Effettuare il restore di un backup
  • Utilizzare il wizard di import/export e spiegare la connessione con SSIS
  • Lavorare con security model, login e user
  • Lavorare con i diversi tipi di server role
  • Lavorare con le permission
  • Lavorare con SQL Server Audit
  • Configuarare database mail, alert e notification
  • Lavorare con SQL Profiler e SQL Trace
  • Lavorare con Central Management Servers e Multi-Server queries, Virtualization e Data-Tier Applications
  • Effettuare il troubleshooting di database

Contenuto

Introduction to SQL Server 2012 and its Toolset

  • Introduction to the SQL Server Platform
  • Working with SQL Server Tools
  • Configuring SQL Server Services

Preparing Systems for SQL Server 2012

  • Overview of SQL Server Architecture
  • Planning Server Resource Requirements
  • Pre-installation Testing for SQL Server

Installing and Configuring SQL Server 2012

  • Preparing to Install SQL Server
  • Installing SQL Server
  • Upgrading and Automating Installation

Working with Databases

  • Overview of SQL Server Databases
  • Working with Files and Filegroups
  • Moving Database Files

Understanding SQL Server 2012 Recovery Models

  • Backup Strategies
  • Understanding SQL Server Transaction Logging
  • Planning a SQL Server Backup Strategy

Backup of SQL Server 2012 Databases

  • Backing up Databases and Transaction Logs
  • Managing Database Backups
  • Working with Backup Options

Restoring SQL Server 2012 Databases

  • Understanding the Restore Process
  • Restoring Databases
  • Working with Point-in-time recovery
  • Restoring System Databases and Individual Files

Importing and Exporting Data

  • Transferring Data To/From SQL Server
  • Importing & Exporting Table Data
  • Inserting Data in Bulk

Authenticating and Authorizing Users

  • Authenticating Connections to SQL Server
  • Authorizing Logins to Access Databases
  • Authorization Across Servers

Assigning Server and Database Roles

  • Working with Server Roles
  • Working with Fixed Database Roles
  • Creating User-defined Database Roles

Authorizing Users to Access Resources

  • Authorizing User Access to Objects
  • Authorizing Users to Execute Code
  • Configuring Permissions at the Schema Level

Auditing SQL Server Environments

  • Options for Auditing Data Access in SQL
  • Implementing SQL Server Audit
  • Managing SQL Server Audit

Automating SQL Server 2012 Management

  • Automating SQL Server Management
  • Working with SQL Server Agent
  • Managing SQL Server Agent Jobs

Configuring Security for SQL Server Agent

  • Understanding SQL Server Agent Security
  • Configuring Credentials
  • Configuring Proxy Accounts

Monitoring SQL Server 2012 with Alerts and Notifications

  • Configuration of Database Mail
  • Monitoring SQL Server Errors
  • Configuring Operators, Alerts and Notifications

Performing Ongoing Database Maintenance

  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance

Tracing Access to SQL Server 2012

  • Capturing Activity using SQL Server Profiler
  • Improving Performance with the Database Engine Tuning Advisor
  • Working with Tracing Options

Monitoring SQL Server 2012

  • Monitoring Activity
  • Capturing and Managing Performance Data
  • Analyzing Collected Performance Data

Managing Multiple Servers

  • Working with Multiple Servers
  • Virtualizing SQL Server
  • Deploying and Upgrading Data-Tier Applications

Troubleshooting Common SQL Server 2012 Administrative Issues

  • SQL Server Troubleshooting Methodology
  • Resolving Service-related Issues
  • Resolving Concurrency Issues
  • Resolving Login and Connectivity Issues

Partecipanti

IT Professional

Durata
5 giorni
Codice
MOC10775
Prezzo
€ 1.600,00
€ 1.400,00