Suresh V

Years of Experience in MS SQL Administration Training

15

Teaching Experience in detail in MS SQL Administration Training

? DBMS ? RDBMS ? Introduction to SQL SERVER ? Software And Hardware Requirements ? Client-Server Architecture ? SQLSERVER Installation 1. Requirements 2. 2012 Installation Steps ? Services & Checks after installation ? Features of SQLSERVER 2012 ? Server startup process ? Tools in SQL SERVER 2012 1. Management Studio(SSMS) 2. BI Tools(BIDS) 3. Configuration Tools 4. Performance Tools(Profiler) ? ARCHITECTURE 1. SQLSERVER ARCHITECTURE 2. PROTOCOLS 3. STORAGE STRUCTURE 4. DATABASE ARCHITECTURE ? Configuration Settings 1. Memory Settings 2. Processor 3. Connections 4. Database Settings ? Transactions in SQL SERVER 1. Commit 2. Rollback 3. Buffer 4. Checkpoint ? Databases 1. System Databases 2. User Databases 3. Creating Database 4. Altering Database 5. Data Files 6. Log Files 7. File Groups ? Security 1. Windows Authentications 2. SQL Server Authentications 3. Logins and Users 4. Roles 5. Schema 6. Orphaned Users ? Recovery Models 1. Full 2. Bulk Logged 3. Simple 4. Non Logged Operations ? Backups and Planning 1. Full 2. Differential 3. Transaction Log 4. Files and File Groups 5. Compressed backups 6. Mirrored Backups 7. Split Backup 8. Jobs and Schedules 9. Back up Device 10. Append and Over write 11. Permissions and Settings 12. Enhancements ? Restore 1. Complete restoration 2. Point in Time restoration 3. Restore Modes 4. Recover Process ? Migrations 1. Steps in Migration 2. Migrating System databases 3. Migration to other RDBMS 4. SSIS , Package creation & Issues ? Database Upgrade 1. Types 2. Planning for Upgrade 3. Upgrade Advisor ? Replication 1. Publisher 2. Publication 3. Subscriber 4. Subscription 5. Distributor 6. Agents 7. Snap Shot Publication 8. Transactional Publication 9. Merge Publication 10. Replication monitor 11. Jobs 12. Latency Issues ? Log Shipping 1. Configuring Log shipping 2. Monitoring logshipping 3. Failover Process 4. Issues ? Mirroring 1. Principle Server 2. Mirror Server 3. Witness Server 4. Quorum 5. High Availability 6. High Protection 7. High performance 8. Synchronization 9. Disaster Recovery 10. Monitoring & Issues ? CLUSTERING 1. Types 2. Configuring Clustering 3. Monitoring Clustering 4. Issues ? SQL SERVER AGENT 1. Jobs 2. Schedules 3. Alerts 4. Operators 5. Error Logs ? Database Mail Configuration ? Maintenance Plan 1. Through SSMS 2. Through SSIS ? PERFORMANCE TUNING 1. Isolation levels 2. ACID Properties 3. Normalization 4. Blocking 5. Dead Locks 6. Indexes 7. DBCC and DMV 8. Stored procedures 9. Performance Monitor 10. Profiler 11. Counters 12. Tuning Adviser ? TROUBLE SHOOTING 1. Tempdb Full Issues 2. Log file Full Issues 3. Suspect Mode Issues 4. Page Corruption Issues 5. Tail Log Backup 6. Moving system databases 7. Moving User databases 8. Rebuild Matser Database 9. Orphaned Users 10. Connection Issues 11. SQLSERVER Service Issues 12. LONG Running Slow Queries 13. Index Fragmentation Issues 14. SP_RECOMPILE SP’S 15. Tickets, SLA ? SSRS Configuration & Issues ? Sql Browser ? REGULAR, WEEKLY AND MONTHLY ACTIVITIES ? INTERVIEW STUFF