i just finish mysql interm i want some small projects that i could work on

Question

small projects

Answer 1

BOUBKER NAQI unfortunately Sololearn does not have an sql database-playground in the code-bit section so you are pretty much on your own to build program to create a database and extract the data based on how you structure it.

Answer 2

If you really want to do SQL on SoloLearn, you can only do that using Sqlite within a programming language like Python. So it is possible to execute SQL queries, but not MySQL specifically and not standalone SQL.

If you have MySQL on your computer and just want ideas for small projects, here are a couple ideas just to practice:

1. Create a small Address Book / Contact Manager - Create tables for people, phones, emails, call history, meetings, etc. Build all those relationships. You can expand this with additional related tables to whatever complexity you like. Such as - MeetingLocations, multiple meeting attendees, etc. You can build this as involved as you like. The idea being to create multiple relationships between different tables and associated reports such as: Who has met at xxx location? Who have you not met with in past 6 months?

2. Create a Game database. Games, Publishers, Platforms, Stores, Prices, etc. Whatever you like. Maybe add player info for people you play multiplayer games with. Guilds, Leagues, Accomplishments. Again, go as crazy as you like with relationships and reports.

3. Personal Budget System. Expenses, Incomes, Budgets, Actuals, Transactions, etc.

4. You can also download existing database learning projects. I know Microsoft used to provide a complex database to run tests against. I forgot what it's called. I think it is a books database with publishers, etc.

If you are also a programmer, you can write something in Python or whatever language that can collect data for you. Maybe a file manager that reconstructs trees of your hard drive into a database or maybe something that can extract data from websites using an API. github, for example, has an API. Incorporate that into a local database for you to query.

A few sample codes for doing things via programming:

1. Github queries - https://www.sololearn.com/en/compiler-playground/cbpcUJDLpZhj

2. Python using SqlLite - https://www.sololearn.com/en/compiler-playground/cTIqwQk059BB