Jump to content

Basics of sql is easy, but how did you learn advanced sql? How did you started tinkering with data?


Recommended Posts

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.

Link to comment
Share on other sites

  1. How did you learn advanced SQL?
    With practice.
  2. 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.
  3. Problem is I've no data to tinker with.
    Then create some.

(See tutorials link in my signature)

Link to comment
Share on other sites

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.


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.