everything.study
ESD.264

Database, Internet, and Systems Integration Technologies

Graduate · Historical course

Fall 2013

Topics

  • System process: Introduction
  • System process: Fundamentals
  • System process: Time and resource estimation, part 1
  • System process: Time and resource estimation, part 2
  • System process: CMMI, ISO
  • System process: UML, part 1
  • System process: UML, part 2
  • Database: Data modeling, part 1
  • Database: Data modeling, part 2
  • Database: Data normalization
  • Database: SQL basics: SELECT, INSERT
  • Database: SQL lab
  • Database: SQL joins, subqueries, views
  • Database: SQL Homework 5
  • Database: SQL transactions, connections
  • Web: Introduction, HTTP
  • Web: XHTML, CSS
  • Web: Connecting Web and database
  • Web: Web and database: Forms
  • Web: Web and database
  • Web: XML
  • Web: Web services
  • Web: Web services: WSDL, registries
  • Web: Service oriented architecture, EDI
  • Security: Framework, concepts
  • Security: Protocols, part 1
  • Security: Protocols, part 2
  • Security: Cryptography
  • Security: SSL, Internet
  • Networks: System architecture, part 1
  • Networks: System architecture, part 2
  • Networks: Basic telecom technology
  • Networks: Wired LANs, WANs
  • Networks: Connecting wired LANs, WANs
  • Networks: Fiber optics
  • Networks: Wireless
  • Networks: Enterprise, VPN, MPLS. Course summary.

