Understanding Databases with SQLAlchemy: 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.
Course info
Level
Beginner
Updated
Mar 16, 2019
Duration
1h 23m
Table of contents
Description
Course info
Level
Beginner
Updated
Mar 16, 2019
Duration
1h 23m
Description

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.

About the author
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.

More from the author
T-SQL Data Manipulation Playbook
Intermediate
2h 54m
Sep 27, 2019
Programming Python Using an IDE
Intermediate
2h 0m
Jun 26, 2019
More courses by Xavier Morera
Section Introduction Transcripts
Section Introduction Transcripts

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.