Getting to Know SQL (Two-Part Workshop)
Nov. 13, 2019, 3 p.m. - Nov. 15, 2019, 5 p.m.
DataLab: Data Science and Informatics
Michele Tobias firstname.lastname@example.org Pamela Reynolds email@example.com
DataLab: Data Science and Informatics classroom (Shields Library room 360). Directions: http://datalab.ucdavis.edu/dsl-location/
Learn the basics of SQL in this two-part, hands-on workshop geared for undergraduates and those who prefer a paced, practice-based approach to learning! SQL is a command-driven language used to communicate with relational database management systems. SQL statements are used to perform tasks such as updating or retrieving data from a database, performing calculations, and exporting extracted data to other software for analysis. This 2-part workshop series on Nov. 13 and Nov. 15 is designed for undergraduate students.
After this workshop learners should be able to:
– perform common SQL commands including: sorting, filtering, calculating values, aggregating, combining data, basic data cleaning (i.e. replace missing values)
– combine commands to construct a query to get to know a database, answer specific questions, and extract subsets of data.
PREREQUISITES & TARGET LEARNERS
Prior to the workshop download this easy-to-use SQL engine
http://www.sqlitetutorial.net/download-install-sqlite/ to your laptop. Bring your laptop to the workshops and please ensure that you have access to campus wireless “Eduroam.” No prior programming experience is necessary.
Registration is required. Link coming soon!
Participants are expected to attend both days of the workshop. Workshop dates are Wednesday and Friday, November 13 and 15, from 3-5pm each day.
You will receive a confirmation email once you are accepted into the workshop.
Undergraduates receive priority registration. Graduate students, postdocs, faculty, staff, etc. are welcome to attend, space permitting.
After this course learners have the option to become Bloomberg certified. After completing both sessions of the workshop, request to join the Bloomberg Training Team by emailing firstname.lastname@example.org with the subject “Bloomberg” from your UC Davis email address. Within a few days you will receive training material to complete for your certification. This certification may be particularly relevant to students interested in careers in business and/or finance. You do not need to complete the Bloomberg certification to enroll in this workshop. For more information about the Bloomberg Terminal and why you might want to become Bloomberg certified, see the Bloomberg website and/or contact Mr. Lundblad in Agricultural and Resource Economics.