Understanding Databases with SQLAlchemy 1: Python Data Playbook

Focused View

Xavier Morera

1:22:34

58 View

01.Course Overview

0101.Course Overview.mp4

01:47

02.Up and Running with SQLAlchemy

0201.Up and Running with SQLAlchemy.mp4

02:56

0202.Installing and Importing SQLAlchemy.mp4

03:16

0203.Loading Data Using SQLAlchemy.mp4

04:07

0204.Using Pandas and SQLAlchemy to Load, Work, and View Your Data.mp4

02:50

0205.Visualizing and Graphing Data with Matplotlib.mp4

03:34

0206.Takeaway.mp4

01:10

03.Querying with SQLAlchemy

0301.Querying with SQLAlchemy.mp4

01:17

0302.Picking a Database.mp4

02:42

0303.Connecting to Databases Connectors and the Connection String.mp4

03:43

0304.Querying with SQL.mp4

01:07

0305.Object-relational Mapper (ORM) and Classical Mapping.mp4

03:58

0306.The Declarative API.mp4

06:23

0307.More Querying and Database Functions.mp4

04:52

0308.Using Joins.mp4

01:27

0309.Working with Hierarchical Tables.mp4

02:13

0310.Takeaway.mp4

01:35

04.Creating Your Database

0401.Creating Databases with SQLAlchemy.mp4

01:09

0402.Creating Databases.mp4

02:19

0403.Creating Tables.mp4

02:34

0404.Primary Keys, Constraints, and Data Defaults.mp4

05:31

0405.Inserting Data Single and Multiple Rows.mp4

04:32

0406.Loading a CSV into a Table.mp4

01:59

0407.Takeaway.mp4

01:04

05.Manipulating Your Database

0501.Manipulating Databases with SQLAlchemy.mp4

01:05

0502.Updating Data in a Database.mp4

04:44

0503.Correlated Updates.mp4

01:19

0504.Deleting Data from a Database.mp4

02:29

0505.Deleting Tables.mp4

01:31

0506.Takeaway.mp4

01:14

06.Final Takeaway

0601.Final Takeaway.mp4

02:07

Exercise Files

python-sqlalchemy-playbook-understanding-databases.zip

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Python

Xavier Morera

Instructor's Courses

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 with complex enterprise software solutions, working with companies that range from startups to Microsoft. Xavier also worked as a worldwide v-trainer/evangelist for Microsoft.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.