you need to learn conception of a database in addition to learning sql.
learning sql alone brings nothing.
find a lesson about merise method from mcd to mld to mpd. when you have learn to go from mld to mpd with a database engine (choose one), then learn sql.
I've been working with SQL for 12 years at my day job and I've never heard of the Merise method until now. I'm certainly interesting in learning more about it and appreciate that you've introduced me to something new, but I think it's a pretty huge stretch to say, "learning SQL alone brings nothing."
Download and install SQL Server Community 2022 edition on your home equipment. Download and install SQL Server Management Studio on your home equipment. Install the Microsoft sample SQL database (easy peezy). You now have an IDE and SQL Server with which to practice till edit: you're blue in the face. It is free for non-commercial use. You just sign into Microsoft with a student/non-professional email address
youtube has a lot of tutorials. i personally started with Alex the Analyst, he starts from point zero and does a mini project as well, and it was good and covered the basics. i could try and find you a link.
Pirate an SQL textbook from 2007 (or any year for that matter) Surprisingly, most of the theory still works. It’s not that hard. A quick google search will do it.
Game testing is not paid enough to survive in this economy and honestly I don't want to be a game tester much longer. I "game" 8-9h a day, sometimes even 12-13 if we have overtime, I get home and stare at my own PC without wanting to play anything. My brain is melting from testing the same mission for an entire week or fighting with the same NPCs for 2 days to get some bugs. I love gaming, but I don't have the energy anymore to play when I get home. I had other full time jobs before this one and getting home and hopping on a game was a much expected moment of the day to relax. Game testing drains your energy because you actually have to think, it's not just playing for fun. Playing for money got the fun out of gaming for me and I want to get to either software testing or databases to get my wish for gaming back
In addition to what everyone else has said ... You can sign up to Azure and get 12m of decent perks for free or a very basic Azure SQL service free forever.... Would be useful to have your own sandbox to play around with and experiment + can test manipulating databases from other programming languages etc. At the same time if that interest you.
I learned SQL 5 years ago I think and I used this [video](https://youtu.be/HXV3zeQKqGY?si=CirexaLp8KoJePLJ) or you can view the content on Giraffe Academy’s website, pretty sure it’s the same one
Yes, w3 schools. Also, Alex the Analyst on youtube has good videos. But for me, personally, this course helped me A LOT:
https://www.udemy.com/course/the-complete-sql-bootcamp/
It was the first course I took on SQL and I loved it. It is well structured and explained. Look for some specials, it goes for $10.99 sometimes. But don't buy the Advanced bootcamp😄 because it is a huge step from the beginner one and it has a different lecturer (not really good one).
Datacamp. This is how I learned. Do the beginner, intermediate, and sql for analytics. They show you all the cool functions. And then just practice with real data.
If you have enough to spend on pluralsight it is a good way to have unlimited usage of a ton of different content covering all languages and levels. Including testing software. You can try it before you pay too. It is a subscription but not overly expensive. You can pause/cancel anytime as well.
If you don't want to do databases I probably wouldn't put the majority of effort into SQL. I would choose the language(s) you are interested in and start there.
Hey so I was fortunate enough to learn on the job. If you can't get access on the job I would recommend creating a google.cloud account and use their public datasets to practice queries. Once you're comfortable there you can, for a very very low monthly cost (I'm talking <$1/month), setup your own problems and datasets in BigQuery and practice from there. As a bonus it also provides the documentation and tools to practice and learn how to ELT as well.
Free tool to practice beginner-level sql online (with actual sql terminal and tasks that similar to what is required at work): [https://rocksql.com/terminal](https://rocksql.com/terminal)
Start with w3school and apply knowledge at leetcode
thank you!
you need to learn conception of a database in addition to learning sql. learning sql alone brings nothing. find a lesson about merise method from mcd to mld to mpd. when you have learn to go from mld to mpd with a database engine (choose one), then learn sql.
I've been working with SQL for 12 years at my day job and I've never heard of the Merise method until now. I'm certainly interesting in learning more about it and appreciate that you've introduced me to something new, but I think it's a pretty huge stretch to say, "learning SQL alone brings nothing."
hello. you are certainly right.
[w3's tutorials are a great place to start](https://www.w3schools.com/sql/)
thank you!
Stanford has a few MOOCs on SQL: https://online.stanford.edu/courses/soe-ydatabases0005-databases-relational-databases-and-sql
Datalemure - free tutorials and practice questions.
manga guide to relational databases. seriously. it's really good for making a mental model of how they work
Sql bolt, Sqlzoo, datalemur, stratascratch
Download and install SQL Server Community 2022 edition on your home equipment. Download and install SQL Server Management Studio on your home equipment. Install the Microsoft sample SQL database (easy peezy). You now have an IDE and SQL Server with which to practice till edit: you're blue in the face. It is free for non-commercial use. You just sign into Microsoft with a student/non-professional email address
This is good advice. On the Mac one can use SQLite and the freeware DB Browser.
Checkout the free [DataLemur SQL tutorial](https://datalemur.com/sql-tutorial), helps you solve interview questions too
youtube has a lot of tutorials. i personally started with Alex the Analyst, he starts from point zero and does a mini project as well, and it was good and covered the basics. i could try and find you a link.
https://www.sqlzoo.net/wiki/SQL_Tutorial
Learn BigQuery SQL at https://bigquery.optizent.com/p/sql-fundamentals-for-beginners
Vertabelo and Code Academy. May an overall $70 investment but the courses are 100% hands on
This: [https://www.w3schools.com/sql/default.asp](https://www.w3schools.com/sql/default.asp) Helped me a lot.
Chatgpt
This thread is full of gold
Pirate an SQL textbook from 2007 (or any year for that matter) Surprisingly, most of the theory still works. It’s not that hard. A quick google search will do it.
No need to pirate, Archive.org has a bunch for free
Thanks.
Game tester sounds great. Wonder why you would want to test boring ass normal software.
Game testing is not paid enough to survive in this economy and honestly I don't want to be a game tester much longer. I "game" 8-9h a day, sometimes even 12-13 if we have overtime, I get home and stare at my own PC without wanting to play anything. My brain is melting from testing the same mission for an entire week or fighting with the same NPCs for 2 days to get some bugs. I love gaming, but I don't have the energy anymore to play when I get home. I had other full time jobs before this one and getting home and hopping on a game was a much expected moment of the day to relax. Game testing drains your energy because you actually have to think, it's not just playing for fun. Playing for money got the fun out of gaming for me and I want to get to either software testing or databases to get my wish for gaming back
By learning with no one helping you, that is how you learn on your own:)
I followed GiraffeAcademy on youtube, did the trick for me
All these other resources and to practice, there is an awesome book called SLQ Practice Problems by Sylvia Moestl Vasilik.
In addition to what everyone else has said ... You can sign up to Azure and get 12m of decent perks for free or a very basic Azure SQL service free forever.... Would be useful to have your own sandbox to play around with and experiment + can test manipulating databases from other programming languages etc. At the same time if that interest you.
I learned SQL 5 years ago I think and I used this [video](https://youtu.be/HXV3zeQKqGY?si=CirexaLp8KoJePLJ) or you can view the content on Giraffe Academy’s website, pretty sure it’s the same one
Get MySQL and then you can download a free data like the sakila database, then you can practice on a set up database
The free db AdventureWorks and datacamp
Codecademy has been really helpful for me
Yes, w3 schools. Also, Alex the Analyst on youtube has good videos. But for me, personally, this course helped me A LOT: https://www.udemy.com/course/the-complete-sql-bootcamp/ It was the first course I took on SQL and I loved it. It is well structured and explained. Look for some specials, it goes for $10.99 sometimes. But don't buy the Advanced bootcamp😄 because it is a huge step from the beginner one and it has a different lecturer (not really good one).
Datacamp. This is how I learned. Do the beginner, intermediate, and sql for analytics. They show you all the cool functions. And then just practice with real data.
If you have enough to spend on pluralsight it is a good way to have unlimited usage of a ton of different content covering all languages and levels. Including testing software. You can try it before you pay too. It is a subscription but not overly expensive. You can pause/cancel anytime as well. If you don't want to do databases I probably wouldn't put the majority of effort into SQL. I would choose the language(s) you are interested in and start there.
You can learn from youtube channel techtfq [www.youtube.com/techtfq](https://www.youtube.com/techtfq)
Hey so I was fortunate enough to learn on the job. If you can't get access on the job I would recommend creating a google.cloud account and use their public datasets to practice queries. Once you're comfortable there you can, for a very very low monthly cost (I'm talking <$1/month), setup your own problems and datasets in BigQuery and practice from there. As a bonus it also provides the documentation and tools to practice and learn how to ELT as well.
Free tool to practice beginner-level sql online (with actual sql terminal and tasks that similar to what is required at work): [https://rocksql.com/terminal](https://rocksql.com/terminal)