Elvin Chu Elvincth

There are a number of good introductory SQL resources available for free and online. There are also some paid resources which I recommend for beginners, that are very effective, and well worth expensing in my opinion.

A couple of notes:

I haven’t used all of these resources, but they come with strong recommendations around the web or myself/my peers.
You absolutely don’t need to use every single resource. Find a couple that work for you, and go to town.
You can always reach out to me if you have questions. I always paste this online when people are new to asking very technical questions – it’s not meant to be snarky – it's a gentle guide on how to compose your questions and gather necessary resources in order to best give technical people the information needed to get a quick/effective response: http://www.mikeash.com/getting_answers.html

Video/Class/Mini-course based:

Stanford Self-paced ‘Database’ course

The original Coursera

Setting up Heroku and Cloudflare (the right way)

The following outlines how to setup Heroku + Cloudflare with a full SSL certificate. What this means is that communication between the browser and the Cloudflare CDN is encrypted as well as communication between Cloudflare and Heroku’s origin server. Follow these steps exactly and the setup is a breeze.

Step 1: Set up domain names in Heroku

First you want to add the root domain and the www domain to heroku. You do this by clicking into your production application, then going to settings and then scrolling down to Domains and certificates.

Here you will add <your_domain>.com and www.<your_domain>.com. This will give you two CNAME records. They will look something like <your_domain>.com.herokudns.com and www.<your_domain>.com.herokudns.com.

Step 2: Add CNAME records to Cloudfare.

SQL Tutorial for Beginners

語法教學：

Choose Database

USE [database];

DB中選擇要使用的DB空間。

Chat GPT "DAN" (and other "Jailbreaks")

	// Gist by [email protected] Rev 2.1.2 May 15, 2019
	// go to your insta profile page (not the home page). It looks something like this: https://instagram.com/YOUR_PROFILE
	// Open javascript console "Ctrl + Shift + i" in Windows/Linux and "Cmd + option + i" in Mac.
	// Paste the entire code below to the console and hit enter
	// You will get the list of people whom you follow but who don't follow you back and viceversa as well as the entire list of followers and following

	var following = [],
	followers = [],
	followersCount = 0,
	followingCount = 0,

	// Run GOOGLE CHROME - WORKING AS OF MARCH 23 2025
	// Please @ me in the comments if this stops working, I will try to get it working again within the month

	// INSTRUCTIONS
	// 1. Open Instagram in Chrome
	// 2. Click on "followers" on any Instagram profile so you can see the list of followers
	// 3. Open developer tools by right clicking on the page and clicking "INSPECT"
	// 4. Copy the code below and paste in the developer tools console and press enter to run
	// 5. Script will not run if tab is navigated away from, minimized of unfocused (It is recommended to open a new chrome window or push tab to the side and let script run in background)

	# Couldn't figure out how to do /s or get VS Code to search over newlines so came up with this convoluted mess '[\S\s]*?\n?' that matches all characters plus newlines

	Search for: <(table\|tr\|td\|p\|div\|span)[\S\s]*?\n?>
	Replace with: <$1>