jnewman12

Intro to SQL

Objectives

After this lesson, students will be able to:

• Create a database table
• Insert, retrieve, update, and delete a row or rows into a database table

Preparation

jnewman12

Intro to Relational Data Modeling

Objectives

After this lesson, SWBAT:

• Describe the relationship between tables, rows, and columns
• Draw entity relationship diagrams (ERDs) with crow's foot notation for ideas for web apps
• Describe how tables relate to each other using foreign keys
• Explain the different relationship types – one to one, one to many, many to many

jnewman12

Your project on github pages

• first, make sure you have been pushing your project to github
• if you're in a good spot for your project, commit and push to master

---

gh-pages branch

• go into your project directory in your terminal
• run git checkout -b gh-pages
• then run git commit -am "gh-pages branch"

jnewman12

What is a Callback?

A reference to executable code, or a piece of executable code, that is passed as an argument to other code.

All a callback is, is a function that takes a function as an argument.

Here is an example

function mySandwich(param1, param2, callback) {
 alert('Started eating my sandwich.\n\nIt has: ' + param1 + ', ' + param2);

jnewman12

Fellowship of the Bling ($)

Using our new-found knowledge of jQuery, create a function for each of the following steps to practice DOM Manipulation, JavaScript, and jQuery.

Setup

jnewman12

JS Debugging

Objectives

After this lesson, students will be able to:

• Identify and resolve common and uncommon "logical errors" that affect the results of your program
• Use logs to troubleshoot errors in an application (console log in Dev Tools)
• Conduct real-time debugging in the browser (start small, triangulation, remove code)
• Access properties of a class using helper methods ( typeOf( ) for datatypes)
• Use debuggers and breakpoints to identify logical errors in expressions

jnewman12

Intro to the DOM

Students will be able to...

• Explain what the DOM is
• Use JavaScript to select parts of the DOM
• Use JavaScript to change parts of the DOM

---

What is the DOM?

jnewman12

DOM Manipulation & Events

SWBAT

• Understand the role of events
• Recognize and respond to common types of events
• Describe how to pass an anonymous function to an event listener
• Describe how to pass a named function to an event listener

What are events?

jnewman12

Functions and Javascript Scope

---

Students will be able to...

• Confidently write functions, then invoke them
• Explain what scope is
• Create a new local scope
• Explain hoisting in terms of load order

jnewman12

JavaScript Functions Lab

Introduction

This lab provides an opportunity to practice defining and coding some real-world functions.

Note: Feel free to work in pairs or groups to complete this lab. Also, Google/StackOverflow is a good friend to have around...