Giter Club home page Giter Club logo

pycon-sql-tutorial's Introduction

SQL for Python Developers

This repository contains all of the materials that go with my 2012 PyCon tutorial “SQL For Python Developers” that people are still enjoying thanks to its having been put online by Next Day Video and the conference:

https://www.youtube.com/watch?v=Thd8yoBou7k

If you are interested in trying out the materials yourself, here is the SQLite 3 database that you can download that powers all of the examples:

https://rhodesmill.s3.amazonaws.com/movie.db

Enjoy!

pycon-sql-tutorial's People

Contributors

brandon-rhodes avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

pycon-sql-tutorial's Issues

The YouTube video doesn't cover the solution to question 2-d.

Hi Mr. Rhodes,

Thank you so much for this amazing talk. Your SQL tutorial and Pandas tutorial are marvelous. I really appreciate what you've done.

But probably due to the video editing, the YouTube video doesn't actually cover the solution to question 2-d :"Which movie(s), not counting movies whose titles start with punctuation, come first in alphabetical order, and which come last?"

I tried "select * from movie where title REGEXP '[a-z]' order by title asc limit 10" with no luck. Could you illuminate how to solve the problem please?

Thanks.

copy of, or link to movie.db would be useful

Hey Brandon. I stumbled across a video of your pycon talk here:
https://www.youtube.com/watch?v=Thd8yoBou7k

The file 'movie.db' is neccessary to work through the examples that you present.
The youtube page doesn't have a link to the file movie.db. Comments on that page indicate that posting the link as a commenter would have some kind of issue, because of youtube commenting restrictions.

The repo doesn't have the db. Neither does it have a hyperlink to the db. (not that I could find after a few seconds off looking, anyway)

For people reading this post, the link is here:

http://rhodesmill.s3.amazonaws.com/movie.db

The video is pretty cool. It'd be great to have the link to that file being a little more easily discoverable. I suggest putting it in a readme.

Thanks.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.