Southern Utah University

Course Syllabus

Southern Utah University
Southern Utah University
Fall Semester 2025

Data Management and Organization (Online)

ANLY 6250-B70

Course: ANLY 6250-B70
Credits: 3
Term: Fall Semester 2025
Department: MESA
CRN: 30154

Course Description

This course will provide an introduction to the management and organization of data, with a particular emphasis on the current database tools for industry analytics. Students will learn how to develop a successful data strategy in order to create business value from data assets. This course will have a heavy focus on developing and understanding Structured Query Language (SQL) in order to retrieve and analyze data from relational databases. Other topics include the logical structure of databases as well as the methods and technology for efficient data storage, retrieval, and presentation.
(Fall) [Graded (Standard Letter)] 

Required Texts

Readings (e.g. articles, canvas pages, online content) as assigned by the instructor found in each module on Canvas.

Required Software

https://dbeaver.io/download/ DBMS tool with SQLite database
https://console.cloud.google.com/ Google BigQuery
https://sqlbolt.com/  Practice SQL coding
Text editor of your choice (notepad ++, notepad, even MS word)

Learning Outcomes

1. Work with database management systems’ graphical user interface and SQL development tools
2. Identify classes/entities of data, their attributes, and relationships
3. Build and optimize queries for data definition, manipulation, and retrieval to prepare data for analysis
4. Effectively present database query results as summary tables, graphs and dashboards
5. Design the logical and physical structure of a relational database for efficient data storage
6. Build advanced analytical functions and choose advanced techniques for data analysis
7. Choose data management, administration plans, and a data strategy using data governance principles

Course Requirements

Individual Homework Assignments
Students will be assigned individual homework assignments or analyses throughout the course. These assignments will include tasks designed to introduce and expand knowledge of data management and organizations.  While it is acceptable to discuss aspects of the homework and solution strategy with others, students' submissions should represent their own work. For instance, it would be acceptable to ask for help if you keep getting an error message in SQL, but it would be unacceptable to take someone else’s SQL script, run it, and report the results. When in doubt, consult the professor.  Assignments should be submitted online by the due date and time, a 20% reduction in points will be given for late work.  No late work will be accepted after a solution is posted.  Students will be allowed to make multiple attempts on assignments.

COURSE PRACTICE ACTIVITIES
For each module (7 total) in the course, students will be given the opportunity to complete a relevant course practice activity covering material from that particular module. These activities are ungraded, do not require a submission, and a solution will be provided so students can check their work. The purpose of the activities are to provide further learning before completing the scored assignments.

Quizzes and Tests
Each module will have an accompanying quiz to test student knowledge of the material (7 total quizzes across the course).   A mid-term test will be taken during module 4 and a course final test will be taken during module 7. Quizzes and tests are open note, open book, and even open Google. However, students may not work with others on these quizzes, either students registered for the class or others outside the class.  Quizzes and tests will have a time limit and will be taken with only 1 attempt.

Course Activities
For each module (7 total) in the course, students will be asked to complete a relevant course activity covering material from that particular module.   These activities will be submitted via Canvas as with the individual assignments, though these activities are designed to be shorter and address a particular task of the module. (For example, developing a piece of SQL using a specific function.)

Course Project
Students will form teams and identify datasets the team wish to investigate using the discussed database methods and visualization techniques.  This project will be developed throughout the course, with a final presentation on what the team found.   While emphasis will be placed on technical skills during development of the project, particular emphasis will be placed on coherent and accurate insights and analysis in the form of a presentation to non-technical audience.

Course Outline

Module 1: Introduction to Database Management Systems and Relational Databases
Module 2: Introduction to SQL
Module 3: Joins, Relationships, and Data Definition Language (DDL)
Module 4: Database Design
Module 5: Cloud Databases and Data Movement
Module 6: Analytic Functions and Advanced Techniques
Module 7: Data organization and strategy

Instructor's policies on late assignments and/or makeup work

Late Policy
If an assignment is late but submitted before the sample answer key is posted, it will be graded but with a 20% penalty. If an assignment is submitted after the answer key is posted, it will receive a zero

Make-Up Work / Extra Credit
Make-up work will be considered, but not guaranteed, on a case-by-case basis.  Email the professor if needed.  Some extra credit may be possible throughout the course at the professor's discretion.

Attendance Policy

As this is an asynchronous online course, your attendance will be measured by your participation and completion of course activities.
Optional "SQL Saturdays" or Office Hours will be conducted over Zoom

Course Fees

Content for this section will be provided by the instructor.

ADA Statement

Students with medical, psychological, learning, or other disabilities desiring academic adjustments, accommodations, or auxiliary aids will need to contact the Disability Resource Center, located in Room 206F of the Sharwan Smith Center or by phone at (435) 865-8042. The Disability Resource Center determines eligibility for and authorizes the provision of services.

If your instructor requires attendance, you may need to seek an ADA accommodation to request an exception to this attendance policy. Please contact the Disability Resource Center to determine what, if any, ADA accommodations are reasonable and appropriate.

