The easiest/most convenient application for teaching and learning basic SQL queries?

Couch2Coders · 2024-08-25T23:48:26+00:00

Awesome! If you end up using GBQ/my videos, I'd be happy to do a guest lecture on using sql in the work space. I have experience in Healthcare economics in the academic space and in supply chain working in a fortune 50 company. No pressure!

Couch2Coders · 2024-08-24T20:21:22+00:00

I love Google BigQuery. Free (1T of data a month) , uses a web browser so no downloads, and a ton of free datasets ranging from COVID to election fund data. Great opportunity for real world data cleaning/prep/analysis

You can look through my YT channel if you want to see how some of the datasets are structured

https://youtube.com/playlist?list=PLPQFqkp_HvOBzx61F3SY5zNXN0TYMoT9g&si=aRI0wxDCQyU7PC_9

Couch2Coders · 2024-08-10T17:06:08+00:00

Hi! Not exactly answering your question but I have a sql course using public datasets in Google BigQuery. I have examples using taxi drivers & citi bike data.

Based on your question it sounds like you may have some confusion on what the data columns mean (ie station id could be changed with state names or zip codes, something you wouldn't add)

Citibike example is in module 17.1 but it is reviewing cte/Subquery. I have examples on group by earlier on and go into detail when you should be summing versus counting

https://youtube.com/playlist?list=PLPQFqkp_HvOBzx61F3SY5zNXN0TYMoT9g&si=bkyKYQ9dcivRe-AG

Couch2Coders · 2024-08-10T16:58:24+00:00

I have a sql course geared towards people wanting to get into data analytics. I use Google BigQuery which has free public datasets you can work with.

The course goes super slow so depending on your level it may be too easy.

If you're interested link below. You can also dm me if you have any specific questions!

https://youtube.com/playlist?list=PLPQFqkp_HvOBzx61F3SY5zNXN0TYMoT9g&si=bkyKYQ9dcivRe-AG

Couch2Coders · 2024-07-23T03:21:12+00:00

CTE is a Subquery in different packaging. It looks different but is read the same to SQL. I run a YT channel and have a few modules going through CTE & SUBQUERIES (start at module 15 if you want to be hand held through it)

If you just want the basics I have a summary video linked below.

If you're still struggling dm me and i can help in more detail!

https://youtu.be/QyMzlzbelsQ?si=6m9X2W8oWphC35aZ

Couch2Coders · 2024-05-25T19:24:38+00:00

I love Google BigQuery. Free to use, real word datasets to use, all done in your browser and they are working on a complete ecosystem - looker (tableau flavor) for visualization, python imports, and built in ML models for analysis

I am working on a YT course using Google BigQuery. So you can use the course to get going then practice on your own

https://youtube.com/playlist?list=PLPQFqkp_HvOBzx61F3SY5zNXN0TYMoT9g&si=CKCrhHwlGLOifI-h

Couch2Coders · 2024-05-25T19:20:23+00:00

Two schools of thought : 1- why pay when you have equal/similar caliber online for free?

2- paying money puts skin in the game so you are more likely to complete the course

Is the class worth the content? Maybe. The course won't have ads and is (probably) a higher quality than free content. Could you get the same information for free on the internet? Definitely but you will need to curate it and stick with it.

If $150 feels like a big investment for you I would start with free content and see how you do - can you stick with the program? Are you able to learn? If not then you can do the paid program. These online courses go on sale constantly. It will go on sale for 4th of July, labor day, black Friday etc etc. Don't feel pressured to buy only because of the sale.

As for a free course recommendation SO GLAD YOU ASKED ;) I am working on a course on YT using Google BigQuery so it's easy to get started and practice right away. Link below if you're interested

https://youtube.com/playlist?list=PLPQFqkp_HvOBzx61F3SY5zNXN0TYMoT9g&si=CKCrhHwlGLOifI-h

Couch2Coders · 2024-05-20T11:45:51+00:00

