Great video information in the video! My complaints are; 1. The closed caption obstructs the view of the commands being typed, making in more difficult to follow along while practicing and, 2. There should be clearer instructions on how to get the data site on Stanford instead of just jumping to it.
these instructions dont match up with the instructions provided in the tutorial: For Macs, use the Mac OS X (x86) sqlite-tools package: 1. Install it, and unzip it. 2. In your terminal, navigate to the directory of the unzipped folder using cd. 3. Run the command mv sqlite3 /usr/local/bin/. This will add the command sqlite3 to your terminal path, allowing you to use the command from anywhere. 4. Try typing sqlite3 newdb.sqlite. If you’re presented with a sqlite> prompt, you’ve installed SQLite! Enter control + d to quit. You can also exit by typing .exit in the prompt and pressing return.
what is the specific command to install like codeacademy said? they said we need 3200100 version, but I can not see any command to install that version, it comes with another more recently. thank you.
It was pretty confusing for me. I wish he showed links to web pages when he switched from one website to another. For example, how can I find the "SQLite Data Starter Packs" page?
Up until this point in the course codecademy has been holding my hand and going step by step... but as soon as it got the page where I am to download and attach to databases it ASSUMES that I know SO many things, Git Bash, and directories, and how to speak to the terminal, and even when I'm following the steps in the video it is not doing the things it is doing for him. So frustrating. Why did you all decide to give up on the SQL course right at the point of application?
Example: I am supposed to type "cd ~/Downloads/sqlite-tools-win32-x86-3200100/sqlite-tools-win32-x86-3200100/." into the terminal. that doesn't work. Well, probably because I did what the man in this video told me to do, which was moving the file to my own folder OUT of downloads. So I use the directory there: "cd ~C:\Users\Admin\Desktop\Learning\sqlite-tools-win32-x86-3380200" that doesn't work. So I drop the "C:\Users\Admin" and try it again, but the same issue. No such directory found. Why all this struggle? And why are the dashes going the opposite direction now between the example they shared and the actual directory? Completely in the dark here and it's like they go from holding your hand to pushing you off into the deep end without help, except actually there is help, it just sends conflicting signals that don't go with the actual instructions on the page...
@@fulvoma512 If you struggle with it, just learn some basic command line funcctions. It's really easy. Git bash is just a way to use a bash terminal in Windows.
make sure you choose desktop (or wherever your sqlite file is saved) in the terminal before you go to sqlite. if you're not in the right location it won't read your table so there will be no schema to show
@4:13 when I type in .schema on my imac the next colum only displays the exact sqlite> syntax. Does not display the tables, colums, etc from the acs file. Please help
Hi Rob, I hope someone from codeacademy can help me with this. I downloaded SQLite and all the steps went well (for my mac) until I attempted to down the data starter pack. I always get an alert saying I need to find or download an application to open the date with?? Super stuck. Been trying to figure it out for ages. Is it because I'm based in the UK or have I not really downloaded the SQLite? Thanks :)
1) District 15, New York has the highest poverty population: 285896 2) If you don't count null values then Montana has the lowest amount of immigrants: 21356 3) New York has higher asian population: 1196134. LA has 451761
@@lyudmilastarodubtceva801 Can you share the commands for question 1 and 3? I got the same district for 1, but with a different population. Answer to 1 shows: Congressional District 15 (114th Congress), New York|762550 For question 3, how did you search for asian population by city? Thanks!!
@@westonclarke4546 question 1: SELECT name, below_poverty_line FROM congressional_districts ORDER BY below_poverty_line ASC; question 3: SELECT name, asian FROM places ORDER BY asian ASC;
For my answers I got the following, let me know if anyone has a better way of doing it: #1 SELECT name, below_poverty_line FROM congressional_districts ORDER BY below_poverty_line DESC; #2 SELECT name, foreign_born_population FROM states ORDER BY foreign_born_population ASC; #3 SELECT name, asian FROM places WHERE name LIKE 'Ne%' OR name LIKE 'Lo%' ORDER BY asian DESC;
Not sure if it's better but a bit different: #1 SELECT name, below_poverty_line ...> FROM congressional_districts ...> ORDER BY below_poverty_line DESC ...> LIMIT 1; #3 SELECT name, asian FROM places WHERE name = 'New York city, New York' OR name = 'Los Angeles city, California' ORDER BY asian DESC;
I figured it out. When you're in the terminal and you're typing out the acs-1-year etc, make sure that you type 2015.sqlite NOT 2015-sqlite If you use the dot instead of the dash it should work, at least that is what helped me
Great video information in the video! My complaints are; 1. The closed caption obstructs the view of the commands being typed, making in more difficult to follow along while practicing and, 2. There should be clearer instructions on how to get the data site on Stanford instead of just jumping to it.
You can turn off the CC or drag it to the top
these instructions dont match up with the instructions provided in the tutorial:
For Macs, use the Mac OS X (x86) sqlite-tools package:
1. Install it, and unzip it.
2. In your terminal, navigate to the directory of the unzipped folder using cd.
3. Run the command mv sqlite3 /usr/local/bin/. This will add the command sqlite3 to your terminal path, allowing you to use the command from anywhere.
4. Try typing sqlite3 newdb.sqlite. If you’re presented with a sqlite> prompt, you’ve installed SQLite! Enter control + d to quit. You can also exit by typing .exit in the prompt and pressing return.
my terminal doesnt read cd~and after typing .schema nothing pops up even though ive made sure to choose where i have it saved. what am i doing wrong?
you need to add a space between cd and ~ like "cd ~" NOT "cd~"
@@yufliu I added that but nothing happened.. anyone know what I can do
@@khoatruong91 Did you end up solving the problem?
what is the specific command to install like codeacademy said? they said we need 3200100 version, but I can not see any command to install that version, it comes with another more recently. thank you.
I never thought this would be that easy. I struggled a lot for setting MySQL on my system. But this is done just in 1 to 2 minutes
Hopefully it will work for me
It was pretty confusing for me. I wish he showed links to web pages when he switched from one website to another. For example, how can I find the "SQLite Data Starter Packs" page?
google it ....
Does anyone know where can I download the SQLite Data Starter Packs from? Thanks in advance!
I have the same question! Just messaged Codecademy
Wonderful video! Thank you
Up until this point in the course codecademy has been holding my hand and going step by step... but as soon as it got the page where I am to download and attach to databases it ASSUMES that I know SO many things, Git Bash, and directories, and how to speak to the terminal, and even when I'm following the steps in the video it is not doing the things it is doing for him. So frustrating. Why did you all decide to give up on the SQL course right at the point of application?
Example:
I am supposed to type "cd ~/Downloads/sqlite-tools-win32-x86-3200100/sqlite-tools-win32-x86-3200100/." into the terminal. that doesn't work. Well, probably because I did what the man in this video told me to do, which was moving the file to my own folder OUT of downloads. So I use the directory there:
"cd ~C:\Users\Admin\Desktop\Learning\sqlite-tools-win32-x86-3380200"
that doesn't work. So I drop the "C:\Users\Admin" and try it again, but the same issue. No such directory found. Why all this struggle?
And why are the dashes going the opposite direction now between the example they shared and the actual directory?
Completely in the dark here and it's like they go from holding your hand to pushing you off into the deep end without help, except actually there is help, it just sends conflicting signals that don't go with the actual instructions on the page...
@@fulvoma512 If you struggle with it, just learn some basic command line funcctions. It's really easy. Git bash is just a way to use a bash terminal in Windows.
so a newer version comes up on mac, and when I press .schema nothing happens
ideas?
make sure you choose desktop (or wherever your sqlite file is saved) in the terminal before you go to sqlite. if you're not in the right location it won't read your table so there will be no schema to show
Great video, very useful thank you
sqlite3 comes pre installed on a mac...
should i use this or do i have to re-download it ? ...
Thanks...
weird how there is no support for the questions here
Does this work on a M1 mac?
Where is the link to download the sqlite?
@4:13 when I type in .schema on my imac the next colum only displays the exact sqlite> syntax. Does not display the tables, colums, etc from the acs file. Please help
I'm having the same issue. Please let me know if you figure this out.
Thank you!
Hi Rob, I hope someone from codeacademy can help me with this. I downloaded SQLite and all the steps went well (for my mac) until I attempted to down the data starter pack. I always get an alert saying I need to find or download an application to open the date with?? Super stuck. Been trying to figure it out for ages. Is it because I'm based in the UK or have I not really downloaded the SQLite? Thanks :)
do you have the answers for these questions?
1) District 15, New York has the highest poverty population: 285896
2) If you don't count null values then Montana has the lowest amount of immigrants: 21356
3) New York has higher asian population: 1196134. LA has 451761
@@lyudmilastarodubtceva801 Can you share the commands for question 1 and 3? I got the same district for 1, but with a different population.
Answer to 1 shows: Congressional District 15 (114th Congress), New York|762550
For question 3, how did you search for asian population by city?
Thanks!!
@@westonclarke4546
question 1:
SELECT name, below_poverty_line
FROM congressional_districts
ORDER BY below_poverty_line ASC;
question 3:
SELECT name, asian
FROM places
ORDER BY asian ASC;
My Mac mini stops the install as it is form an unknown source. How do I override that?
Those are my answer:
1.- Congressional District 15 (114th Congress), New York|285896
2.-Montana|21356
3.-New York city, New York|1196134
For my answers I got the following, let me know if anyone has a better way of doing it:
#1
SELECT name, below_poverty_line
FROM congressional_districts
ORDER BY below_poverty_line DESC;
#2
SELECT name, foreign_born_population
FROM states
ORDER BY foreign_born_population ASC;
#3
SELECT name, asian
FROM places
WHERE name LIKE 'Ne%' OR name LIKE 'Lo%'
ORDER BY asian DESC;
Not sure if it's better but a bit different:
#1
SELECT name, below_poverty_line
...> FROM congressional_districts
...> ORDER BY below_poverty_line DESC
...> LIMIT 1;
#3
SELECT name, asian
FROM places
WHERE name = 'New York city, New York' OR name = 'Los Angeles city, California'
ORDER BY asian DESC;
I have figured out Further Queries 2/3 except which place has the higher Asian population: NYC or LA. The OR and City specific thew in a curveball
E
All great until i hit ".schema" Nothing comes up
any solutions?
I figured it out. When you're in the terminal and you're typing out the acs-1-year etc, make sure that you type 2015.sqlite NOT 2015-sqlite
If you use the dot instead of the dash it should work, at least that is what helped me