|
Technology: |
Windows 2000 / SQL 2000 |
|
|
Course: |
|
|
|
Type: |
DBA/Development |
|
|
Duration: |
2 Days |
Description:
|
Delivery Method: |
Instructor led |
|
Summary Description: |
|
Audience: |
|
The goal of this course is to provide students with the
technical skills required to write basic Transact-SQL queries for Microsoft
SQL Server™ 2000. |
|
This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries. |
|
Objectives: |
|
Comments: |
|
This course will help the student prepare for the following Microsoft
Certified Professional exams: This
course is not directly associated with any Microsoft Certified Professional
exams, although it will help in preparation for 70-229. |
|
|
|
Topics Covered: By the end of this
course, the student should be able to: ü
Describe the uses of and ways to execute the
Transact-SQL language. ü
Use querying tools. ü
Write SELECT queries to retrieve data. ü
Group and summarize data by using Transact-SQL. ü
Join data from multiple tables. ü
Write queries that retrieve and modify data by using
subqueries. ü
Modify data in tables. ü
Query text fields with full-text search. ü
Describe how to create programming objects. |
|
Prerequisites: Student should have: ü
Experience using a Microsoft Windows® operating
system. ü
An understanding of basic relational database
concepts, including: o
Logical and physical database design. o
Data integrity concepts. o
Relationships between tables and columns (primary
key and foreign key, one-to-one, one-to-many, and many-to-many). o
How data is stored in tables (rows and columns). ü
Familiarity with the role of the database
administrator ü
The course materials, lectures, and lab exercises
are in English. |