Objectives

Students will be able to:

  • Design a database-driven webpage based on CRUD principles.

Scenario

Some clients (eg your laptop or smartphone) are requesting information from imdb.com's server in the cloud. The clients are using a web browser. The information will be sent in the form of a webpage.

But where is all the information coming from?

For example, visit and do a search for your favourite actor. What information does the website send back to you?

And where is this information coming from exactly?

The data is being stored on a database on a web server. Clients can request information from the database!

Full Stack & C.R.U.D.

 

Part 1 - Full Stack

A Full Stack Web Developer is proficient at using:

  1. Front End development technologies such as HTML, CSS and Javascript
  2. Back End development technologies such as SQL and PHP

Let's complete an intro unit as we get started with Full Stack skills.

  • Full Stack

  • Web Design

Part 2 - CRUD

The following operations can be performed on a database:

  • Create
  • Read
  • Update
  • Delete

These operations can be performed using SQL.

Full Stack developers can create webpages which, using back end technologies such as PHP, can perform these operations in an intuitive and user-friendly way ie the webpage user does not need to know anything about SQL to perform these operations.

 

Let's dive into CRUD operations and other issues facing Full Stack web developers.

Note: it is recommended that you study the READ operation first, as it is the most basic operation.

  • Read

  • view records

  • Create

  • add new records

  • Update

  • amend records

  • Delete

  • remove records

  • Login

  • Logging In

  • SQL Injection

  • Hack Attack!

TBD

essential vocabulary

database import evidence table integer screenshot record text field double data type

SUBSCRIBE

Join my mailing list to receive updates on the latest blog posts and other things.