(Click Category to List Courses)
38 - IT-D Information Technology - Databases and Related Technologies
IT-D 221 - Administering a SQL Database Infrastructure
| Code | Start Date | Duration | Venue | |
|---|---|---|---|---|
| IT-D 221 | 06 May 2024 | 5 Days | Istanbul | Registration Form Link |
| IT-D 221 | 10 June 2024 | 5 Days | Istanbul | Registration Form Link |
| IT-D 221 | 15 July 2024 | 5 Days | Istanbul | Registration Form Link |
| IT-D 221 | 19 August 2024 | 5 Days | Istanbul | Registration Form Link |
| IT-D 221 | 23 September 2024 | 5 Days | Istanbul | Registration Form Link |
| IT-D 221 | 28 October 2024 | 5 Days | Istanbul | Registration Form Link |
| IT-D 221 | 02 December 2024 | 5 Days | Istanbul | Registration Form Link |
Please contact us for fees
Course Description
In this course, professionals who administer and maintain SQL Server databases and who develop applications that deliver content from SQL Server databases will gain the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.
Course Objectives
- Authenticate and authorize users
- Assign server and database roles
- Protect data with encryption and auditing
- Describe recovery models and backup strategies
- Backup SQL Server databases
- Configure security for the SQL Server agent
- Managing SQL Server using PowerShell
- Monitor a SQL Server infrastructure
- Troubleshoot a SQL Server infrastructure
Who Should Attend?
- Managers
- IT professionals
- Engineers involved in data storage operations
- Anyone who deals directly or indirectly with data
Course Details/Schedule
Day 1
- SQL Server Components
- Installing SQL Server
- SQL Server Security
- Authenticating connections to SQL Server
- Authorizing logins to connect to databases
- Authorization across servers
- Assigning Server and Database Roles
- Working with server roles and fixed database roles
- Assigning User-Defined Database Roles
- Authorizing Users to Access Resources
- Authorizing user access to objects and to execute code
- Configuring permissions at the schema level
Day 2
- Database Maintenane
- Protecting Data with Encryption and Auditing
- Implementing and managing SQL Server audit
- Protecting data with encryption
- Recovery Models and Backup Strategies
- SQL Server transaction login
- Planning a backup strategy
- Backup of SQL Server Databases
- Managing database backups
- Working with backup options
Day 3
- Restoring SQL Server 2016 Databases
- Point-in-time recovery
- Performing a Piecemeal Restore
- Automating SQL Server Management
- Working with SQL Server agent
- Managing SQL Server agent jobs
- Configuring Security for SQL Server Agent
- Configuring credentials
- Configuring proxy accounts
Day 4
- Monitoring SQL Server with Alerts and Notifications
- Configuring database mail
- Operators, alerts and notifications
- Alerts in Azure SQL database
- Introduction to Managing SQL Server by using PowerShell
- Configure SQL Server using PowerShell
- Administer and Maintain SQL Server using PowerShell
- Managing Azure SQL Server databases using PowerShell
- Tracing Access to SQL Server with Extended events
- Extended Events Core Concepts
Day 5
- Monitoring SQL Server
- Capturing and managing performance data
- Analyzing collected performance data
- SQL Server utility
- Troubleshooting SQL Server
- Cluster (SQL Server AlwaysOn)
- Resolving service related issues, login and connectivity issues
- Importing and Exporting Data
- Transferring data to/from SQL Server
- Using BCP and BULK INSERT to import data
- Deploying and upgrading data-tier applications
