COP 3710 Intro. to Data Engineering - 3 credit(s)

print[↑]
Florida Gulf Coast University
U.A. Whitaker College of Engineering
Department of Computing & Software Engineering

Course Catalog Description

This course covers database design and applications of database management systems in software development. It includes relational database management systems (RDBMS) and SQL, and how databases are accessed in computer programs. It also covers different data formats, i.e. XML, JSON, etc. This course will also introduce to students the application of NoSQL systems. It will explore topics related to data analysis.

Prerequisites

COP 3530 for level Undergraduate with minimum grade of C

Required Material

Textbook:

Database System Concepts 7th Edition by Abraham Silberschatz, ISBN: 9780078022159

Software

Learning Outcomes

Upon successful completion of this course, the student will be able to:
  • Understand the principles behind the relational data model and basic information storage & retrieval (IS&R) concepts.
  • Understand the principles of RDBMS including normalization, relational data models, and ACID.
  • Create data flows to extract and load information from text data sources onto a database.
  • Be able to write and perform DDL & DML SQL Queries using both programing interfaces & database interfaces directly to support searching & retrieving information needs.
  • Build backend systems which support the building of software and information applications.
  • Understand the basic principles of Big Data and other data systems (data frames, SaaS, Warehouses) and the differences between them and relational databases.

Instructional Methods

This is a face-to-face course with lectures, instructor led programming examples, and in-class labs.

Attendance

Attendance is mandatory for all classes. Attendance will be taken and will count towards participation credit. Students should notify me at least 48 hours in advance of intent to miss a class to arrange alternate schedules for in-class assignments.

Communication:

All course related communication should be via Canvas message. Each student is responsible for checking his/her FGCU email at least once a day. The instructor will respond to your emails within 24 hours except weekends and holidays.

Topics / Tentative Schedule

  • Intro to Relational Model
  • Intro to SQL
  • Intermediate SQL
  • Exam 1
  • Database Design Using the E-R Model
  • Relational Database Design
  • Advanced SQL
  • Intro to Python w/SQL
  • Python UI Programming
  • Database Application Development
  • Exam 2
  • Group Project Demonstrations

Assessment

There is no grace period for late submission of assignments. All assignments with due dates and times will be posted on Canvas. Alternate schedules can be arranged ahead of time with instructor approval.

Working Independently:

Students are to work independently on all non-group assignments. It is cheating to see other classmate's work or let other classmates see yours. This does not mean you cannot assist or discuss assignments with your classmates.

*** IMPORTANT ***

Student submissions that contain work from another student or source will receive a zero for that assignment. A second occurrence will result in failing the class, and the academic sanction will be reported to the Dean of Students.

Assignments (45%):

Individual problems and small programs worked outside of class.

Exams (30%):

Written exams taken in class.

Group Project (15%):

Group project is a small database application with backend database and frontend user interface.

Participation (10%):

In class quizzes and labs, attendance, and overall participation.

Grading

GRADE GPA Range
 A  4.00 93 - 100
 A-  3.75 90 - 92
 B+ 3.25 87 -  89
 B  3.00 83 -  86
 B- 2.75 80 -  82
 C+ 2.25 77 -  79
 C  2.00 70 -  76
 D  1.00 60 -  69
 F  0.00  0 -  59

University Resources and Syllabus Policies