2071B Querying Microsoft SQL Server 2000 with Transact-SQL

Before attending this course, students must have:
• Experience using a Microsoft Windows operating system.
• An understanding of basic relational database concepts, including: • Logical and physical database design.
• Data integrity concepts.
• Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many).
• 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. To benefit fully from our instruction, students need an understanding of the English language and completion of the prerequisites.