SQL DBA Training (Database Administration)

In this program we cover all the modules required for SQL DBA. We also cover all the aspect of database designing and programming. By joining our DBA training course you will become Professional Database Administrator in SQL Server 2008 R2 and SQL Server 2012 (DENALI). Our DBA and Database programming training courses are designed to give your real time and live project experience. After completion of the SQL DBA course, we will provide 1 week exclusive training on international real time project Absolutely Free.

Duration: 30 Days

Each class session: 1.5 hours

Before joining the Microsoft SQL Server Programming course you can attend a free demo class, for demo class timings please call us on 8008203031

Who Can Join this course?

Engineering graduates, B.E., B.Tech, MCA final year students and anyone who wants to gain database knowledge and wants to become SQL DBA. Join one of the best SQL DBA training institutes in Hyderabad and learn the DBA training course with experienced faculty with tons of real time project experience. We offer both classroom and online dba training.

Topics Covered:

  • Plan and install SQL Server
  • Physical structure of databases and configurations related to them
  • Concept of the transaction log and SQL Server recovery models
  • Study on different backup strategies available with SQL Server
  • Create SQL Server Backup
  • Restore SQL Server databases
  • Use the import/export wizards and explain how they relate to SSIS
  • Controlling Server and Database Security
  • SQL Server security models, logins and users
  • Server roles, user-defined server roles, fixed database roles and user-defined database roles
  • Permissions and the assignment of permissions
  • Managing Databases
  • Disk structures
  • Space management strategies
  • Moving databases
  • Migrating data
  • SQL Server Audit
  • SQL Server Agent, jobs and job history
  • SQL Server agent security, proxy accounts and credentials
  • Configure database mail, alerts and notifications
  • Create database maintenance plans
  • SQL Profiler and SQL Trace stored procedures
  • DMVs and the configuration of data collection
  • Troubleshoot SQL Server databases
  • Building simple packages
  • Data Flow in an SSIS Package
  • Control Flow in an SSIS Package
  • Debug and Troubleshoot SSIS packages
  • Deploy and Configure SSIS packages
  • Planning for and recovering from disasters
  • Implementing database mirroring
  • Deploying Replication
  • Replication concepts
  • Managing transactional replication
  • Automating Tasks with Jobs and Alerts
  • Multistep jobs
  • Monitoring SQL Server