Database, Internet, and Systems Integration Technologies

Lecture Notes & Exercises

Most lectures include an in-class exercise. The lecture notes contain a description of the exercise and sample solutions.

Each student must submit 30/35 class activities (case studies and / or in-class exercises) to complete the course. In-class exercises are due after the class. Each class activity is worth 0.33% (for a total of 10%) of the final grade.

LEC #	LECTURE TOPICS	Supporting files for EXCERCISES
1	System process: Introduction (PDF)
2	System process: Fundamentals (PDF)
3	System process: Time and resource estimation, part 1 (PDF)
4	System process: Time and resource estimation, part 2 (PDF)
5	System process: CMMI, ISO (PDF)
6	System process: UML, part 1 (PDF)	UML exercise 1 - input file (VPP) UML exercise 1 - solution (VPP)
7	System process: UML, part 2 (PDF)	UML exercise 2 - input file (VPP) UML exercise 2 - solution (VPP)
8	Database: Data modeling, part 1 (PDF)
9	Database: Data modeling, part 2 (PDF)	Data modeling exercise 2 - input file (VPP)
10	Database: Data normalization (PDF)
11	Database: SQL basics: SELECT, INSERT (PDF)	SQL: Basics, SELECT exercise 1 - input file (SQL) SQL: Basics, SELECT exercise 1 - solution (SQL)
12	Database: SQL lab (PDF)	SQL: Basics, SELECT exercise 2 - solution (SQL)
13	Database: SQL joins, subqueries, views (PDF)	SQL: Joins, views exercise - solution (SQL)
14	Database: SQL homework 5 (PDF)	SQL exercise 1 - input aircraft parts data part 1 (ZIP - 2.2MB) (This ZIP file contains: 1 .mdf file.) & part 2 (ZIP - 3.6MB) (This ZIP file contains: 1 .mdf file.)
15	Database: SQL transactions, connections (PDF)	SQL exercise 2 - input beef data (CSV) & SQL file (SQL)
16	Web: Introduction, HTTP (PDF)
17	Web: XHTML, CSS (PDF)	XHTML, CSS exercise - input data (ZIP) (This ZIP file contains: 2 .jpg files.) XHTML, CSS exercise - solution (ZIP) (This ZIP file contains: 2 folders, 2 .jpg files, 3 .html files and 1 .xml file.)
18	Web: Connecting Web and database (PDF)	Connecting Web and database - input data (ZIP) (This ZIP file contains: 1 folder, 1 .sitemap file and 1 .master file.) Connecting Web and database - solution (ZIP) (This ZIP file contains: 1 folder, 2 .aspx files, 1 .sitemap file and 1 .master file.)
19	Web: Web and database: Forms (PDF)	Web database: Forms and controls exercise 1 - solution (ZIP - 11.5MB) (This ZIP file contains: 2 folders, 5 .aspx files, 1. sitemap file and 1. master file.)
20	Web: Web and database (PDF)	Web database: Forms and controls exercise 2 - solution (ZIP) (This ZIP file contains: 1 folder, 1 .asax file, 9 .aspx files, 1 .sitemap file and 1 .master file.)
21	Web: XML (PDF)	XML exercise - input data (ZIP) (This ZIP file contains: 1 folder, 1 .asmx file and 3 .aspx files.) XML exercise - solution (XML)
22	Web: Web services (PDF)	Web services exercise - input data (ZIP) (This ZIP file contains: 1 folder, 1 .asmx file and 4 .sql files.)
23	Web: Web services: WSDL, registries (PDF)
24	Web: Service oriented architecture, EDI (PDF)
25	Security: Framework, concepts (PDF)
26	Security: Protocols, part 1 (PDF)
27	Security: Protocols, part 2 (PDF)
28	Security: Cryptography (PDF)
29	Security: SSL, Internet (PDF)
30	Networks: System architecture, part 1 (PDF)
31	Networks: System architecture, part 2 (PDF)
32	Networks: Basic telecom technology (PDF)
33	Networks: Wired LANs, WANs (PDF)
34	Networks: Connecting wired LANs, WANs (PDF)
35	Networks: Fiber optics (PDF - 1.5MB)
36	Networks: Wireless (PDF - 1.1MB)
37	Networks: Enterprise, VPN, MPLS. Course summary (PDF)