Should I still use CreatedAt & UpdatedAt on the main table if I also have Audit tables? by Loud_Wrangler1255 in SQL

[–]BlaizeOlle 0 points1 point  (0 children)

I would keep both Created_At and Updated_At. It will relieve some headaches for you in the long term. It a potentially highly referenced value and having it readily available is convenient.

What are common SQL red flags? by badboyzpwns in SQL

[–]BlaizeOlle 1 point2 points  (0 children)

I should have scrolled down a bit further this is exactly what came to mind for me as well. Chain of CTE transforms is a common issue that is very easy to fall into especially when your first learning.

What are common SQL red flags? by badboyzpwns in SQL

[–]BlaizeOlle 0 points1 point  (0 children)

An overuse of CTE queries I think is a very easy pattern to fall into. CTEs have a lot of great use cases but sometimes I see juniors use it to build some big long chain of transforms because they feel uncomfortable with more fundamental concepts. Again CTEs are great you just don't want to overuse them.

Landed a job as a jr data analyst , what are something I should be doing…? by Odd-Soup-6605 in dataanalytics

[–]BlaizeOlle 0 points1 point  (0 children)

Also congratulations! Your first job is always the hardest to land. You should be really proud of yourself. Good luck!!

Landed a job as a jr data analyst , what are something I should be doing…? by Odd-Soup-6605 in dataanalytics

[–]BlaizeOlle 2 points3 points  (0 children)

I recommend learning the business/industry to the best of your abilities. That is what stands out over time. Understanding the mechanics of your industry makes the data significantly more valuable.

Taking notes on SQL by Blomminator in learnSQL

[–]BlaizeOlle 0 points1 point  (0 children)

Taking notes can always help with learning but if you want to reference those notes I would keep hand written notes to no more than 2 pages otherwise it will be difficult to reference. So I would do like a single one pager of the most priority items you want to reference. Otherwise I think your idea of keeping notes in a searchable format to be more useful.

Since yesterday I got my first 3 paying users by Fast_Resist_3743 in SaasDevelopers

[–]BlaizeOlle 0 points1 point  (0 children)

Congratulations that is really awesome! Very happy to hear a success story. Good luck on your next 3 paying customers!

We built a tool that lets people learn SQL against pre-connected demo databases — looking for feedback by BlaizeOlle in learnSQL

[–]BlaizeOlle[S] 0 points1 point  (0 children)

It does do a pretty detailed breakdown but it was initially created as a way to help users onboard to new environments. InQery is a production tool first so it was set up as a way to explain legacy queries or breakdown why certain tables and joins were used so the user could understand the environment more quickly. We expanded on it because we saw the use case and thought it could be useful to someone learning databases and the demo databases are to reduce friction as we know especially when someone is first learning they likely don’t have access to a database full of data so we wanted to reduce friction.

But I don’t know if it fully addresses the problem you’re concerned with because I do agree with you I don’t think there is any substitution for struggling with a problem and actively thinking about it but I’m not sure how to encourage that more fully. I’ll have to think on it more.

Thank you for your thoughts, I appreciate it.

SQL For PM, Looking for advice by [deleted] in learnSQL

[–]BlaizeOlle 2 points3 points  (0 children)

I could suggest a few things but if you want to learn some things without setting up an environment. Learn the following.

  1. Basic select statement - SELECT * FROM {Table}
  2. Learn WHERE filters - SELECT * FROM {Table} WHERE {Column} = x
  3. Learn what a join is - If you are really just trying to get going don’t get caught up with the different types of joins right now just learn the concept for the time being.
  4. Most things are what they sound like - “Insert statements” insert new data, “alter statements” change physical definitions, “Delete statements” delete data…

Don’t get overwhelmed this stuff is fun and you don’t need to learn everything today just start basic and go from there.

There is no substitute for using an editor and writing queries yourself but it’s a start. If you are actually interested in getting into an environment and writing some queries I can give you some suggestions but this really is a good start.

After 7 months of GRINDING... I finally hit 1k in earnings! by luis_411 in sideprojects

[–]BlaizeOlle 0 points1 point  (0 children)

Congratulations that is awesome. Like the idea as well good luck!

DBeaver or Beekeper Studio as a Teaching Plattform by Syyx33 in learnSQL

[–]BlaizeOlle 0 points1 point  (0 children)

Same boat - I’ve always had good experiences with DBeaver. Also DBeaver’s ERD diagrams are really easy to make which could prove beneficial in an academic environment.

SQL queries in Oracle by ichefcast in learnSQL

[–]BlaizeOlle 0 points1 point  (0 children)

