Implementing SQL Database Administration (sf)

• A1 "“ Conduct basic installation, configuration and upgrade of databases and servers according to standard guidelines and methodologies
• A2 "“ Perform simple maintenance as well as data storage, updates and extraction, using appropriate database management system software and tools
• A3 "“ Grant user access to database based on the appropriate levels of access given to users
• A4 "“ Utilise basic system software and tools to track and consolidate performance statistics of databases
• A5 "“ Perform routine data backup and recovery activities
• A6 "“ Document upcoming and completed data backups and archiving activities
• K1 "“ Understand basic steps in installation, configuration and upgrading of databases and servers
• K2 "“ Understand usage of basic database management system software and tools
• K3 "“ Understand performance indicators of databases
• K4 "“ Understand basic processes in data backup, recovery and reporting

What You'll Learn

• Installation and Configuration of SQL Server
• SQL Server Security
• Assigning Server and Database Roles
• Authorizing Users to Access Resources
• Protecting Data with Encryption and Auditing
• Recovery Models and Backup Strategies
• Backup of SQL Server Databases
• Recovering SQL Server Databases
• Automating SQL Server Management
• Configuring Security for SQL Server Agent
• Monitoring SQL Server with Alerts and Notifications
• Introduction to Managing SQL Server by using PowerShell
• Tracing Access to SQL Server with Extended Events
• Monitoring SQL Server
• Troubleshooting SQL Server
• Importing and Exporting Data

Minimum Entry Requirement

Education:

• Minimum GCE O Levels.
• English Speaking at ESS level 5.

Technical Skills and Knowledge

• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Working knowledge of Transact-SQL.
• Working knowledge of relational databases.
• Some experience with database design.

Working Experience

• Recommended to have at least 1-year working experience in Microsoft SQL environment.