this post was submitted on 21 Jul 2023
2 points (75.0% liked)
SQL - any and all
307 readers
1 users here now
For discussion about SQL and databases. All versions welcome.
- MSSQL
- PostgreSQL
- MariaDB
- SQLite
- etc...
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
It's difficult to give any advice without knowing the sort of questions you were asked, can you give any examples?
When I first learnt SQL I remember finding it really fiddly and kept making syntax errors due to it being so different to traditional programming.
I did loads of multiple choice practice tests where all the answers are very similar. So frustrating at first but helps to identify all the "gotchas" of the language.
These days it might be useful to paste your non-working query into ChatGPT and ask why it's incorrect.
I am familiar with the syntax and the differences from other languages. What I have been presented are problems challenging at a higher level of abstraction, in which for example a combinatorial problem needs to be solved in SQL. Just to be clear, I only barely code in Python and JS. I never solved such problems in those languages either.
I'm not sure what you mean by combinatorial problems?
I know you mentioned you didn't want to get into specifics, but it's really difficult to comprehend what you're struggling with without examples. Is there any reason you can just state a question you find difficult?
Presumably you understand basic SELECT statements? Is it JOINs or maybe group functions you are stuck on or something more advanced?