CODICE: MOC20462
TITOLO: Administering Microsoft SQL Server Databases
DURATA: 5
PREZZO: 1.600,00 € iva esclusa
LINGUA: Italiano
MODALITA': Classroom
CERTIFICAZIONI ASSOCIATE:
SCHEDULAZIONE:
Luogo Data
Torino 30/11/2015
Milano 18/01/2016
Roma 08/02/2016
Torino 11/04/2016
Milano 13/06/2016
Roma 04/07/2016
Torino 26/09/2016
Roma 17/10/2016
Torino 07/11/2016
Milano 28/11/2016
PREREQUISITI:
Per partecipare con profitto a questo corso è necessario che gli allievi possiedano i seguenti prerequisiti: • Conoscenza di base del sistema operativo Microsoft Windows e la sua funzionalità di base. • Conoscenza operativa di Transact-SQL.
• Conoscenza operativa di database relazionali. • Esperienza con la progettazione di database.
OBIETTIVI:
Al termine del corso gli allievi saranno in grado di: • Pianificare e installare SQL Server.
• Descrivere database di sistema, la struttura fisica del database e le opzioni di configurazione più comuni ad esse correlate.
• Spiegare il concetto di log delle transazioni e dei modelli di recupero di SQL Server e di attuare diverse strategie di backup che sono disponibili con SQL Server.
• Eseguire il backup dei database di SQL Server. • Ripristinare database di SQL Server.
• Importazione ed esportazione di dati utilizzando procedure guidate, l'utilità di copia di massa, e le applicazioni di livello dati.
• Lavorare con i modelli di sicurezza di SQL Server, gli account di accesso, utenti e contenuti database.
• Lavorare con ruoli server e ruoli del database. • Utilizzare le autorizzazioni per proteggere le risorse.
• Audit Server Utilizzare SQL e Transparent Data Encryption.
• Lavorare con SQL Server Agent per configurare ed eseguire i lavori.
• Implementare la sicurezza di SQL Server Agent, account proxy, e le credenziali. • Configurazione elettronica del database, avvisi e notifiche.
• Creazione di piani di manutenzione del database.
• Utilizzare SQL Server Profiler, SQL Trace, e Relay distribuita.
• Utilizzare Distributed Management Vista e configurare la raccolta dei dati.
CONTENUTI:
Questo corso della durata di cinque giorni, fornisce agli studenti le conoscenze e le competenze per mantenere il database Microsoft SQL Server 2014. Il corso si concentra sull'insegnamento su come utilizzare le caratteristiche dei prodotti e degli strumenti per il mantenimento di un database SQL Server 2014.
Module 1: Installing SQL Server 2014
This module introduces the SQL Server 2014 platform. It describes the components, editions, and versions of SQL Server 2014, SQL Server services and configuration options, and service accounts. The module also explains how to assess resource requirements for SQL Server 2014 and how to install SQL Server 2014.
Module 2: Working with Databases
This module describes he preinstalled system databases, the physical structure of databases, and the most common configuration options related to them.
Module 3: SQL Server 2014 Recovery Models
In this module, you will consider how to create a strategy that is aligned with organizational needs and see how the transaction logging capabilities of Microsoft SQL Server can help you to achieve an appropriate outcome.
Module 4: Backup of SQL Server 2014 Databases
In this module, you will explore the key backup types in more depth and learn how to implement the backups. You will also see how to apply options that affect the way that the backups work.
Module 5: Restoring SQL Server 2014 Databases
In this module, you will see how to restore user and system databases and how to implement point-in-time recovery.
This module covers the use of the import/export wizards and explains how they relate to SSIS. It also introduces BCP and BULK INSERT.
Module 7: Authenticating and Authorizing Users
This module covers SQL Server security models, logins, users, and contained databases.
Module 8: Assigning Server and Database Roles
This module covers fixed server roles, user-defined server roles, fixed database roles, and user-defined database roles.
Module 9: Authorizing Users to Access Resources
This module covers permissions and the assignment of permissions.
Module 10: Protecting Data by Using Encryption and Auditing
This module describes the available options for auditing in SQL Server, how to use and manage the SQL Server audit feature, and how to implement encryption.
Module 11: Automating SQL Server 2014 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.
Module 12: Configuring Security for SQL Server Agent
This module describes the considerations for SQL Server Agent security, including proxy accounts and credentials.
Module 13: Monitoring SQL Server 2014 by Using Alerts and Notifications
This module covers the configuration of database mail, alerts, and notifications.
Module 14: Performing Ongoing Database Maintenance
This module covers database maintenance plans.
Module 15: Tracing Access to SQL Server 2014
This module describes how to use SQL Server Profiler and SQL Trace stored procedures to capture information about SQL Server. It also describes how to use Distributed Replay to capture
Module 16: Monitoring SQL Server 2014
This module explains how to use Distributed Management Views to monitor SQL Server. It also describes how to configure data collection and the SQL Server Utility.
CERTIFICAZIONI:
Server certification path
By level of expertise, choose a certification to view its details and required exams. MTA
MTA
Technology Associate
The fundamentals of IT
Start here to validate your knowledge of fundamental technology concepts.NoteMTA exams do not qualify for MCP certification, nor are they a prerequisite for MCSA or MCSE certification.
MTA:
IT Infrastructure
MCSA
MCSA
Solutions Associate
The skills for your professional career
Prove you have the core technical skills required to build a sustainable career in IT.
MCSA:
Windows Server 2012 MCSA:
Windows Server 2008
MCSE
MCSE
Solutions Expert
The globally recognized standard for IT Professionals
Demonstrate your ability to build innovative solutions across multiple technologies, both on-premises and in the cloud.
MCSE:
Server Infrastructure MCSE:
Desktop Infrastructure MCSE:
Private Cloud MCSE: Messaging MCSE:
Communication MCSE:
SharePoint
Microsoft Azure certifications
Learn about certifications for Microsoft Azure.
Desktop certification path
By level of expertise, choose a certification to view its details and required exams. MTA
MTA
Technology Associate
The fundamentals of IT
Start here to validate your knowledge of fundamental technology concepts.NoteMTA exams do not qualify for MCP certification, nor are they a prerequisite for MCSA or MCSE certification.
MTA:
IT Infrastructure
MCSA
MCSA
Solutions Associate
The skills for your professional career
MCSA: Windows 8 MCSA: Windows 7
MCSE
MCSE
Solutions Expert
The globally recognized standard for IT Professionals
Demonstrate your ability to build innovative solutions across multiple technologies, both on-premises and in the cloud.
MCSE:
Enterprise Devices and Apps
Applications certification path
By level of expertise, choose a certification to view its details and required exams. MCSA
MCSA
Solutions Associate
The skills for your professional career MCSA:
Office 365
Microsoft Office Specialist (MOS)
Microsoft Office Specialist (MOS)
Recognition of core skills in Office applications
After you pass your first MOS exam, you become a Microsoft Office Specialist.NoteMOS exams do not qualify you for MCP certification.
MOS
Microsoft Office Specialist (MOS) Expert
Recognition of advanced skills in Word and Excel
After you pass your first MOS exam, you become a Microsoft Office Specialist.
MOS Expert
Microsoft Office Specialist (MOS) Master
Microsoft Office Specialist (MOS) Master
Recognition of mastery across Office applications
After you pass your first MOS exam, you become a Microsoft Office Specialist.
MOS Master
Database certification path
By level of expertise, choose a certification to view its details and required exams. MTA
MTA
Technology Associate
The fundamentals of IT
Start here to validate your knowledge of fundamental technology concepts.NoteMTA exams do not qualify for MCP certification, nor are they a prerequisite for MCSA or MCSE certification.
MTA: Database
MCSA
MCSA
Solutions Associate
The skills for your professional career
MCSA:
SQL Server 2012
MCSE
MCSE
Solutions Expert
The globally recognized standard for IT Professionals
Demonstrate your ability to build innovative solutions across multiple technologies, both on-premises and in the cloud.
MCSE: Data Platform MCSE:
Business Intelligence
Developer certification path
By level of expertise, choose a certification to view its details and required exams. MTA
MTA
Technology Associate
The fundamentals of IT
Start here to validate your knowledge of fundamental technology concepts.NoteMTA exams do not qualify for MCP certification, nor are they a prerequisite for MCSD certification.
MTA: Developer
MCSD
MCSD
Solutions Developer
The globally recognized standard for developer excellence
MCSD:
Windows Store Apps MCSD:
Web Applications MCSD:
SharePoint Applications MCSD:
Application Lifecycle Management
