sql dba server online training@MindQ

24/03/2014 Other Classes

Price: Check with seller

No image available


At the end of this course you will be able to:

Install Microsoft SQL Server 2005 and the associated bundled toolsUnderstand the many tools that facilitate effective Database AdministrationMonitor the smooth running of the Database ServerMaintain the Database and IndexesSetup and control Database SecurityCope effectively with Database Disaster RecoveryImplement High Availability and ReplicationUse relevant TSQL commandsUnderstand the basics of Integration ServicesImplement SQL Server Full-text searchSQL Server 2005 Database Administration TrainingSQL Server 2005 Overview

Availability and Scalability FeaturesSecurity FeaturesData Management FeaturesAdministration and Maintenance FeaturesDevelopment FeaturesTo enable SQLiMail Testing mail deliveryInstalling SQL Server 2005

Installing Microsoft SQL ServerSystem RequirementsPreparing for a SQL 2005 InstallationInstallation ChecklistSetup FeaturesUsing the System Consistency CheckerUnattended InstallationInstallation SequenceInstallation MaintenanceUpgrading from previous versions of SQL ServerTo verify the InstallationAdministrative ToolsUpgrading to SQL Server Management Studio

Management Studio WindowsRegistered ServersObject ExplorerReview Database ObjectsModify Database PropertiesCreate Database ScriptsThe Maintenance Plans NodeSolution ExplorerQuery EditorTemplate ExplorerDynamic HelpSQL Server 2005 Services nodeSQL Server 2005 Network Configuration nodeSQL Server 2005 Native Client Configuration nodeDedicated Administrative ConnectionSQL Server Management Studio SQLCMD ModeUsing SQL Management ObjectsSMO Object ModelMonitoring the Database Server

Managing Metadata ViewsMetadata StorageSystem ViewsInformation SchemaCatalog ViewsSys AllDynamic Management ViewsSystem Stored ProceduresDatabase and Index Maintenance

Index Management New Index FeaturesCreating IndexesOnline Index MaintenanceLock OptionsIncluded Columns in IndexesPartitioned Tables and IndexesXML Index SupportAltering an IndexRebuilding an IndexReorganising an IndexDisabling an Index Dropping an IndexIndex FragmentationUsing the Database Tuning AdvisorSecuring SQL Server 2005Implementing SecurablesNew Security FeaturesPrincipals Securables

More Details

Total Views:5
Reference Id:#348234
Phone Number:9502991277
Website URL:Click To Visit
Current Rating: /5 0 Vote
Copyright © 2018 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us : info[at]tuffclassified.com