⚡ UML INFO-2480
Ctrl K
    • Syllabus
    • Welcome Letter
      • Course Description
      • Pre-Requisites
      • Course Materials
      • Chat Schedule
      • Course Materials "Release" Day
      • Class Overview
      • Grading
      • Type Of Assignments
      • Make Up Policy
      • Interaction Guideline
      • General
      • Contributions
      • Dicussion Boards
      • Chats
      • Mail (My Messages)
      • Journals
      • Netiquette
      • A Note on Personality Types
      • Academic Integrity Policy
      • Student Disability Services
      • Course Vocabulary List
    • Deep Background
      • Addresses and ports
    • Week 1: Software and Setup
      • Folder Structure
      • Getting Started
        • Connecting to the VPN
        • Setting up Multifactor Authentication (MFA)
      • 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
        • Dreamweaver
      • Choosing Your Tools
        • Core FTP
      • Testing Your Setup
      • 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
        • Datagrip
        • 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
      • Introduction To SQL Studio
      • Introduction to Creating Tables with SQL
    • Week 4: Server Side Languages
      • Learn CF
        • Welcome and Introduction
        • Basic Format: Tag
        • Math and Stuff (Don't Freak)
        • Basic Format: Script
        • Data Types and Formatting
        • Intro To Variables
        • Intro To Complex Variables: Objects/Structs
        • Intro To Complex Variables: Arrays
        • Forms And URLs
        • Functions
        • Intro To Data
        • Scripts And Components
    • Week 4: 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 5: Managing Books
      • Introduction To Modelling
      • Our Data Models
      • Adapting Our Management Page To Be Multi-Tool
      • Our First Management Page
      • Expanding And Styling The Main Form
      • Adding to our Management Tool
      • Creating The Manage Books Page
      • Adding Search To Our Front Index Page
    • Week 6: Working with Selects, Files, WYSIWYG and more
      • Adding Search To Our Management Page
      • Adding WYSIWYG Capabilities
      • Adding WYSIWYG to the Manage Books Tool
      • Adding Images To Our Store
      • Creating Our Publisher Select Control
    • Week 7: 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
    • Week 9: A Simple Content Management System
      • Making a Forgot Password Page
      • Adding Permissions To The Site
      • Personalizing Your WebSite
    • Week 10: Complete Final Project
    • End of Project Checkllist
    Powered by BxSites

    Index

    Week 9: Joins and Better Searching

    Download Markdown
    ← Creating Our Publisher Select Control Displaying Our Publisher →