Oracle DB development

• Autonomous transactions

• Basic DDL

• Binding ANYDATA with DBMS_SQL

• Limiting query results

• Listagg — collecting string results

• Loop labels

• Multiset operators

• Nested tables

• Oracle text context indexes

• Pipelined functions

• Pivoting a table in Oracle

• Recursive subquery factoring

• Row generation

• SQL collection types in queries

• Select FOR UPDATE locks

• Temporary tables

• Using client_info

• Using external tables for loading CSV

• Using xml schemas to serialize objects

Ruby

• Bundler

• Callable objects

• Concerns and ‘included’ hook

• ERB syntax

• Encoding magic

• Formatting all errors as JSON with Sinatra

• Memory usage

• Naming convention

• RSpec basics

• RSpec expectations

• RSpec: before and after

• RSpec: figuring out flimsy tests

• Read/write JSON

• Sinatra routes

• Using Rubocop

• Working with strings

JS

• Connecting to redux store with TS

• DOM selector functions

• Enabling strict mode

• Equality operators

• Extending window object for debugging typescript

• Importing types for packages

• Index signatures in TypeScript

• Interface and Type Alias syntax

• Link local packages with yarn

• Linking JS files

• String interpolation in Javascript

• Using TSLint

• Using foreman

• Webpack development server

• Window location parts

• XSS tester

CSS

• Linking a stylesheet

• Media queries

• SCSS rule nesting

• SCSS variables

Rails

• ActiveRecord and raw SQL: Execute

• ActiveRecord and raw SQL: Select

• Form helpers for views

• Querying Rails models

• Rails console commands

• Rails controllers

• Rails migrations

• Rails models and relations

• Routing in Rails

• Scopes in Rails models

• Switching off migrations warnings

Docker

• Building images with Dockerfiles

• Cleaning up Docker containers

• Copying from and to a container

• Docker compose file

• Docker containers: running and managing

• Docker volumes

• Managing images

• Networking in Docker

• Publishing images to dockerhub

Regular expressions

• Regex basics

• Regex groups

• Regex lookahead/lookbehind

Mongo DB

• Inserting documents

• MongoDB indexes

• Running a Mongo docker container

• Select

Oracle DB administration

• ‘Popular’ queries

• Calculate table sizes

• Database links

• Drop all tables in a schema

• Gathering table starts

• Indexes to data ratio

• Lock types

• Oracle data dictionary

• Pushing a cursor out of shared pool

• Sort usage

• Tracing sql

PostgreSQL

• Analyzing space

• Anonymous blocks

• Basic commands

• Building database URLs

• Data dictionary

• JSON operators

• Killing PostgreSQL sessions

• Limiting query results

• Recursive subquery factoring

• Row generation

• Running a dev DB server in docker

AWS

• EC2 CLI commands

• ECR CLI commands

• S3 CLI commands

• Setting up the CLI

Python

• List colon (:) syntax

• List comprehensions

• Looping through collections

• Python 3 environments

• Python built-in collection functions

• Python collections: dictionaries

• Python collections: lists

• Python collections: sets

• Python debugger

• Python strings

• Setting up pytest

• Using pip package manager

Go / Golang

• Gin gonic routes

• Goroutines and channels syntax

• Goroutines and waitgroups syntax

• JSON in Golang

SSH

• Authorizing SSH keys

• Basic commands

• SSH configuration file format

• SSH key generation

Nginx

• Basic authentication in nginx

• Caching static media

• Static site configuration example

• Try_files syntax

GIT

• Basic commands

• Bisect

• Exporting diffs and applying patches

• Git PS1 in command prompt

• Git hooks

• Removing objects in origin

• Squash commits / rebase

FFmpeg

• Building a timelapse out of images

• Combine audio and video

Linux

• Basic iptables configuration

• Create and manage users

• File path tools

• Grep options

• PS (processes) output

• Redirecting input and output

• Screen

• Symlinks

• Tracking space usage

• Using apt package manager

• Using curl to send HTTP requesys

• Using tar to pack/unpack

• Vim commands

• iptables: saving and restoring rules