Working with databases is a huge part of any data professional's tool belt. In this Playbook we will utilize SQLAlchemy to learn how to use SQL within Python and leverage the object-relational mapper capabilities of SQLAlchemy.
Databases are an integral part of data science, and every programmer that interacts with data needs to be able to work with a database. In this course, Understanding Databases with SQLAlchemy: Python Data Playbook, you will learn foundational knowledge to work with databases using SQLAlchemy. First, you will see how to perform queries. Next, you will discover how to create databases and tables and populate them with data. Finally, you will explore how to manipulate the data you inserted and queried. When you are finished with this course, you will have the skills and knowledge of interacting with databases needed to successfully work with your database using Python with SQLAlchemy.
Xavier is very passionate about teaching, helping others understand search and Big Data. He is also an entrepreneur, project manager, technical author, trainer, and holds a few certifications with Cloudera, Microsoft, and the Scrum Alliance, along with being a Microsoft MVP.
Course Overview Hi everyone, my name is Xavier Morera, and welcome to my course Understanding Databases with SQLAlchemy: Python Data Playbook. I am very passionate about working with data. And did you know that despite the advances in technology, including the rising popularity of NoSQL databases, as well as big data repositories, that at the heart of many applications resides a relational database? And many of these applications are written in Python, with which you could work with raw SQL statements. But of course, there is a better way, and it's called SQLAlchemy. In this course, we're going to learn how to work with a database from Python using SQLAlchemy. Some of the major topics that we will cover include installing SQLAlchemy, using it to load and visualize data, learning how to query, create a database, insert one or many rows, update data, and delete data, as well as more advanced concepts like hierarchical tables, joins, relationships, and core-related updates. By the end of this course, you will be able to perform all kinds of operations in a database using SQLAlchemy. Before beginning the course, you should be familiar with the basic mechanics of Python, including how to use the REPL and how to import libraries. This course is not a deep dive on Python, instead it compliments your existing Python knowledge to help you work with databases. I hope you'll join me on this journey to learn how to work with databases with the Understanding Databases with SQLAlchemy: Python Data Playbook at Pluralsight.