CCIS2786 SQL Server - System Administration
This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot Microsoft SQL Server client/server database management system.
Course Requirements and Evaluation
Refer to Course Syllabus for detailed information regarding the requirements and evaluation standards for this course. The Course Syllabus will be distributed the first week of the course.
Learning Outcomes
The following outcomes will be addressed in the course:
Interpret SQL server data engine and service processes
Interpret relational database architecture
Install SQL server database
Configure SQL server database
Manage file space allocation
Create SQL server database and file structure
Demonstrate database security
Demonstrate database maintenance
Manage user and groups
Perform Bulk Copy of database
Create Data Transformation Services
Create performance monitoring and tuning
Perform database backup and restore
Text and References
A list of textbooks required for this course is available at the bookstore.
Course Scheduling
The scheduled hours of instruction include sixteen hours for each lecture credit, thirty two hours for each lab credit and forty hours for each credit of supervised occupational experience (SOE). Lecture credit may include formal or impromptu lectures, demonstrations or discussions with the entire class or with small groups or individuals. Refer to the Credit Details section of this course outline for the credit breakdown.
Accommodations Statement
Disability Services assists students with disabilities who need accommodations to access programs, services and college activities. If this applies to you, please contact the DS Office on your campus to initiate the accommodations process.
Brooklyn Park Campus - 763-488-2477
Eden Prairie Campus – 952-995-1544
Campus
Eden Prairie Campus
952-995-1300
Credit Details