20764 ADMINISTERING A SQL DATABASE INFRASTRUCTURE

KENELLE

Kurssi on tarkoitettu tietokantapalvelinta ylläpitäville henkilöille, tietokantaa hyödyntävien sovelluksien pääkäyttäjille, IT-infrasta vastaaville asiantuntijoille sekä yleisesti tietokannoista kiinnostuneille henkilöille. 

ESITIETOVAATIMUKSET

Kurssille osallistuvalla tulisi olla perusteet Windows-käyttöjärjestelmästä sekä työskentelykokemusta Transact-SQL:n ja relaatiotietokantojen parissa. 

KURSSIN SISÄLTÖ

MODULE 1: AUTHENTICATING AND AUTHORIZING USERS

• Authenticating connections to SQL Server
• Authorizing logins to access databases
• Authorization across servers
• Partially contained databases

MODULE 2: ASSIGNING SERVER AND DATABASE ROLES

• Working with server roles
• Working with Fixed database roles
• Creating user-defined database roles

MODULE 3: AUTHORIZING USERS TO ACCESS RESOURCES

• Authorizing user access to objects
• Authorizing users to execute code
• Configuring permissions at the schema level

MODULE 4: PROTECTING DATA WITH ENCRYPTION AND AUDITING

• Options for auditing data access in SQL Server
• Implementing SQL Server audit
• Managing SQL Server audit
• Protecting data with encryption

MODULE 5: SQL SERVER RECOVERY MODELS

• Backup strategies
• Understanding SQL Server transaction login
• Planning a SQL Server backup strategy

MODULE 6: BACKUP OF SQL SERVER DATABASES

• Backing up databases and transaction logs
• Managing database backups
• Working with backup options

MODULE 7: RESTORING SQL SERVER DATABASES

• Understanding the restore process
• Restoring databases
• Working with point-in-time recovery
• Restoring system databases and individual files

MODULE 8: AUTOMATING SQL SERVER MANAGEMENT

• Automating SQL Server management
• Working with SQL Server agent
• Managing SQL Server agent jobs
• Multi-server management

MODULE 9: CONFIGURING SECURITY FOR SQL SERVER AGENT

• Understanding SQL Server Agent Security
• Configuring credentials
• Configuring proxy accounts

MODULE 10: MONITORING SQL SERVER WITH ALERTS AND NOTIFICATIONS

• Configuration of database mail
• Monitoring SQL Server errors
• Configuring operators, alerts, and notifications
• Alerts in Azure SQL database

MODULE 11: INTRODUCTION TO MANAGING SQL SERVER BY USING POWERSHELL

• Configure SQL Server using PowerShell
• Administer SQL Server using PowerShell
• Maintain the SQL Server environment using PowerShell
• Managing Azure SQL Server databases using PowerShell

MODULE 12: TRACING ACCESS TO SQL SERVER

• Capturing activity using SQL Server profiler
• Improving performance with the database engine tuning advisor
• Working with tracing options
• Distributed replay
• Monitoring locks

MODULE 13: MONITORING SQL SERVER

• Monitoring activity
• Capturing and managing performance data
• Analyzing collected performance data
• SQL Server utility

MODULE 14: TROUBLESHOOTING SQL SERVER

• SQL Server troubleshooting methodology
• Resolving service related issues
• Resolving login and connectivity issues
• Troubleshooting common issues

MODULE 15: IMPORTING AND EXPORTING DATA

• Transferring data to/from SQL Server
• Importing and exporting table data
• Using BCP and BULK INSERT to import data
• Deploying and upgrading data-tier applications