sql dba server online training@MindQ

24/03/2014 Other Classes

Price: Check with seller

No image available

Description

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