CSCI-2910 Resource
Final Exam Topic Study Guide

Back to Resources Study Guides

Database (DB) Review

Object-Relational Mappers (ORMs)

Overview of ORMs and their role in abstracting database interactions.

Schema

Understanding database schema design and implementation.


Web Architecture

Data Transmission

Methods of transmitting data over the web.

HTTP(S)

Overview of HTTP and HTTPS protocols.


APIs (Application Programming Interfaces)

Markup Language

Understanding the role of markup languages (such as XML and JSON) in APIs.

Serialization/Deserialization

Converting data structures into formats suitable for storage or transmission and vice versa.

API Analysis Scenario Question

How to analyze an API and use some or all of its endpoints. There will be a scenario question for this topic. Be prepared!

Dataset Analysis & API Creation Scenario Question

How to analyze a dataset and create an API to interface with it. There will be a scenario question for this topic. Be prepared!


MVC Framework Web Development

Models, Views, and Controllers

Understand what each component of an MVC Framework are, the role they serve, and how they interact.

Components

In the context of views, understand what a component is and why its modularity and reusability are important to component-based frameworks.


Continuous Integration/Continuous Deployment

Unit Testing

  • What is a unit test?
  • What are the 3 "A"s of unit testing?
  • Understand edge cases.

Testing

  • Why do we test things?
  • Why is testing considered part of Continuous Integration?

Containers

  • What is a container?
  • What main concern do containers address for Continuous Deployment?