SQL Server Database Administrator (DBA)

The SQL Server Database Administration training course in Kolkata will lay the foundation to start in your career in this domain. One will learn SQL Server Database Administration concepts and techniques and do hands-on project to understand the concepts and prepare you for a career role in this field. There are multiple courses available to fit the requirement of students and working Professionals.
  1. SQL Server Database Administration On weekends.
  2. SQL Server Database Administration Plan On weekdays
Mode of Training
  • The classes are delivered during Weekday or Weekend in classroom or online modes
Locations:
  • The training is offered in locations like Chennai, Bangalore, Kolkata, Mumbai and NCR.
 
SQL Server Database Administration Course Overview
Getting Started with SQL Server
  • Selecting installation options
  • Installing a named instance
  • SQL Server Management Studio
  • Configuration Manager
  • Transact-SQL
  • sqlcmd
  • PowerShell
Constructing and Managing Databases
  • Relating servers, databases and files
  • Creating databases and transaction logs
  • Maximizing storage utilization
  • Placing tables on file groups
  • Choosing between upgrade and migration
  • Detaching and attaching databases
Controlling database space
  • Permitting automatic database growth
  • Adding database files to expand databases
Handling Server and Database Security
  • Comparing authentication modes
  • Defining logins
  • Creating user-defined server roles
  • Enforcing password policy
  • Contrasting users and logins
  • Adding users
  • Defining new roles
  • Delegating privileges with predefined roles
  • Repairing mis-mapped logins
Granting and Revoking Permissions
  • Permitting object creation
  • Giving blanket permissions
  • Limiting object access
  • Meeting complex permission requirements with roles
Backup and Recovery
  • Selecting a recovery model
  • Investigating the transaction log
  • Running full, log and differential backups
  • Performing a post-crash log backup
  • Rebuilding the master database
  • Recovering user and system databases
Streamlining Tasks with Jobs, Alerts and Database Mail
  • Setting agent properties
  • Implementing database mail
  • Creating alerts and operators
  • Initiating multi-step jobs
  • Associating alerts with jobs
Database Maintenance and Monitoring
  • Identifying and curing fragmentation
  • Repairing database corruption
  • Scheduling plan execution
  • Notifying operators of success or failure
  • Identifying blocked processes
  • Killing blockers
Course NameDelivery ModeFeeSpecial Offer
SQL Server Database Administration Live Online/Offline Rs. 16,000+ 18% GST Discount for 3+ enrollments

Basic sql programing knowledge will be helpful.

Delegate pack consisting of study material and exercises Live Instructor training with a proficient, industrially-rich and seasoned expert

This is a complete hands-on training where the trainer will demonstrate each feature and participants will follow and do the same on the system.

After you enroll, you will be guided on how to access the system.

No. You will need to arrange software for your use.

You can gather your doubts and come by prior appointment to get your doubts cleared.

Yes, participants receive a certificate after completing the course provided they have attended 90% of the class.

Related Courses

Course Categories

A Few Things You’ll Love!

  • Experienced Training Partner
  • Certified & Industry Expert Trainers
  • Multiple Training Delivery Models
  • Customized
    Course
  • 24/7 e-Learning Access
  • Assessments and Mock Tests
  • Placement Assistance
Training Calendar
Whatsapp Logo