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?
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).
I'm not a programmer or anything, I know only the basic stuff; the only experience I have is with Visual Basic some years ago. What other online resources would you suggest? Or should I just look for physical courses in my area? Thanks!
I'm trying to learn SQL to develop more job skills and break into business intelligence. All i need now is a good project where i actually create a database and use SQL so i can get some experience. Any ideas?
So I'm wanting to pursue a database related role within our school's financial aid office, namely on our systems team. Our financial aid office is divided into 4 teams, there's management, processing, service, and systems. Systems is where all of the backend stuff takes place. They work with software systems like Ellucian Banner, CLOGIC, and a couple other systems. there's a severe need for folks with SQL and Python coding skills as we have only one guy that is capable of writing these programming languages. So I want to learn these because I've always been fascinated and have wanted to learn SQL, Python, Tableau, Power Bi, etc. I don't want to pay like $300 or $400 for some certification on the office chance that i fail the exam only to have wasted $400 on an attempt to pass a difficult certification exam/test, however, I've heard great things about Udemy and Codecademy. Any thoughts on these online platforms? Are they worth it or would employers look at that and laugh? Thanks!
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.
I'm currently an accountant that is looking to develop more of a financial and operational analysis role at my company. As such I'm looking to try and pick up some technical skills that would help me with regards to data analytics. The most obvious skill being SQL.
I'm really enjoying the programming aspect of it, at least the bare bones intro that CodeAcademy is providing me, and it's really fun to build a little table and recall specific information.
What I'm noticing is that SQL is providing me with ample means to filter through data to get specific subgroups of data, by identifying items with specific values or value filters on certain columns and all--which is awesome, but in my current role we use a ton of Excel to do data mining, clean-up and manipulation, so I guess I'm just failing to see how I will be able to implement SQL into my role as it currently stands. Am I able to use add-ons or tools to enhance my analysis and data manipulation through Excel, or would I be using SQL to likely design my own data bases?
I think I'm just looking for some contextual, real life examples of how SQL would work in an accounting/financial analyst style of position so I can utilize and implement it into my current role.
I am looking to learn some basics of SQL. I am proficient in Python and Excel, but missing SQL in my toolbox.
I am looking to get to a basic level of proficiency as my short term goal.
Just wanted to know which of the aforementioned sites are better to learn about SQL and other languages like python, R etc. Have been swinging between Datacamp and Codeacademy to learn these languages but couldn't decide on one , need advice.
Edit: just started using Codeacademy as well , found out that it doesn't display the tables that i am working on like it does in DataCamp , you have to put the query to display the tables you are working with everytime you want to see the tables.
How are you guys finding it? I've just finished up the free edX course offered by Stanford and am trying to decide if the $200 is worth it.
$200? Probably not imo. There is so much free stuff available and $200 seems like a lot for an online course.
free edX course offered by Stanford
Why would you Codeacademy then?
Doesn't it cover everything? There is a 1100 page book that goes with it, lol. How can codeacademy have more?
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.
I really like codecademy but have almost completed it. I do a lot of this at work when I have time so it works out great. I don't want to do the Udacity courses at work because of the video. Is there anything else like codecademy that I can do at work? Especially for SQL? I looked at the interactive tutorials but didn't see anything. Any suggestions? Thanks
What is the review of sql tutorial in codeacademy.is it worth learning in codeacademy.com
Hello,
I'm looking to up my sql skills and transition from being a beginner to somewhat intermediate level. I really enjoyed the codecademy sql course because it was very hands on. I finished that course and have been looking at some sql courses on udemy, however I don't like learning in this way. I feel that I'm forced to watch a ton of videos and follow along the exercises but that's not allowing me to think for myself and apply what I am learning. So I'm wondering if any of you can recommend me a course, book, or anything that is more doing and less watching? Thank you so much.
If Udemy any recommended courses? Also interested in getting some kind of certificate to put on LinkedIn
when i try winpty it does not work
What is SQLite? | Codecademy when it comes to winpty it says 1% is not a valid win32 application.
your link requires a login so I can't access it.
do you have a detailed error message or stack trace? hard to know how to debug your problem without seeing the details. My best guess based on what you've posted is that you're trying to install a version of SQLite that was built for a different operating system (Linux probably). You'll need to install the Windows version.
Ye basically it says to download sqlite and git bash and then open the sqlite file on the terminal and then type winpty./sqlite3.dll and it should produce a sqlite> prompt but it says the 1% is not valid thing, and I definitely downloaded the windows one, also on the tutorial it says sqlite.exe but mine says sqlite.dll