Course Course Summary Section 1 Content Section 1 Content Left Section 1 Content Right Credit Type: Course ACE ID: UOPX-0074 Organization's ID: CITM 254.1 Organization: University of Phoenix Location: Classroom-based Dates Offered: 9/1/2000 - 9/30/2003 Credit Recommendation & Competencies Section 2 Content Section 2 Content Left Section 2 Content Right Level Credits (SH) Subject Lower-Division Baccalaureate 3 Computer Information Systems and Technology Description Section 3 Content Section 3 Content Left Section 3 Content Right Objective: To provide students with the technical skills that are required to implement a database solution with the Microsoft SQL Server 7.0 relational database management system and to provide preparation for Microsoft Exam 70-029. Learning Outcomes: Understand and describe Microsoft SQL Server architecture, security, databases, design options, implementation activities, and administrative activities Understand and use Transact-SQL for programming and query processing Evaluate database storage considerations Define databases, filegroups, database tables, and indexes as necessary Understand the different types of data integrity and the implementation considerations Demonstrate the creation of database queries including multiple ta Instruction & Assessment Section 4 Content Section 4 Content Left Section 4 Content Right Instructional Strategies: Classroom Exercise Computer Based Training Discussion Laboratory Lectures Supplemental Materials Section 5 Content Section 5 Content Left Section 5 Content Right Section 6 Content Section 6 Content Left Section 6 Content Right Button Content Rail Content 1 Page Content