Loading...

SQL Server DBA/Programming Training in Chennai - Chennai

SQL Server DBA/Programming Training in Chennai - Chennai
Ad Details
Posted On : 21-Aug-2014
SQL Server 2008 R2/2012 Course Contents



MSSQL Server history

•SQL Server

Versions and Editions

services of SQL Server

Tools of SQL server

New Features in SQL Server 2012



Installing SQL Server

• Installing SQL Server

• Configuring the run-time SQL Server system

• Patching SQL Server - Service packs



SQL Server data storage management



• SQL Server file management architecture

• Creating database files

• Creating SQL Server log files

• Using SQL Server file groups

• Detaching and attaching databases

• Capacity planning



Managing data with the DTS utility

• Using DTS to export and import SQL Server table data



SQL Server security management

• Windows and SQL authentication

• Database and Server role management



SQL Server Backup & recovery

• Overview of SQL Server backup & recovery

• Backup Types

• Restoring a SQL Server database



SQL Server Job scheduling

• Common database scheduled jobs

• Scheduling multi-step job streams



Monitoring SQL Server

• Job Activity Monitor

• Activity monitor

• Log File Viewer

• Performance Monitor

• Windows Event viewer

• Monitoring by SQL Server Alerts

• SQL Server Profiler



New Features in SQL Server 2008

• RBS

• TDE



Log Shipping



Replication

• Snapshot replications

• Transactional Replication

• Merge Replications



Mirror



maintenance Plan



Performance and Turning



Cluster



Please Contact : 7401483370

When you call, plz mention that you found my contact info on Quikr!

Share this on
7401483370 Send Free SMS
Get the Best Distance Education Today! MBA, BBA, BCA, MCA, BscIT & More!, Click & Apply!
Will redirect to www.smude.edu.in
Recommended Professional & Short Term Courses for You
SEO, SEM, Digital Marketing-FIVE PULSE TECHNOLOGIES
Why digital marketing training? 1) completely customized training for professionals and organi...
Professional & Short Ter...
|
9 minutes ago
Big Data Analytics Classroom Training in Chennai
� big data analytics has become all the rage. even so, many organizations are discovering tha...
28 minutes ago
Experience Certificates IT/NON IT/BPO
Do you required work experience documents diploma/ iti electrical or ece any other engineering...
40 minutes ago
SAP (BI) - VICAPRI LABS- Discount Offer
Sap training by vicapri labs vicapri labs is the offshoot of vicapri services india (p) ltd ...
46 minutes ago
8
AVEVA Authorized PDMS Course Training Institute In India
We are offering pdms,piping,pds and ceasar courses with aveva certification. mobile: 9500 100...
51 minutes ago
Ads by Google
Check MSP