Analyst Programmer_AP113: Building WEB Applications

About Course

In this course, students build back-ends to Web applications using the foundations of server
scripting (with PHP) and databases (with MySQL).
A Web Application is any site or feature on the Web that help users do something. Students build traditional Web applications such as forums, picture and video sharing applications and content admin systems like blogs.

Upon successful completion of this course, the student will have demonstrated the ability to:
● Organize data and map data flow through common Web application systems.
● Make forms in HTML.
● Receive data from HTML forms in the server scripting language PHP.
● Use programming basics such as variables, functions, loops, conditionals, and arrays to
control flow of the data.
● Create properly organized tables in a database such as MySQL using a database admin
system such as PHPMyAdmin.
● Insert, select, update and delete data in a database using a query language such as SQL.
● Display dynamic data in HTML.

Course Content

Module 1

Topic 1: The Workflow

00:00
LO1: Identify different types of Text Editors used for Web Development

00:00
LO2: Explain the Purpose and Functionality of Version Control Systems

00:00
LO3: Recognize the role of Browsers in Web Development

00:00
LO4: Compare Browser Developer Tools for Debugging and Testing Web Applications

00:00
LO5: Knowledge Check
Case Study: The Workflow
Topic 2: The Structure

00:00
LO1: Define the Structure and Syntax of an HTML Document

00:00
LO2: Explain the concept of the DOM and its Hierarchical Structure

00:00
LO3: Describe HTML Validation Tools to Identify and Fix Syntax Errors

00:00
LO4: Integrate semantic HTML Principles into the Amazeriffic project

00:00
LO5: Knowledge Check
Case Study: The Structure
Topic 3: The Style

00:00
LO1: Describe the Purpose and Syntax of CSS

00:00
LO2: Apply Inline, Internal, and External CSS to style an HTML Document

00:00
LO3: Identify and implement different types of CSS Selectors

00:00
LO4: Explain the concept of Floating Elements in CSS Layouts

00:00
LO5: Knowledge Check
Case Study: The Style
Topic 4: Working with Fonts

00:00
LO1: Explain the importance of Resetting Browser Default Styles

00:00
LO2: Implement CSS Resets to ensure consistent Styling across Browsers

00:00
LO3: Describe CSS Lint to Identify and resolve potential Styling Issues

00:00
LO4: Navigate and utilize Chrome Developer Tools for Inspecting and Debugging CSS

00:00
LO5: Discuss the Amazeriffic project by applying consistent Styling Rules

00:00
LO6: Knowledge Check
Case Study: Working with Fonts
Topic 5: The Interactivity

00:00
LO1: Define the basic Syntax and Features of JavaScript

00:00
LO2: Describe how to use jQuery to simplify DOM Manipulation

00:00
LO3: Evaluate the Advantages of using jQuery for Interactive Features

00:00
LO4: Knowledge Check
Case Study: The Interactivity
Topic 6: JavaScript Generalizations

00:00
LO1: Explain the role of JSLint in maintaining JavaScript Code Quality

00:00
LO2: Apply JSLint to Identify and Correct potential problems in Scripts

00:00
LO3: Enhance the Amazeriffic project by adding Interactive Features using JavaScript

00:00
LO4: Test and Debug Interactive Elements to ensure Functionality

00:00
LO5: Knowledge Check
Case Study: JavaScript Generalizations
Topic 7: The Bridge

00:00
LO1: Define and Implement JavaScript Objects to organize Data

00:00
LO2: Explain the concept of Client-server Communication

00:00
LO3: Integrate the Flickr API to Fetch and Display Images Dynamically

00:00
LO4: Troubleshoot API Requests for successful Communication

00:00
LO5: Describe a Tagging system for the Amazeriffic using JavaScript and APIs

00:00
LO6: Knowledge Check
Case Study: The Bridge
Topic 8: The Server

00:00
LO1: Define Development Environment for Server-side Applications

00:00
LO2: Develop Mental Models to understand Server-client Interaction

00:00
LO3: Create Server Routes using Express for Handling Requests

