Zein Miftah zmiftah

Direct links to free Springer books (pdf versions)

Graduate texts in mathematics

duplicates = multiple editions

A Classical Introduction to Modern Number Theory,Kenneth IrelandMichael Rosen

The introduction to Reactive Programming you've been missing

This tutorial as a series of videos

If you prefer to watch video tutorials with live-coding, then check out this series I recorded with the same contents as in this article: Egghead.io - Introduction to Reactive Programming.

Studying for a Tech Interview Sucks, so Here's a Cheat Sheet to Help

This list is meant to be a both a quick guide and reference for further research into these topics. It's basically a summary of that comp sci course you never took or forgot about, so there's no way it can cover everything in depth. It also will be available as a gist on Github for everyone to edit and add to.

Data Structure Basics

###Array ####Definition:

Stores data elements based on an sequential, most commonly 0 based, index.
Based on tuples from set theory.

	-- Create Enum
	CREATE TYPE enum_type AS ENUM ('Value 1', 'Value 2');

	-- List All Enum
	SELECT UNNEST(ENUM_RANGE(null::enum_type));

	-- Add Value
	ALTER TYPE enum_type ADD VALUE 'New Value';

	-- Delete Value

	WITH all_ipp AS (
	SELECT program_id, SUM(total_amount_eqv) AS total_amount
	FROM pdg.ipp
	GROUP BY program_id
	), top_ipp AS (
	SELECT program_id
	FROM all_ipp
	WHERE total_amount > (SELECT SUM(total_amount)/10 FROM all_ipp)
	)
	SELECT

	-- Row to json (per row)
	SELECT row_to_json(project) FROM (
	SELECT * FROM pdg.project WHERE id=1750
	) project
	-- Ex
	SELECT row_to_json(datum) FROM (SELECT 'ID' AS id, 'Name' AS name) AS datum

	-- Aggregate Row to Array json
	SELECT json_agg(project) FROM (
	SELECT * FROM pdg.project WHERE id=1750

	/* Write in Console, your choice */

	["Choice 1", "Choice 2", "Choice 3"][Math.round(Math.random())]