Saturday, April 13, 2019

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.

Friday, March 29, 2019

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!


Monday, March 25, 2019

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

Sunday, March 24, 2019

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!!!


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 for...