Loading…
WiLSWorld has ended
Back To Schedule
Wednesday, July 22 • 9:30am - 12:30pm
SQL 101 — Tables, Queries, and a Little MS Access: A Hands-On Introductory Workshop LIMITED

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Limited Capacity seats available

Join Eric for a hands-on opportunity to learn the basics of SQL! He’ll cover basic SQL language, and some behind the scenes details on what SQL looks like, while at the same time covering how to use MS Access to create and edit queries.

Using Microsoft Access as the tool to build and run your queries, you’ll learn:
  • Simple queries selecting data, counting data, and summarizing data.
  • How to link tables together to build more sophisticated reports
  • How to modify how tables are linked together to pull in information that only exists for some records but not others

  • Concepts around database design for understanding of limitations of spreadsheets, why multiple tables are used, and some commentary of things to look for to make your life easier as you work with vendor tables and try to decipher why the vendors database is the way it is.
MS Access is very powerful and we’ll be scratching the surface on what it can do using it to make SQL more accessible. We’ll cover what SQL looks like providing basic understanding of both SQL and how to use MS Access to quickly generate queries to access and compile data. We’ll be focused on tables, queries and SQL in MS Access, the workshop will not cover forms, reports or other advanced MS Access topics.

This workshop will not cover how to do any web programming, or how to setup the database connections. For specific databases, the vendors will provide documentation on how to setup, and depending on security settings on your work machine, your IT folks may have to be involved.

Speakers
EG

Eric Giefer

Director, Information Technology, UW Law School
Eric started working with the Law Library back in 1999 where he migrated reports to the new Voyager system and spent the next couple years working with a SQL support group, helping librarians do a myriad of quick reports of interest to their areas.  Now Eric oversees and programs... Read More →


Wednesday July 22, 2015 9:30am - 12:30pm CDT
Pyle Center, Room 335

Attendees (0)