St. Xavier's Catholic College of Engineering

COURSE OVERVIEW:

This course engages students to analyze complex business scenarios and create a data model-a conceptual representation of an organization’s information.

 

COURSE OBJECTIVES:

Participants implement their database design by creating a physical database using SQL. Basic SQL syntax and the rules for constructing valid SQL statements are reviewed. This course culminates with a project that challenges students to design, implement, and demonstrate a database solution for a business or organization.

 

PRE-REQUISITE KNOWLEDGE/SKILLS:

Basic Computer Knowledge

 

COURSE MODULE:

DATABASE DESIGN:

 

Module 1: Introduction

Module 2: Entities and Attributes

Module 3: Relationship Basics

Module 4: Super/Sub Types and Business Rules

Module 5: Relationship Fundamentals

Module 6: UIDs and Normalization

Module 7: Arcs, Hierarchies, and Recursive Modeling

Module 8: Changes and Historical Modeling

Module 9: Mapping

Module 10: Creating Database Projects

Module 11: Presenting Database Projects

 

DATABASE PROGRAMMING WITH SQL:

 

Module 1: Introduction

Module 2: SELECT and WHERE

Module 3: Intro to Functions

Module 4: Single Row Functions Part I

Module 5: Single Row Functions Part II

Module 6: JOINs Part I

Module 7: JOINs Part II

Module 8: Group Functions Part I

Module 9: Group Functions Part II

Module 10: Subqueries

Module 11: Ensuring Quality Queries Part I

Module 12: DML

Module 13: DDL

Module 14: Constraints

Module 15: Views

Module 16: Sequences and Synonyms

Module 17: Privileges and Regular Expressions

Module 18: TCL

Module 19: Final Project

Module 20: Ensuring Quality Queries Part II

 

PROJECT WORK

Participants are required to do a project work as a part of the program. The project work should be done in groups, with 4 or 5 participants in a group

 

ASSESSMENT CERTIFICATION:

Online Exam

 

CERTIFICATE:

On successful completion of the assessments in the course, the student will be eligible for a certificate.