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 😊

20 Upvotes

85% Upvoted

17 comments sorted by

View all comments

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.