ITCS 1170 - Database Design & Implementation With SQL
Credit Hours: 4.00
Prerequisites: ITCS 1140 or ITCS 1950 ; and ITCS 1010
No credit after ITCS 2280. ITCS 1170 familiarizes students with database usage, design, and implementation. It also explores fundamentals of Structured Query Language (SQL).
Billable Contact Hours: 4
Search for Sections
OUTCOMES AND OBJECTIVES
Outcome 1: Upon completion of this course, students will be able to outline the various database types and applications as it pertains to common industry usage.
- Use appropriate terms, concepts, and examples.
- Explain the various types of databases.
- Describe end user interaction with databases.
- Describe database maintenance.
Outcome 2: Upon completion of this course, students will be able to model or design a simple transaction processing database system utilizing the relational database model.
- Identify entities, attributes, and relationships for a case scenario.
- Normalize entities to third normal form.
- Create an entity relationship diagram based on a set of normalized entities or software package.
Outcome 3: Upon completion of this course, students will be able to apply techniques for constructing a basic SQL statement, multi-table query, and using server-side database administration commands.
- Construct a single-table query.
- Create a database schema using DDL statements.
- Construct multi-table queries utilizing various join methods.
- Construct both DDL and Outcome
- Determine which server-side database administration commands are needed.
COMMON DEGREE OUTCOMES (CDO)
• Communication: The graduate can communicate effectively for the intended purpose and audience.
• Critical Thinking: The graduate can make informed decisions after analyzing information or evidence related to the issue.
• Global Literacy: The graduate can analyze human behavior or experiences through cultural, social, political, or economic perspectives.
• Information Literacy: The graduate can responsibly use information gathered from a variety of formats in order to complete a task.
• Quantitative Reasoning: The graduate can apply quantitative methods or evidence to solve problems or make judgments.
• Scientific Literacy: The graduate can produce or interpret scientific information presented in a variety of formats.
CDO marked YES apply to this course:
Critical Thinking: YES
Information Literacy: YES
Quantitative Reasoning: YES
COURSE CONTENT OUTLINE
- Introducing Databases and Database Management Systems
- Designing a Database
- Implementing a Database using SQL
- Data Access and Manipulation using SQL
- Data Access and Security
- Database Processing for Business Intelligence Systems
Official Course Syllabus - Macomb Community College, 14500 E 12 Mile Road, Warren, MI 48088
Add to Favorites (opens a new window)