Batch Date: Sep 30th @ 9:30AM Faculty: Mr. Ramesh (10 yrs of EXP) Duration: 45 Days Fee: 2000/- INR + Reg fee 100/- INR Location : Maitrivanam, Hyderabad. Venue : DURGA SOFTWARE SOLUTIONS at Maitrivanam Plot No : 202, IInd Floor , HUDA Maitrivanam, Ameerpet, Hyderabad-500038. Ph.No : 09246212143 Syllabus: DBMS RDBMS Introduction to SQL SERVER Software And Hardware Requirements Client-Server Architecture SQLSERVER Installation Requirements 2008 Installation Steps Services & Checks after installation Features of SQLSERVER 2008 & 2012 Server startup process Tools in SQL SERVER 2008 Management Studio(SSMS) BI Tools(BIDS) Configuration Tools Performance Tools(Profiler) ARCHITECTURE SQLSERVER ARCHITECTURE PROTOCOLS STORAGE STRUCTURE DATABASE ARCHITECTURE Configuration Settings Memory Settings Processor Connections Database Settings Transactions in SQL SERVER Commit Rollback Buffer Checkpoint Databases System Databases User Databases Creating Database Altering Database Data Files Log Files File Groups Security Windows Authentications SQL Server Authentications Logins and Users Roles Schema Orphaned Users Recovery Models Full Bulk Logged Simple Non Logged Operations Backups and Plann Full Differential Transaction Log Files and File Groups Compressed backups Mirrored Backups Split Backup Jobs and Schedules Back up Device Append and Over write Permissions and Settings Enhancements Restore Complete restoration Point in Time restoration Restore Modes Recover Process Migrations Steps in Migration Migrating System databases Migration to other RDBMS SSIS , Package creation & Issues Database Upgrade Types Planning for Upgrade Upgrade Advisor Replication Publisher Publication Subscriber Subscription Distributor Agents Snap Shot Publication Transactional Publication Merge Publication Replication monitor Jobs Latency Issues Log Shipping Configuring Log shipping Monitoring logshipping Failover Process Issues Mirroring Principle Serve Mirror Server Witness Server Quorum High Availability High Protection High performance Synchronization Disaster Recovery Monitoring & Issues ALWAYS ON CLUSTERING Types Configuring Clustering Monitoring Clustering Issues SQL SERVER AGENT Jobs Schedules Alerts Operators Error Logs Database Mail Configuration Maintenance Plan Through SSMS Through SSIS PERFORMANCE TUNING Isolation levels ACID Properties Normalization Blocking Dead Locks Indexes DBCC and DMV Stored procedures Performance Monitor Profiler & Counters Tuning Adviser TROUBLE SHOOTING Tempdb Full Issues Log file Full Issues Suspect Mode Issues Page Corruption Issues Tail Log Backup Moving system databases Moving User databases Rebuild Matser Database Orphaned Users Connection Issues SQLSERVER Service Issues LONG Running Slow Queries Index Fragmentation Issues SP_RECOMPILE SP’S Tickets, SLA SSRS Configuration & Issues Sql Browser REGULAR, WEEKLY AND MONTHLY ACTIVITIES INTERVIEW STUFF
Batch Date: Sep 30th @ 9:30AM Faculty: Mr. Ramesh (10 yrs of EXP) Duration: 45 Days Fee: 2000/- INR + Reg fee 100/- INR Location : Maitrivanam, Hyderabad.
Batch Date: Sep 30th @ 9:30AM Faculty: Mr. Ramesh (10 yrs of EXP)
Duration: 45 Days
Fee: 2000/- INR + Reg fee 100/- INR
Location : Maitrivanam, Hyderabad.
Venue : DURGA SOFTWARE SOLUTIONS at Maitrivanam Plot No : 202, IInd Floor , HUDA Maitrivanam, Ameerpet, Hyderabad-500038. Ph.No : 09246212143 Syllabus: DBMS RDBMS Introduction to SQL SERVER Software And Hardware Requirements Client-Server Architecture SQLSERVER Installation Requirements 2008 Installation Steps Services & Checks after installation Features of SQLSERVER 2008 & 2012 Server startup process Tools in SQL SERVER 2008 Management Studio(SSMS) BI Tools(BIDS) Configuration Tools Performance Tools(Profiler) ARCHITECTURE SQLSERVER ARCHITECTURE PROTOCOLS STORAGE STRUCTURE DATABASE ARCHITECTURE Configuration Settings Memory Settings Processor Connections Database Settings Transactions in SQL SERVER Commit Rollback Buffer Checkpoint Databases System Databases User Databases Creating Database Altering Database Data Files Log Files File Groups Security Windows Authentications SQL Server Authentications Logins and Users Roles Schema Orphaned Users Recovery Models Full Bulk Logged Simple Non Logged Operations Backups and Plann Full Differential Transaction Log Files and File Groups Compressed backups Mirrored Backups Split Backup Jobs and Schedules Back up Device Append and Over write Permissions and Settings Enhancements Restore Complete restoration Point in Time restoration Restore Modes Recover Process Migrations Steps in Migration Migrating System databases Migration to other RDBMS SSIS , Package creation & Issues Database Upgrade Types Planning for Upgrade Upgrade Advisor Replication Publisher Publication Subscriber Subscription Distributor Agents Snap Shot Publication Transactional Publication Merge Publication Replication monitor Jobs Latency Issues Log Shipping Configuring Log shipping Monitoring logshipping Failover Process Issues Mirroring Principle Serve Mirror Server Witness Server Quorum High Availability High Protection High performance Synchronization Disaster Recovery Monitoring & Issues ALWAYS ON CLUSTERING Types Configuring Clustering Monitoring Clustering Issues SQL SERVER AGENT Jobs Schedules Alerts Operators Error Logs Database Mail Configuration Maintenance Plan Through SSMS Through SSIS PERFORMANCE TUNING Isolation levels ACID Properties Normalization Blocking Dead Locks Indexes DBCC and DMV Stored procedures Performance Monitor Profiler & Counters Tuning Adviser TROUBLE SHOOTING Tempdb Full Issues Log file Full Issues Suspect Mode Issues Page Corruption Issues Tail Log Backup Moving system databases Moving User databases Rebuild Matser Database Orphaned Users Connection Issues SQLSERVER Service Issues LONG Running Slow Queries Index Fragmentation Issues SP_RECOMPILE SP’S Tickets, SLA SSRS Configuration & Issues Sql Browser REGULAR, WEEKLY AND MONTHLY ACTIVITIES INTERVIEW STUFF
Venue : DURGA SOFTWARE SOLUTIONS at Maitrivanam Plot No : 202, IInd Floor , HUDA Maitrivanam, Ameerpet, Hyderabad-500038. Ph.No : 09246212143 Syllabus:
