What’s the best free beginner course for learning SQL?
How to learn SQL in-depth
Can someone recommend a tutorial for working with SQL?
Any free courses? I want to learn more.
Does AI2sql optimize SQL queries?
What databases does AI2sql support?
How do I start using AI2sql?
Videos
Specifically using it to query company data in different Salesforce CRMs from altered software.
Hi everyone. I'm a data scientist currently and interested in switching to data engineering. The latter requires better SQL knowledge. I already know basic SQL, can solve easy and intermediate questions on hackerrank, but i want to go deeper. I want to understand how the particular query works, what happens in background, how SQL parses queries and how to write more optimal SQL. I think here I need some resources teaching theoretical, fundamental knowledge, not only practicing on Hackerrank or DataLemur. Any advice, book, course, docs, etc will be appreciated.
P.S. As for SQL variant, I'm going to use Oracle, but I think it's not that important in my situation, as I look for fundamental SQL knowledge (correct me if I'm wrong).
I just got hired as a business analyst and I'm expected to be able to access the databases and pull data as needed. Tomorrow is my first day.
My employer knows I don't know SQL well, I used it a few years ago for a single class, but I'm familiar with Python, R, and a little bit of experience in other code. I started the SQL lessons on W3 but if anyone can recommend one specifically for someone working alongside SQL at work, that would be really helpful.
I'm not a database architect or a programmer, just need to be able to work with the tools available for now.