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.
Module 6: Importing and
Exporting Data
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.