What is a Database Administrator?

Database Administrator (DBA) is usually described as an IT professional who manages Microsoft SQL Server, Oracle databases, MySQL, IBM DB2 and/or Postgres databases which includes installs relational database software, provisions users’ access to the databases, secures data, tunes database performance, disaster recovery, etc. as a full-time employee.

Depending on the organization where you work, the Database Administrators work as a member of the IT Operations Team, the Application Support Team or part of the Software Development Team working with Programmers \ Developers. Regardless of the team, DBAs usually interact with all other IT teams and often with the business as well.

You can learn about the Database Administrator’s role from job descriptions which will vary from site to site.

The following course will introduce to you the very important Day to day frequently performing activitiesof aSQL Server Administrator. Anyone interested in understanding, configuring, managing or is responsible for SQL Server systems will benefit from this short course. All you need is a desire to learn and fulfill your future goals. These sessionswill guideyou in rightdirection and in easily understandable manner.

This short course below sessions

Backups and Restorations

Backup and Restore Generator

SQLServer Patching on Stand Alone

SQLServer Patching in cluster environment (Active\Passive)

Logins Transfer

DBMaintenance Plans

SQLServer Decommission

Detach and Attach Method

SQLServer Alwayson Job Logic

Script out jobs

Moving Data Files from one drive to another

Moving tempdb from one drive to another

SQLServer Collation Change

Extracting Data BasePermissions

Note:All above mentioned sessions are simulated on VMWare workstation with 100 practically.

Note:Please install VMWare workstation, Windows Server 2012, SQLServer 2014 for practice in your local machine.