Danny Kirschner danman01

SQL Notes

In this workshop, we will be learning and using SQL to access data in a relational database

Objectives:

Explain what a database is
Compare and contrast relational db vs NoSQL db
Write SQL commands to get data out of a database
Write SQL to put data into a database

I had to run the following cryptic commands to get my C compiler working in mac osx Mojave, after having everything working fine in a previous OS (Yosemite I think it was...)

This is an (somewhat) obvious step when upgrading osx:

xcode-select --install

I also had to do this, which I never would've known how to do without google and this post

sudo installer -pkg /Library/Developer/CommandLineTools/Packages/macOS_SDK_headers_for_macOS_10.14.pkg -target /

	vim

	Vim is a text editor available on most unix systems, and can easily be installed via package managers if not installed.
	Great for working in the terminal.
	Learning curve, but improves speed overtime.
	Terminal based text editor is the tool of choice for most professional coders (vim or emacs).

	My reasoning: why work with Atom, when you can work with Vim? Vim will always be there, always improving. Available on all systems, to all devs around the world (ssh into a server, use vim)

	<!DOCTYPE html>
	<html>
	<head>
	<title>Page Title</title>
	</head>

	<body>

	<h1>This is a Heading</h1>

	// Extend jquery with flashing for elements
	$.fn.flash = function(duration, iterations, hideAfter) {
	duration = duration \|\| 1000; // Default to 1 second
	iterations = iterations \|\| 1; // Default to 1 iteration
	const iterationDuration = Math.floor(duration / iterations);

	for (let i = 0; i < iterations; i++) {
	this.fadeOut(iterationDuration).fadeIn(iterationDuration);
	}

	.some-static-class:before {
	content: "";
	display: block;
	position: absolute;
	top: -30px;
	right: -30px;
	bottom: -30px;
	left: -30px;
	animation: some-static-class .2s infinite;
	animation-name: some-static-class;

	# Note: make sure you get the correct chromedriver link for your version of chrome, and that it's a stable release. Check here: https://sites.google.com/a/chromium.org/chromedriver/downloads
	# steps:
	# get the file
	# unzip it
	# move it to /usr/local/bin (or wherever)
	# I already added the above to my path. If you haven't, edit your ~/.bashrc or terminal profile of choice, and add `export PATH=/usr/local/bin:$PATH`
	# change owner to root
	# add executable
	# check version...
	# done!

	-- return all public tables
	SELECT * FROM information_schema.tables WHERE table_schema = 'public'