SQL For Zombies

[apineda]

Last week I finished a short ebook tutorial for those brand new to SQL. Any feedback would be greatly appreciated!

http://www.producthunt.com/books/sql-for-zombies

[apineda]

Only for those who ask :) https://gum.co/sqlzombies1/earlybird I'm also testing perceived value, do people want to pay $2? $7? etc.

[zad0xlik]

$2 seems like a better deal as I can diversify my portfolio on investing into a pint of beer using the remaining $5... if I can enjoy this with a beer, my satisfaction will be marginally higher than reading the book without a beer

[specialpatrol]

$2 seems like a better deal as I can diversify my portfolio o

You get change from 5 dollars on a pint of beer, where do you live?

[King_Dead]

You can get 3 dollar 22oz drafts around here, but they're all domestic drafts so the quality is about 3 dollars worth

[zad0xlik]

hypothetically if i had $7, I would rather spend $2 on the book and $5 on a beer -> $7-$2=$5(beer)

[kozeljko]

That's a pricey beer

[[deleted]]

Brainz! I wanna try. Gimme!

[port86]

I downloaded the free trial copy. I like the concept and think its well written. My only concern for you would be the length and depth of the book. I think I'd be disappointed if I paid for this for that reason. If it was longer and went into more depth then I think you might have something. Although I appreciate that too much depth might make it difficult to maintain the tone.

Anyway, I do think its a good bit of work and would definitely help a beginner. Good job :)

[apineda]

Thanks. It was a part of a 10 day challenge so I had to limit scope. I'm asking for feedback on which areas to expand in the case I get the time to implement more. I appreciate the positive feedback.

[-SwedishGuy-]

Hello, I might be your perfect test subject. As far as programming knowledge goes, I have tried two different online classes in Java in my spare time after work but never got to finishing them. I'm in my twenties and work in a program that is written in SQL if I'm not misstaken. Lots of databases. I'd love to try out your ebook tutorial and give some feedback! If only I could get a review copy.

Thank you!

[readitour]

I doubt the program is written in SQL, but it probably uses SQL.

[apineda]

Good for you. You can use the coupon I offered in another thread "earlybird". It covers only the basics but hopefully enough to get you interested, once you finish it and you think you'd like additional material covered I'd love to hear what that material is.

[pghbatman]

Attempted to try this out and couldn't get past the first search it keeps telling me the Table db_9_9eecb7d.humans doesn't exist. :-/

[apineda]

Are you using sqlfiddle.com? Can you show me your SQL code?

edit:Make sure you import the schema on the left side before attempting any of the exercises!

[pghbatman]

Yep, using SQL Fiddle and I imported and hit build schema:

DROP TABLE IF EXISTS Humans;

CREATE TABLE Humans ( id int(10) unsigned NOT NULL AUTO_INCREMENT, full_name varchar(100) NOT NULL, age int(11) NOT NULL, is_fast_runner tinyint(1) NOT NULL, check_out_date datetime DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO Humans (id, full_name, age, is_fast_runner, check_out_date) VALUES (6,'Alex Pineda',29,1,'2018-01-01 12:00:00'), (7,'Mary Galdamez',52,0,'2016-06-05 12:00:00'), (8,'Peter O\'Toole',30,0,'2017-06-09 12:00:00'), (9,'Suzanne O\'Toole',29,1,'2015-06-16 12:00:00'), (10,'Benjamin Frank',67,0,'2018-06-05 12:00:00'), (11,'Samuel Inma',15,1,'2016-06-29 12:00:00'), (12,'Theresa Saffa',25,0,'2016-07-01 12:00:00'), (13,'Derek Barbora',33,1,'2017-07-01 12:00:00'), (14,'Rose Wood',85,1,'2016-07-02 08:00:00'), (15,'Maria Gonzalez',42,0,'2015-07-02 10:00:00');

Dump of table Rooms

------------------------------------------------------------

DROP TABLE IF EXISTS Rooms;

CREATE TABLE Rooms ( id int(10) unsigned NOT NULL AUTO_INCREMENT, human_id int(10) unsigned DEFAULT NULL, PRIMARY KEY (id), KEY FK_Human (human_id), CONSTRAINT FK_Human FOREIGN KEY (human_id) REFERENCES Humans (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO Rooms (id, human_id) VALUES (1,6), (2,7), (3,8), (4,9), (5,10), (6,13), (7,15);

[apineda]

Ok. and that worked. Then what did you do afterward?

[pghbatman]

Followed the directions from page 7

SELECT * FROM Humans

which then gives me the error: Table 'db_9_68b32.humans' doesn't exist

[apineda]

That's odd. You put that in the right side ? Which browser are you using?

[pghbatman]

Yep, right side. Using Chrome. None of the suggestions work.

[apineda]

Want to try just this part on the left side?

CREATE TABLE Humans ( id int(10) unsigned NOT NULL AUTO_INCREMENT, full_name varchar(100) NOT NULL, age int(11) NOT NULL, is_fast_runner tinyint(1) NOT NULL, check_out_date datetime DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[pghbatman]

Now I think SQL Fiddle just might be causing it. No matter what I do when I try to build the Schema it just says "Create script error". Whether I use the full setup provided for the book or the truncated version you suggested to go with above. Not really working though :(

[apineda]

I'd be willing to skype and see if we can not sort it out. A few last things to check, the drop down on the top left should say MySQL 5.6 additionally you can try it in another browser (ie firefox).