May 02, 2024  
OHIO University Undergraduate Catalog 2022-23 
    
Catalog Navigation
  Catalog Home
  Vision, Mission, and History
  Diversity and Inclusion Commitment
  Advising
  Academic Calendar
  Academic Policies
  Admissions
  Fees and Financial Aid
  General Information
  Graduation Requirements – Universitywide
  OHIO BRICKS
  Services for Students
  Arts and Sciences
  Business
  Communication
  Education
  Engineering and Technology
  Fine Arts
  Health Sciences and Professions
  Honors Tutorial
  International Studies
  Leadership and Public Service
  University College
  OHIO Online/eCampus
  Regional Higher Education
  Course Descriptions
  Course Information
  Curricula – Certificates, Major Programs, Minors
  Departments and Schools
  Faculty
  Major, Minor, and Certificate Codes
  Abbreviations
  University Contacts
  Notice of Non-Discrimination and Title IX Coordinator Contact Information
  Copyright and Disclaimer
  My Portfolio
HELP
OHIO University Undergraduate Catalog 2022-23 [Archived Catalog]

Facebook this Page (opens a new window)
Tweet this Page (opens a new window)
Add to Portfolio (opens a new window)

ETM 3310 - Database Applications & Analytics

Teaches students relational database fundamentals, SQL programming skills, and simple database analytics. Includes principles of database design techniques and implementations. Upon completion, students will understand SQL functions, interfacing with an object oriented programming language, and will be able to write SELECT, INSERT, UPDATE, and DELETE statements. Extensive hands on exercises are used throughout the course to reinforce the material using Windows Forms and ASP.NET.

Requisites: ETM 3030 and advanced standing in ETM
Credit Hours: 3
Repeat/Retake Information: May be retaken two times excluding withdrawals, but only last course taken counts.
Lecture/Lab Hours: 2.0 lecture, 2.0 laboratory
Grades: Eligible Grades: A-F,WP,WF,WN,FN,AU,I
Learning Outcomes:
  • Students will be able to list and explain the fundamental concepts of a relational database system.
  • Students will be able to design and create database tables in Access and Microsoft SQL .
  • Students will be able to design and create database tables in Access and Microsoft SQL.
  • Students will be able to explain the role of the database administrator.
  • Students will be able to identify and develop various Database Management Systems (DBMS).
  • Students will be able to manipulate a database using SQL to retrieve, store, modify, delete, insert and update data.
  • Students will be able to design and create customs forms in Access, Windows C# and ASP websites.
  • Students will be able to imports and export data between Excel, Access, and Microsoft SQL server using Windows C#.
  • Students will be able to implement an inventory control database using ASP website.
  • Students will be able to display a database table in a DataGridView control and write applications that display, sort and update database data.
  • Students will be able to interface AutoID technology with Windows C# applications and ASP Websites.
  • Students will be able to create a data logger application with computer hardware to collect and log data to a database.


Facebook this Page (opens a new window)
Tweet this Page (opens a new window)
Add to Portfolio (opens a new window)