How to Query Databases with SQL

ACCESS the FULL COURSE here: https://academy.zenva.com/product/data-science-mini-degree/?zva_src=youtube-datascience-md

TRANSCRIPT

Hello world, and thanks for joining me. My name is Mohit Deshpande, and in this course we'll be learning about querying databases. So databases are ubiquitous and pretty much everything that we do nowadays, every time you go to a website, chance are there's a database, running somewhere on the back end that's helping manage all of your data. Definitely anytime you log into a website, there's a database that's going on that has all of your login credentials and it's managing all that information, so they're ubiquitous, Especially in companies, any kind of large company you've heard, they definitely have it and use a database on a regular basis. It's kind of the backbone infrastructure of their entire operation, and we're gonna be learning how we can query these databases.

So, primarily we're gonna be focused on how we can query data, in other words, how can we ask questions about the data that we have stored in our database, so we could do interesting things like ask our database to... retrieve a list of all of our purchases that we've made over the past six months that have cost more than $35. This is a kind of example query that you might hear about when you visit any kind of retail site, and this is what we're gonna be learning about. We're gonna be learning about how to query data, and we'll learn about how we can do different kinds of sorting of the data that we already have. We'll learn about grouping and aggregation, and then finally how we can take data from multiple, we can take different kinds of data and merge it into, when combining the information across different datas.

We've been making courses since 2012, and we're super excited to have gone for it. Online courses are a fantastic way to learn new skills, and I take a lot of online courses myself. General courses consist mainly of video lessons that you can watch and re-watch as many times as you want. We also have downloadable source code and project files, and they contain everything that we're working on during the lessons. It's highly recommended that you code along with me. In my experience that's the best way to learn something is to get your feet wet, so to speak. And lastly we've seen that students who get the most out of these online courses are those who make a weekly plan, and stick to it depending on your own availability and learning style of course. So Zenva over the past six years or so, has taught all different kinds of topics on programming and game development to over three hundred thousand students, over a hundred courses. The skills that they've learned in these courses, in fact are completely transferable to other domains as well, ... https://www.youtube.com/watch?v=QzQnUHAfFhs