Syllabus
This is a blended course that meets in Bldg. 13, Room 105

Course Name: Data Integration and Manipulation
Term: Fall 2018
Course Number: ISM 4138C
Session: 4

Table of Contents

Faculty Contact Information Schedule and Course Activities
Course Description and Purpose Grading and Instructions for Course Activities
General Course Outcomes Attendance and Participation Policies
Prerequisites & Co-requisites Communication Practices
Textbook and Course Materials General Policies and Technical Requirements
Methods of Instruction (Course Structure)  

Faculty Contact Information

Instructor Name: Prof. Fenick
Office Phone: 954-201-6698
Department Phone: 954-201-6723
Email: Please use mfenick@broward.edu to reach me.
Office Hours: TBA
BC Safety Phone #: 954-201-HELP (4357)

Return to Table of Contents

Course Description and Purpose

In this course, students extract data from a wide variety of data sources, such as files and relational data sources, perform data integration and transformation solutions, and load data into single or multiple destinations including data warehouses. Students will solve data integration business problems using best practices and troubleshooting techniques. This will prepare students for the Alteryx Designer Core Certification.

Return to Table of Contents

General Course Outcomes

1.0 The student shall be able to read and write from multiple data sources.

2.0 The student shall be able to parse data from multiple sources

3.0 The student shall be able to load data from multiple sources at once.

4.0 The student shall be able to join data sets and write to multiple data files grouped by key fields.

 

Return to Table of Contents

Prerequisites & Co-requisites

To maximize your chances for success in this course, make sure that you meet the following course prerequisites:

Return to Table of Contents

Textbook and Course Materials

Textbook and Material Information

Learning Alteryx: A beginner's guide to using Alteryx for self-service analytics and business intelligence

Baruti, Renato

  • Paperback: 228 pages
  • Publisher: Packt Publishing
  • Language: English
  • ISBN-10: 1788392655
  • ISBN-13: 978-1788392655

 

Return to Table of Contents

Methods of Instruction (Course Structure)

This is a credit hour blended course. In this class, you will attend on-campus classes plus engage in structured out-of-class and online activities. The online and in-class activities may include, but are not limited to, readings, discussions, essays, case studies, research, and/or online quizzes and tests. See the course activity schedule for a detailed description of activities. Students are responsible for regularly reviewing the activity schedule and completing all required assignments including quizzes and participating in discussions.

There will be times during class where you may be asked to watch a video or read an article prior to attending class. This will be part of the class discussion and you may be asked to work in a group. Students who are ready for class generally are more successful in the course. Always check a rubric to see how you will be graded.

Return to Table of Contents

Schedule and Class Activities

Read and refer to this section regularly. It will provide you with an in-class and online schedule of due dates. Deadlines for assignments, assessments, discussions, quizzes, tests, and all other graded and non-graded activities are posted in the course schedule. Submitting work late will be permitted only under extenuating circumstances and only with prior notification and documentation (original funeral notice, original doctor note, etc.).

Class Activities Schedule

 

Meeting Dates

 

Specific Learning Outcomes Readings Activities, Assignments & Assessments

Week 1

Thursday, October 18, 2018

 

By the end of this lesson, you will be able to:

1.1 Retrieving, restrict and sort Data
1.2 Describe the features of a relational database
1.3 Interpret a database diagram

Orientation to the course

1. Orientation to class
2. Review of syllabus
3. Login and Navigate Apex (Oracle)
4. Overview of database concepts

Week 2
Thursday, October 25, 2018


By the end of this lesson, you will be able to:

2.1 Describe the value of functions within a SQL query
2.2 Use character, number, and date functions in SELECT statements
2.3 Apply conversion functions that are available in SQL
2.4 Apply conditional expressions in a SELECT statement

Orientation

CH 2: Basic SQL SELECT Statements

Before class:

Read Chapter 2

In class:

1. Practice queries

Online/Out of class:

  1. Read CH 8
  2. Assignment 1
  3. Quiz 1

 

Dates & Units Specific Learning Outcomes Readings Activities, Assignments & Assessments

Week 3

Thursday, November 1, 2018

 By the end of this lesson, you will be able to:

3.1 Describe the types of reports that use grouping
3.2 Group data by using the GROUP BY clause
3.3 Include or exclude grouped rows by using the HAVING clause
3.4 Write SELECT statements to access data using inner, outer, and self joins

CH 8: Restricting Rows and Sorting Data

Before class: Read Chapter 8

In class: Practice queries

Online/Out of class:

  1. Read CH 9
  2. Assignment 2
  3. Quiz 2
Dates & Units Specific Learning Outcomes Readings Activities, Assignments & Assessments

Week 4

Thursday, November 8, 2018


By the end of this lesson, you will be able to:

4.1 Describe the types of problems that subqueries can solve
4.2 Use subqueries to solve problems
4.3 Use a set operator to combine multiple queries into a single query
4.4 Control the order of rows returned

CH 9: Joining Data from Multiple Tables

Before class:

Read chapter 9

In Class: In class lab