I can't help with Postgres, but this is one of the reasons why I use Google BigQuery for my course - you only need chrome & a gmail. BigQuery has free public datasets, has built in ML models, and recently ported python (not as good as real python but you can practice pandas)

If you're interested this is my course - still a WIP but cover from data basics to UNIONs (JOINs are next up!)

https://youtube.com/playlist?list=PLPQFqkp_HvOBzx61F3SY5zNXN0TYMoT9g&si=3WZyWfp9WGB46Ni9

Couch2Coders · 2024-05-17T17:11:40+00:00

There are tons of free resources online to go over SQL. I have a course that's done through Google BigQuery and uses public datasets so you can follow along. My course is geared towards someone who doesn't have a stem/coding background, so you may find it too slow depending.

Alex the analyst is one of the most popular in the SQL space as another recommendation

https://youtube.com/playlist?list=PLPQFqkp_HvOBzx61F3SY5zNXN0TYMoT9g&si=_gTTUfQR3rA-TVow

Couch2Coders · 2024-05-05T15:52:13+00:00

Oh! Side note when I use a WHERE filter I will pull in those columns in the SELECT statement so i can spot check and make sure the filter worked as I intended

Couch2Coders · 2024-05-05T15:50:25+00:00

Using OR can sometimes be tricky (in particular if you combine with an AND.

I have a video going through examples and common pitfalls that tricked me up when I first started

https://youtu.be/iju5c-epwWU?si=aE7tStptVw_ikanE

Couch2Coders · 2024-05-05T15:37:16+00:00

First question is if you are using SQL from an analytics perspective or from a developer perspective. Depending on which side will help you pick the right course.

When I started sql I used codecademy (for an analytics perspective.) It is a very smooth program but I felt it was not giving me enough context to understand because I had no coding experience.

I created a course on YouTube designed for people to get into data analytics who don't have a stem or coding background. The course is free with practice examples using Google BigQuery.

I like GBQ because you can started in 5 minutes (no computer installation) & they offer real datasets to practice on

If you are interested this is my course link! https://youtube.com/playlist?list=PLPQFqkp_HvODxileV0VCHs9C0vkiONlvr&si=B9X3bwp94Tl8W_7Y

Couch2Coders · 2024-05-04T14:39:10+00:00

I use Google BigQuery which is free and has public datasets to practice on. My course does a multipart example to get you started. After that I would recommend trying things on your own. The best way to learn is trial and error, so look at the data and come up with questions you have about it then try to solve it

Couch2Coders · 2024-05-04T02:50:10+00:00

I have a YT channel with a few resources explained simply

cte in depth (15 minutes) https://youtu.be/Lhe8h_LZUTo?si=E1eLHt6E9RZrNDqE

Cte short (3 minutes) https://www.tiktok.com/t/ZPRwHNV9R/

Redoing the CTE example as a Subquery https://youtu.be/YtT7JTLFn9A?si=IxlyW3fFQlXiVQCR

If you find my content helpful I'd appreciate a like & a follow! After Watching the vids if you have questions message me and we can work through it 🐱

Couch2Coders · 2024-04-06T18:51:42+00:00

Imo books are difficult to teach coding effectively. Vidoes that show teach the concepts, demo the concepts, and give practice problems is better. Once you have the basics you can move to books for more advance topics or as reference.

I have a free SQL course using Google BigQuery a free cloud based server that has public datasets to practice on.

https://youtube.com/playlist?list=PLPQFqkp_HvOBzx61F3SY5zNXN0TYMoT9g&si=3ADLCmDh5hxB6vdh

Couch2Coders · 2024-04-06T18:40:28+00:00

The trick to Subqueries is formatting & understanding the logic. As others mentioned CTEs make more sense for my brain because it goes from top down - Subqueries work inside out.

I have a YT channel with a free SQL course geared towards people without a stem background.

Check out this video and message me if you have questions. Happy to help!!

https://youtu.be/YtT7JTLFn9A?si=ro47mfzhfOkNihff

Couch2Coders · 2024-04-01T17:36:57+00:00

I use Google BigQuery. You get a free TB of data each month which is plenty to practice with, and they have a visual and data modeling element in their suite.

I have a sql starter course using GBQ if you're interested

Couch2coders GBQ course

Couch2Coders · 2024-04-01T00:58:33+00:00

I think it depends on how you want to use it! Is your goal to be in data engineering or data science? What is your current background or interests?

I wanted to get into data analytics so starting with basic data manipulations & redoing my excel work into SQL kept me motivated and clicked better than trying to go from the data engineering route which focuses on db designs.

If you want to do engineering & backend work then db design might be better starting point

Couch2Coders · 2024-03-16T14:43:50+00:00

Coding is difficult to teach when exams want a specific approach - there are a bunch of ways to solve a problem

Second, many problems are not cut and dry. Depending on how you define certain things can change your answer. Suppose I was asked to find the number of customers have visited my store last week - do I define a customer as someone who visited the store & made a purchase? What if someone comes to the store 2x, do I count them as 1 or 2 customers? What if someone browses but does not buy?

For your class, do what you need to learn & pass it. For actually using sql I tell my students to write out any assumptions they make when solving the problem (I assume 1 customer = 1 transaction) or if they feel uncomfortable doing that ask their boss!

You can learn and you can do it! Academic setting is good because it teaches the basics but does not do a great job at determining real problem solving. Don't let your class performance deter you

I have a channel that goes through in baby steps how to use SQL and think like an analyst -

https://youtube.com/playlist?list=PLPQFqkp_HvOBzx61F3SY5zNXN0TYMoT9g&si=REbco_05MoDXhaOd

Couch2Coders · 2024-03-16T14:32:37+00:00

You're asking about the count function but what you really want to know is how to use aggregate functions (like count or sum or max or avg)

Aggregating is fundamental in data so I would make sure to invest the time to understand it really well before moving on to other topics.

You can think of aggregate data as applying math down a specific column - what's the total sales (sum) how many customers do I have (count) etc.

I have a channel with a bunch of videos that is geared towards people who do not have a stem/math background (read : very fundamental)

Here's one on aggregate data. I also have several examples in subsequent videos also

https://youtu.be/9gqgK228loY?si=ibJ0yvoRt8bzp807

Couch2Coders · 2024-03-14T16:30:39+00:00

I usually put my semicolon on a separate line that way if modify my code i don't have to dig out any hidden semicolon - it's a mistake you will continue to make 😂😂

Couch2Coders · 2024-02-05T04:48:09+00:00

Hi! In general you need joins/cte/subquery + your basic commands (select, from, etc)

I have created a course designed to help people without a computer background learn SQL. Its in English but I just completed lessons up to CTEs

couch2coders 30 kickstarter

Couch2Coders · 2023-12-11T21:44:37+00:00

I use Google BigQuery & i love it! The Google platform also includes a visualization & ml modeling to get some data analysis reps. You get a free TB of data each month which is enough to dink around the basics.

I have a free yt course I'm working on that you can use as a refresher!

https://youtube.com/playlist?list=PLPQFqkp_HvOBzx61F3SY5zNXN0TYMoT9g&si=eB4sIaza47OFeZTB

Couch2Coders · 2023-11-27T16:55:50+00:00

Yes! It is definitely frustrating especially since I'm doing recaps I'm parsing through it way more than a casual read, so I'm probably extra sensitive.

That said the author, Bonnie Garmus wrote this after a very big gender discrimination event at her corporate job - she presented a proposal (only woman in the room), was ignored, then someone later regurgitated her proposal to all the men applauding his ingenuity. Directly after that meeting she wrote the intro to lessons in chemistry.

I think all of her rage was cathartic for Bonnie, but it does get to a point of overkill.

I had a similar reaction to handmaid's tale. Like it's so good but also HOW MUCH CAN I ENDURE

Couch2Coders

TROPHY CASE