PS Query & SQL

What is the name of the Udemy course Lara? 

Once you have your bearings, some useful recommendations:

Formatting:

https://poorsql.com/

or if you're using an editor like VSCode there's plenty of plugins to do a similar function.

For testing/working out query ideas, you can use Fiddles such as the ones below.  You can create a small table that replicates what you are trying to work with (using faked data of course).

https://sqlfiddle.com/ and https://dbfiddle.uk/ghB9CI-W.

------------------------------
Michael Williams
Systems Analyst
University of Connecticut
------------------------------

Message from the HEUG Marketplace:
------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
------------------------------

I also want to mention that ChatGPT (and I would assume Claude as well), is great for SQL as well.  It can help troubleshoot things and even write SQL for you.  I have used it in the past to find better ways to write what I have.

Once you have your bearings, some useful recommendations:

Formatting:

https://poorsql.com/

or if you're using an editor like VSCode there's plenty of plugins to do a similar function.

For testing/working out query ideas, you can use Fiddles such as the ones below.  You can create a small table that replicates what you are trying to work with (using faked data of course).

https://sqlfiddle.com/ and https://dbfiddle.uk/ghB9CI-W.

------------------------------
Michael Williams
Systems Analyst
University of Connecticut
------------------------------

Message from the HEUG Marketplace:
------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.

I also want to mention that ChatGPT (and I would assume Claude as well), is great for SQL as well.  It can help troubleshoot things and even write SQL for you.  I have used it in the past to find better ways to write what I have.

Once you have your bearings, some useful recommendations:

Formatting:

https://poorsql.com/

or if you're using an editor like VSCode there's plenty of plugins to do a similar function.

For testing/working out query ideas, you can use Fiddles such as the ones below.  You can create a small table that replicates what you are trying to work with (using faked data of course).

https://sqlfiddle.com/ and https://dbfiddle.uk/ghB9CI-W.

------------------------------
Michael Williams
Systems Analyst
University of Connecticut
------------------------------

Message from the HEUG Marketplace:
------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.