Home   Schulung > EDV > Backoffice > SQL Server

The course aims to get delegates quickly on board with SQL Server. It covers all commonly used tasks when dealing with SQL Server in day-to-day operations. High intensity course. Upon successful completion of this course, students will be able to: Describe the architecture and components of SQL Server.

Microsoft SQL Server 2008/R2 Crash Course

Ziel
The course aims to get delegates quickly on board with SQL Server. It covers all commonly used tasks when dealing with SQL Server in day-to-day operations. High intensity course. Upon successful completion of this course, students will be able to: Describe the architecture and components of SQL Server.
Schulungsinhalte


· Introduction to SQL Server
Architecture and components of SQL Server 2008/R2 . Creating databases, tables, views . Optimal database design

· Optimizing Performance
How indexes work in SQL Server . Creating indexes, advanced features of indexes . Optimization of indexes – missing and unused indexes, consolidation of indexes .Atypical usage of indexes to optimize queries . Full-text indexes, introduction to XML and spatial indexes . SQL Profiler – Recording the workload . Database Engine Tuning Advisor . SQL Nexus

· Troubleshooting and Monitoring
Activity Monitor . Dynamic Management Views – diagnostics of SQL Server . Resource Governor . Data Collector

· Automation in SQL Server
Creating automated tasks . SQL Server error messages and automatic notification . Transferring data between servers and files (Import / Export Wizard) . Introduction to ETL tools - SQL Server Integration Services

· Backup and Restore of Databases
Options for database backups .Restoring databases from backups . Recovery to a point in time . Advanced recovery overview

· Security and Encryption
The concept of login, DB user and sysadmin . Server, database and application roles . Introduction to SQL Server encryption and TDE .
Zielgruppe
The course is intended for developers and novice administrators, who need to learn quickly how to work with SQL Server, because its administration is not the primary concern of their work.
Voraussetzungen
Fundamentals of administering Windows Servers, and at least theoretical fundamentals of databases and SQL language.
Ausschließlich als Inhouse-Schulung
Dieses Seminar bieten wir ausschließlich als Inhouse-Seminar in Ihren Räumlichkeiten oder bei uns in Münster an.
Seminardaten
Schulung-Nrsqlcceng
Dauer2 Tage
Inhouse-Schulung
Dieses Seminar bieten wir Ihnen als Inhouse-Seminar oder -coaching vor Ort in Ihren Räumlichkeiten an.

Rufen Sie uns bitte an:

+4925198 110 99 0
QRCode zu dieser Schulung

Aktuelle Termine
Garantierte Durchführung Garantierte Durchführung!