Microsoft SQL Server 2005 Curriculum.

Good day!

UP, Mapua, St. Benilde, and PUP in cooperation with Microsoft agreed on a venture to create industry and technology aware instructional materials which will be used by the said schools in its curriculum to arm its students with the necessary skills when the leave their respective schools. C#.NET, ADO.NET, ASP.NET, Mobile Programming, and SQL 2005 will be the main focus of the said venture.

PUP has been assigned to create materials on MSSQL Server 2005.

The following is the module to be discussed (Microsoft Official Curriculum # 2734):

Course outline

Module 1: SQL Server 2005 Overview
Module 2: Transact-SQL Enhancements in SQL Server 2005
Module 3: Using XML in SQL Server 2005
Module 4: Using Service Broker
Module 5: Using Native HTTP Support
Module 6: Using Notification Services
Module 7: Using the .NET CLR in SQL Server 2005
Module 8: Developing Client Applications
Module 9: Using SQL Management Objects

Module 1: SQL Server 2005 Overview

The information in this module introduces the main new features and enhancements in SQL Server 2005 and describes the new development tools.

Lessons

• SQL Server 2005 Components and Architecture
• SQL Server Developer Tools
• SQL Server 2005 Security Implementation

After completing this module, students will be able to:

• Describe the components and architecture of SQL Server 2005.
• Use SQL Server Management Studio to create a database solution.
• Use security features of SQL Server 2005.
  

Module 2: Transact-SQL Enhancements in SQL Server 2005

In this module, students learn about the improvements in Transact-SQL in SQL Server 2005.

Lessons

• Data Definition Language Enhancements
• Data Manipulation Language Enhancements
• Structured Exception Handling
  

After completing this module, students will be able to:

• Use new Data Definition Language (DDL) features in SQL Server 2005.
• Use new Data Manipulation Language (DML) features in SQL Server 2005.
• Implement structured exception handling in Transact-SQL.
  

Module 3: Using XML in SQL Server 2005

In this module, students learn about the XML-related functionality in the SQL Server 2005 database engine will be described.

Lessons

• XML Enhancements in SQL Server 2005
• The xml Data Type
• Using XQuery

After completing this module, students will be able to:

• Use enhanced XML features in SQL Server 2005.
• Use the xml data type for typed and untyped XML.
• Use XQuery expressions with XML data.
  

Module 4: Using Service Broker

The information in this module introduces Microsoft SQL Server 2005 Service Broker-a message-based platform for building service-oriented database solutions.

Lessons

Service Broker Architecture

Using the Service Broker

After completing this module, students will be able to:

• Describe the Service Broker architecture.
• Use Service Broker for message-based communication.
  

Module 5: Using Native HTTP Support

In this module, students learn how to create HTTP endpoints that make database services available to Web services clients.

Lessons

• Native HTTP Support in SQL Server 2005
• Configuring Native HTTP Support
  

After completing this module, students will be able to:

• Describe the native HTTP support features in Microsoft SQL Server 2005.
• Implement a Web service using native HTTP endpoints.
  

Module 6: Using Notification Services

The information in this module introduces Notification Services and how to develop Notification Services applications.

Lessons

• Notification Services Architecture
• Building Notification Services Solutions
  

After completing this module, students will be able to:

• Describe the architecture of a Notification Services solution.
• Design and implement a simple Notification Services solution.
  

Module 7: Using the .NET CLR in SQL Server 2005

In this module, students learn how to implement managed code in a SQL Server 2005 database.

Lessons

• SQL Server and the .NET CLR
• Implementing Managed Code in SQL Server 2005
  

After completing this module, students will be able to:

• Identify appropriate scenarios for using managed code in the database.
• Implement managed database objects.
  

Module 8: Developing Client Applications

The information in this module introduces database developers to client application development techniques that use the data access classes provided in the .NET Framework.

Lessons

• Developing Client Applications with ADO.NET
• Data Binding in the .NET Framework 2.0
  

After completing this module, students will be able to:

• Use ADO.NET to build a database client application.
• Use data binding in a client application.
  

Module 9: Using SQL Management Objects

The information in this module introduces the SQL Management Objects (SMO) Application Programming Interface (API) in Microsoft SQL Server 2005, which provides classes that you can use to manage SQL Server. SQL Server 2005 also introduces Replication Management Objects (RMO) to allow automation of replication.

Lessons

• Introduction to SQL Management Objects
• Replication Management Objects

After completing this module, students will be able to:

• Use SMO to manage SQL Server.
• Use RMO to manage replication.
  

Now, here is the dillema. You see, I (ahem, we ) don't have much idea on the new features of SQL 2005. Search for reference materials here in RP proved futile. So I am posting here, just in case you guys may have the time (and the technical knowledge of course ) to give me a helping hand.

Thanks in advance.

a good start to know the latest features of SQL 2005 is to read about the top 30 new features in SQL 2005

you can also look at this book(Microsoft SQL Server 2005 New Features) by Michael Otey which outlines the new features of SQL 2005. I suggest skirming the table of contents.

Some syllabi's from Microsoft is also searcheable like:

Implementing a Microsoft SQL Server 2005 Database http://www.microsoft.com/learning/syllabi/en-us/2779afinal.mspx

Maintaining a Microsoft SQL Server 2005 Database http://www.microsoft.com/learning/syllabi/en-us/2780afinal.mspx

Designing Microsoft SQL Server 2005 Server-Side Solutions http://www.microsoft.com/learning/syllabi/en-us/2781afinal.mspx

Designing Microsoft SQL Server 2005 Databases http://www.microsoft.com/learning/syllabi/en-us/2782afinal.mspx

Designing the Data Tier for Microsoft SQL Server 2005 http://www.microsoft.com/learning/syllabi/en-us/2783afinal.mspx

Tuning and Optimizing Queries using Microsoft SQL Server 2005 http://www.microsoft.com/learning/syllabi/en-us/2784afinal.mspx

Designing a Microsoft SQL Server 2005 Infrastructure http://www.microsoft.com/learning/syllabi/en-us/2786afinal.mspx

Designing Security for Microsoft SQL Server 2005 http://www.microsoft.com/learning/syllabi/en-us/2787afinal.mspx

There's more that can be found on the microsoft.com/learning page

-----------------------------------

I found the outline below from the premier training institution in South Africa: http://www.ace.co.nz/tools/courses/course_product.asp?Area=2&Product=59

2787: Designing Security for Microsoft SQL Server 2005 This two-day instructor-led course enables database administrators who work with enterprise environments to design security for database systems using Microsoft SQL Server 2005. The course emphasizes that students should think about the whole environment, which includes business needs, regulatory requirements and network systems, and database considerations during design. 2734: Updating Your Database Development Skills to Microsoft SQL Server 2005 This three-day instructor-led course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can design, build, query and develop enterprise SQL Server 2005 databases and servers. 2779: Implementing a Microsoft SQL Server 2005 Database This three-day instructor-led course provides students with product knowledge and skills needed to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database. 2780: Maintaining a Microsoft SQL Server 2005 Database This three-day instructor-led course provides students with product knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database. 2781: Designing Microsoft SQL Server 2005 Server-Side Solutions This three-day instructor-led course provides students with the knowledge and skills to design server-side solutions for Microsoft SQL Server 2005. The course focuses on teaching database developers who work in enterprise environments to identify and place database technologies during design to achieve a suitable solution that meets the needs of an organization. Students will also learn to consider the solution from a system-wide view instead of from a single database or server perspective. 2782: Designing Microsoft SQL Server 2005 Databases This two-day instructor-led course provides students with the knowledge and skills to design databases for Microsoft SQL Server 2005 using business requirements to guide their decisions (beyond structured third normal form [3NF] modeling techniques). Students will also learn to incorporate security requirements throughout their design. 2783: Designing the Data Tier for Microsoft SQL Server 2005 This one-day instructor-led clinic provides students with the knowledge and skill to design the data tier for Microsoft SQL Server 2005. The clinic focuses on teaching database developers working in enterprise environments to understand and decide how application developers are going to access and consume their data. This is a major failure point of database solutions today. 2733: Updating Your Database Administration Skills to Microsoft SQL Server 2005 This learning product will enable database administrators experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005 so that they can support, configure, and maintain enterprise SQL Server 2005 databases and servers 2786: Designing a Microsoft SQL Server 2005 Infrastructure This two-day instructor-led course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL Server 2005 database infrastructure. The course focuses on the development of strategies for data archiving, consolidation, distribution, and recovery. 2797: Designing a Reporting Solution Architecture using Microsoft SQL Server 2005 Reporting Services The purpose of this 2-day course is to teach Business Intelligence (BI) professionals working in enterprise environments to design a reporting solution architecture that supports their BI solution. 2788: Designing High Availability Database Solutions Using Microsoft SQL Server 2005 This three-day instructor-led course provides students with the knowledge and skills to design high availability database solutions using Microsoft SQL Server 2005. The course focuses on teaching experienced database administrators working in enterprise environments to design database solutions that meet the availability needs of their organization. 2789: Administering and Automating Microsoft SQL Server 2005 Databases and Servers This one-day instructor-led course provides students with the knowledge and skills to administer and automate Microsoft SQL Server 2005 databases and servers. This course focuses on the need to maintain administering and automation information. 2790: Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 The purpose of this two-day workshop is to teach database administrators working in enterprise environments how to determine and troubleshoot performance issues using Microsoft SQL Server 2005. 2794: Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005 This course teaches Business Intelligence (BI) professionals working in enterprise environments how to design a BI solution architecture. 2795: Designing an ETL Solution Architecture using Microsoft SQL Server 2005 Integration Services The purpose of this 2-day instructor-led course is to teach Business Intelligence (BI) professionals working in enterprise environments to design an extract, transform, and load (ETL) solution that supports their BI solution. 2796: Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services The purpose of this 3-day course is to teach Business Intelligence (BI) professionals working in enterprise environments to design a multidimensional solution architecture that supports their BI solution. 2784: Tuning and Optimizing Queries using Microsoft SQL Server 2005 This three-day instructor-led workshop provides database developers working in enterprise environments using Microsoft SQL Server 2005 the knowledge and skills to evaluate and improve queries and query response times. The workshop focuses on systematic identification and optimization of database factors that impact query performance.

 

HTH :)

Knowing how the business goes in the Philippines, I doubt this will go on full blast.  This will probably kill the CPLS business

bass_player:

Knowing how the business goes in the Philippines, I doubt this will go on full blast.  This will probably kill the CPLS business

what do you mean?