Find
in
Avoid scams by dealing locally! Always exchange items and money in person and Never pay in advance. More info

SQL Server Online Training

$10.00

SUDEEP TECHNOLOGIES which is a high profiled SQL SERVER online training institute in Hyderabad India offers online training with real time experts and with real time concepts.
SQL SERVER 2010 online training course content
Module1: Starting with SQL Server
• Responsibilities of Database Administrator
• Types of DBAs
• History of SQL Server
• Editions of SQL Server
• Tools of SQL Server
• Differences between Standard and Enterprise editions
• Instances types in SQL Server
o Default Instance
o Named Instance
• SQL Server Services
o Instance aware services
o Instance unaware services
Module2: Installing SQL Server
• Pre-requisites
• Installation
• Post Installation verification Session
Module3: Functioning of Databases
• Database
• Types of Database and Brief explanation
o System Databases
o User Database
• Database Architecture
o Pages
o Extents
o File groups
o Database
• Transaction Architecture
• Creating Database
• Modifying Database
o Adding Files
o Moving and renaming of Database files
• Database modes
• Real time Scenario
Module4: Security
• Authentication Types in SQL Server
• Types of Login
o Windows Login
o SQL Login
• Creating Users and Logins
o Server roles
o Password policy
o Understanding Database and Server Roles
o Permissions
o Working on access level issues
o Orphan users Finding and Fixing
o Important Queries
Module5: Database Backups and Restoration
• Database Backups
o Why we need backups
• Types of Backup
o Full Backup
o Differential Backup
o Transaction Log Backup
• Copy-only, Mirrored, Split and Tail log Backups
• Differences between backups
• Backup Strategy
• Understanding how the data moving from Log to Data File, CHECKPOINT
• Monitoring the space usage of Log File and fixing
• Checking the backup files VALID or CORRUPTED
• Backup storage tables
• Important Queries
• Performing Restorations
o Types of Restoration
o Attach and Detach
o Shrinking files
Module6: Recovery Models of Database
• Types of Recovery Models
o Full
o Bulk Logged
o Simple
• Differences between Recovery Models
• Setting Recovery Models according to the Scenarios with examples
Module7: Automation of SQL SERVER

• Working with SQL SERVER Agent
o Creating Jobs
o Managing Jobs and Resolving issues
o Monitoring Jobs
o Monitoring Tables
• Log Shipping
• Mirroring
• Replication
• Clustering
HIGH AVAILABILTY CONCEPTS

Module1: Log Shipping
• Log Shipping
o Working with Log Shipping
o Terminology
o Pre-requisites to implement Log Shipping
o Different modes of Log Shipping
o Configuring Log Shipping
o Monitoring
o Manually Performing Failover
o Log Shipping Tables
• Discussing Real Time Scenarios
Module2: Database Mirroring
• Working with Database Mirroring
o Terminology
o Pre-requisites to implement Mirroring
o Pre check mirroring ports ENABLED or DISABLED
o Architecture
o Operating Modes
o Differences between Modes
o Port numbers involved in Mirroring
o Requirements for Mirroring
o Configuring Mirroring
o Mirroring failover
o Issues on Mirroring
Module3: Replication
• Working with Replication
o Terminology
o Pre-requisites to implement to Replication
o Types of Replications
o DISTRIBUTOR Database
o Agents involved in Replication
o Configuring Replication
o Resolving Issues
Module4: Clustering
• Introduction about clustering
• Clustering Architecture
• Importance of IP’s involved in Clustering
• SAN importance
• Drive dependency
• Nodes in Clustering
• Important commands





For more details please contact 7799071404 or 7569397388.
Mail id: sudeeponlinetraining@gmail.com

For detailed course content visit
http://www.sudeeptechnologies.com/sql-server-online-training-india.html
 Respond to this ad


Ad ID: 3202818
Similar ads in Hammond, IN: