Open Book Shelf

Introduction to Git and Github

• A guide to Git and Github
  • Getting Started
    • Introduction
      • Getting Started
      • Who Is This Guide For?
      • How To Read This Guide
      • Source Control Management
      • Code repositories
      • What is Version Control?
      • What is Git?
      • Local vs. Remote
      • Free and Open Source Software
      • What is GitHub?
      • Goals
    • Preparations
      • Installing git
      • Interacting With git
      • Installing a GUI
  • Working Locally
    • Creating Repositories
      • Create an example project
      • git init
      • Git directory
      • The config file
      • Git ignore
      • Private repos
      • Summary
    • Tracking Change
      • git status
      • Creating a commit
      • git log
      • Video Review
      • Summary
    • Branching
    • What is Branching?
    • Why Would I Want to Branch?
    • Local vs. Remote
    • Video Review
    • Summary
  • Summary
  • Installation
  • Your First Repo
  • Command Reference
  • Local vs. Remote Revisited
• Remote Repositories
  • Introduction
  • Distributed vs. Centralized
  • Options
  • Github
    • Registering
    • Creating a Repo
    • Connecting to GitHub Repo
    • What did we just do?
    • GitHub Authentications
    • git push
    • Video Review: git push
    • git pull
    • Video Review: git pull and git fetch
    • git clone
    • Video Review: git clone and forking
    • Summary
  • Passwords
    • Password caching
    • SSH
  • Conclusion
    • Cheatsheets
      • Git commands
      • Git workflow
      • Resources

Introduction to programming with Ruby.

• I read it, but took physical notes in a notebook

Object Oriented Programming with Ruby.

• I read it, but took physical notes in a notebook

Introduction to the Command Line

• Introduction
• Preparations
• The CLI
• Files, Directories and the Command Line
  • Linux/Unix File System
  • Navigating
  • Executables
• The environment
  • Environment variables
  • How to change your command line environment
  • $PATH and Executables
• Permissions
  • Interpreting permissions
  • Setting permissions
  • Users and Groups
  • Root user and Sudo
  • Summary
  • Changing context in Terminal
• REPLs
• Editors
• Conclusion
• My CLI vocab

Core Ruby Tools

• Introduction
• Your Ruby Installation
  • On Cloud9
  • On a Mac
  • On Linux
  • What Ruby am I running?
  • What gets installed with Ruby?
• Gems
  • What are Gems?
  • Gems, Ruby and your Computer
    • The Remote library
    • The local library
    • Gems and your File System
    • Which file was required?
    • Multiple gem versions
  • Summary
• Ruby Version Managers
  • Which Ruby version should I use?
    • Installing Rubies
    • Setting local Rubies
    • Where are my Rubies, Gems and Apps now?
    • When things go wrong
  • rbenv
    • installing rubies
    • Setting local rubies
    • Where are my rubies, gems and apps now?
      • When things go wrong
      • Plugins
  • Summary
• Bundler
  • An article about Bundler Ollie showed me
  • Installing Bundler
  • Gemfile and Gemfile.lock
  • Running apps with Bundler
  • Where are my Rubies, Gems and Apps now?
  • Bundle exec
  • binstubs
    • When things go wrong
  • Summary
• Rake
  • What is Rake
  • How do you use rake?
  • Why do I need Rake?
  • A real world example
  • When things go wrong
• Conclusion
  • Relationships
  • Useful links

Introduction to HTTP

• Background
  • Introduction
    • How the internet works
    • DNS
    • Clients and Servers
    • Resources
    • Statelessness
  • What is a URL?
    • Introduction
    • URL components
    • Query Strings and parameters
    • URL encoding
    • Summary
• HTTP
  • Preparations
    • HTTP GUI tools
    • HTTP command line tools
  • Making Requests
    • HTTP request with a browser
    • HTTP request with an HTTP tool
    • Using the inspector
    • Request Methods
    • Get Requests
    • Post requests
    • HTTP Headers
    • Request headers
    • Summary
  • Processing responses
  • Status code
    • 302 Found
    • 404 Not Found
    • 500 Internal Server Error
  • Response Headers
  • Summary
  • Stateful Web Applications
    • Introduction
    • A Stateful App
    • Sessions
    • Cookies
    • AJAX
    • Summary
  • Security
    • HTTPS
  • Same Origin Policy
  • Session Hi-jacking
    • Countermeasures for Session Hijacking
  • Cross site scripting
    • Potential solutions for cross-site-scripting
  • Summary
• Conclusions and next steps

Introduction to Regular Expressions

• Other resources
• Basic Matching
  • Alphanumerics
• Character classes
• Range of characters
• Character Class Shortcut
• Anchors
• Quantifiers
  • Greediness

Introduction to SQL

• GETTING STARTED
  • 1. Introduction
    • The importance of data
    • Structured Data
    • Spreadsheet as Database
    • Relational Database Management Systems
    • SQL
    • Why learn SQL?
    • Summary
  • 2. Preparations
    • Vocabulary
    • Installing PostgreSQL
    • Summary
  • 3. Interacting With PostgreSQL
    • Interacting with a database
    • PostgreSQL Client Applications
    • The psql console
    • SQL Sub-languages
    • Summary
  • 4. SQL Basics Tutorial
    • Set Up
    • Connect
    • Select all
    • Selecting columns
    • Selecting rows
    • Selecting columns and rows
    • Data vs Schema
    • Summary
    • Exercises
• YOUR FIRST DATABASE: SCHEMA
  • 5. Create and View Databases
    • Create a database
      • Using a SQL statement
      • Database naming
    • Connecting to a Database
    • Delete the Database
      • Using dropdb
    • Summary
    • Exercises
  • 6. Create and View Tables
    • Table Creation Syntax
      • Creating a users table
    • Data Types
    • Keys and Constraints
    • View the Table
    • Schema and DCL
    • Summary
    • Exercises
  • 7. Alter a Table
    • Alter Table Syntax
    • Renaming a Table
    • Renaming a Column
    • Changing a Column's Datatype
    • Adding a Constraint
    • Removing a Constraint
    • Adding a Column
    • Removing a Column
    • Dropping Tables
    • Summary
    • Exercises
• YOUR FIRST DATABASE: DATA
  • 8. Add Data with INSERT
    • Data and DML
      • A bit about CRUD
    • Setup
      • Insertion Statement Syntax
    • Adding Rows of Data
      • Rows
      • Adding a single row
      • Adding multiple rows
    • Constraints and Adding Data
      • Default values
      • NOT NULL constraints
      • Unique constraints
      • CHECK constraints
      • Quote marks
    • Summary
    • Exercises
  • 9. Select Queries
    • Select Query Syntax
      • Identifiers and key words
    • ORDER BY
    • Operators
      • Comparison operators
      • Logical operators
      • String matching operators
    • Summary
    • Exercises
  • 10. More on Select
    • LIMIT and OFFSET
      • Pagination
    • DISTINCT
    • Functions
      • String Functions
      • Data/time functions
      • Aggregate functions
    • GROUP BY
      • Ian Austin article
    • Summary
    • Exercises
  • 11. Update Data in a Table
    • Updating Data
    • Update all rows
    • Update specific rows
  • Deleting Data
    • Delete specific rows
  • Delete all rows
  • Update vs Delete
  • Use Caution
  • Summary
  • Exercises
• WORKING WITH MULTIPLE TABLES
  • 12. Create Multiple Tables
    • Normalization
    • Database Design
      • Entities
      • Relationships
    • Keys
      • Primary keys
      • Foreign keys
    • One-to-One
    • Referential Integrity
      • The ON DELETE clause
    • One-to-Many
    • Many-to-Many
    • Summary
    • Exercises
  • 13. SQL Joins
    • Join Syntax
      • Transient tables
    • Types of Joins
      • INNER JOIN
      • LEFT JOIN
      • RIGHT JOIN
      • FULL JOIN
      • CROSS JOIN
    • Multiple Joins
    • Aliasing
      • Column aliasing
    • Subqueries
      • Subquery expressions
    • Summary
    • Exercises
  • CONCLUSION
  • 14. Summary and Additional Resources
    • Summary
    • Next Steps

Working with Web APIS.

Agile Planning.

Demystifying Rails.

Introduction to Programming with Javascript.

Object Oriented Javascript