- SQL Server 2000 with Transact-SQL. - Module 1: Introduction to Transact-SQL Overview...1. - The Transact-SQL Programming Language ...2. - Types of Transact-SQL Statements ...3. - Transact-SQL Syntax Elements ...7. - Lab A: Using SQL Server Books Online...29. - Module 2: Using Transact-SQL Querying Tools Overview...1. - Executing Transact-SQL Statements ...8. - Lab A: Creating and Executing Transact-SQL Scripts ...15. - iv Querying Microsoft SQL Server 2000 with Transact-SQL. - Introduction to Subqueries. - Lab A: Working with Subqueries. - Module 8: Querying Full-Text Indexes Overview. - Introduction to Microsoft Search Service. - Lab A: Querying Full-Text Indexes. - Module 9: Introduction to Programming Objects. - Introduction to Views ...4. - Introduction to Stored Procedures...12. - Introduction to Triggers ...15. - Introduction to User-defined Functions ...16. - About This Course. - This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft ® SQL Server ™ 2000.. - The course content reflects the need to focus on querying with Transact-SQL. - The material comes primarily from course 833, Implementing a Database Design Using Microsoft SQL Server 7.0.. - This new course is a prerequisite for course 2073A, Programming a Microsoft SQL Server 2000 Database and course 2072A, Administering a Microsoft SQL Server 2000 Database.. - This course is designed for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.. - This course requires that students meet the following prerequisites:. - viii Querying Microsoft SQL Server 2000 with Transact-SQL. - Describe the uses of and ways to execute the Transact-SQL language.. - Group and summarize data using Transact-SQL.. - 9:00 10:00 Module 1: Introduction to Transact-SQL Lab A: Using SQL Server Books Online Break. - Module 2: Using Transact-SQL Querying Tools Lab A: Creating and Executing Transact-SQL Scripts Module 3: Retrieving Data. - 3:00 4:00 Module 9: Introduction to Programming Objects 4:00 4:30 Lab A: Working with Views. - x Querying Microsoft SQL Server 2000 with Transact-SQL. - Trainer Materials Compact Disc Contents. - The Trainer Materials compact disc contains the following files and folders:. - It contains the steps for manually installing the classroom computers.. - This folder contains a template that is used to record any errors and corrections that you find in the course.. - This folder contains fonts that are required to view the Microsoft PowerPoint ® presentation and Web-based materials.. - This folder contains files that are required to install Microsoft Windows Media Player.. - This folder contains the PowerPoint slides that are used in this course.. - This folder contains the PowerPoint Viewer, which is used to display the PowerPoint slides.. - This folder contains the Web page that provides students with links to resources pertaining to this course, including additional reading, review and lab answers, lab files, multimedia presentations, and course-related Web sites.. - This folder contains the Trainer Preparation Presentation, a narrated slide show that explains the instructional strategy for the course and presentation tips and caveats. - The Student Materials compact disc contains the following files and folders:. - This folder contains additional reading pertaining to this course. - If there are no additional reading files, this folder does not appear.. - This folder contains answers to the module review questions and hands-on labs.. - This folder contains appendix files for this course. - If there are no appendix files, this folder does not appear.. - This folder contains batch files and scripts for modules and lab setup.. - This folder contains scripts that are used in the modules.. - This folder contains fonts that are required to view the PowerPoint presentation and Web-based materials.. - This folder contains files that are used in the hands-on labs. - This folder contains files that are used in multimedia presentations for this course. - If this course does not include any multimedia presentations, this folder does not appear.. - This folder contains the files that are required to view the course Web page. - This folder contains the Word Viewer that is used to view any Word document (.doc) files that are included on the compact disc. - If no Word documents are included, this folder does not appear.. - xii Querying Microsoft SQL Server 2000 with Transact-SQL
Xem thử không khả dụng, vui lòng xem tại trang nguồn hoặc xem
Tóm tắt