Email the Author

You can use this page to email Akash Lodha about Portfolio Optimisation using SQL: A hands on introductory approach to learn SQL.

Please include an email address so the author can respond to your query

This message will be sent to Akash Lodha

This site is protected by reCAPTCHA and the Google  Privacy Policy and  Terms of Service apply.

About the Book

"Practical Portfolio Optimization with SQL" is an essential guide for financial engineering students seeking to hone their practical skills in database management, particularly in the realm of portfolio optimization. This hands-on guide aims to provide comprehensive knowledge and practical experience with SQL, using portfolio optimization as the key application.

The book's structure is crafted into ten carefully designed modules, each focusing on a specific aspect of SQL and its application in portfolio management. The first few modules introduce the fundamentals, starting from creating database and tables to manipulating and querying data. As readers progress, they delve deeper into advanced SQL features like Joins, Unions, Subqueries, Views, and Transactions. 

The guide further elevates the learning experience by illustrating the creation of stored procedures and functions to automate recurring tasks. Readers will learn to leverage database triggers and events for real-time portfolio management and explore database performance tuning and optimization strategies for efficient portfolio management. 

Additionally, the book places significant emphasis on data security, privacy, and adhering to financial industry regulations. Towards the end, it offers insights on how to interface MySQL with Python, which facilitates complex data analysis and optimization tasks. 

"Practical Portfolio Optimization with SQL" is an invaluable resource for aspiring financial engineers, data analysts, or anyone interested in managing financial portfolios more effectively using SQL. By the end of this book, readers will be equipped with the skills to create, manage, and optimize their own portfolio database.


About the Author

Akash Lodha’s avatar Akash Lodha

I'm Akash Lodha, leveraging a unique blend of finance and technology to educate others. I'm a Financial Engineer and Software Developer, currently pursuing an MS in Risk Management & Financial Engineering at Imperial College London. Before this, I earned my Bachelor’s Degree in Computer Science And Engineering from Vellore Institute of Technology.

I started my professional journey at Morgan Stanley, working as a consultant and then an associate software engineer. I then moved to Wissen Technology and later Semlr, honing my skills as a software engineer. My most recent position was at AInsurCo, where I served as an Analyst for Algorithmic Trading.

Now, I'm channeling my knowledge and experience into writing technical books on Python, SQL, and Java. My aim is to help finance professionals navigate the intricate world of programming, making these topics accessible and applicable to their daily work.

Join me in exploring the fascinating intersection of technology and finance, and arm yourself with the essential programming skills needed in our digital era.

Logo white 96 67 2x

Publish Early, Publish Often

  • Path
  • There are many paths, but the one you're on right now on Leanpub is:
  • Portfolio › Email Author › New
    • READERS
    • Newsletters
    • Weekly Sale
    • Monthly Sale
    • Store
    • Home
    • Redeem a Token
    • Search
    • Support
    • Leanpub FAQ
    • Leanpub Author FAQ
    • Search our Help Center
    • How to Contact Us
    • FRONTMATTER PODCAST
    • Featured Episode
    • Episode List
    • MEMBERSHIPS
    • Reader Memberships
    • Department Reader Memberships
    • Author Memberships
    • Your Membership
    • COMPANY
    • About
    • About Leanpub
    • Blog
    • Contact
    • Press
    • Essays
    • AI Services
    • Imagine a world...
    • Manifesto
    • More
    • Partner Program
    • Causes
    • Accessibility
    • AUTHORS
    • Write and Publish on Leanpub
    • Create a Book
    • Create a Bundle
    • Create a Course
    • Create a Track
    • Testimonials
    • Why Leanpub
    • Services
    • TranslateAI
    • TranslateWord
    • TranslateEPUB
    • PublishWord
    • Publish on Amazon
    • CourseAI
    • GlobalAuthor
    • Marketing Packages
    • IndexAI
    • Author Newsletter
    • The Leanpub Author Update
    • Author Support
    • Author Help Center
    • Leanpub Authors Forum
    • The Leanpub Manual
    • Supported Languages
    • The LFM Manual
    • Markua Manual
    • API Docs
    • Organizations
    • Learn More
    • Sign Up
    • LEGAL
    • Terms of Service
    • Copyright Policy
    • Privacy Policy
    • Refund Policy

*   *   *

Leanpub is copyright © 2010-2025 Ruboss Technology Corp.
All rights reserved.

This site is protected by reCAPTCHA
and the Google  Privacy Policy and  Terms of Service apply.

Leanpub requires cookies in order to provide you the best experience. Dismiss