SQL, the Sequel

Picking up where he left off in his last talk , Ryan Harvey will discuss more advanced concepts in SQL and using relational data in your data munging and analysis toolset. Possible topics include views, built-in and custom functions, indexes, triggers, rules, and relational algebra.  More information to come after the talk materials are created...

Bio:

Ryan Harvey is a local coder, datahead, project manager, wonk and dad. For work, he manages several government web apps at the Office of Management and Budget, in addition to doing data science, software architecture and application and database engineering for Kitchology, Inc. on the side. He's also a former PhD candidate (all-but-dissertation) in the Applied Mathematics, Applied Statistics and Scientific Computing program at the University of Maryland's Norbert Wiener Center for Harmonic Analysis and Applications.  Ryan lives in Lanham, MD, with his wife and two children and several pets

Join or login to comment.

  • Nevin H.

    Fabulous content!!! Hopefully, we can encourage Ryan to give more such insightful presentations in the months and years ahead; he has a great grasp of modern Open Source data processing technologies to share!

    2 · August 7

    • Ryan B. H.

      Thanks, Nevin. I'm happy to do future talks, but I'd like to make sure they're relevant. Let me know what topics you're interested in, and I'll see what I can do!

      August 12

  • Ann V.

    Great session! Ryan rocks SQL! :-)

    BTW, somebody during the intro shoutouts mentioned a meetup tomorrow nite in Arlington using BikeShare data - more details? thx

    August 6

  • Enrique

    Got tied up at work uggg

    August 6

  • Robert D.

    We are in the basement of 805! Pizza is here. Drinks are on the way.

    August 6

  • Ryan B. H.

    Looking forward to seeing everyone this evening. Slides and materials are at https://www.github.com/nihonjinrxs/dwdc-august2014. For the slides, you may have better luck with the PDF version than the HTML one, particularly if you're running Windows.

    1 · August 6

  • Robert D.

    Pizza and beverages are ordered. See you all tonight at 6:30. Come hungry!

    2 · August 6

  • Franz D.

    Hi Ryan:
    Enjoyed your last talk but unfortunately will have to look forward to looking at your talk material via the links. Cheers.
    Franz

    August 5

    • Ryan B. H.

      Sorry to hear you can't attend. Maybe next time. The materials should be helpful, and if you have questions, please feel free to ask, or create a GitHub issue in the repo with your question.

      August 5

  • Kartik M.

    Would any member be interested in forming Data Science / Hadoop study group

    4 · July 19, 2014

    • Doug T.

      I like the idea... I've been to a number of meetups on various hardware/software data sci products, but it's usually some specific subtopic... would be nice to have a more general "lets get our hands dirty" working group rather than just trying to play around with things on my own.

      August 5

    • Ryan B. H.

      Sounds fun. If you attend the talk tomorrow night, you'll see that a couple of the examples use DC Open Data, and for one, I'll point you to my repo with all the code to setup the database structures to make it queriable.

      August 5

  • Ryan B. H.

    The talk materials are almost ready. Topics include custom views and functions, performance tuning via indexes, and using SQL on data frames in R and Python. I'll briefly mention rules and triggers, but won't go into any detail on them. I'm also working on examples doing SQL on data frames in Julia, but I don't know if that will be ready by Wednesday.

    I'll post links when they're ready (probably just before the talk).

    I encourage folks to take pictures during the talk and post them here. I'd love to have a record of the talk and the audience. :-)

    3 · August 4

  • Ryan B. H.

    In addition to some of the other topics mentioned, I think I may also present on how you can use SQL statements to intelligently munge your data frames in R. Should be a fun talk with plenty of good material.

    2 · July 20, 2014

  • Jing

    Sounds great. Very useful and want to learn it!

    3 · July 19, 2014

  • Raphael

    Great minds think alike.

    1 · July 6, 2014

Our Sponsors

  • ARPC

    Economic, financial, statistical, analytics and operational consulting.

  • Data Community DC

    DWDC is a proud member meetup of the DC2 community.

  • Statistics.com

    15% off EVERYTHING with code "DC2"

  • Cloudera

    Organizational sponsor of Data Community DC!

People in this
Meetup are also in:

Imagine having a community behind you

Get started Learn more
Rafaël

We just grab a coffee and speak French. Some people have been coming every week for months... it creates a kind of warmth to the group.

Rafaël, started French Conversation Group

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy