Programming a Microsoft SQL Server 2000 Database

Dimension Data Learning Solutions
Syndey,Brisbane,Canberra,South Melbourne,Adelaide,Perth, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course provides students with the technical skills required to program a database solution by using Microsoft® SQL Server 2000.

Skills Gained:
At the end of the course, students will be able to describe the elements of SQL Server 2000; design a SQL Server enterprise application architecture; describe the conceptual basis of programming in Transact-SQL; create and manage databases and their related components; implement data integrity by using the IDENTITY column property, constraints, defaults, rules, and unique identifiers; plan for the use of indexes; create and maintain indexes; create, use, and maintain data views; implement user-defined functions; design, create, and use stored procedures; create and implement triggers; program across multiple servers by using distributed queries, distributed transactions, and partitioned views; optimize query performance; analyze queries; and manage transactions and locks to ensure data concurrency and recoverability.

Key Topics:
Module 1: SQL Server Overview
Module 2: Overview of Programming SQL Server
Module 3: Creating and Managing Databases
Module 4: Creating Data Types and Tables
Module 5: Implementing Data Integrity
Module 6: Planning Indexes
Module 7: Creating and Maintaining Indexes
Module 8: Implementing Views
Module 9: Implementing Stored Procedures
Module 10: Implementing User-defined Functions
Module 11: Implementing Triggers
Module 12: Programming Across Multiple Servers
Module 13: Optimizing Query Performance
Module 14: Analyzing Queries
Module 15: Managing Transactions and Locks
...''

Phone:61 2 9299 3333

School Address:

Level 10
301 George St
Sydney, NSW
Australia - 2000
Phone : 61 2 9299 3333
Fax : 61 2 9299 7585
Email : training@didata.com.au

10th Floor, Thakral House
301 George St
Syndey , NSW
Australia - 2000
Phone : 61 131 201 or 61 2 9299 3333
Fax : 61 2 9299 3154

12th Floor,
307 Queen St
Brisbane , QLD
Australia - 4000
Phone : 61 131 201 or 61 7 3221 2444
Fax : 61 7 3221 2744


1st Floor,
32 London Circuit
Canberra , ACT
Australia - 2601
Phone : 131204 or 2 62637900
Fax : 61 2 6248 6436


3rd Floor,
11-17 Dorcas St
South Melbourne , VIC
Australia - 3205
Phone : 61 131 201 or 61 3 9626 0770
Fax : 61 3 9696 0786


4th Floor,
139 Frome St.
Adelaide , SA
Australia - 5000
Phone : 61 131 201 or 61 8 8236 8200


Jobs & Resumes: Syndey, Brisbane, Canberra, South Melbourne, Adelaide, Perth
Houses & Roommates: Syndey, Brisbane, Canberra, South Melbourne, Adelaide, Perth

Installing, Configuring, and Administering Microsoft Windows XP Professional
Designing a Microsoft Exchange Server 2003 Organ
Upgrading Your Skills from Microsoft Exchange Server 5.5 to Microsoft Exchange Server 2003
Troubleshooting Microsoft Exchange Server 2003
Implementing and Managing Microsoft?Exchange Server 2003
Customizing Microsoft?SharePoint?Products and Technologies 2003
Designing IT Platform Collaborative Applications with Microsoft SharePoint 2003 Workshop
Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services
Querying Microsoft SQL Server 2000 with Transact-SQL
Administering a Microsoft SQL Server 2000 Database
Updating Your Database Administration Skills to Microsoft SQL Server 2005 (Yukon)
Updating Web Server Skills to Internet Information Services 6.0
Developing E-Business Solutions using Microsoft BizTalk Server 2004
Deploying and Managing E-Business Solutions Using Microsoft BizTalk Server 2004
Designing, Deploying, and Managing a Network Solution for the Small and Medium-sized Business
Building Microsoft Commerce Server 2002 Solutions
Building Microsoft Content Management Server 2002 Solutions
Designing E-Business Solutions using Microsoft BizTalk Server 2004
Fundamentals of Network Security

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.