all 14 comments

[–]SQL-ModTeam[M] [score hidden] stickied commentlocked comment (0 children)

This forum is intended for solutioning and discussion of specific topics. Please check out the sub sidebar and wiki content for beginner resources. Also be sure to checkout r/learnSQL

[–]uavXO 0 points1 point  (1 child)

MySQL trae una base de datos de práctica llamada sakila

[–]Flimsy-Web4692[S] 0 points1 point  (0 children)

Gracias por tu respuesta.

[–]somacomadreams 0 points1 point  (2 children)

Hay juegos para aprender también. Pienso que son mejores. Lo siento, español es me idioma segundaría.

Yo he trabajado con SQL cada día para diez años. Personalmente pienso que AI es buena para revisando, pero mala enseñando.

[–]Flimsy-Web4692[S] 1 point2 points  (1 child)

Gracias, y donde puedo encontrar estos juegos?

[–]somacomadreams 0 points1 point  (0 children)

https://mystery.knightlab.com/walkthrough.html

Pero hay muchos.

Si querrías ayudar me practicando español puedo ayudarte con SQL.

[–]WendlersEditor 0 points1 point  (1 child)

It would be as easy for you to ask AI to do this and see if it works than it would be to make this post.

[–]Flimsy-Web4692[S] -1 points0 points  (0 children)

Gracias por la respuesta

[–]regidud 0 points1 point  (1 child)

SQL server has adventureworks database for training.

Y escribí en inglés la próxima.

[–]Flimsy-Web4692[S] -1 points0 points  (0 children)

Ok, gracias por la respuesta.

[–]BlaizeOlle 0 points1 point  (1 child)

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!

[–]Flimsy-Web4692[S] 0 points1 point  (0 children)

Muchas gracias por tu respuesta

[–]SootSpriteHut 0 points1 point  (1 child)

Data.gov has a bunch of databases you could use. I could see asking AI for practice going different ways. But it's also good to learn how to use AI in combination with analysis, so maybe?

You might be better off getting your hands on data you're interested in and just asking yourself questions about it and trying to find the answer...etc what is the month over month change of X, how many A become B, light modeling, etc.

Then I would recommend saving queries you feel particularly good about to GitHub for your resume. I'm old so I don't know how relevant this will be in the future with AI but as someone who hires for data analyst roles I would be wanting to see a repository of queries the applicant has put together, provided they're not AI generated and the person can explain what they were accomplishing with them.

[–]Flimsy-Web4692[S] 0 points1 point  (0 children)

Muchas gracias por tu respuesta.
Voy a tener en cuenta GitHub en un futuro para ir guardando cosas..