INFO 2480-61: Website Database Implementation
  • Syllabus
  • Welcome Letter
  • Week 1: Software and Setup
    • Folder Structure
    • Git: Getting Started
      • Installing a Git Client
      • Creating a Local Repository
      • Making Changes and Merging them
      • Git Wrap Up
    • Git: Github
      • Creating a New Account
      • Creating a Repo on Github
      • Cloning and Forking
      • Cloning a Repo from Github
      • Pushing Changes to Github.com
      • Github: Adding a Collaborator
    • Command Box
      • Downloading the Software
      • Unzipping and Running the Software for the first time
      • Using CommandBox And Installing the UML-Info package.
      • Setting Up Your Local Server
      • Last Step
    • IDE ( Integrated Development Environment )
      • VS Code
      • IntelliJ
    • Journal
  • Week 2: Review of HTML and CSS
    • Making Point In Time and Working Branches
    • Opening our Project from Week 1 and Starting our BoxLang server
    • HTTP Calls and Requests
    • Making a Static Website Dynamic
    • Creating The Management Index.bxm
    • Creating An HTML Form with Bootstrap
    • Last Steps
  • Week 3: Working Forms and our First Table
    • Data Types
    • Case Types and Naming Conventions
    • Database Tools and Your First DB
      • Installing MySql WorkBench
      • Connecting to your MySQL database
      • Creating Your First Table
    • Working Forms
      • Separation of Concerns
      • Configuring Our Site To Use Our Database
      • Capturing Your Form Data
      • Creating Our Server Side Logic
  • Week 5: SQL and Modelling
    • Our Project And Its Users
    • Introduction to SQL
    • Completing our Articles page.
      • Adapting manageArticles.bxm to display existing articles in the database
      • Completing ManageArticles.bxm to Edit Existing Articles.
      • Making Active Articles Appear On The Public Page
  • Week 6: Managing Books
    • Introduction To Modelling
    • Our Data Models
    • Adapting Our Management Page To Be Multi-Tool
    • Creating The Manage Books Page
    • Adding Search To Our Front Index Page
  • Week 7: Working with Selects, Files, WYSIWYG and more.
    • Adding WYSIWYG Capabilities
    • Adding WYSIWYG to the Manage Books Tool
    • Adding Images To Our Store
    • Creating Our Publisher Select Control
  • Week 9: Joins and Better Searching
    • Displaying Our Publisher
    • Searching By Publisher
    • Creating a Browse by Genre
      • Adapting Our Database
      • Building our Queries: Part 1
      • Assigning Genres to a Book in our AddEdit.bxm page
      • Building our Queries: Part 2
      • Building the GenreNav.bxm
      • Adapting The Details.bxm Page to Search By Genre
  • End of Project Checkllist
Powered by GitBook
On this page

Welcome Letter

Hi Folks,

Welcome to Web Site Database Implementation. It’s my goal that this is one of the most helpful and important classes you’ll take in your academic career. Ambitious? Perhaps, but, if I didn’t think it was important, I wouldn’t be here.

Working with databases is one of the most valuable skills you can have as a web developer. It marks a major jump from making the equivalent of online posters to tools that can be made to run everything from CMS systems such as Wordpress and Sharepoint, eCommerce sites such as Amazon and Etsy, Social Media sites such as X and Facebook and even unmanned systems such as security, transportation and the “Internet of Things”. However, before we get ahead of ourselves, we have the next 10 weeks to get through.

My name is Dan Card. I’m an adjunct faculty member at UMass Lowell. Over the past 20+ years, I have developed education systems for middle and high school programs, created commercial software for the transportation and financial industries, created data visualizations for the NFL and MLB and built business applications for scientific organizations. Over the past 15 years, I’ve taught computer and technology classes on the Middle School, High School, Undergraduate and Adult levels.

We have a great deal of material to get through over the next 10 weeks. It’ll be work and we need to take it somewhat seriously but that is a far cry from taking ourselves very “somberly”. There is a difference and I hope we’ll do the former and not the latter.

The first step is to set up your development environment. This might take some time so make sure you block off enough and start early.

Sincerely,

Dan Card

PreviousSyllabusNextWeek 1: Software and Setup

Last updated 4 months ago