SQL Indexes — #17

Welcome to Learning at Lambert Labs session #17. This week, Tom discusses indexes in the context of a SQL database, and how they can be used to improve query speed.

In today’s Learning Session:

  • Explanation of indexes, and how an indexed table compares to a non-indexed table
  • Clustered vs non-clustered indexes
  • Discussion of Tree data structures, including Binary Search Trees and B-trees
  • Overview of how B-trees are used as indexes
  • Demonstration of using an index to speed up queries

🔊 Subscribe to our channel for weekly learning sessions! https://www.youtube.com/channel/UCi7G5sY0IWqSNUMnRptuJmw 🔗

Lambert Labs Links 🔗 :

🌎 Website: https://www.lambertlabs.com

📱 Twitter: https://twitter.com/lambertlabs

📝 LinkedIn: https://www.linkedin.com/company/lambertlabs

📂 GitHub: https://github.com/lambertlabs

Introspection and Control Flow in Python — #16

Welcome to Learning at Lambert Labs session #16. This week, Amelia discusses the concept of introspection and how it can be applied in Python, as well as diving into control flow graphs and their use cases.

In Today’s Learning Session:

  • What are introspection and reflection?
  • How to examine Python code at runtime
  • How to disassemble Python code
  • Control flow graphs, and how to construct them in Python
  • Q&A from our developers!

🔊 Subscribe to our channel for weekly learning sessions! https://www.youtube.com/channel/UCi7G5sY0IWqSNUMnRptuJmw 🔗

Lambert Labs Links 🔗 :

🌎 Website: https://lambertlabs.com/​​

📱 Twitter: https://twitter.com/lambertlabs​

📝 LinkedIn: https://www.linkedin.com/company/lambertlabs/

📂 GitHub: https://github.com/lambertlabs​​

Websocket APIs — #15

Welcome to Learning at Lambert Labs session #15. This week, Ramin explains what a Websocket API is, how it compares to the alternatives such as REST and GraphQL, and how to implement one for a real application.

In Today’s Learning Session:

  • What is a Websocket API
  • How these APIs differ from the alternatives e.g. REST, GraphQL
  • Receiving data from a Websocket
  • Implementing a Websocket API in JavaScript, both locally and on AWS API Gateway
  • Q&A from our developers!

🔊 Subscribe to our channel for weekly learning sessions! https://www.youtube.com/channel/UCi7G5sY0IWqSNUMnRptuJmw 🔗

Like and comment on our other videos and posts and if you find want to learn more about the technologies shown in this video, check out our Technologies page!

Lambert Labs Links 🔗 :

🌎 Website: https://lambertlabs.com/​​

📱 Twitter: https://twitter.com/lambertlabs​

📝 LinkedIn: https://www.linkedin.com/company/lambertlabs/

📂 GitHub: https://github.com/lambertlabs​​