SQL

Raul Montellano

UTech
Data Science

A fourth-year student who works in the D-Lab as a UTech. I love to play board games, long runs, and trying new food. Connect with me on LinkedIn (:

Shusheng Li

UTech Management
Data Science
Economics

Shusheng is currently a fourth-year undergraduate student studying Data Science and Economics. He is currently a part of the UTech Management team at D-Lab. Shusheng loves playing all types of sports because it's a great way to stay fit and be together with friends. Working as a UTech Front desk, Shusheng loves helping others and directing them to the right resources available.

Bobo Kwok

UTech
Data Science

I am an undergraduate student studying Data Science with an emphasis in Applied Mathematics & Modeling. I enjoy storytelling through data visuals and learning new visualization tools.

Amanda Jorgensen

IUSE Undergraduate Advisory Board
Data Science
Economics

I am currently a fourth-year undergraduate, studying Data Science and Economics.

dbplyr: do we still need to learn SQL to create and manage databases?

April 11, 2022

How to deal with datasets that are larger than our computer’s memory? Do we still need to learn Structured Query Language (SQL) to create and manage a database?

As an incipient data analyst, one of my first major challenges was to build and manage a spatial database using PostGIS, an open-source software that adds a geographic to PostgreSQL relational databases. I was given several text files in a hard drive that weighed approximately 10 GB each! My first reaction was to double click on the first text file that I saw… but this was clearly...

Spencer Le

Data Peer Consultant, UTech
Computer Science
Data Science

I am a senior majoring in Computer Science and minoring in Data Science. I love crunching down big data and analyzing it in order to help solve real-life issues. In my free time, I like jamming out to music, drawing, studying history, and posting on my foodstagram. If you have any questions regarding Computer Science or Data Science, please stop by!

Ian Castro

D-Lab Alumni
School of Information

Ian is a graduate student in the Master of Information Management and Systems program at the School of Information with a focus in applied data science. He earned his B.A. in Media Studies and B.S. in Microbial Biology from UC Berkeley, and his research interests and work experience are in STEM education. He focuses in building courses and academic programs to make data and computing accessible to historically marginalized students and those without prior exposure to the field.

Lia Chin-Purcell

Consultant
School of Information

Hello! I am a first-year Masters's student at the School of Information in the MIMS program with a focus is in data science and ethics. Before joining Berkeley, I studied computer science at the University of Puget Sound.

Tiffany Taylor

PhD Student
Anthropology

Tiffany Taylor is a doctoral student at the University of California, Berkeley. Previously, she received a Master of Public Health in Epidemiology from Columbia University's Mailman School of Public Health. She graduated from the University of Chicago with majors in Political Science, Sociology, and Comparative Race and Ethnic Studies (Asian American Studies). Some of her research interests include social medicine, educational sociology, and social demography. Additional interests include pilates, yoga, and fashion.

Ash Tan

Consultant
School of Information

Ash is a Masters of Information and Data Science student at the Berkeley School of Information. He currently studies data collection, analysis, and visualization, as well as research design and machine learning techniques. His interests include cognitive science, Wikipedia data, and privacy research.

Submit a Consulting Request