5 Tips to Learn SQL the Hard Way
The following is a guest post by Li Ouyang and originally appeared on her blog. Li is currently a student a The Flatiron School. You can learn more about her here, or follow her on twitter here. Have you been trying to Learn SQL The Hard Way, but can’t figure out how to run sql code in the […]
Reading Time 0 mins
Have you been trying to Learn SQL The Hard Way, but can’t figure out how to run sql code in the terminal? Better yet, you have downloaded a GUI, and still don’t know how to run your newly minted sql code? Your frustrations are warranted. See below for examples, screenshots, and solutions.
I’m forever stuck in the sqlite prompt. How do I get back to terminal prompt?
I messed up and want to start over!
I’m feeling shakey with this syntax. How can I play around with SQL queries on the command line, without running a SQL file, a la Mr. Shaw?
Typing new rows is tedious. Tell me there’s a faster way.
Forget this terminal crap. I’m a visual person. Show me how to use a friendly interface please….oh yeah, and I’m cheap.
Posted by Flatiron School / October 10, 2012
Learn to Code Python: Free Lesson for Beginners
What is the difference between a data analyst and a data scientist?
While data analyst and data scientist roles attract similar types of creative and logical people, their roles do have stark differences. Here’s our breakdown of the lines between these often mixed up roles.