Advanced Business Programming

Overall Aims of Course

This is an advanced course in computer programming applied to business using Visual Basic 2008.NET. It is built on the prerequisite course "Introduction to Business Programming - MIS311". This course focus on Object-Oriented terminology, Windows Database Applications, Windows Database using Related Tables, Windows Database Updates, the WCF Services, Web Applications, Web Database Applications, and Reports. In addition, this course is developed in a logical fashion that is based on the software development life cycle. This makes it easy for students to relate the topics to each other along one logical line. The theoretical material in this course is supplemented by some lab components. These labs provide hands-on training for students and link to Business applications.

Course Objectives

Students who successfully complete this course will be able to:

¤Apply and develop object oriented code.

¤Build multitier programs with classes.

¤Explain the relationship of datasets, tables, rows, and constraints.

¤Retrieve and display data from a SQL Server database on Windows Forms.

¤Perform updates on Windows Database.

¤Create a WCF Service; add a service reference to a Windows project.

¤Discuss concepts of Web-based applications.

¤Display and update database files in Web applications.

¤Create a Crystal Reports template and display the report from a Windows Form or a Web Form.

¤Use advanced reporting features, such as numeric functions, grouping, sorting, and special fields.

¤Create a collection of objects and add and remove items in the collection.

Course Syllabus