Click Here for the Outline in PDF Version Course Outline: Microsoft SQL Server 7.0: Database Design (5 Days) with Hands-On Labs Learning Objectives Discover and Identify the features of SQL Server 7.0 Understand how to use Transact-SQL to query their databases Create and manage tables Implement data integrity techniques Design and implement indexes Query multiple tables through the use of joins Design subqueries Use aggregate functions in queries Create and manage views Design and implement stored procedures Learn to create triggers Manage transactions and locks Implement queries across multiple servers This course description should be used to determine whether the course is appropriate for you based on your current skill and technical training needs. Technical information is provided on the intended audience, course prerequisites, and covered topics. Course content, prices, and availability are subject to change without notice. Course Audience Students enrolling in this course should be able to complete the tasks necessary to implement and administer a Windows NT Server 4.0 domain and should be familiar with relational database concepts. Course Description Students will learn how to implement databases in Microsoft SQL Server 7.0. Students will learn how to design, create, and manage databases and their objects in Microsoft SQL Server 7.0. In addition, students will learn how to use the Transact-SQL language to retrieve and manipulate data from SQL Server. Course Objectives At course completion the student will be able to perform the following tasks: Discover and Identify the features of SQL Server 7.0 Understand how to use Transact-SQL to query their databases Create and manage tables Implement data integrity techniques Design and implement indexes Query multiple tables through the use of joins Design subqueries Use aggregate functions in queries Create and manage views Design and implement stored procedures Learn to create triggers Manage transactions and locks Implement queries across multiple servers Install and use Microsoft Search Service and Microsoft English Query Prerequisites Ziff-Davis Education’s course Windows NT 4.0: System Architecture and Network Support or equivalent knowledge. In addition, students should have experience working with relational databases and an understanding of basic SQL statements. TOPICS COVERED IN LECTURE & LAB An Overview of SQL Server Exploring the features of SQL Server SQL Server database structure The SQL Server architecture Identifying SQL Server management tasks Exploring Transact-SQL What is Transact-SQL? Transact-SQL statements Programming in Transact-SQL Designing and implementing databases Identifying database design issues Creating databases Maintaining databases Creating and managing tables Creating tables Maintaining tables Scripting tables Designing data integrity Understanding data integrity Implementing constraints Implementing indexes Designing indexing Implementing indexes Maintaining indexes Joining tables Querying multiple tables Implementing advanced table joins Advanced queries Designing subqueries Changing data through queries Using functions Working with aggregate functions Designing views Creating and managing views Creating stored procedures Designing stored procedures Creating stored procedures Using parameters in stored procedures Managing stored procedures Creating triggers Designing triggers Creating and managing triggers Understanding transactions and locks Working with transactions Working with locks Implementing distributed queries Establishing linked servers Creating and managing distributed queries Designing advanced queries Implementing the Microsoft Search Service Using Microsoft English Query

Policy