|
Provided by: Affinity IT Training, LLC SQL Server 2005 Administration |
 |
Training
Provided by Affinity IT Training, LLC
Learn about the features of SQL Server; how to design and create a
database; and how to build basic queries using Transact-SQL.
Learn how to build effective views, stored procedures,
triggers, and user-defined functions, using Transact-SQL.
Learn about the new enhancements to the Transact-SQL
programming language including improved support for error handling
and hierarchical queries, and programmers can now use .NET languages
like C# and Visual Basic to build database objects.
Audience:Anyone responsible for the administration of a SQL Server 2005 database server, and those seeking more detail on advanced techniques and trouble-shooting.
|
|
||||||||||
SQL Server 2005 Administration
Objectives
- Install and configure Microsoft SQL Server 2005.
- Understand basic database design principles and how to implement them in SQL Server.
- Learn the fundamentals of writing Transact-SQL queries that retrieve or modify data.
- Understand the differences between view, stored procedures, triggers, and user-defined functions.
- Perform calculations with Visual Basic and Visual C# code rather than T-SQL.
- Use the new Common Table Expressions for creating hierarchical queries.
- Understand the SQL Server security model.
- Configure and tune SQL Server, and monitor database activity.
- Support distributed users by implementing SQL Server Replication.
- Publish data to the Web, and take advantage of SQL Server's rich support for XML.
- Understand Business Intelligence to add reporting and analysis capabilities.
Outline
A Tour of SQL Server 2005
SQL Server 2005 Editions, Components, and Tools
Using SQL Server Management Studio (SSMS)
Working with Tables and Queries
New Transact-SQL Features
Business Intelligence Services
Installing SQL Server 2005
Preparing for Installation
Upgrading an Earlier Version
Installation Steps
Configuring the Server
Designing and Creating a Database
Relational Database Design Principles
Implementing the Design
Data Selection Queries
Understanding Transact-SQL
The SELECT Statement
The WHERE Clause
Using ORDER BY to Sort Data
The GROUP BY Clause
Joining Tables
Modifying Data
Modifying Data
Inserting Data
Updating Data
Deleting Data
Understanding Transaction Isolation
Working with SQL Server Management Studio
Getting Started with SSMS
Exploring the Object Explorer
Working with the Query Editor
Using SQL Server Books Online
Transact-SQL Programming
Overview of Transact-SQL
Using Built-In Functions
Controlling Flow
Ranking Results
Transactions and Error Handling
Transaction Concepts
Applications and Transactions
Creating Explicit Transactions
Using TRY/CATCH Error Handling
Setup
- Access to SQL Server 2005
- Databases and Accounts for students and Instructor
Seminar Pre-Requisites
- To get the most out of the Microsoft SQL Server 2005 course, you should have a solid understanding of relational databases. No particular programming experience is required, but the course is taught from a developer's perspective.
Training Materials
- Course Workbook
Jan08
About The Training Provider: Affinity IT Training, LLC
Affinity IT Training, LLC - .
We are a provider of hands-on, instructor-led IT training for the global business community including website development, databases, programming languages and more. Training includes: ASP, .NET, C#, C , DB2, AJAX, JavaScript, HTML/XHTML/XML, Unix, Linux, Perl, Python, Ruby On Rails, Oracle, Sybase, SQL Server, Project Management Training and customized Integrated Case Study.
