DESIGNING, OPTIMIZING AND MAINTAINING A DATABASE ADMINISTRATIVE SOLUTION WITH SQL SERVER

Content

Getting Started with SQL Server

• Setting up SQL Server
• Leveraging Essential Tools

Constructing and Managing Databases

• Inspecting Storage Structures
• Designing File Groups
• Upgrading and Moving Databases
• Controlling Database Space

Handling Server and Database Security

• Implementing Server Security
• Granting Database Access

Granting and Revoking Permissions

• Managing Database – Scoped Privileges
• Defining Object-Level Permissions

Backup and Recovery

• Backing Up Databases
• Restoring Databases

Streamlining Tasks with Jobs, Alerts and

Database Mail

• Configuring SQL Server Agent
• Defining Jobs to Handle Routine Tasks

Database Maintenance and Monitoring

• Handling Fragmentation and Database
• Corruption
• Building Database Maintenance Plans
• Resolving Contention Problems

FOR WHOM: Chief Information Officers, Database Administrators, Server Managers, IT Professionals, Systems Administrators, IT Managers and others who work in environments where databases play a key role in their primary job responsibilities or develop applications that deliver content from databases.

DATE: 12^th – 14^th April, 2023

4th – 6th October, 2023