Master Using SQL with Python: Lesson 2 - Using SQLite

In this second training video on using Python with SQL, you will learn a way to get a lot of power with little effort so I call it the Middle Path after Buddhist tradition. Using Pandas and SQLite together, you gain the flexibility of having a fully functional client-side relational database with the ease of using Pandas data frames.

Jupyter Notebook, slides, and Data at:

Chinook Demo Database and Documentation Available at:

[antonio_carvalho]

Thank you for this video. Very specific (mixing python and sqlite), so not many people might be interested, but for those of us who are, it's invaluable!

[camilogarcial]

Thank you very much. I just had my first class as a teacher and was looking for an easy way to teach my students SQL without spending too much time setting up and this is perfect

[filosofiadetalhista]

Thanks for these first two introductory videos on this topic. It truly gave me the bearings I needed.

[mikolajwojnicki]

Great video to get me started with SQLite on Python

[dataarchitect]

It has support for SQL server as well... now in 2021 ...

[TheCHero]

Im having trouble loading big data with SQL to a dataframe. My kernel dies while performing the operation. Any tips?

[ahbabahmed]

Was the PostgreSQL DB installed on your local system ? I mean I just saw you simply passed to DB name, User and Pwd to the connection, can we connect using a host or in this case localhost ?

[colesprouse]

When I run this cell I am getting this error. Do you know why?

conn = sqlite3.connect('chinook.db')
cur = conn.cursor()
albums = cur.execute('''select * from albums order by title limit 3;''').fetchall()
print(albums)

OperationalError: no such table: albums

[tello]

Do you recommend learn sql and Python for business and marketing?

[aggretsukolovers]

How much data would be too much data to have to use Spark?