CIS-215: Advanced Visual Basic.Net Database Programming

This course is INACTIVE
School
Business, Entrepreneurship, & Professional Development
Department
Computer Information Systems
Academic Level
Undergraduate
Course Subject
Computer Information Systems
Course Number
215
Course Title
Advanced Visual Basic.Net Database Programming
Credit Hours
3.00
Instructor Contact Hours Per Semester
62.00 (for 15-week classes)
Student Contact Hours Per Semester
62.00 (for 15-week classes)
Grading Method
A-E
Pre-requisites
(CIS-111 or CIS-270) and CIS-130
Catalog Course Description

This advanced-level course focuses on writing Windows application forms that interface with a database management system using the VB.Net language. Covers using data sources and datasets for Rapid Application Development, three-layer Windows Forms applications, using reporting features of Visual Studio, and how to use LINQ.

Goals, Topics, and Objectives

Core Course Topics
  1. Working with Data Sources and Datasets
  2. Bound Controls and Parameterized Queries
  3. How to use the Dataset Designer
  4. How to work with Connections, Commands, and Data Readers
  5. Parameters and Stored Procedures
  6. Working with Logical Transactions
  7. Binding Controls to Object Data Sources
  8. Using the Reporting Features of Visual Studio
  9. Coding Query Expressions with LINQ
Core Course Learning Objectives (Separated)
  • Compose a Windows Form application using data sources from datasets.
  • * Design and code a Windows Form application using bound controls and parameterized queries.
  • Demonstrate the use of the Dataset Designer to compose a data source to be used by a Windows Form application
  • * Develop business and database classes that utilizes connections, commands and data readers.
  • Create a Windows Form application that references an object data source for its bound controls.
  • Design, code and test a Windows Form application using the reporting features of Visual Studio.
  • Develop a Windows Form application using the LINQ language to work with object data sources and datasets.

Assessment and Requirements

Assessment of Academic Achievement

Quizzes, laboratory assignments and examinations, which involve lab problems.

Approval Dates

Effective Term
Winter 2018
Deactivation Date
12/04/2017
ILT Approval Date
10/18/2017
AALC Approval Date
11/15/2017
Curriculum Committee Approval Date
12/04/2017