Understanding Databases with SQLAlchemy 1: Python Data Playbook
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.
What you'll learn
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 1: 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.
Table of contents
- Querying with SQLAlchemy 1m
- Picking a Database 3m
- Connecting to Databases: Connectors and the Connection String 4m
- Querying with SQL 1m
- Object-relational Mapper (ORM) and Classical Mapping 4m
- The Declarative API 6m
- More Querying and Database Functions 5m
- Using Joins 1m
- Working with Hierarchical Tables 2m
- Takeaway 2m
About the author
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. He has spent a great deal of his career working on cutting-edge projects with a primary focus on .NET, Solr, and Hadoop among a few other interesting technologies. Throughout multiple projects, he has acquired skills to deal... more