SQL

I've hit a wall in my SQL studies via the Khan Academy, and as such, I am engaging in additional studies prior to attempting to move forward.

Via a very limited, free SQL tutorial from Codecademy:

BACKGROUND

SQL, Structured Query Language, is a programming language designed to manage data stored in relational databases. SQL operates through simple, declarative statements. This keeps data accurate and secure, and it helps maintain the integrity of databases, regardless of size.

Here’s an appendix of commonly used commands.

COMMANDS

ALTER TABLE

ALTER TABLE table_name 
ADD column_name datatype;

ALTER TABLE lets you add columns to a table in a database.

GitHub

GitHub approved my complimentary professional account! I of course, am not a professional programmer (yet), but it brings me joy just the same.

Happy Coding!

SQL Documentation (From the Khan Academy)

SQL development

If you're new to SQL, you can learn more from this course: SQL.

Creating tables

• CREATE TABLE customers (id INTEGER PRIMARY KEY, name TEXT, age INTEGER, weight REAL);

  Many data types
• CREATE TABLE customers (id INTEGER PRIMARY KEY, age INTEGER);

  Using primary keys

See also: specifying defaults, using foreign keys. For more details, see the following: SQLite reference for CREATE.

Intro to SQL: Querying and managing data

I'm so happy to be learning computer programming. The process is invigorating! I started the Khan Academy courses over Spring Break and managed to complete Intro to JS: Drawing & Animation in about 81 hours. I began the evening by finishing course 2 in the series (Intro to HTML/CSS: Making webpages), and finished it a few hours ago. Oh, and a pleasant bit of good news; GitHub approved my free Pro account! Thanks GitHub!!!

HTML Review via the Khan Academy

Web development

HTML

Web development

HTML

• Headlines

  <h1> - <h6>
• Paragraphs

  <p>
• Line breaks

  <br>
• Lists

  <ul>, <ol>, <li>
• Emphasis

  <strong>, <em>
• Links

  <a>
• Images

  <img>
• Tables

  <table>, <thead>, <tbody>, <tr>, <th>, <td>

For more HTML tags, see also: MDN HTML elements reference

CSS Selectors

• h1 {
    color: rgb(0,0,0);
  }

  The element selector
• ul em {
    color: rgb(0,0,0);
  }

  The descendant selector
• .stripe {
    color: rgb(0,0,0);
  }

  The class selector
• #star {
    color: rgb(0,0,0);
  }

  The ID selector

For more CSS selectors, see also: MDN CSS selectors reference

CSS Properties

• color
• background-color
• font-family
• font-size

For more CSS properties, see also: MDN CSS properties reference

The Khan Academy

ProcessingJS Functions

ProcessingJS

Shapes

• rect(x, y, w, h)
• ellipse(x, y, w, h)
• triangle(x1, y1, x2, y2, x3, y3)
• line(x1, y1, x2, y2)
• point(x, y)
• arc(x, y, w, h, start, stop)
• bezier(x1, y1, cx1, cy1, cx2, cy2, x2, y2)
• quad(x1, y1, x2, y2, x3, y3, x4, y4)
• image(image, x, y, width*, height*)

See also: ellipseMode, rectMode, imageMode, strokeCap, bezierPoint, bezierTangent, curve, curvePoint, curveTangent, curveTightness

Complex Shapes

• beginShape() / endShape() / vertex()
• curveVertex()
• bezierVertex()

See also: strokeJoin, curveTightness

(keep reading...)