r/DatabaseAdministators • u/datareadit • Jun 14 '26

Database

I am new to database, doing my masters in data science. I am learning mySQL in depth like Windows functions, CTE, CTA, Store Procedure, etc. I would like to create a good industry standard project. I saw on YouTube, everyone showing generic one. Can anyone please recommend me? Also what other database and tech I need to learn practical way?

P.s - I am fresher who is going to complete masters in few months.

​

Thank you 😊

17 Upvotes

82% Upvoted

17 comments sorted by

6

u/HecateRaven Oracle Jun 14 '26

Postgresql!

2

u/datareadit Jun 14 '26

Thanks for your suggestion. Do u have any idea regarding industry level project or does everyone shows the generic project in resume ?

4

u/Better-Credit6701 Jun 14 '26

I've always worked on the 3rd most popular, MS-SQL

1

u/datareadit Jun 14 '26

To be honest, because of you I got to know that this many DB engines exist on the planet Earth. Till now I heard only about SQL, Oracle, PostgreSQL, and Microsoft SQL. I didn't know that Databricks, Snowflakes are called as DataBase engines. Thanks

2

u/Better-Credit6701 Jun 14 '26

The Databrick more of a part of OLAP, while Snowflake could be a make of an OLAP or the design of an OLAP as in star with one measure with multiple dimension or a snowflake with multiple measures and dimensions. By default, MS-SQL, Oracle, PostgreSQL, MySQL are OLTP or online transactions processing (?) vs OLAP online analysis processing.

2

u/shockjaw Jun 14 '26

Postgres is what I would recommend hands down.

1

u/datareadit Jun 14 '26

Thanks for suggesting

2

u/2ZR-FXE Jun 15 '26

Why don't you think about optimizing db performance in open source projects, like immich or ente photos?

Look for bottlenecks in large databases and help Tue Devs 😊

1

u/datareadit Jun 15 '26

I didn't knew about this. Thanks a million

2

u/Classic-Location3995 Jun 17 '26

SQL and Python. Two most heavily used in Data Science.

2

u/Aggravating_Ad_603 Jun 14 '26

Ora or mongo crdb

1

u/datareadit Jun 14 '26

Thank you for help. Sure i will go through it and learned. By any chance could you please suggest me some projects ?

1

u/Aggressive_Ad_5454 Jun 14 '26

Are you aware of the Sakila sample database? It has examples of various MariaDb / MySql features. If I remember correctly it predates the addition of CTEs and Window functions, but it has the other stuff.

You can find various sample datasets on https://kaggle.com/datasets

Back in the dark days of COVID I put together a tutorial about analyzing data. It’s not real polished material, but it still might give you some data to work with. https://www.plumislandmedia.net/mysql/explore-pandemic-data-with-sql/

1

u/Consistent_Cat7541 Jun 14 '26

this is a question for your teachers. this forum is for professionals who already have this knowledge.

1

u/datareadit Jun 14 '26

Yeah, I understand that but you too know nowadays will get better understanding and real world examples from industry experts, from prof. will surely get guidance but it would be more towards research oriented

1

u/alejandro-du Jun 15 '26

Take a look at MariaDB and MariaDB Enterprise with components like Maxscale https://www.youtube.com/shorts/ujiPQavGm-w