Tuesday, 30 July 2013

| SQL DBA Online Training | Call us +917386622889

SQL DBA Online Training

Introduction to DBA 
  • Database Environment
  • DBA Types
  • DBA Responsibilities
  • Versions and features of SQL Server 
Creating Database System
  • Installation Strategy
  • Type of Installation
  • Editions of SQL Server
  • O/S Compatibility and Hardware requirements
  • Pre-requisite Software
  • Default and Named Instances Installation
  • Troubleshooting Installation
  • Configuration
  • Troubleshooting Connectivity
  • CDC (Change Data Capture) 
SQL Server Environment 
  • System Databases
  • User Databases
  • Database Setup
  • Database Architecture
  • Database Configuration
  • SQL Server Architecture
  • SQL Server optimized Configuration
  • SQL Power Shell Scripts 
Protecting Database System 
  • Authentication and Authorization
  • Windows Authentication
  • SQL Server Authentication
  • Logins
  • Permissions Using Roles and DCL
  • Database User, Schema
  • Encryption and Decryption
  • TDE [Transparent Data Encryption]
  • Policy Based Management
  • Service Accounts Configuration
  • Linked Servers Setup
Maintaining Database System
  • Recovery Models
  • Backup Methods
  • Restoring Methods
  • SQL Server Agent Jobs, Schedules, Operators and Alerts
  • Database Mail Configuration
  • Database Maintenance Plan Preparation
  • DBCC Commands
  • Database Snapshots
  • Data Compression 
Creating Standby Servers for High Availability [HA] 
  • Database Monitoring
  • Log Shipping
  • Replication
  • Clustering [Windows & SQL Server] 
Monitoring the Database System
  • Windows and SQL Server Event Logs
  • User Activity Tracking
  • Performance base Line
  • CPU, RAM and I/O Utilization
  • Performance Monitor
  • SQL Server Profiler
  • Database Level Tuning
  • Query /SP Tuning
  • Resource Governor 
DBA practical Usage Of:
  • DMV and DMF
  • System Stored Procedures
  • System Tables and Catalog Views
Objects Level Maintenance
  •  Data Partitions
  • Indexes fragmentation
  • Statistics updation
  • Consistency & Data integrity Check[DBCC]
  • Copying Objects from One Server to Another Server
  • Script based Backup of Objects
 Upgrading To SQL Server 2005/2008
  • Up gradation Plan
  • Upgrade Advisor Tool
  • In place Up gradation
  • Side by Side Up gradation
  • Post up gradation checks
Core MS-BI Administration
  • Installing and Configuring SSIS, SSRS, SSAS
  • Deployment
  • Security 
  • Managing with SSMS      
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)