Academic Credit

According to the federal definition of a Carnegie credit hour: A credit hour of work is the equivalent of approximately 60 minutes of class time or independent study work. A minimum of 45 hours of work by each student is required for each unit of credit. Credit is earned only when course requirements are met. One (1) credit hour is equivalent to 15 contact hours of lecture, discussion, testing, evaluation, or seminar, as well as 30 hours of student homework. An equivalent amount of work is expected for laboratory work, internships, practica, studio, and other academic work leading to the awarding of credit hours. Credit granted for individual courses, labs, or studio classes ranges from 0.5 to 15 credit hours per semester.

Academic Freedom

SUU is operated for the common good of the greater community it serves. The common good depends upon the free search for truth and its free exposition. Academic Freedom is the right of faculty to study, discuss, investigate, teach, and publish. Academic Freedom is essential to these purposes and applies to both teaching and research.

Academic Freedom in the realm of teaching is fundamental for the protection of the rights of the faculty member and of you, the student, with respect to the free pursuit of learning and discovery. Faculty members possess the right to full freedom in the classroom in discussing their subjects. They may present any controversial material relevant to their courses and their intended learning outcomes, but they shall take care not to introduce into their teaching controversial materials which have no relation to the subject being taught or the intended learning outcomes for the course.

As such, students enrolled in any course at SUU may encounter topics, perspectives, and ideas that are unfamiliar or controversial, with the educational intent of providing a meaningful learning environment that fosters your growth and development. These parameters related to Academic Freedom are included in SUU Policy 6.6.

Academic Misconduct

Scholastic honesty is expected of all students. Dishonesty will not be tolerated and will be prosecuted to the fullest extent (see SUU Policy 6.33). You are expected to have read and understood the current SUU student conduct code (SUU Policy 11.2) regarding student responsibilities and rights, the intellectual property policy (SUU Policy 5.52), information about procedures, and what constitutes acceptable behavior.

Please Note: The use of websites or services that sell essays is a violation of these policies; likewise, the use of websites or services that provide answers to assignments, quizzes, or tests is also a violation of these policies. Regarding the use of Generative Artificial Intelligence (AI), you should check with your individual course instructor.

Emergency Management Statement

In case of an emergency, the University's Emergency Notification System (ENS) will be activated. Students are encouraged to maintain updated contact information using the link on the homepage of the mySUU portal. In addition, students are encouraged to familiarize themselves with the Emergency Response Protocols posted in each classroom. Detailed information about the University's emergency management plan can be found at https://www.suu.edu/emergency.

HEOA Compliance Statement

For a full set of Higher Education Opportunity Act (HEOA) compliance statements, please visit https://www.suu.edu/heoa. The sharing of copyrighted material through peer-to-peer (P2P) file sharing, except as provided under U.S. copyright law, is prohibited by law; additional information can be found at https://my.suu.edu/help/article/1096/heoa-compliance-plan.

You are also expected to comply with policies regarding intellectual property (SUU Policy 5.52) and copyright (SUU Policy 5.54).

Mandatory Reporting

University policy (SUU Policy 5.60) requires instructors to report disclosures received from students that indicate they have been subjected to sexual misconduct/harassment. The University defines sexual harassment consistent with Federal Regulations (34 C.F.R. Part 106, Subpart D) to include quid pro quo, hostile environment harassment, sexual assault, dating violence, domestic violence, and stalking. When students communicate this information to an instructor in-person, by email, or within writing assignments, the instructor will report that to the Title IX Coordinator to ensure students receive support from the Title IX Office. A reporting form is available at https://cm.maxient.com/reportingform.php?SouthernUtahUniv

Non-Discrimination Statement

SUU is committed to fostering an inclusive community of lifelong learners and believes our university's encompassing of different views, beliefs, and identities makes us stronger, more innovative, and better prepared for the global society.

SUU does not discriminate on the basis of race, religion, color, national origin, citizenship, sex (including sex discrimination and sexual harassment), sexual orientation, gender identity, age, ancestry, disability status, pregnancy, pregnancy-related conditions, genetic information, military status, veteran status, or other bases protected by applicable law in employment, treatment, admission, access to educational programs and activities, or other University benefits or services.

SUU strives to cultivate a campus environment that encourages freedom of expression from diverse viewpoints. We encourage all to dialogue within a spirit of respect, civility, and decency.

For additional information on non-discrimination, please see SUU Policy 5.27 and/or visit https://www.suu.edu/nondiscrimination.

Pregnancy

Students who are or become pregnant during this course may receive reasonable modifications to facilitate continued access and participation in the course. Pregnancy and related conditions are broadly defined to include pregnancy, childbirth, termination of pregnancy, lactation, related medical conditions, and recovery. To obtain reasonable modifications, please make a request to title9@suu.edu. To learn more visit: https://www.suu.edu/titleix/pregnancy.html.

Disclaimer Statement

Information contained in this syllabus, other than the grading, late assignments, makeup work, and attendance policies, may be subject to change with advance notice, as deemed appropriate by the instructor.