Curriculum:
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 (optional lab base for interview preparation)
o Introduction to Cloud Computing
o Product and Services in Cloud
o Account creation and logon
o Databases on AWS & Microsoft Azure
o Introduction and configure/create EC2, RDS, S3 bucket, and purpose
o Create instance and database on-premise
o Create instance and database on the cloud
o Database migration: Homogeneous, Heterogeneous
o Everyday DBA tasks on the cloud platform
o Oracle database installation and creation
o Create and manage account
o Configure AZ and HA
