ga-wdi-boston / sql Goto Github PK
View Code? Open in Web Editor NEWLicense: Other
License: Other
This is important to follow on lessons sql-join and sql-join-tables which rely on the state of this database.
Align with version of PostgreSQL installed in MAC OS X from brew.
SELECT
is used throughout, and parts of it's syntax, most notably WHERE
are reused in other commands.
This requires scaffolding creating and loading tables.
via @gaand
use --file=filename
instead of -f filename
I understand the change from instructor -> consultant. But why add 'lead consultant' @gaand ? Seems like we lose flexibility that way...
e.g.
"We've been talking about Rails... why are we suddenly talking about databases?"
Context, scaffolding, etc etc.
Excluding multi-author books (2?)
Removed illustrator mention for Charlotte's Web.
At least most of it, with a quick review during the talk.
a) because there are none, and
b) because in the ALTER TABLE exercise, we deleted the 'height' column in the 'people' table.
search and replace.
@gaand should check that I got this issue right. It was about 050_update_books
grep Rowling sql/data/books.csv |cut -f 2 -d,
Correction to output of the above
-J.K. Rowling
+J. K. Rowling
J. K. Rowling
J. K. Rowling
J. K. Rowling
J. K. Rowling
J. K. Rowling
J. K. Rowling
#4 of Preparation instructs to install dependencies. No dependencies needed.
Learning objective? Note for delivery? Recapitulation?
Demo into lab, or code-along into lab at most.
In books.csv
per @jrhorn424
- `scripts/library/create_table_books.sql`. We can execute the commands in the
+ `scripts/library/000_create_table_books.sql`. We can execute the commands in the
I will provide more specific commits later.
Because feminism.
per @gaand
This requires the creation of a data repo
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.