sql square

Goals


- Authenticate and authorize users

- Assign server and database roles

- Authorize users to access resources

- Protect data with encryption and auditing

- Describe recovery models and backup strategies

- Back up data SQL Server databases

- Restore SQL Server databases

- Automate database management

- Configure security for SQL Server agent

- Manage alerts and notifications

- Manage SQL Server via PowerShell

- Trace access to SQL Server

- Monitor SQL Server infrastructure

- Troubleshoot SQL Server infrastructure

- Import and export data

Program

Authenticate connections to SQL Server
Authorize logins to access databases
Inter-server authorization
Databases « Containment partial »

Workshop – Security implementation for a SQL-Server instance

Working with Server Roles
Working with Fixed Database
Roles Creating Database Roles

Workshop – Implementation of database server roles 

Allow users to access objects
Allow users to execute code
Configure schema level permissions

Workshop – Implementation of resource access authorizations

Options for auditing data access in SQL Server
Implement SQL Server
auditing Manage SQL Server auditing
Protect data with encryption

Workshop – Using auditing and encryption

Understand Backup Strategies
SQL Server Transaction Logs
Plan SQL Server Backup Strategies

Workshop – Plan a backup strategy and configure recovery models

Back up databases and transaction logs
Manage database backups
Advanced database option

Workshop – Implementation of different database backups

Understand the
restore process Restore databases
Advanced
restore scenarios Restore a database to a point in time (PITR)

Workshop – Restore a database

Automate SQL Server Management
Work with SQL Server Agent
Manage SQL Server Agent Jobs
Multi- Server Management

Workshop – Planning implementation with SQL Server agent

Understanding SQL Server Agent Security
Configure Credentials
Configure Proxy Accounts

Workshop – Configure SQL Server Agent Security

Monitor SQL Server errors
Configure database messaging
Configure operators, alerts and notifications
Alerts in the SQL Azure database

Workshop – Implementation of alerts and notifications

Get started with Windows PowerShell
Configure SQL Server through PowerShell
Administer and maintain SQL Server through PowerShell
Manage SQL Azure databases through PowerShell

Workshop – Using PowerShell to administer SQl Server

Basic concepts of extended events
Working with extended events

Workshop – Using the System_Health session

Monitor activity
Capture and manage performance
data Analyze collected performance data

Workshop – Monitor SQL Server activity

SQL Server
Troubleshooting Methodology Resolve Service Problems
Resolve Connectivity and Connection Problems

Workshop – Troubleshoot common problems

Transfer data to and from SQL Server
Import and export data from tables
Use BCP and BULK INSERT to import data
Deploy and upgrade third-party data applications

Workshop – Import and export data

Passing of the certification (if foreseen in the financing)

Duration

5 days

Price

£ 2599

Audience

Database administrators

Prerequisites

Knowledge of SQL language and DBMS concepts

Reference

BAS100723-F

Sessions

Contact us for more informations about session date