Skip to main content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.
Link to Libraries homepage
Link to Libraries homepage
Rutgers University Libraries

Graduate Specialist Program (New Brunswick Libraries): SQL

Home page for the New Brunswick Libraries' Graduate Specialist Program

Workshop Schedule and Topics

Fall 2020 workshop information now available at:

NBL Workshop Calendar - https://libcal.rutgers.edu/nblworkshops

 

Data Science Basics: Introduction to SQL for Database Querying (Beginner)

Thursday | November 12, 2020 | 3:00pm ET (online)

This workshop will be a beginner level introduction to the fundamentals of the database language SQL. We will be using basic query statements and pattern matching to access data about Haas avocado prices (or another freely available alternative).

 

Data Science Basics: Beyond Basics in SQL (Beginner)

Thursday | November 19, 2020 | 3:00pm ET (online)

This workshop will be a beginner level introduction to summarizing and joining data using SQL. We will be querying from a dataset about Wish eCommerce products and sales (or another freely available alternative).

Tools

No need to worry about downloading a database management system! We will be using DB Fiddle.

Resources

Workshop Presentations

Slides from each workshop will be posted here.

Some cheat sheets to assist you in using SQL: SQL Cheat Sheets

Data Sources

Kaggle: Kaggle is a dataset repository, data science competition host, tutorial provider, and more. It has an active community that discusses and contributes solutions to various data science problems.

DATA.GOV: A home for U.S. government open data. Topics include climate, education, finance, and many more.

UCI Machine Learning Repository: The UCI Machine Learning Repository is a collection of databases, domain theories, and data generators that are used by the machine learning community for the empirical analysis of machine learning algorithms. This project is in collaboration with Rexa.info at the University of Massachusetts Amherst and receives funding support from the National Science Foundation.

Quantitative Data Science Graduate Specialist

Rutgers, The State University of New Jersey, an equal access/equal opportunity institution. Individuals with disabilities are encouraged to direct suggestions, comments, or complaints concerning any accessibility issues with Rutgers web sites to: accessibility@rutgers.edu or complete the Report Accessibility Barrier / Provide Feedback Form.