Readings

  • You can share the texts with your homework partner, so each of you needs to get three texts. Obtain either the Bowman et al. (2003) text or the Syverson (2002) but not both, for the SQL language.
    Listed reading
  • McConnell, Steve. Rapid Development: Taming Wild Software Schedules . Microsoft Press, 1996. ISBN: 9781556159008.
    Listed reading
  • Fowler, Martin. UML Distilled: A Brief Guide to the Standard Object Modeling Language . 3rd ed. Addison-Wesley, 2003. ISBN: 9780321193681.
    Listed reading
  • Bowman, Judith S., Sandra L. Emerson, and Marcy Darnovsky. The Practical SQL Handbook: Using SQL Variants . 4th ed. Addison-Wesley, 2001. ISBN: 9780201703092.
    Listed reading
  • Syverson, Bryan. Murach’s SQL for SQL Server . Murach, 2002. ISBN: 9781890774165.
    Listed reading
  • McFarland, David S. Dreamweaver 8: The Missing Manual . O’Reilly, 2005. ISBN: 9780596100568.
    Listed reading
  • Anderson, Ross. Security Engineering: A Guide to Building Dependable Distributed Systems . John Wiley & Sons, 2001. ISBN: 9780471389224.
    Listed reading
  • Green, James H. The Irwin Handbook of Telecommunications . 5th ed. McGraw-Hill, 2005. ISBN: 9780071452229.
    Listed reading
  • [RD] = McConnell, Steve. Rapid Development: Taming Wild Software Schedules . Microsoft Press, 1996. ISBN: 9781556159008.
    Listed reading
  • [UM] = Fowler, Martin. UML Distilled: A Brief Guide to the Standard Object Modeling Language . 3rd ed. Addison-Wesley, 2003. ISBN: 9780321193681.
    Listed reading
  • [SQ] = Bowman, Judith S., Sandra L. Emerson, and Marcy Darnovsky. The Practical SQL Handbook: Using SQL Variants . 4th ed. Addison-Wesley, 2001. ISBN: 9780201703092.
    Listed reading
  • [MU] = Syverson, Bryan. Murach’s SQL for SQL Server . Murach, 2002. ISBN: 9781890774165.
    Listed reading
  • [DR] = McFarland, David S. Dreamweaver 8: The Missing Manual . O’Reilly, 2005. ISBN: 9780596100568.
    Listed reading
  • [SE] = Anderson, Ross J. Security Engineering: A Guide to Building Dependable Distributed Systems . John Wiley & Sons, 2001. ISBN: 9780471389224.
    Listed reading
  • [TE] = Green, James H. The Irwin Handbook of Telecommunications . 5th ed. McGraw-Hill, 2005. ISBN: 9780071452229.
    Listed reading
  • [ASP] = Spaanjaars, Imar. Beginning ASP. NET 4.5: In C# and VB . Wrox, 2012. ISBN: 9781118311806.
    Listed reading
  • LEC #: 2 · TOPICS: System process: Fundamentals · READINGS: [RD] Chapters 1–3.
    Reading assignment
  • LEC #: 3 · TOPICS: System process: Time and resource estimation, part 1 · READINGS: [RD] Chapters 4–6.
    Reading assignment
  • LEC #: 4 · TOPICS: System process: Time and resource estimation, part 2 · READINGS: [RD] Chapters 7–8; 9–10 optional.
    Reading assignment
  • Paulk, Mark C., et al. Capability Maturity Model for Software, Version 1.1 (PDF) . Software Engineering Institute, Carnegie Mellon University. February 1993. ↗
    Listed reading
  • LEC #: 6 · TOPICS: System process: UML, part 1 · READINGS: [UM] Chapters 1–2 (skim), 4, and 8–9.
    Reading assignment
  • LEC #: 7 · TOPICS: System process: UML, part 2 · READINGS: [UM] Chapters 10–12, and 14–15.
    Reading assignment
  • LEC #: 8 · TOPICS: Database: Data modeling, part 1 · READINGS: [MU] Chapter 9.
    Reading assignment
  • LEC #: 11 · TOPICS: Database: SQL basics: SELECT, INSERT · READINGS: [MU] Chapters 1–3.
    Reading assignment
  • LEC #: 12 · TOPICS: Database: SQL lab · READINGS: [MU] Chapter 7.
    Reading assignment
  • LEC #: 13 · TOPICS: Database: SQL joins, subqueries, views · READINGS: [MU] Chapters 4–6.
    Reading assignment
  • LEC #: 14 · TOPICS: Database: SQL Homework 5 · READINGS: [MU] Chapter 12.
    Reading assignment
  • LEC #: 15 · TOPICS: Database: SQL transactions, connections · READINGS: [MU] Chapter 16.
    Reading assignment
  • LEC #: 16 · TOPICS: Web: Introduction, HTTP · READINGS: [ASP] Chapter 1.
    Reading assignment
  • LEC #: 17 · TOPICS: Web: XHTML, CSS · READINGS: [ASP] Chapters 2–3.
    Reading assignment
  • LEC #: 19 · TOPICS: Web: Web and database: forms · READINGS: [ASP] Chapter 4.
    Reading assignment
  • LEC #: 20 · TOPICS: Web: Web and database · READINGS: [ASP] Chapters 11–12.
    Reading assignment
  • LEC #: 22 · TOPICS: Web: Web services · READINGS: [ASP] Chapter 10 (Web svcs only).
    Reading assignment
  • LEC #: 25 · TOPICS: Security: Framework, concepts · READINGS: [SE] Chapters 1–2.
    Reading assignment
  • LEC #: 26 · TOPICS: Security: Protocols, part 1 · READINGS: [SE] Chapter 3.
    Reading assignment
  • LEC #: 27 · TOPICS: Security: Protocols, part 2 · READINGS: [SE] Chapter 4.
    Reading assignment
  • LEC #: 28 · TOPICS: Security: Cryptography · READINGS: [SE] Chapter 10.
    Reading assignment
  • LEC #: 29 · TOPICS: Security: SSL, Internet · READINGS: [SE] Chapter 20 (not covered in class).
    Reading assignment
  • LEC #: 32 · TOPICS: Networks: Basic telecom technology · READINGS: [TE] Chapters 1–3 (skim Chapter 1).
    Reading assignment
  • LEC #: 33 · TOPICS: Networks: Wired LANs, WANs · READINGS: [TE] Chapters 4, 6–7, and 10 (skip data fundamentals).
    Reading assignment
  • LEC #: 34 · TOPICS: Networks: Connecting wired LANs, WANs · READINGS: [TE] Chapters 8, 32.
    Reading assignment
  • LEC #: 35 · TOPICS: Networks: Fiber optics · READINGS: [TE] Chapter 17 (skip tech parts).
    Reading assignment
  • LEC #: 36 · TOPICS: Networks: Wireless · READINGS: [TE] Chapters 18–21 (skip modulation).
    Reading assignment
  • LEC #: 37 · TOPICS: Networks: Enterprise, VPN, MPLS. Course summary. · READINGS: [TE] Chapters 31, 33, 36, and 39.
    Reading assignment
Sources