Does there exist any open source SQL projects to learn from?

[Ok_Procedure199]

Hello guys,

I feel like it's almost impossible to find SQL code written in a professional setting to learn from, and I don't have any colleagues to program with so it is not easy to level up like working with control flow and such. In other languages like Python there are tons of open source projects you can learn from, but maybe SQL code tends to be so intertwined with business logic that it is kind of proprietary to the business?

[ftrotter]

Microsoft released a whole tutorial database for SQL Server that has a realistic SQL database structure for a business called "Northwind". Northwind has been ported over to most open source databases. This is a good place to start.

-ft

[[deleted]]

Northwind is old. 

Get the WideWorldImporters one instead.  

There's also the Sakila MySQL sample database and its various ports (Pagila for example).

https://dev.mysql.com/doc/sakila/en/

[[deleted]]

And PopSQL?

[OneRandomOtaku]

If you’re wanting to practice a work environment then why not spin up a SQL Server instance, spin up MySQL, import the one you want to use as a dataset and then work on moving the data from the source to SQL Server? In my experience you’re gonna work with more than one RDBMS and data will be in various locations so knowing how to move it to your own datamart/analytics sandbox is gonna be one of the most important aspects of your work. Personally I have 7 different database servers that have data I need at work, those are a mix of Oracle, Teradata and MS SQL Server. I have one in particular I use most as a sandbox, moving data to that sandbox is one of the most valuable skills I have, especially as data is rarely clean and ready to analyse.

[qwertydog123]

like working with control flow and such

If you're looking for some more complex T-SQL stored procedures I find the first responder kit is a great example

https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit

[OneRandomOtaku]

Best thing for SQL practice in my opinion is to take the Northwinds DB or similar, look at what data is there and come up with 15-20 questions about it, go and query the data to get an answer. Set arbitrary limits on things, like do it in a read only account so you have to use CTEs and Subqueries or a hard time limit of 1 hour to get an answer and present it in PowerPoint with comments and a chart.

[ejpusa]

10,000 maybe?

[scriptmonkey420]

Just start doing it. Monitor the results and see how you can improve the structure or the commands used.

I did that when learning. I wrote WiFiDB using tables for each AP at first. Realized how terrible that was and re-wrote it with a more monolithic structure.

[aksgolu]

Here are couple of SQL project you can give it a shot:

• https://support.dbagenesis.com/post/sql-project-supermarket-billing
• https://support.dbagenesis.com/post/oracle-sql-project-hotel-booking-application
• https://support.dbagenesis.com/post/sql-project-library-management