PostgreSQL Exercises
pgexercises.com
PostgreSQL Exercises
1–10 of 47 posts
Re: PostgreSQL Exercises
#2Great idea, does what it should and can be extended to cover a lot more. Keep up the great work.
First time looking at it I thought I was on a official Ubuntu site, what a font and color can do to a branding is fascinating.
Re: PostgreSQL Exercises
#3Great idea, does what it should and can be extended to cover a lot more. Keep up the great work. First time looking at it I thought I was on a official Ubuntu site, what a font and color can do to a branding is fascinating.
Well, it is using the Ubuntu font!
https://pgexercises.com/css/site.css
Re: PostgreSQL Exercises
#4Very impressive! Works well, nice UI, informative.
After doing a couple exercises what I don't like is the naming convention. Something like "montlymaintenance" or "recommendedby" are just hard to read and type and I'd much rather use snake-case and/or shorter names. Eg. "monthly_maintenance" or "maintenance_per_month" or just "maintenance" if it's explicit enough that it's always per month.
Also to me using shorthands for ids is a bit hmm hmm I mean sure you write them a lot so it's useful to spare your fingers when typing queries but "facid" just seems wrong. Again maybe underscore? "fac_id" or even "facility_id".
Well that's at least my opinion. Also would it be a better practise to use "timestamptz" instead of "timestamp"? And FYI I had to zoom to 125% because the font was so small on my laptop.
Re: PostgreSQL Exercises
#5Neat - thanks for sharing!
In the SQL MOOC space, you can also check out https://academy.vertabelo.com.
If other people have resources, please share them out, I think this is an area where spreading the knowledge is particularly useful to most developers.
Re: PostgreSQL Exercises
#6Cool.SQL Zoo http://sqlzoo.net/ is also worth recommending for beginners.
Re: PostgreSQL Exercises
#7Very impressive! Works well, nice UI, informative. After doing a couple exercises what I don't like is the naming convention. Something like "montlymaintenance" or "recommendedby" are just hard to read and type and I'd much rather use snake-case and/or shorter names. Eg. "monthly_maintenance" or "maintenance_per_month" or just "maintenance" if it's explicit enough that it's always per month. Also to me using shorthan…
Same thing, took me a while to understand that facid was indeed facility_id.
In my previous work, we used this to test candidates when their job involved writing SQL. Worked great.
Re: PostgreSQL Exercises
#8Very impressive! Works well, nice UI, informative. After doing a couple exercises what I don't like is the naming convention. Something like "montlymaintenance" or "recommendedby" are just hard to read and type and I'd much rather use snake-case and/or shorter names. Eg. "monthly_maintenance" or "maintenance_per_month" or just "maintenance" if it's explicit enough that it's always per month. Also to me using shorthan…
Timestamptz is better practice. Same size (8 bytes) on disk and saves you from headaches further down the line.
Re: PostgreSQL Exercises
#9Did a few exercises and seems nice. An improvement would be if hints included links to PostgreSQL documentation, would make it easier for beginners to find good information.
Re: PostgreSQL Exercises
#10i was just googling for these yesterday! this is great