SQL ADMINISTRATION

Enquire, Join and get training by Well Experienced & Certified tutors
for your professional IT Course.

Watch Sample Session!

Get in Touch

+1 202-403-9022

+91 951 583 9400

info@suvenit.com

MODULE#1 –Introduction to SQL Server
• History of SQL Server
• Different Editions of SQL Server
• Tools of SQL Server
• Hardware and Software Requirements
• Instances
• Default Instance and Named Instances
• SQL Server Services
• Instance Aware Services
• Instance Unaware Services
MODULE#2 –Installation and configuring SQL Serve
• Installing SQL Server 2005 & 2008.
• Pre–installation steps
• Installations
• Viewing installation process with LOG files
• Adding /Removing components
• Installing service packs.
• Best Practices after Installing SQL Server
• Configuring various Services with Local and Domain Account
• Startup Parameter
• Configuring data file and log file paths
• Memory configuration
• Remote connections
• Configuring Network protocols, Ports
MODULE#3 – Working with Databases
• Working with databases.
• System Defined databases
• Steps to move System databases
• Handling TempDb issues.
• Database Architecture.
• Data File & Log File
• Filegroups & Extents
• Pages – types
• Page architecture
• Tracking free space
• Creating Databases
• Database Snapshots
• Adding files, file groups and Schema
MODULE#4 –Implementing Security
• Security in SQL Server 2008
• Types of Authentications.
• Windows Authentication
• Creating logins from windows users and groups
• Orphan logins.
• SQL Server Authentication
• Creating SQL logins and testing logins
• Setting authentication Mode
• Security Auditing
• Understanding server roles
• Working with users
• Resolving orphan users issues
• Understanding database roles, custom and application roles
• Understanding permissions
• Encryption and decryption
MODULE#5 –Backup and Restoration
• Understanding Transaction process
• Understanding Transaction Log file
• Checkpoint & Lazy writer process
• Truncating log file.
• Database Recovery Models
• Bulk Logged
• Setting recovery model
• Database Backups
• Backup types.
• Differential
• Transaction Log
• File or Filegroup
• Copy-only, Mirrored and tail log backup
• Performing Restoration operations

MODULE#6 –High Availability
• Introduction to High Availability
• Working with Log Shipping
• Log Shipping Requirement
• Configuring Log Shipping
• Monitoring Log Shipping Status
• Manually performing Fail Over
• Transferring logins
• Log shipping tables and stored procedures
• Fixing log shipping issues
• Working with Database Mirroring
• Difference bet Log shipping and Mirroring
• Operating Modes in Mirroring
• Server Roles in Mirroring
• Requirements for Mirroring
• Configuring Mirroring
• Performing failover in Mirroring
• Different Ways to monitor Mirroring Status
• Orphan logins.
• SQL Server Authentication
• Creating SQL logins and testing logins
• Setting authentication Mode
• Security Auditing
• Understanding server roles
• Working with users
• Resolving orphan users issues
• Understanding database roles, custom and application roles
• Understanding permissions
• Encryption and decryption

MODULE#7 –Backup and Restoration
• Understanding Transaction process
• Understanding Transaction Log file
• Checkpoint & Lazy writer process
• Truncating log file.
• Database Recovery Models
• Bulk Logged
• Setting recovery model
• Database Backups
• Backup types.
• Differential
• Transaction Log
• File or Filegroup
• Copy-only, Mirrored and tail log backup
• Performing Restoration operations
MODULE#8 –High Availability
• Introduction to High Availability
• Working with Log Shipping
• Log Shipping Requirement
• Configuring Log Shipping
• Monitoring Log Shipping Status
• Manually performing Fail Over
• Transferring logins
• Log shipping tables and stored procedures
• Fixing log shipping issues
• Working with Database Mirroring
• Difference bet Log shipping and Mirroring
• Operating Modes in Mirroring
• Server Roles in Mirroring
• Requirements for Mirroring
• Configuring Mirroring
• Performing failover in Mirroring
• Different Ways to monitor Mirroring Status
MODULE#9- Replication
• Replication and advantages
• Replication Entities
• Replication Architecture
• Replication Agents
• Types of Replications
• Configuring Replication
• Snapshot Replication
• Transactional Replication
• Merge Replication
• Peer to peer replication
• Replication Topologies
MODULE#10 –Automating Administrative Tasks Introduction to Clusters
• Working with Database Mail.
• Mail architecture.
• Configuring Profiles and Accounts
• Creating Operators
• Configuring linked servers
• Implementing Automation
• Configuring SQL Server Agent
• Creating Jobs and managing jobs and resolving errors.
• Monitoring jobs.
• Auto alert when job are enabled, disabled or failed
• Managing replication.
• Monitoring and Tuning Replication
MODULE#11- Advanced Administration Concepts
• Maintenance plans
• Monitoring and Tuning SQL Server
• Performance counters setup
• Measuring performance of server.
• Tuning queries.
• Tuning databases.
• Tuning physical architecture of databases.
• Monitoring Tools
• Performance Monitor
• SQL Server Profiler
• Database Engine Tuning Advisor.
• Dynamic Management Views.
• SQL Server and Windows Event Logs.
• Troubleshooting
• Physical server performance.
• Connectivity to SQL Server
• Database Performance.
• Using the DAC.
• Shrink Files
• Using DBCC commands.
MODULE#12 –SQL Server Architecture
• SQL Server Architecture
• Relational Engine & Storage Engine
• Buffer pool
• Managing execution plans.
• Locking and Blocking
• Locks & Deadlocks
• Understanding Blocking.
• Terminating Processes
• Transaction Isolation Levels.
MODULE#13 –Index Management Performance Issues
• Why Indexes
• Type of Indexes
• Cluster Index
• Non cluster Index & Full Text Index
• Creating Indexes
• Manage Index Fragmentation
• DBCC Showcontig
• DM.DB_Index_Physical_Stats
• Index Rebuilding and Reorganizing.
• Manage Statistics
• Performing database integrity checks

MODULE#14 – SQL Server 2000/2005 to 2008 Upgrade Process
• SSUA Tool
• Upgrade Type
• Inplace Upgrade
• Side By Side Upgrade
• Compatibility level
• Transferring logins
• Transferring Jobs
• DTS to SSIS Migration

MODULE#15 – Clustering
• Overview of Windows Clustering.
• Types of Cluster
• Pre- Requisites to implement Cluster
• Installing SQL Server Failover Cluster
• Applying service packs and hot fixes
• Performing failover
• Adding node on a SQL Server Failover cluster.

Quick Contact
close slider