Microsoft training courses, Cisco training courses, Prince2 training courses, ISEB training courses with locations nationwide
Call now to speak to an experienced Training Advisor
 
     
 
Home
  
How it works
  
About the quality of your course
 
Managed services
  
Partner CourseMonster
  
 
 
Thousands of Microsoft, ISEB, ITIL, Cisco and Prince2 Training Courses and more
  
 
Browse Microsoft Training Courses

SQL Server 2005: Introduction for Beginners (5 day)

Course Code: MSQ05-I5      Days: 5
Show all Microsoft Courses
Scheduled Dates
Locations filtered. Show all UK course locations.
Request availability or book by selecting a date:
England
Berkshire
Wokingham (RG40) 08/12/08 £ 1,475
Wokingham (RG40) 05/01/09 £ 1,475
Wokingham (RG40) 02/02/09 £ 1,475
Wokingham (RG40) 02/03/09 £ 1,475
Wokingham (RG40) 30/04/09 £ 1,475
Wokingham (RG40) 11/05/09 £ 1,475
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.

Course Overview

Students should have attended or have equivalent knowledge to Managing and Maintaining a Windows Server 2003 Environment course.

Course Outline

SQL Server 2005 installation

  • SQL Server features
  • SQL Server installation
  • Alternative installations

SQL Server management tools

  • SQL Server 2005 services
  • Management tools
  • SQL Server settings
  • Database Mail

Database management

  • SQL Server data storage
  • Database management
  • Capacity planning and management

Data design

  • The data design process
  • Table and data design
  • Data normalization
  • Data types

Tables, constraints, and indexes

  • Objects
  • Tables and constraints
  • Indexes

Data retrieval

  • Queries
  • Transact-SQL functions
  • Data organization
  • Multiple table queries
  • Data modification
  • Query Designer

Programmable objects

  • Programming fundamentals
  • User views
  • Stored procedures
  • User-defined functions

Data management

  • Multiple language support
  • Full-text search
  • Partitions
  • Error handling
  • Transactions and locking
  • Triggers

XML support

  • XML fundamentals
  • The XML data type
  • XML methods and indexes
  • XML and relational data integration

Data transfers

  • Bulk transfers
  • SQL Server 2005 Integration Services
  • XML import and export

SQL Server security

  • Principles
  • Server securables
  • Database and schema securables
  • SQL auditing
  • Encryption
  • CLR security

Management and maintenance

  • SQL Server Agent
  • Distributed queries
  • Replication

SQL Server optimization

  • Monitoring and optimization
  • Database optimization
  • Database tune-ups
  • Query optimization concepts

Reliability and availability

  • Database backup
  • Database restore
  • Log shipping
  • Database snapshots
  • Mirrored databases

Applications

  • Service Broker
  • HTTP endpoints

Troubleshooting and repair

  • Blocks and deadlocks
  • SQL Server errors
  • Recovery

Appendix A: Outlander Spices case study

  • Outlanders Spices

Appendix B: Command reference

  • SQL Server command reference

Appendix C: MCTS 70-431 exam objectives map

  • Comprehensive exam objectives


How to make a booking for the MSQ05-I5 course
 
  CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.  
     
CourseMonster® Patent Pending © SeaKom, All Rights Reserved - Channel partners with Business Training Partnership