MS SQL SERVER DATABASE ADMINISTRATION

Module 1: Installation & Configuration, Relational Database Management Systems/Platforms

Module 2: Database Designing, Data Modeling, Database Creation & Security

Module 3: Database Backup, Recovery Model, and Maintenance

Module 4: Database Mail & Agent, T-SQL, Join & Encryption(TDE)

Module 5: High Availability, Disaster Recovery, VMware, Cloud Computing

Module 6: Performance Monitoring, Troubleshooting & Performance Tuning

Module 7: SSIS, SSRS, Upgrading, Migration, Installing, Configuring, Developing, Deploying SQL Server Components, and provide Career Services

Module 8: Revision & Assisting

CLOUD COMPUTING

Introduction to Cloud Computing

Product and Services on Cloud

Account creation and logon

Databases on AWS

Introduction and configure/create EC2, RDS, S3 bucket and purpose

Create instance and database on premise

Create instance and database on cloud

Database migration: Homogeneous, Heterogeneous

Common DBA tasks on cloud platform

Oracle database installation and creation

Create and manage account

Configure AZ and HA