Database administrators (DBAs) use specialized software to store and organize data. The role may include capacity planning, installation, configuration, database design, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery. see more about sql dba on wikipedia.

Any one who wants learn database administration.

Basic Knowledge of database queries, theory, design is plus points

As on 24th Sep, 2019, 300+ SQL Server DBA related jobs are available on Naukri.com

SQL Server DBA Training Course Content

  • Basics of Database Administration
  • DBMS
  • RDBMS
  • Data Models
  • Introduction to SQL SERVER
  • History of SQL SERVER
  • Software And Hardware Requirements
  • IP Configuration, Domain Creation
  • Client-Server Architecture
  • Installation Process
  • Services, Checks after installation
  • Architecture of SQL SERVER 2005
  • Server startup process
  •  Management Studio(SSMS)
  • BI Tools(BIDS)
  • Configuration Tools
  • Performance Tools(Profiler)
  • TCP/IP
  • Named Pipes
  • Windows Authentications
  • SQL Server Authentications
  •  Logins
  • Users
  • Roles
  • Password Management
  • Database Assignment
  • Privileges
  • Schema
  • System Databases
  • User Databases
  • Creating Database
  • Altering Database
  • Data Files
  • Log Files
  • Primary File Group
  • Commit
  • Rollback
  • Buffer
  • Checkpoint
  • Full
  • Bulk Logged
  • Simple
  • Non Logged Operations
  • 2005
  • 2000
  • 7.0
  • Full
  • Differential
  • Transaction Log
  • Files and File Groups
  • Temporary
  • Jobs and Schedules
  • Back up Device
    8.    Append and Over write
  • Complete restoration
  • Point in Time restoration
  • Restoration Options
  • Migrations
  • SSIS Vs DTS Packages
  • Transformations
  • Publisher
  • Publication
  • Subscriber
  • Subscription
  • Distributor
  • Agents
  • Snapshot Publication
  • Transactional Publication
  • Merge Publication
  • Replication monitor
  • Primary Servers
  • Secondary Servers
  • Monitoring Servers
  • Jobs and Schedules
  • Blocking of Jobs
  • Principle Server
  • Mirror Server
  • Witness Server
  • Types of Mirroring
  • Mirror_Error
  • Jobs
  • Schedules
  • Alerts
  • Operators
  • Error Logs
  • Through SSMS
  • Through SSIS
sql server dba training in hyderabad madhapur

Best SQL Server DBA Training Institute in Hyderabad Madhapur

Join Now WinPath IT Services is the best SQL Server DBA Training Institute in Hyderabad Madhapur.

Course Offering On:

  • SQL Server DBA Classroom Training.
  • SQL Server DBA Online Training.
Testimonials
Spread the love