SQL Server DBA Online Training - PowerPoint PPT Presentation

About This Presentation
Title:

SQL Server DBA Online Training

Description:

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 – PowerPoint PPT presentation

Number of Views:198

less

Transcript and Presenter's Notes

Title: SQL Server DBA Online Training


1
(No Transcript)
2
Introduction
  • Architecture
  • 2005 Installation
  • 2008 Installation
  • 2008 Enhancements
  • Configuration Settings
  • System Data bases
  • db Creation
  • db options

3
Backups
  • Recovery Models
  • Backup types
  • Compressed backups
  • Backup options
  • Backup Destination
  • Backup Permissions
  • Backup History
  • Backup Strategies

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

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

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

7
Migration
  • Launching the DBs into production
  • DB refreshes
  • Consolidation
  • Virtualization
  • Migration b/w servers different locations
  • Moving to new hardware
  • Steps in Migration
  • Migration from other RDBMS

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

9
Performance Tuning
  • Locks, Blocking Deadlocks
  • Isolation Levels
  • Execution plans
  • Performance analysis
  • Hardware counters
  • Performance monitor tools
  • Profiler
  • DBCC commands
  • DMVs
  • Performance dash board 2.0
  • Sql health checks
  • Event viewer
  • Reading error logs

10
Follow Online IT Guru
  • Fb https//www.facebook.com/onlineitguruindia
  • Tw https//twitter.com/onlineitguru
  • G https//plus.google.com/ONLINEITGURUINDIA/abo
    ut
  • YouTube https//www.youtube.com/c/ONLINEITGURUIND
    IA
  • LinkedIn https//in.linkedin.com/in/onlineitgurui
    ndia
Write a Comment
User Comments (0)
About PowerShow.com