[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_28":-5,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58},"routes/_store+/_readers+/email_author.$slug/route",{"_9":10,"_11":-5},"book",{"_12":13,"_14":15,"_16":17,"_18":19,"_20":21,"_22":23},"currentUser","id","Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6Qm9va1Byb2R1Y3QvNTU4Njc","title","Portfolio Optimisation using SQL: A hands on introductory approach to learn SQL","state","retired","contactAuthorMethod","email","aboutText","

\"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.

","authors",[24],{"_12":25,"_26":27,"_28":29},"Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6UHJvZHVjdEF1dGhvci81ODg5Ng","name","Akash Lodha","user",{"_30":31},"avatar",{"_32":33,"_34":35,"_36":37},"url","https://d39qdlcrvnra4b.cloudfront.net/avatars/3043901/medium/1569250175064.jpeg?1690053349","styleName","medium","exists",true,"shoppingCartId","shoppingCart",{"_12":71,"_72":73,"_74":37,"_75":76,"_77":78,"_79":80,"_81":37},"locale","en","readerTheme","light","constants",{"_69":70},"publishers",{"_65":66,"_67":68},"learnerOrganizations",[],"needsLocaleCookieSync",false,"announcements",{"_59":60,"_61":-5},"sentryEnvironment","production","sentryRelease","df93851502eaca28221564c255c8e24e2e3b5c50","announcement_store",{"_62":37,"_63":64},"announcement_authors","flag","text","

Kick off your book project in 3 hours! Live workshop on Zoom. You’ll leave with a real book project, progress on your first chapter, and a clear plan to keep going. Saturday, June 6, 2026. Learn more…

\n","companies",[],"universities",[],"paypalClientId","AX53Cwz8jR6rVVzzZiZNWWXl0dGagi-GZrjG-S3Ua14E5nrKMn7DxDQ730O4R8LusLPp49ALn6aRVaEy","no-cart","count",0,"free","updatedAt","","paymentGateway","STRIPE","cartItems",[],"loading"]

Email the Author