Microsoft SQL Server 2005

Microsoft SQL Server 2005

Introduction
This course is designed for Microsoft SQL Server 2005 Implementation and Maintenance. The full content will also prepare you for the [70-431] exam. If you are pursuing a career as a database administrator, database developer or business intelligence developer, or you need a technical understanding of SQL server 2005 features and implementation, this course will provide you with the necessary skills. You should be familiar with Microsoft Windows server 2003 administration and Windows Active Directory environments. You must understand networking and security concepts, including the use of certificates, and be familiar with web technology concepts. You should also have a general familiarity with .NET framework and Web programming concepts. If there are four or more delegates from the same company, we can tailor the course to meet your specific requirements at no extra cost. Please contact us for more information.

Objectives
By the end of the course you will be able to:

 

• Install SQL Server 2005
   
• Use SQL Server management tools
   
• Create and manage databases
   
• Develop a database design for data
   
• Create tables, constraints and indexes
   
• Retrieve data from SQL Server 2005 databases
   
• Create programmable objects
   
• Manage data in a SQL Server database
   
• Support XML data in a SQL Server database
   
• Import and Export data
   
• Configure security
   
• Complete maintenance and management tasks
   
• Optimise SQL Server for performance
   
• Increase reliability and availability of data
   
• Implement applications
   
• Trooble shoot and repair SQL Server 2005 databases
  
  Introduction to SQL  
  Content
  SQL Server 2005 installation: features - installation - alternative installations  
  SQL Server management tools: SQL server services - management tools - server settings - database mail  
  Database management: Data storage - database management - capacity planning and management  
  Data design: Design process - table and data design - normalisation - data types  
  Tables, Constraints and Indexes: Objects - tables and constraints - indexes  
  Data retrieval: Queries - transact SQL functions - data organisation - 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 - XML data type - methods and indexes - relational data integration  
  Data transfers: Bulk transfers - SQL server integration services - XML import and export  
  SQL Server security: Principles - server securables - database and schema securables - SQL auditing - encription - CLR security
  Management and maintenance: SQL server agent - distributed queries - replication  
  SQL Server optimisation: Monitoring and optimisation - database optimisation - database tune-ups - query optimisation concepts
  Reliability and availability: Database backup - restore - log shipping - snapshots - mirrored databases  
  Applications: Server broker - HTTP endpoints  
  Troubleshooting and repair: Blocks and deadlocks - SQL server errors - recovery