SQL Database Optimization

We can use deep reinforcement learning to optimize a SQL database, and in this video we'll optimize the ordering of a series of SQL queries such that it involves the minimum possible memory/computation footprint. Deep RL involves using a neural network to approximate reinforcement learning functions, like the Q (quality) function. After we frame our database as a Markov Decision Process, I'll use Python to build a Deep Q Network to optimize SQL queries. Enjoy! Code for this video: https://github.com/llSourcell/SQL_Database_Optimization Please Subscribe! And like. And comment. That's what keeps me going. Want more education? Connect with me here: Twitter: https://twitter.com/sirajraval Facebook: https://www.facebook.com/sirajology instagram: https://www.instagram.com/sirajraval More learning resources: https://rise.cs.berkeley.edu/blog/sql-query-optimization-meets-deep-reinforcement-learning/ https://mldb.ai/ https://docs.microsoft.com/en-us/sql/advanced-analytics/what-is-sql-server-machine-learning?view=sql-server-2017 https://towardsdatascience.com/machine-learning-in-your-database-the-case-for-and-against-bigquery-ml-4f2309282fda https://www.quora.com/Which-database-is-best-for-machine-learning Join us in the Wizards Slack channel: http://wizards.herokuapp.com/ School of AI: https://www.theschool.ai And please support me on Patreon: https://www.patreon.com/user?u=3191693 Signup for my newsletter for exciting updates in the field of AI: https://goo.gl/FZzJ5w Hiring? Need a Job? See our job board!: www.theschool.ai/jobs/ Need help on a project? See our consulting group: www.theschool.ai/consulting-group/ Hit the Join button above to sign up to become a member of my channel for access to exclusive content! Join my AI community: http://chatgptschool.io/ Sign up for my AI Sports betting Bot, WagerGPT! (500 spots available): https://www.wagergpt.xyz