SQL Server database system administration

The general goal of the program:

Developing trainees’ skills to manage the SQL Server 014 database system efficiently and effectively.

Capabilities that the program aims to develop:

Manage the SQL Server database system efficiently and effectively

Objectives:

• SQL Server planning and installation
• Create and manage databases in SQL Server
• Create tables in SQL Server
• Create indexes in SQL Server
• Security management in SQL Server
• Data transfer in SQL Server
• SQL Server  Automation
• Maintenance of the database D

Outputs:

After completing the training in the program, it is expected that the trainee will be able to:

• Plans and installs the Oracle server with precision and perfection.
• Uses Oracle administrative tools efficiently and effectively.
• Creates Oracle databases efficiently and effectively.
• Manages database space accurately and perfectly.
• Manages user accounts and permissions on Oracle Server efficiently and effectively.
• Transmits data accurately and perfectly.
• CDBs and PDBs are created efficiently and effectively.
• Manages CDBs and PDBs efficiently and effectively.