| Appraisal Skills |
| Assertiveness for Managers |
| Basic Employment Law |
| Change Management |
| Coaching for Performance |
| Equality and Diversity |
| Facilitating Effective Meetings |
| Finance for Non-Financial Managers |
| Recruitment and Selection |
| Stress Management |
| Supervisory Management |
| The Middle Managers Toolkit |
| Time Management for Managers |
| Access |
| AutoCAD Intermediate |
| AutoCAD Introduction |
| Crystal Reports |
| Excel |
| Lotus Notes |
| Microsoft Office Upgrade Courses |
| Outlook Advanced |
| Outlook Introduction |
| PC Awareness - Level 1 |
| PC Awareness - Level 2 |
| Powerpoint |
| Project Advanced |
| Project Introduction |
| Publisher |
| Sageline Accounts |
| Sageline Payroll |
| SharePoint Administration |
| Sharepoint End-User |
| VBA |
| Visio Advanced |
| Visio Introduction |
| Word |
| A+ |
| Active Directory |
| Configuring Windows Server 2008 Active Directory |
| Exchange 2000/2003 Administration |
| Exchange 2007 |
| Exchange 2010 |
| Introduction to PC Technology |
| MCDST |
| Microsoft Exchange Server 2010 |
| Network + |
| Oracle Database 10g: Administration |
| SQL 2005 |
| SQL 2008 |
| TCP/IP |
| Windows 7 |
| Windows 7 Enterprise Desktop Support Technician |
| Windows Desktop Support Skills |
| Windows SBS |
| Windows Server 2003 MCP |
| Windows Server 2008 Administration |
| Windows Server 2008 New Features |
| WLAN Networking |
| ITIL® Foundation V3 |
| PRINCE2® Combined Foundation and Practitioner |
| PRINCE2® Foundation |
| PRINCE2® Overview |
| PRINCE2® to Practical |
| Advanced Presentation Skills |
| Assertiveness |
| Business & Letter Writing |
| Cold Calling |
| Communication Skills |
| Creating Sales People that Sell! |
| Customer Care |
| Dealing with Aggressive Callers |
| Introduction to Marketing |
| Managing the Anger Habit |
| Minutes & Note-Taking |
| NLP |
| Participating Effectively in Meetings |
| Persuasive Selling |
| Presentation Skills |
| Presentation Skills for Sales People |
| Report Writing |
| Sales Skills and Strategy |
| Telephone Techniques |
| The Effective Receptionist |
| The Executive Secretary |
| The Training Administrator |
| Time Management |
| Train the Trainer |
| Requirements for Electrical Installations 3-days |
| Requirements for Electrical Installations 5-days |
| Working at Height |
Implementing and Maintaining SQL Server 2008
Duration 5 daysPrerequisites
A working knowledge of Windows Server, Active Directory and Basic Networking.
Course Content
Unit 1: SQL Server 2008 installation
Topic A: SQL Server features
Topic B: SQL Server installation
Topic C: Alternative installations
Unit 2: SQL Server Management tools
Topic A: SQL Server 2008 services
Topic B: Management tools
Topic C: SQL Server settings
Topic D: Database Mail
Unit 3: Database Management
Topic A: SQL Server data storage
Topic B: Database Management
Topic C: Capacity planning and management
Unit 4: Data Design
Topic A: The data design process
Topic B: Table and data design
Topic C: Data Normalization
Topic D: Data types
Unit 5: Tables, constraints and indexes
Topic A: Objects
Topic B: Tables and constraints
Topic C: Indexes
Unit 6: Data retrieval
Topic A: Queries
Topic B: Transact-SQL functions
Topic C: Data Organization
Topic D: Multiple table queries
Topic E: Data modification
Topic F: Query Designer
Unit 7: Data Management
Topic A: Multiple language support
Topic B: Full-text search
Topic C: Partitions
Topic D: Error handling
Topic E: Transactions and locking
Topic F: Triggers
Unit 8: Data transfers
Topic A: Bulk transfers
Topic B: SQL Server 2008 Integration
Services
Topic C: XML import and export
Unit 9: SQL Server security
Topic A: Principles
Topic B: Server securables
Topic C: Database and schema securables
Topic D: SQL auditing
Topic E: Encryption
Topic F: CLR security
Unit 10: Management and Maintenance
Topic A: SQL Server Agent
Topic B: Distributed queries
Topic C: Replication
Unit 11: SQL Server optimization
Topic A: Monitoring and optimization
Topic B: Database optimization
Topic C: Database tune-ups
Topic D: Query optimization concepts
Unit 12: Reliability and availability
Topic A: Database backup
Topic B: Database restore
Topic C: Log shipping
Topic D: Database snapshots
Topic E: Mirrored databases
Unit 13: Applications
Topic A: Service Broker
Topic B: HTTP endpoints
Unit 14: Troubleshooting and repair
Topic A: Blocks and deadlocks
Topic B: SQL Server error
Topic C: Recovery
Windows Server 2008 New Features
Well run course, flexible, informal presentation style - good.
Well run course, flexible, informal presentation style - good.
SCDC
Transact SQL
Fit for purpose. Enjoyed Course Fully
Fit for purpose. Enjoyed Course Fully
Call Connection
MCDST
Friendly, informative and tailored to content and ability of delegates
Friendly, informative and tailored to content and ability of delegates
Circle Anglia