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:                   22nd – 24th May, 2024

                                20th – 22nd November, 2024

 

Category:

Objective

SQL Server offers a sophisticated platform for enterprise data management. Organizations rely on database administrators who know how to manage their mission -critical databases correctly. This workshop targets those who are new and old to database administration and offers the essential skills you need to administer SQL Server.

Reviews

There are no reviews yet.

Be the first to review “DESIGNING, OPTIMIZING AND MAINTAINING A DATABASE ADMINISTRATIVE SOLUTION WITH SQL SERVER”

Your email address will not be published. Required fields are marked *

Shopping Cart