oslon Posted June 8 Share Posted June 8 Problem is I've no data to tinker with. No meaningful data i mean. One dataset that I have is jira(scrum). I use SQL on it and write my report, that's all. Is there anything else meaningful data that I can get where I can tinker stuffs? I am stuck in this phase where I am unable to find any data to tinker with. I am unable to find solid exercises to help me in my learnngs. Or maybe I am looking at the wrong things. Quote Link to comment Share on other sites More sharing options...
Barand Posted June 8 Share Posted June 8 How did you learn advanced SQL? With practice. How did you start tinkering with data? By designing and building databases to support applications I needed to develop, then developing them using the database. Problem is I've no data to tinker with. Then create some. (See tutorials link in my signature) Quote Link to comment Share on other sites More sharing options...
requinix Posted June 9 Share Posted June 9 Quote Link to comment Share on other sites More sharing options...
oslon Posted June 9 Author Share Posted June 9 So, let me ask you, how do you create entire database on your own? Unless you use chatgpt to do it. I mean meaningful data. Quote Link to comment Share on other sites More sharing options...
Barand Posted June 9 Share Posted June 9 14 hours ago, oslon said: how do you create entire database on your own? Design the data model Create the tables Populate tables with test data And one thing I forgot to mention earlier... RTFM Quote Link to comment Share on other sites More sharing options...
gizmola Posted June 11 Share Posted June 11 On 6/8/2024 at 9:43 PM, oslon said: So, let me ask you, how do you create entire database on your own? Unless you use chatgpt to do it. I mean meaningful data. In addition to Barand's excellent tutorial, which you should take advantage of, there are any number of sample databases you can use. If you're learning MySQL, there are several reference database schemas. There's an employee schema and "Salika" which is a fairly well fleshed out DVD rental schema. Here's a page that documents these and a few others for MS SQL for students of a Nanyang Tech University: https://www3.ntu.edu.sg/home/ehchua/programming/sql/SampleDatabases.html A little bit of googling will find you many many more. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.