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
  1. Week 1: Software and Setup

Folder Structure

Goal: By the end of this document, you will create the folder which will house all your work for this class.

TLDR : Skip to the last item to see absolutely essential info about your class folder structure.

How you set up your folders is important in that it can make your life easier or more complicated. A large part of any web design (or any software design project for that matter) is getting your files in the right place at the right time. You want your folder structure to be clear, intuitive and, above all, easy!

Since each developer / designer has their own way of thinking, your structure might deviate slightly from this but make sure it makes sense and works for you. To start off, make a folder on your hard drive which is going to house all of your web projects which I’ll call “sites”. Under that, make a folder for each “client” you have. This “client” level might include actual clients, personal projects, experimental sites and whatever you choose. The next level down is an actual project for that client.

Sites
    Client
        Project

Here is a more detailed example with real world clients and projects

Sites – The folder housing all of my projects
    AMS – a “client”

        AMSLive – a project

        AMSConversion – a project

    UML – a “client”

        SP21 – a project

        FA21 – a project

        SU22 – a project

    MyStuff – you are your own “client”

        LearnReact – a project

        CFSamples – a project

        PersonalIntranet – a project

For this class I'd suggest doing something like this:

Sites – houses all your web projects
    UML – houses all your UML coursework
        WebDataImplementation – the work for this class
            practiceGit - a project in this class
            ongoingWork - the main folder for your classwork
            

If you're on a Windows machine and sites was in your root folder, that would be C:\Sites\UML\WebDataImplementation

At the very minimum, you will need to start this course with a dedicated folder for all your work.

PreviousWeek 1: Software and SetupNextGit: Getting Started

Last updated 4 months ago