MySQL Basics and Beyond

MySQL is the world's most popular open source database and is used by large companies like Facebook, Google, and Adobe. CMS platforms like Drupal or WordPress are most often configured for use with MySQL databases.

In this beginner-to-intermediate session, we'll outline some of the most essential knowledge for understanding and working with MySQL databases.

This session will be ideal for those who would like to learn or better understand how to work with MySQL as a web database. You'll learn how to use SQL to extract meaningful data and how to work with multiple databases.

Topic include:

  • Core concepts: tables, columns, keys, and indexes
  • Basic queries
  • Joins and relational queries
  • Beyond basic queries (functions, subqueries, group by, etc)
  • Importing and Exporting Data
  • Command line vs GUI
  • Running MySQL on your Mac or PC

Brush up on existing skills or learn for the first time!

About the Speaker

Dave Sawyer is a Solutions Architect at OHO Interactive - a proud sponsor of NERD SUMMIT 2014. He has 15 years experience in web development and specializes in architecting multi-site solutions. Dave is an Acquia Certified Developer and works extensively with Drupal. He has given talks at numerous Drupal conferences and camps including DrupalCon Austin, Drupaldelphia, and DrupalCamp New Jersey. Previously, Dave has worked as a consultant and developer for Adobe Systems, Bloomsbury Publishing, and The Vineyard Gazette. You can follow him on Twitter at @cmsdave.

Experience level: 
Beginner
Sessions Topics: 
Speaker Bio(s): 
Dave Sawyer is a Solutions Architect at OHO Interactive - a proud sponsor of NERD SUMMIT 2014. He has 15 years experience in web development and specializes in architecting multi-site solutions. Dave is an Acquia Certified Developer and works extensively with Drupal. He has given talks at numerous Drupal conferences and camps including DrupalCon Austin, Drupaldelphia, and DrupalCamp New Jersey. Previously, Dave has worked as a consultant and developer for Adobe Systems, Bloomsbury Publishing, and The Vineyard Gazette. You can follow him on Twitter at @cmsdave.
Requested Session: