1 / 10

SQL Server DBA Online Training

SQL Server DBA Online Training at Online IT Guru with 9 years of hands on exp trainer,Job oriented Online SQL Server DBA training wilth placement assistance<br>http://onlineitguru.com/sql-server-dba-online-training-placement.html<br>

GuruIttrainings
Télécharger la présentation

SQL Server DBA Online Training

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. http://onlineitguru.com/

  2. Introduction • Architecture • 2005 Installation • 2008 Installation • 2008 Enhancements • Configuration Settings • System Data bases • db Creation • db options http://onlineitguru.com/

  3. Backup’s • Recovery Model’s • Backup type’s • Compressed backup’s • Backup options • Backup Destination • Backup Permissions • Backup History • Backup Strategies http://onlineitguru.com/

  4. Restorations • Types of restorations • Pre restoration options • Restoration options • Point in time • Point of failure • DR plan • states of restoration • Restore history • Using third party tools- Sql light speed and legato networker http://onlineitguru.com/

  5. Automation • Automating • Automating the regular activities • Creating the jobs • Creating maintenance plans • Changing the schedule • Trouble shooting the jobs • Viewing job history migration of jobs http://onlineitguru.com/

  6. Security • Types of logins, authentication models • Log in creation • Server roles • User Creation • User Mapping • Database roles • Schemas • User defined roles • Principles, Permissions, Securable • Encryption, Authentication, Authorizations • Orphan users • Finding & fixing orphan users http://onlineitguru.com/

  7. Migration • Launching the DB’s into production • DB refreshes • Consolidation • Virtualization • Migration b/w servers different locations • Moving to new hardware • Steps in Migration • Migration from other RDBMS http://onlineitguru.com/

  8. High Availability • Log shipping • Replication • Replication enhancements in 2008 • DB mirroring • Failover the databases • Steps in Failover • Clustering • Types of Clusters • Clustering enhancements in 2008 http://onlineitguru.com/

  9. Performance Tuning • Locks, Blocking & Deadlocks • Isolation Levels • Execution plans • Performance analysis • Hardware counters • Performance monitor tools • Profiler • DBCC commands • DMV’s • Performance dash board 2.0 • Sql health checks • Event viewer • Reading error logs http://onlineitguru.com/

  10. Follow Online IT Guru • Fb: https://www.facebook.com/onlineitguruindia • Tw: https://twitter.com/onlineitguru • G+: https://plus.google.com/+ONLINEITGURUINDIA/about • YouTube: https://www.youtube.com/c/ONLINEITGURUINDIA • LinkedIn: https://in.linkedin.com/in/onlineitguruindia http://onlineitguru.com/

More Related