PS Query & SQL

Hello everyone! This has been a great HEUG discussion board. So much participation!

I learned SQL at a community college class around 2003. I took a semester of SQL. They happened to teach it on an Oracle database. I have not taken another instructor lead SQL class since. However, I know there have been advances with SQL since then. For example, Window Functions and Common Table Expressions.

Now we do not have to go to a community college in person class to learn SQL. There is a lot of online learning. And good old-fashioned books.

Please share any resources you have used to learn, update, or refresh your knowledge of SQL.

Thanks,

Enrique

Hello everyone! This has been a great HEUG discussion board. So much participation!

I learned SQL at a community college class around 2003. I took a semester of SQL. They happened to teach it on an Oracle database. I have not taken another instructor lead SQL class since. However, I know there have been advances with SQL since then. For example, Window Functions and Common Table Expressions.

Now we do not have to go to a community college in person class to learn SQL. There is a lot of online learning. And good old-fashioned books.

Please share any resources you have used to learn, update, or refresh your knowledge of SQL.

Thanks,

Enrique

Hello everyone! This has been a great HEUG discussion board. So much participation!

I learned SQL at a community college class around 2003. I took a semester of SQL. They happened to teach it on an Oracle database. I have not taken another instructor lead SQL class since. However, I know there have been advances with SQL since then. For example, Window Functions and Common Table Expressions.

Now we do not have to go to a community college in person class to learn SQL. There is a lot of online learning. And good old-fashioned books.

Please share any resources you have used to learn, update, or refresh your knowledge of SQL.

Thanks,

Enrique

What is the name of the Udemy course Lara? 

Hello everyone! This has been a great HEUG discussion board. So much participation!

I learned SQL at a community college class around 2003. I took a semester of SQL. They happened to teach it on an Oracle database. I have not taken another instructor lead SQL class since. However, I know there have been advances with SQL since then. For example, Window Functions and Common Table Expressions.

Now we do not have to go to a community college in person class to learn SQL. There is a lot of online learning. And good old-fashioned books.

Please share any resources you have used to learn, update, or refresh your knowledge of SQL.

Thanks,

Enrique

Hello everyone! This has been a great HEUG discussion board. So much participation!

I learned SQL at a community college class around 2003. I took a semester of SQL. They happened to teach it on an Oracle database. I have not taken another instructor lead SQL class since. However, I know there have been advances with SQL since then. For example, Window Functions and Common Table Expressions.

Now we do not have to go to a community college in person class to learn SQL. There is a lot of online learning. And good old-fashioned books.

Please share any resources you have used to learn, update, or refresh your knowledge of SQL.

Thanks,

Enrique

------------------------------
Enrique Pizana
PeopleSoft Developer and Support Engineer
Washington State Board for Community and Technical Colleges
------------------------------

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

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.

Original Message:
Sent: 02-05-2025 01:09 PM
From: Enrique Pizana
Subject: How to learn SQL in 2025?

Hello everyone! This has been a great HEUG discussion board. So much participation!

I learned SQL at a community college class around 2003. I took a semester of SQL. They happened to teach it on an Oracle database. I have not taken another instructor lead SQL class since. However, I know there have been advances with SQL since then. For example, Window Functions and Common Table Expressions.

Now we do not have to go to a community college in person class to learn SQL. There is a lot of online learning. And good old-fashioned books.

Please share any resources you have used to learn, update, or refresh your knowledge of SQL.

Thanks,

Enrique

------------------------------
Enrique Pizana
PeopleSoft Developer and Support Engineer
Washington State Board for Community and Technical Colleges
------------------------------

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.

Original Message:
Sent: 02-05-2025 01:09 PM
From: Enrique Pizana
Subject: How to learn SQL in 2025?

Hello everyone! This has been a great HEUG discussion board. So much participation!

I learned SQL at a community college class around 2003. I took a semester of SQL. They happened to teach it on an Oracle database. I have not taken another instructor lead SQL class since. However, I know there have been advances with SQL since then. For example, Window Functions and Common Table Expressions.

Now we do not have to go to a community college in person class to learn SQL. There is a lot of online learning. And good old-fashioned books.

Please share any resources you have used to learn, update, or refresh your knowledge of SQL.

Thanks,

Enrique

------------------------------
Enrique Pizana
PeopleSoft Developer and Support Engineer
Washington State Board for Community and Technical Colleges
------------------------------

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.

Original Message:
Sent: 02-05-2025 01:09 PM
From: Enrique Pizana
Subject: How to learn SQL in 2025?

Hello everyone! This has been a great HEUG discussion board. So much participation!

I learned SQL at a community college class around 2003. I took a semester of SQL. They happened to teach it on an Oracle database. I have not taken another instructor lead SQL class since. However, I know there have been advances with SQL since then. For example, Window Functions and Common Table Expressions.

Now we do not have to go to a community college in person class to learn SQL. There is a lot of online learning. And good old-fashioned books.

Please share any resources you have used to learn, update, or refresh your knowledge of SQL.

Thanks,

Enrique

------------------------------
Enrique Pizana
PeopleSoft Developer and Support Engineer
Washington State Board for Community and Technical Colleges
------------------------------

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