Relational database concepts are introduced. Topics covered are data modeling using ER diagrams and normalization, database creation in Microsoft SQL Server. Students will use Structure Query Language (SQL) creating tables, views, stored procedures and triggers, and selection. Database Administration concepts include security, backup and restore. Students completing this course will be prepared to take the Microsoft Technology Associate Database Fundamentals Exam.
Textbook info is available at http://www.bhc.edu/on-campus/bookstore/ You will need to know the BHC course number, e.g. BL 201, and section number.
Upon successful completion of this course, the student shall be able to: A. Design a data model based on user requirements. B. Normalize tables to 3NF (third normal form). C. Create quies using SQL. D. Create complex queries using SQL. B. Design and build database using SQL Server. E. Explain the concepts of transactions and concurrency control. F. Describe and use objects in SQL Server database. G. Implement security in SQL Server. H. Understand SQL Server administration. I. Enforce data integrity using constraints, defaults, and rules.
Black Hawk College: 6600 34th Ave Moline, IL 61265 Phone: 3097965000