Loading…
RMACC HPC Symposium 2016 has ended
View analytic
Thursday, August 11 • 1:00pm - 4:30pm
Managing Data with SQL- 3 hours

Sign up or log in to save this to your schedule and see who's attending!

Software Carpentry's mission is to help scientists and engineers get more research done in less time and with less pain by teaching them basic lab skills for scientific computing. This hands-on workshop will cover basic concepts and tools, including program design, version control, data management, and task automation (with Unix shell). Participants will be encouraged to help one another and to apply what they have learned to their own research problems.

The course is aimed at undergraduate student researchers, graduate students, faculty, postdocs, and other researchers from RMACC. You don't need to have any previous knowledge of the tools that will be presented at the workshop.

Participants must bring a laptop with a Mac, Linux, or Windows operating system (not a tablet, Chromebook, etc.) that they have administrative privileges on. They should have a few specific software packages installed (we will send out information ahead of time). They are also required to abide by Software Carpentry's Code of Conduct.

  • Reading and sorting data
  • Filtering with where
  • Calculating new values on the fly
  • Handling missing values
  • Combining values using aggregation
  • Combining information from multiple tables using join
  • Creating, modifying, and deleting data
  • Programming with databases

Speakers

Thursday August 11, 2016 1:00pm - 4:30pm
LSC 386

Attendees (10)