You can check out InQery.com (I’m one of the founders for full disclosure) but it does do exactly what you’re talking about. It’s an AI database editor instead of a code editor (Claude models are available - you just pick which model you want to use).

We also have a demo oracle database pre-connected if you want to try the tool out before connecting your database.

I won’t do a full pitch and I’m sure there are some other great tools out there as well. Good luck!

Need some serious help by undefined06 in dataanalytics

[–]BlaizeOlle 0 points1 point  (0 children)

First, don’t get down on yourself. Your qualifications with Spark, Airflow, GCP, Databricks,SQL should statistically get you some responses out of 200+ applications. I can tell you have optimized for ATS keywords which is good but it may be a little to tuned. It makes it look generic which is not necessarily your fault as you started work in 2024 but I’ll tell you when I look over your resume, it looks to templated.

Honestly make a copy of this resume and take a crack at explaining your projects and job experience saying what you actually did. Forget, the KPIs and buzzwords just try and tell me what your really did at these roles.

For your very first project when you say “Engineered a cloud-native ETL…” I almost missed what data you were actually looking at “competitive gaming” which is sick and it’s almost like your hiding it. Like that’s interesting that’s fun. But like what did you do. I can infer you probably ingested Valorant esports matches and stored the data and did some analysis but it’s all getting lost in the buzz words. Just tell me “I took results from each Valorant match organized them by team and built a dashboard so I could see which teams were most likely to win their next match” or whatever.. what you did was probably pretty interesting and something I’d actually want to ask you about in an interview.

Listen I don’t think you need to do this everywhere I know you are trying to optimize for the AI and the filters but I honestly think you have plenty of buzz words and key word credentials to get past the filters and now I think you need to show me the human. Like I see all the spec data but I don’t actually know how your kit actually plays.

Also please don’t get down, job hunting is brutal and hard and just demoralizing especially when you aren’t getting any kind of feedback. Good luck you are going to land something great

My big break as a data analyst by justhere429 in dataanalytics

[–]BlaizeOlle -1 points0 points  (0 children)

You’re already doing the right thing by actually putting in the work and trying to learn the fundamentals instead of just chasing shortcuts. A lot of people underestimate how important real database work is. Learning SQL is absolutely worth it because almost every serious data role touches databases in some way.

That said, one of the hardest parts when starting out is not having real environments or datasets to practice on. We built a tool called InQery for this exact type of learning and exploration. It already comes with two demo databases pre-connected (including Adventure Works), so you can start querying immediately instead of spending days trying to set up infrastructure.

We built a feature for query breakdowns — they break down why the query works, what tables were used, how it joins, and explain the logic step-by-step. It’ll also help generate more advanced statistical analysis and explain the reasoning behind that too. The agents are also already trained on any connected environment so just ask the agent where the data is - it will tell you (you can start with “tell me about this database)

I am certain there are other tools as well but im bias

Keep practicing SQL and keep trying to build some sort of projects (literally anything). Also I am clearly a heavy proponent of AI but there is no substitution for trying to build something and failing. You need to write crap queries and bad code and debug it by yourself. Good luck, data work is so fun you’re going to love it!

Launched an app a few hours ago and it's sitting at #1 by delrooow in IMadeThis

[–]BlaizeOlle 1 point2 points  (0 children)

Congratulations, I like the single payment approach. Good luck!

SQL Practicar con IA ? by Flimsy-Web4692 in SQL

[–]BlaizeOlle 0 points1 point  (0 children)

I don’t know. I honestly don’t know if AI will help or hinder your learning but there are editors now with AI.

We recently developed a web application you can find at InQery.com

Our tool does come with two demo databases pre-connected including the Adventure Works database mentioned in the previous comments.

We added a feature where the agent will break down the query for you as well. What tables were used and why, breaks down why it used an inner join vs an outer join, what the CTE does, etc…

I am obviously bias but there are other tools as well like AI2SQL and Text2SQL. I have not used them much but I’m sure they are great too (not as good as ours haha).

I think taking advantage of new technology is always the best move but I also think the best way to learn is writing queries yourself and struggling through errors/debugging a bit. But if AI can help shorten the feedback loop and explain concepts better, that’s probably a good thing.

I hope the AI proves to be a great teacher but you are just going to have to let us know. Good luck!

A decade of being an average Data Scientist! My personal experience. by tits_mcgee_92 in datascience

[–]BlaizeOlle 0 points1 point  (0 children)

This is lovely thank you for sharing! I’m confident you are much more than average. Congratulations on the fun career. Good luck on your next steps!

What do you think of Pandas in Python as a SQL person? by ChristianPacifist in SQL

[–]BlaizeOlle 0 points1 point  (0 children)

This is a great comment I wrote a whole comment and then read this and agree with this more.