Welcome to Using Databases with Python

So welcome to our databases course, this is the fourth course in the class and if you’ve taken all three you have learned a bunch. There’s a lot in this class. If you’re two weeks into this class and you didn’t take the prerequisite courses and you’re like, what are these people talking about? Well, that’s what those other courses are. Don’t say ooh, why don’t you give me a basic intro to Python? And the answer is we did that, that’s what courses one, two, and three were. You’ll notice that in courses three and four that we’re going more slowly through the book. The material’s more complex, the lectures take longer to develop. In this we’re going to learn object training programming. We’re going to learn structured query language and we’re going to do a little bit of visualization. And in a way, structured query language is the biggest part of this class we’re going to learn what data base design. And this is really so that ultimately if you need these data bases as part of the Python program, you’re competent in data bases. And so this is more about database than it is about Python. We’ll going to learn like block said data base design, one to one relationships, foreign keys, join, select, delete, update. I love SQL, Structured Query Language and I think you probably will too. Most beginning students prefer SQL in a way to Python. Are there, because SQL is a fundamentally different pattern for writing software. In Python you learn that you gotta be very explicitly like do this then do that and keep track of this other thing. And check back in that other thing and like add a thing to this other thing and then print this stuff out and sort them. And you’re like do it and there’s a bunch of really simple kind of things that you construct orders and patterns and loops and that’s what you’re good at by now in SQL. You kind of do it all in one statement, you’re like do this where that happens, pull this other stuff in and then magically you get what you want. You kind of write single-statement programs that are themselves internally Interesting and complex. Kind of like regular expressions but regular expressions are not essential but SQL in lots of job situations is essential. So I think that you should look forward to learning SQL. It’s a fun language, it’s different. So get ready for that and then what we do at the very end is we do a little bit bring it all together and do some analysis, and visualization, and scrape. And which is really sort of a preview for the fifth course or the caps to, which we going to use analysis visualization and scraping. So welcome to course four I hope you enjoy it.