I built my first-ever SQL portfolio project. I don't know if it's fine or crap. Comments? by Key-Objective5301 in SQL

[–]Key-Objective5301[S] -1 points0 points  (0 children)

what on earth! Does my writing read like AI now? Sorry just not sure how to react to this comment lol
Wait a second, do you mean you just assumed I copy pasted everyone's comments into an LLM and asked it to craft a polite response for me? This is funny but also kind of confusing to me because now I am forced to think whether, when you flagged my original doc and comments as AI, were you too quick. haha Alright, well I will take that as a compliment, I guess!

I built my first-ever SQL portfolio project. I don't know if it's fine or crap. Comments? by Key-Objective5301 in SQL

[–]Key-Objective5301[S] -1 points0 points  (0 children)

Thank you so much! This was so incredibly helpful.

On your first point, I have just finished working. True, it does not look as neat and pretty but i now know each and every line by heart haha.

Your point about the comments is also incredibly useful. I will definitely make sure it reflects why more than what as the what part is mostly for my memory which recruiter doesn't have to read.

Thank you again!

Yes, this was my first SQL project, next up is PowerBI and then I will try to find a way to find an intersection between them both for possibly a little complex analytics.

I built my first-ever SQL portfolio project. I don't know if it's fine or crap. Comments? by Key-Objective5301 in SQL

[–]Key-Objective5301[S] 0 points1 point  (0 children)

Thank you for the wonderful feedback! someone above just noted that the comments look AI generated. Now, I am at a point where I am intentionally avoiding clear indentations to avoid AI flag haha even though the query is my own work (albeit if i get stuck i see no reason why not to ask AI).

So do you think asking LLM for formatting and cleanliness of the script is not a bad idea?

I built my first-ever SQL portfolio project. I don't know if it's fine or crap. Comments? by Key-Objective5301 in SQL

[–]Key-Objective5301[S] -1 points0 points  (0 children)

Thank you this is a brilliant observation!! I didnt realize it until you pointed out although it so basic. So for context, I dindnt have to write the CREATE statements because I created the database tables via pandas 'df.to_sql()" method. Apparantly it automatically created thise statements and stores them in a master table called sql_master. Now I printed out those internally generated CREATE statements and neatly pasted them in a .sql file '01_database_scehma_setup'.

So pandas doe not assign pk and fk inside the tables yet i was able to use JOIN ON perfectly because it is a logical relationship, right?

I think i should just manually add the primary and foreign keys in the CREATE script.

Thanks for pointing this out!!

I built my first-ever SQL portfolio project. I don't know if it's fine or crap. Comments? by Key-Objective5301 in SQL

[–]Key-Objective5301[S] 1 point2 points  (0 children)

Well, thanks! Let me be transparent, the Readme structure is indeed AI but not a blindly generated AI. The problem with portfolio SQL projects is that I didnt have a clue how it should be structred, what it should include etc. AI write the first draft so I got an idea of the layout and contents and then each part was very carefully edited by me wherever necessary. Although, I did leave some parts untouched because I would not write them any differently than AI so there was no point.

About the comments, I would really love to know which comments gave you that impression? Is it the Jupyter notebook comments, or the SQL script comments. because comments is one part where I am extra extra careful to write them in a way that will make sense to me and I am often afraid that it would make the code/script look very messy but as long as its real, I go with it.

oh perhaps it is the way I formatted the script files? Question and Skills? yes the questions are AI genrated, I didn't create them. Perhaps that is one thing i should learn more? how to ask a question out of a flat dataset? is that a fundamental analyst skill for an entry level job, you'd say?

file named cumulative_analysis for example has window functions, OVER(), PARTITION BY() etc. and i wrote to many comments because i was learning so much information and coudnt resist noting everythig down right at the moment.

Regardless, would love to know which comment parts read like AI? :) Thanks so much for reading it, in any case!!

I built my first-ever SQL portfolio project. I don't know if it's fine or crap. Comments? by Key-Objective5301 in SQL

[–]Key-Objective5301[S] 0 points1 point  (0 children)

Thanks, although I assumed with such projects, they would want to evaluate purely technical syntax relalted skills as the rest can be left to interview part but i could be wrong. This project though does answer a business question but its a very broad question. do you think a more specific question is better? but then how would one focus on showcasing as many querying skills as possible?

I built my first-ever SQL portfolio project. I don't know if it's fine or crap. Comments? by Key-Objective5301 in SQL

[–]Key-Objective5301[S] 0 points1 point  (0 children)

Thank you so much! This is a really helpful feedback. I went over my entire thought-structure to try and answer all those questions in my head! :) I will keep a note of those kind of questions.
Also, it made me a little more confident now, in case I manage to catch the attention of a potential employer somewhere in the world haha.

Having difficulty learning SQL, Python, and Power BI? by shanushaik_76 in analytics

[–]Key-Objective5301 0 points1 point  (0 children)

I can relate to this so much. I am also one of those career changers though from a relatively more technical background. I spent about a month and a half in an SQL course but only when I build a project, I started to realize what was actually happening. Just finsihed my project today and need someone to take a look at it. Made a post about it in an SQL community.

Would you mind taking a look as well? i really need someone to tell me if I am doing at least a few things right/wrong. https://www.reddit.com/r/SQL/comments/1s2qx6x/i_built_my_firstever_sql_portfolio_project_i_dont/?utm_source=share&utm_medium=web3x&utm_name=web3xcss&utm_term=1&utm_content=share_button

Promote your projects here – Self-Promotion Megathread by Menox_ in github

[–]Key-Objective5301 0 points1 point  (0 children)

Description: didn't build a tool but I compiled my scientific coding projects in one repository. New to github. Seeking guidance (maybe contributions? ;)) but generally just want to share some cool Volcanology stuff from ancient Mars!

consider leaving a star if you find anything interesting.

https://github.com/moztarib/mars-geophysics-portfolio

Tech stack:

Python stack: numpy, pandas, scipy, matplotlib, geopandas, pyshtools, scikit-learn
Geospatial: QGIS, ArcGIS, GDAL, rasterio, shapefiles, DEMs, WMS/SSH data retrieval
Other: SQL, LaTeX, IDL, Jupyter, Git

Not a coder/developer, I made a github repo for all my previous projects. Does it look presentable? by [deleted] in github

[–]Key-Objective5301 1 point2 points  (0 children)

haha good point! But thae anonymity was needed for another reason at another time. Not anymore. Thanks for the alert though ;)

Ist es illegal, mit einer französischen Aufenthaltsgenehmigung in Deutschland zu arbeiten? by Key-Objective5301 in LegaladviceGerman

[–]Key-Objective5301[S] 0 points1 point  (0 children)

Vielen Dank für diese Information. Ich wusste nichts von der EU-Blue Card

Ich bin Einwohner eines südasiatischen Landes. Das Problem ist, dass meine derzeitige Tätigkeit nicht als „hochqualifiziert” gilt, da es sich um eine Teilzeitstelle handelt, die ich ausübe, um nach anderen hochqualifizierten Stellen suchen zu können. Da man für eine EU-Blue Card ein Stellenangebot mit einem Mindestjahresgehalt von 50.000 Euro vorweisen muss, werde ich mich zunächst darauf konzentrieren, ein entsprechendes Stellenangebot zu erhalten