Sql server dba training

City: Noida
Last visit: 02-May-2014
Author's ads: 1

Posted: 02-May-2014


Get Trained by Experienced DBA Professional working in Top MNCs like TCS, Birlasoft and HCL. and earn in lacs. Don't late call on 8377839494 Main Topics for DBA Training ( but not limited to ) SQL Server 2008 Installation and Features Installing SQL Server Creating and Managing Databases Storage structures Creating databases and transaction logs Defining file groups Different database options Managing database space Permitting automatic database growth Specifying database options Moving databases Scripting objects and moving data with Transact-SQL Detaching and attaching databases Implementing Server and Database Security Creating logins Contrasting Windows and SQL Server authentication Making logins members of server roles Enforcing password policy Authorizing database access Adding users and defining new roles Delegating privileges with predefined roles Handling mis-mapped logins Managing Permissions Granting database-scoped privileges Handling object-level permissions Recovering from Disasters Backing up databases Choosing a recovery model Performing full, log and differential backups Reclaiming transaction log space Restoring databases Recovering user databases Point time recovery Logshipping Mirroring Replication The SQL Server Agent Configuring the agent Setting up Database Mail Multistep jobs Defining jobs to handle routine tasks Associating alerts with jobs Fragmentation and database corruption Identifying and curing fragmentation Finding and repairing database corruption Monitoring SQL Server Ad hoc monitoring Identifying problems with Activity Monitor Querying Dynamic Management Objects Performance Tuning : Execution Plans, blockings