Course 2071B: Querying Microsoft ® SQL Server ™ 2000 with Transact-SQL

2 Introduction Name Company Affiliation Title/Function Job Responsibility Database Experience SQL Server Experience Expectations for the Course

3 Course Materials Name Card Student Workbook Student Materials Compact Disc Course Evaluation

4 Prerequisites Experience Using a Microsoft Windows Operating System Understanding of Basic Relational Database Concepts Familiarity with the Role of the Database Administrator

5 Course Outline Module 1: Introduction to Transact-SQL Module 2: Using Transact-SQL Querying Tools Module 3: Retrieving Data Module 4: Grouping and Summarizing Data Module 5: Joining Multiple Tables

6 Course Outline ( continued ) Module 6: Working with Subqueries Module 7: Modifying Data Module 8: Querying Full-Text Indexes Module 9: Introduction to Programming Objects

7 Appendices Appendix A: Library Database Case Study Appendix B: Database Schemas

8 Microsoft Official Curriculum Microsoft Windows Operating Systems Microsoft Office Microsoft BackOffice Small Business Server Microsoft SQL Server Microsoft Exchange Microsoft BackOffice Server Infrastructure and Solutions Microsoft FrontPage Microsoft Systems Management Server Knowledge Management Solutions

9 Microsoft Certified Professional Program Microsoft Certified Systems Engineer (MCSE) Microsoft Certified Database Administrator (MCDBA) Microsoft Certified Solution Developer (MCSD) Microsoft Certified Professional + Site Building (MCP + Site Building) Microsoft Certified Professional (MCP) Microsoft Certified Trainer (MCT)

10 Facilities Building Hours Parking Rest Rooms Meals Phones Messages Smoking Recycling Class Hours