SQL

[Maulik Patel]

Hello,

I want to learn SQL from scratch to advance level.

Any lead will be appreciated.

Thanks

-Maulik

[Mark Holmes]

Hello @Maulik Patel and welcome!

As others have mentioned, there are many resources. The ones that might be helpful getting started are

• https://www.freecodecamp.org/news/sql-and-databases-full-course/
  • video based, covering concepts and capabilities
• https://www.w3schools.com/sql/sql_intro.asp
  • tutorial based, and allows you to try it out in the browser following each topic
• https://www.codecademy.com/learn/learn-sql
  • free course, with hands-on embedded learning, and the opportunity to gain certificates on completion with a membership
  • free trial and a recent flash sale on an annual pro membership

Once you have some capabilities learned, you can followup with the Atlassian related resources.

And don't forget to focus on JQL as well if you haven't done.

All the best on your learning journey!

[Anurag Pandey]

Hello @Maulik Patel 

You can start learning SQL from here after that you can go with advance level focus on db engine specific SQL like Oracle, MSSQL, MySQL, PostgreSQL  etc  : 

https://www.w3schools.com/sql/

Thanks,

Anurag Pandey

[olgaostap]

Stepik.com has free SQL courses and training

[PJ]

Some helpful links to get you started. 

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/

https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-fields-reference-939938743.html