I am a college senior who is trying to hopefully break into consulting. Recently In an internship I got introduced to Microsoft access, and I loved it. I wanna learn SQL, because I think I would like it, and because it’s probably very useful and a competitive advantage. Has anyone ever tried Codecademy to learn SQL and is it any good for someone who has no experience in coding?
Codecademy Launched Learn SQL from Scratch!
For a moment there, I was hoping we were learning how to write SQL using Scratch . . .
More on reddit.comSQL Too Easy with FULL SOLUTIONS
So I got through codeacademy's three courses on SQL. How do I use SQL outside of the site though? And how can I use data/tables I find/want to use for queries?
As a side note, this is hilarious and highlights perfectly the issue with codeacademy type of courses.
More on reddit.comAre there any sites like Codecademy to learn sql?
Not exactly like codeacademy but below are few very good tools/sites
-
GalaXQL - Downloadable app that lets you learn progressively, uses stars and galaxies as sample data (its more fun that way)
-
SQLRU - Interactive SQL textbook. Good explanations, lets you run queries directly on different RDBMS from the site.
-
SQL Exercises
-
Learn SQL The hardway - I like this text book a lot. Uses sqlite for exercises.
What is SQL?
What does SQL do?
What do I need to know before learning SQL?
Videos
A HUGE thank you to all the peeps in this subreddit who helped out on the intensive <3 We worked nonstop over the last few months - building and iterating - aiming for nothing but the best curriculum. Projects from this course will also use datasets from real companies/organizations such as Warby Parker, Kickstarter, The Metropolitan Museum of Art, and Hacker News!
Learn SQL from Scratch - https://www.codecademy.com/pro/intensive/learn-sql-from-scratch
(also releasing!)
Programming with Python - https://www.codecademy.com/pro/intensive/programming-with-python
Data Visualization with Python - https://www.codecademy.com/pro/intensive/data-visualization-with-python
For a moment there, I was hoping we were learning how to write SQL using Scratch . . .
Idk if this is an appropriate question.
This isn’t meant to be offensive but an honest question from a newish learner, why should i choose code academy over the many other tutorial websites online?
I actually just started the “ make a website”, but ive also learned of like 5 other sites that have similar tutorials.
P.S im happy to see more tutorials being added since theres a 99% chance ill be using them. So thanks.
Sorry I'm a noob and probably not using all the correct language, but I'm not sure what kind of "compiler" (I know SQL doesn't use one but that's the word I'm choosing) it needs and how to scrape data to analyze.
As a side note, this is hilarious and highlights perfectly the issue with codeacademy type of courses.
There are multiple implementations of SQL. Simplest one is SQLite. This is nothing more than a file you put on a hard drive in a correct format. Basically an oversized and better structured .txt. How to manipulate it/look for data etc is on the shoulders of your program (most programming languages have tools for dealing with it however).
MySQL/PostgreSQL/MariaDB etc are more complex. Since you no longer manipulate a file directly. They have their own separate programs with which you communicate via SQL language. So your program needs to understand what it is connecting to, what are the credentials and what's the format of input/output but it doesn't need to understand the internal structure of a database nor how it works.
If you decide to learn a different programming language (since SQL by itself is a "bonus" language) then you will see that there are libraries to deal with popular SQL "formats" and if you are more adventurous then you can make one yourself (for SQLite it would require you to read its full documentation, for other types on how to establish an ongoing connection with a database and receive/send data to it).
For my current job I utilize SQL and I know some basic SQL usage. I want to expand on what I know and I enjoy Codecademy's approach.
Not exactly like codeacademy but below are few very good tools/sites
-
GalaXQL - Downloadable app that lets you learn progressively, uses stars and galaxies as sample data (its more fun that way)
-
SQLRU - Interactive SQL textbook. Good explanations, lets you run queries directly on different RDBMS from the site.
-
SQL Exercises
-
Learn SQL The hardway - I like this text book a lot. Uses sqlite for exercises.
The Schemaverse: http://schemaverse.com Take part in a space battle and learn SQL at the same time
Edit: It's my site so I am a tad bias. It is fun though and I have been told on a number of occasions that it has drastically improved the SQL skills of players.