00:00
LO4: Implement a Server that interacts with APIs to count Tweets

00:00
LO5: Develop a Server to handle the Backend Logic for the Amazeriffic

00:00
LO6: Knowledge Check
Case Study: The Server
Topic 9: The Data Store

00:00
LO1: Differentiate between NoSQL and SQL Databases

00:00
LO2: Install and configure Redis as a NoSQL Data Store

00:00
LO3: Use Redis Commands to Store and retrieve Data

00:00
LO4: Explain the features and advantages of MongoDB for Web Applications

00:00
LO5: Knowledge Check
Case Study: The Data Store
Module Based Quiz

About Course

Course Content

Module 1

Topic 1: The Workflow

LO1: Identify different types of Text Editors used for Web Development

LO2: Explain the Purpose and Functionality of Version Control Systems

LO3: Recognize the role of Browsers in Web Development

LO4: Compare Browser Developer Tools for Debugging and Testing Web Applications

LO5: Knowledge Check

Case Study: The Workflow

Topic 2: The Structure

LO1: Define the Structure and Syntax of an HTML Document

LO2: Explain the concept of the DOM and its Hierarchical Structure

LO3: Describe HTML Validation Tools to Identify and Fix Syntax Errors

LO4: Integrate semantic HTML Principles into the Amazeriffic project

LO5: Knowledge Check

Case Study: The Structure

Topic 3: The Style

LO1: Describe the Purpose and Syntax of CSS

LO2: Apply Inline, Internal, and External CSS to style an HTML Document

LO3: Identify and implement different types of CSS Selectors

LO4: Explain the concept of Floating Elements in CSS Layouts

LO5: Knowledge Check

Case Study: The Style

Topic 4: Working with Fonts

LO1: Explain the importance of Resetting Browser Default Styles

LO2: Implement CSS Resets to ensure consistent Styling across Browsers

LO3: Describe CSS Lint to Identify and resolve potential Styling Issues

LO4: Navigate and utilize Chrome Developer Tools for Inspecting and Debugging CSS

LO5: Discuss the Amazeriffic project by applying consistent Styling Rules

LO6: Knowledge Check

Case Study: Working with Fonts

Topic 5: The Interactivity

LO1: Define the basic Syntax and Features of JavaScript

LO2: Describe how to use jQuery to simplify DOM Manipulation

LO3: Evaluate the Advantages of using jQuery for Interactive Features

LO4: Knowledge Check

Case Study: The Interactivity

Topic 6: JavaScript Generalizations

LO1: Explain the role of JSLint in maintaining JavaScript Code Quality

LO2: Apply JSLint to Identify and Correct potential problems in Scripts

LO3: Enhance the Amazeriffic project by adding Interactive Features using JavaScript

LO4: Test and Debug Interactive Elements to ensure Functionality

LO5: Knowledge Check

Case Study: JavaScript Generalizations

Topic 7: The Bridge

LO1: Define and Implement JavaScript Objects to organize Data

LO2: Explain the concept of Client-server Communication

LO3: Integrate the Flickr API to Fetch and Display Images Dynamically

LO4: Troubleshoot API Requests for successful Communication

LO5: Describe a Tagging system for the Amazeriffic using JavaScript and APIs

LO6: Knowledge Check

Case Study: The Bridge

Topic 8: The Server

LO1: Define Development Environment for Server-side Applications

LO2: Develop Mental Models to understand Server-client Interaction

LO3: Create Server Routes using Express for Handling Requests

LO4: Implement a Server that interacts with APIs to count Tweets

LO5: Develop a Server to handle the Backend Logic for the Amazeriffic

LO6: Knowledge Check

Case Study: The Server

Topic 9: The Data Store

LO1: Differentiate between NoSQL and SQL Databases

LO2: Install and configure Redis as a NoSQL Data Store

LO3: Use Redis Commands to Store and retrieve Data

LO4: Explain the features and advantages of MongoDB for Web Applications

LO5: Knowledge Check

Case Study: The Data Store

Module Based Quiz

Final Exam

Final Exam

Quick Links

Resources

Support