Corso Maintaining a Microsoft SQL Server 2008 R2 Database 2008 Specialist

Thecla Informatica
Online

Chiedi il prezzo
Vuoi parlare del corso con un consulente?
Confronta questo corso con altri simili
Leggi tutto

Informazione importanti

  • Corso
  • Online
Descrizione

Il centro presenta a continuazione il programma pensato per migliorare le tue competenze e permetterti di realizzare gli obiettivi stabiliti. Nel corso della formazione si alterneranno differenti moduli che ti permetteranno di acquisire le conoscenze sulle differenti tematiche proposte. Inscriviti per poter accedere alle seguenti materie.

Informazione importanti

Cosa impari in questo corso?

SQL
Server
Microsoft SQL Server

Programma

Nessun prerequisito richiesto Module 1: Introduction to SQL Server 2008 R2 and its Toolset This module introduces you to the entire SQL Server platform and its major tools. This module also covers editions, versions, basics of network listeners, and concepts of services and service accounts. Lessons Introduction to SQL Server Platform Working with SQL Server Tools Configuring SQL Server Services Lab : Introduction to SQL Server 2008 R2 and its Toolset Verify SQL Server Component Installation Alter Service Accounts for New Instance Enable Named Pipes Protocol for Both Instances Create Aliases for AdventureWorks and Proseware Ensure SQL Browser is Disabled and Configure a Fixed TCP/IP Port Describe the SQL Server Platform Work with SQL Server Tools Configure SQL Server Services Module 2: Preparing Systems for SQL Server 2008 R2 This module covers planning for an installation related to SQL Server I/O requirements, 32 bit vs 64 bit, memory configuration options and I/O subsystem pre-installation checks using SQLIOSim and SQLIO. Lessons Overview of SQL Server 2008 R2 Architecture Planning Server Resource Requirements Pre-installation Testing for SQL Server 2008 R2 Lab : Preparing Systems for SQL Server 2008 R2 Adjust memory configuration Perform Pre-installation Stress Testing Check Specific I/O Operations Describe the SQL Server architecture Plan for server resource requirements Conduct pre-installation stress testing for SQL Server Module 3: Installing and Configuring SQL Server 2008 R2 This module details installing and configuring SQL Server 2008 R2. Lessons Preparing to Install SQL Server 2008 R2 Installing SQL Server 2008 R2 Upgrading and Automating Installation Lab : Installing and Configuring SQL Server 2008 R2 Review installation requirements Install the SQL Server instance Perform Post-installation Setup and Checks Configure Server Memory Prepare to install SQL Server Install SQL Server Upgrade and automate the installation of SQL Server Module 4: Working with Databases This module describes the system databases, the physical structure of databases and the most common configuration options related to them. Lessons Overview of SQL Server Databases Working with Files and Filegroups Moving Database Files Lab : Working with Databases Adjust tempdb configuration Create the RateTracking database Attach the OldProspects database Add multiple files to tempdb Describe the role and structure of SQL Server databases Work with files and filegroups Move database files within servers and between servers Module 5: Understanding SQL Server 2008 R2 Recovery Models This module describes the concept of the transaction log and SQL Server recovery models. It introduces the different backup strategies available with SQL Server 2008 R2. Lessons Backup Strategies Understanding SQL Server Transaction Logging Planning a SQL Server Backup Strategy Lab : Understanding SQL Server 2008 R2 Recovery Models Plan a backup strategy Configure recovery models Review recovery models and strategy Describe the critical concepts surrounding backup strategies Explain the transaction logging capabilities within the SQL Server database engine Plan a SQL Server backup strategy Module 6: Backup of SQL Server 2008 R2 Databases This module describes SQL Server 2008 R2 Backup and the backup types. Lessons Backing up Databases and Transaction Logs Managing Database Backups Working with Backup Options Lab : Backup of SQL Server 2008 R2 Databases Investigate backup compression Transaction log backup Differential backup Copy only backup Partial backup Back up databases and transaction logs Manage database backups Work with more advanced backup options Module 7: Restoring SQL Server 2008 R2 Databases This module describes the restoration of databases. Lessons Understanding the Restore Process Restoring Databases Working with Point-in-t Corso di gruppo Corso personalizzato (1 o 2 partecipanti) 40 ore 40 ore (consigliate) min. 5 - max. 10 partecipanti 2 persone: sconto del 50% Corso individuale a distanza su VoIP non previsto

Confronta questo corso con altri simili
Leggi tutto