Course not currently available
Microsoft SQL Server 2005
Course
In Fareham ()
Description
-
Type
Course
-
Duration
4 Days
To implement and maintain Microsoft SQL Server 2005. Suitable for: 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.
About this course
Must have a basic understanding of Microsoft Servers prior to the course.
Reviews
Teachers and trainers (1)
Duncan Dickinson
Technical Trainer
Course programme
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
Microsoft SQL Server 2005