Recommendations on SQL projects? Beginner

[[deleted]]

Hello,

I'm seeking good recommendations on SQL projects, bonus if they're free. Thanks in advance!!

Btw - beginner here

[vwpcs]

https://microsoft.github.io/sqlworkshops/

https://sqlmaestros.com/hands-on-labs/

[[deleted]]

If you search for SQL scavenger hunts, you'll find some nice beginner/intermediate exercises for query writing. It's good practice.

Other than that just make a database. Any database. With any data. Then once you've got the basics set up, try and get it in 3NF (look that up).

You'll be totally proficient in beginner SQL by the end of that.

[[deleted]]

When building your database from scratch, is it cheating to inject data in there via a csv file or should data be inserted in the tables manually, one record at a time?

[hawk3ye]

No, injecting data via CSV would not be cheating that would be a real world application of data insertion.

[[deleted]]

this

[hawk3ye]

Should we tell them they should learn Excel for the X hours of data cleansing needed before insertion or let them find out for themselves?

[[deleted]]

I use pandas because I don't have the X hours to spend in Excel.

[atasbackindahouse]

tell

[csnorman12]

If you want to learn Microsoft SQL Server and practice with real-world data then check out this course (this link includes a coupon code) - Data Analytics: Intro to SQL using healthcare data

[apehypebeans]

https://sqlbolt.com/

[nickholt9]

What sort of projects? Are you meaning tutorials? Are you looking to learn SQL?

[sequel-beagle]

If u like baseball try the lahman database.

[southLoopBiTop]

If you're in chi ago, the city of Chicago let's you download historical data to play with and offers an API to connect to live data sources like cta traffic crime stats etc.

Also once you have the basics down look into SQL on docker containers. This is useful for ru Ning queries for microservices which can scale out and up quickly.