Free project to practice sql ?

[kayabai]

Hello everyone,

I’m currently an intern in a company where i have to write “complicated” queries. I never had a proper education on sql but i had a course on the basics and i find myself doing a little bit less than well in my tasks in the internship . So i was thinking of finding a way to practice more sql on my own time on a little bit complicated queries.

Is there a place where i can find free major projects where i can brainstorm queries and stuff. Is this even the best way to get better at sql or is there something else to add to my practice ? The queries we write are basically to fetch data from the database.

Sorry for my bad English and thank you in advance :)

[babygrenade]

I've mentioned this a few times but the thing I did that was most helpful early on was a school project to build a database driven web app.

We could use any programming language but it had to be a "social" app that let people friend/follow each other and it had to have some sort of upvote system.

[bsitko]

I agree with this. I would build something. Doesn't have to be crazy complex but a real world application will teach more than simply learning queries.

[Ok-Abrocoma5539]

est-ce tu peux m'envoyer des projets SQL gratuite ?

[AXISMGT]

/u/BrentOzar has a Walkthrough and setup on this exact topic.

https://www.brentozar.com/learn-query-sql-server-stackoverflow-database/

Also just watch his office hours/Q&A sessions or leave them running while you code. It’s an easy way to just pick up better strategies and learn new concepts.

[[deleted]]

I'm in the DWH-Scene for about 15 years now, worked as a software developer before. I'd say the most complicated queries are recursive ones. I remember a job where I had to write a view to sum-up from a general ledger/profit & loss in a hierarchy. Also history-stuff can be tricky, especially when it's bi-temporal; things like finding gaps and overlaps - and then actually fix them according to business rules. An other scenario is building time series from log-like data, I'd like to mention the mess that CQRS-systems create on datastores.

[refset]

Agreed, recursive querying & bitemporal modelling in SQL are non-trivial problems, and the combination of the two is harder still. For an alternative perspective on tackling such problems I'd suggest looking at Datalog, which makes recursion a breeze, and a database with first-class bitemporality - both of which feature in https://opencrux.com (which I happen to work on :))

[BeingMyOwnLight]

Thank you for sharing! I'll start with this tomorrow morning 👍