|
Purpose of the Course
This course
provides comprehensive coverage of developing applications using
Microsoft’s new database product, SQL Server 2000. This robust
database product is targeted to large scale database deployment.
This course covers all aspects of installing, querying, performance
tuning and implementing Enterprise solutions. As such a number of
other Microsoft’s technologies are also covered, such as OLAP
(Online Analytical Processing), Cubes and Data Warehousing, English
Query Capabilities.
Benefits to the Participants
This
3 module program provides in depth coverage of implementing, developing
and deploying SQL Server 2000 based applications. The longer term format,
with many hands-on, constructive, real world labs ensures student
retention.
Participants
will learn how to:
 
Design and Normalize an SQL Server 2000 database
Use the many wizards which can speed up development
Create Stored Procedures and Triggers
Program using powerful Transact SQL
Configure and Tune a large database
Use Security, Replication, Publishing and System Backup
Monitoring and Tuning
OLAP Services
Data Warehousing, Analysis Services, Cubes
Keeping
up with ever-increasing new technologies is difficult. This course
provides the student with detailed development coverage of Microsoft’s
latest database product.
Who Should
Attend
This
course is valuable for individuals who need an in depth understanding
of SQL Server 2000 development and related Microsoft technologies.
Individuals looking for an upgrade path from older database products
and those who need to understand relational database development
issues.
A
basic knowledge of SQL and relational database concepts is beneficial.
|
