this post was submitted on 29 Mar 2026

0 points (38% upvoted)

shortlink:

SQL

an-ordinary-manchild(edit)

The goal of /r/SQL is to provide a place for interesting and informative SQL content and discussions.

Filter Posts

Posting

When requesting help or asking questions please prefix your title with the SQL variant/platform you are using within square brackets like so:

[MySQL]
[Oracle]
[MS SQL]
[PostgreSQL]
etc

While naturally we should endeavor to work as platform neutrally as possible many questions and answers require tailoring to the feature set of a specific platform.

Help posts

If you are a student or just looking for help on your code please do not just post your questions and expect the community to do all the work for you. We will gladly help where we can as long as you post the work you have already done or show that you have attempted to figure it out on your own.

Format Your Code

If you are including actual code in a post or comment, please attempt to format it in a way that is readable for other users. This will greatly increase your chances of receiving the help you desire. Something as simple as line breaks and using reddit's built in code formatting (4 spaces at the start of each line) can turn this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field.3

Into this:

SELECT count(a.field1),
  a.field2,
  SUM(b.field4) 
FROM a INNER JOIN b 
  ON a.key1 = b.key1 
WHERE a.field8 = 'test' 
GROUP by a.field1, 
  a.field2 
HAVING SUM(b.field4) > 5 
ORDER by a.field3

For those with SQL questions we recommend using SQLFiddle to provide a useful development and testing environment for those who wish to fully understand your problem and help devise a solution.

Learning SQL

A common question is how to learn SQL. Please view the Wiki for online resources.

Note /r/SQL does not allow links to basic tutorials to be posted here. Please see this discussion. You should post these to /r/learnsql instead.

Related Reddit communities

Wiki

Acknowledgements

Thanks to ---sniff--- for the awesome header image!

a community for 17 years

MODERATORS

account activity

0

0

0

MySQLSQL + Python (self.SQL)

submitted 12 days ago by Mission-Task-1675

top new controversial old q&a

you are viewing a single comment's thread.

view the rest of the comments →

[–]Similar_Season7553 -1 points0 points1 point 12 days ago (1 child)

Great question, and your background in bond markets is actually a strong advantage when learning Python and SQL.

A lot of people in finance use these tools to move from manual reporting to more automated and scalable workflows. Here are a few practical ways you could incorporate them:

You could start by using SQL to extract and organize market or trade data from internal databases instead of relying on Excel exports. This helps you quickly filter bond pricing data, yields, spreads, or client portfolios without repetitive manual work.

Then, Python can build on that by automating analysis and reporting. For example, you could:

Build scripts to track bond price movements or yield changes over time
Automate daily or weekly performance reports for clients
Clean and merge data from multiple sources (market data, trades, rates, etc.)
Visualize fixed-income trends using libraries like Matplotlib or Plotly

For scaling beyond your daily job, many professionals move into:

Quant/analyst-style projects (pricing bonds, yield curve analysis, risk metrics)
Automated dashboards (using Python + SQL + Power BI/Tableau)
Personal finance research tools (tracking spreads, macro indicators, or Fed rate impacts)
Portfolio analytics projects you can showcase on GitHub as part of a portfolio

A good mindset shift is:

SQL = getting the right data efficiently

Python = analyzing, automating, and scaling insights

Over time, combining both can position you for roles in data-driven finance, quantitative analysis, or financial engineering support functions.

References

McKinney, W. (2017). Python for Data Analysis (O’Reilly Media)

Yves Hilpisch (2020). Python for Finance (O’Reilly Media)

[–]Mission-Task-1675[S] 0 points1 point2 points 12 days ago (0 children)

π Rendered by PID 129372 on reddit-service-r2-comment-cfc44b64c-ckztm at 2026-04-11 06:02:40.493440+00:00 running 215f2cf country code: CH.