Online/Out of class

  1. Read CH 8
  2. Assignment 3
  3. Quiz 3
Dates & Units Specific Learning Outcomes Readings Activities, Assignments & Assessments

Week 5

 

Thursday, November 15, 2018

 

By the end of this lesson, you will be able to:

5.1 Insert, update, and delete data 


CH 10: Selected Single-Row Functions

Before class:

 Read chapter 10

In Class: In class lab

Online/Out of class:

  1. Read CH 11
  2. Assignment 4
  3. Quiz 4
Dates & Units Specific Learning Outcomes Readings Activities, Assignments & Assessments

Week 6

Thursday, November 22, 2018

 


By the end of this lesson, you will be able to:

5.2 Explain the table structure
5.3 Describe available data types
5.4 Create, modify, and delete tables

CH 11: Group Functions

Before class:

 Read Chapter 11

In Class:

In class lab

Online/Out of class:

  1. Read CH 12
  2. Assignment 5
  3. Quiz 5

 

Dates & Units Specific Learning Outcomes Readings Activities, Assignments & Assessments

Week 7

Thursday, November 29, 2018

 

Oracle 1Z0-071 SQL Exam Prep

 CH 12: Subqueries and MERGE Statements

Before class:

 Practice Exams

In Class: In class lab

 

Online/Out of class:

  1. Assignment 6
  2. Quiz 6
Dates & Units Specific Learning Outcomes Readings Activities, Assignments & Assessments

Week 8

Thursday, December 6, 2018

Oracle 1Z0-071 SQL Exam Prep

 Practice Exams

Before class:  Practice Exams

In Class:  Cert Exam

Online/Out of class:  Practice Exam

 

Return to Table of Contents

Grading and Instructions for Course Activities

Instructions for Discussions (if used):

Instructions for Quizzes:

Instructions for Exercises:

Instructions for Labs:

Grades

How your Grade will be Determined

 

Assessment

Percent of Final Grade

Quizzes 

25%

Exercises 

25%

In Class Labs

25%

Final Certification Exam

25%

Total

100%

Grading Scale

Grades

Percentage

Grade = A

90 - 100+%

Grade = B

80 - 89.9%

Grade = C

70 - 79.9%

Grade = D

60 - 69.9%

Grade = F

59.9% -0.0%

Return to Table of Contents

Attendance and Participation Policies

You must attend class regularly, attendance is mandatory. If you feel like you will not be able to maintain regular attendance, obtain the required course materials and fulfill the course requirements, you should drop the course by the official drop/add deadline or expect to pay for the course..

If you stop participating after the withdrawal date, you will receive an F. To avoid this situation, you should attend class regularly and remain an active learner in the online portion of the class. Always communicate extenuating circumstances to your instructor. Ongoing communication with the instructor is critical to your course success.

Return to Table of Contents

Communication Practices

Communication

Faculty Response

Netiquette

In all online communication, it is expected that all students will follow rules of online "netiquette". Netiquette is a set of rules for polite online behavior that all members of this class are expected to follow. Review some of the general netiquette rules.

Individuals who violate the netiquette policy or engage in disruptive online behaviors such as flaming (posting disrespectful or hostile comments), posting inappropriate comments, or shouting (posting messages using all capitals) may have their class access privileges revoked and/or they may be referred to the Student Dean. Students who continue to engage in unacceptable online behavior even after being warned, may be permanently denied access to the class and/or may receive an F for the class.

Please don't use email short hand like ROTFLO (rolling on the floor laughing out loud) or BTW (by the way) - not everyone knows what these abbreviations mean. If you want to use emoticons (smileys) to convey feelings, please stick with the basics happy :-) sad :-( or wink ;-). Others are less well known and are subject to different interpretations. The idea is to be clear in your communications.

Return to Table of Contents

General Policies & Technical Requirements

You are responsible for being familiar with Broward College policies and procedures. See technical requirements in this section to "ready" your computer for online activities. A 24/7 helpdesk is available to address all technical issues.

Academic Success Centers (ASC)

Academic Honesty

Your academic work must be the result of your own thought, research, or self-expression. Academic misconduct includes, but is not limited to the following: cheating, plagiarism, unacceptable collaboration, falsification of data, aiding and abetting dishonesty, unauthorized or malicious interference, hacking computer property or software, and online disturbances. Please refer to the Student Code of Conduct Policy and the Student Code of Conduct section located in the Student Handbook for more information. All required class activities are subject to submission to Turnitin.com for the detection of plagiarism. All submitted papers will be included as source documents in the Turnitin.com reference database solely for the purpose of detecting plagiarism of such papers.

Types of Academic Dishonesty:

Class Policies

Disability Services

If you need academic accommodations and/or disability services support, you must contact the Office of Disability Services (ODS). It is your responsibility to contact the ODS to document disability prior to receiving services. You must notify the instructor that you have registered with the ODS and provide the instructor a copy of the ODS letter. Your documentation and any related communication with your instructor remain strictly confidential

Technical Requirements

Technical Issues

Return to Table of Contents

//