SQL

Erin Manalo-Pedro

Research Fellow
Community Health Sciences (UCLA)

Erin Manalo-Pedro is a Ph.D. student in the Department of Community Health Sciences at the UCLA Fielding School of Public Health with a minor in education. She focuses her racial health equity research on curriculum, the health workforce, and political interventions for communities of color. Drawing from Public Health Critical Race Praxis and Pinayism, she aims to use methods, like natural language processing and counter storytelling, to document the subtleties of structural racism and resistance from marginalized groups.

To guide her interdisciplinary approach, Erin leverages
...

Swetha Pola

Research Fellow
School of Information

Swetha (she/her) is a 5th Year Master of Information and Data Science student at the School of Information, with experience in Cognitive Science, Psychology research, and product management. Her research interests include building ethical, transparent AI and the impacts of technologies (specifically, mass media, surveillance, and algorithms of bias) on longitudinal behavioral health. She is happy to help with questions on Python, R, SQL, machine learning, neural networks, statistical analysis, and research design!

...

Aaron Culich

Deputy Director of D-Lab; Cyberinfrastructure Architect and Consulting Lead

Aaron Culich is a staff member at the D-Lab with expertise in Cloud Computing, High Performance Computing (HPC), Databases (SQL and NoSQL), JupyterHub and BinderHub infrastructure, and a variety of programming languages (Python, R, Java, C, C++, and more). His ongoing mission is to explore new compute possibilities, discovering useful tools and practices, and making them more accessible to researchers on campus and beyond.

Shusheng Li

UTech
Data Science
Economics

Shusheng is currently a third-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.

Louie Ortiz

IUSE Undergraduate Advisory Board
Data Science

Louie is a third-year transfer student majoring in Data Science with an emphasis on Cognition. He hopes to analyze how data—both at the computational and human level—can advance our understanding of technology and its socio-cultural implications. He is a part of the IUSE Undergraduate Advisory Board; helping make Data Science at Berkeley inclusive and accessible to all.

Shivani Patel

IUSE Undergraduate Advisory Board
Cognitive Science
Data Science

Hi! I’m a third-year at UC Berkeley studying Cognitive Science and minoring in Data Science. I will be pursuing a Doctorate of Physical Therapy with an emphasis in Sports Medicine but will be using my Data Science education as a way to enhance the field. I like learning about business models, impacted industries, and approaches to solving major problems in our world/communities.

Amanda Jorgensen

IUSE Undergraduate Advisory Board
Data Science
Economics

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

Seyi Olojo

Data Science Fellow
School of Information

Seyi is a PhD Student in the School of Information and is a member of the Algorithmic Fairness and Opacity Group. Her research broadly explores the problem space of digital memory, specifically the social discourse surrounding algorithms, ethics, and engagement. Additionally, her work often explores histories of quantification and the politics of categories within emerging technologies. She uses a mixed methods approach to research; this includes ethnography, interviews, grounded theory, surveys, data analysis and values-based design. Here at the D-lab, she leads the qualitative...

Daniel Lobo

Graduate Student Researcher (GSR)
Sociology

Hi, my name is Daniel and I’m a Ph.D. student in the Department of Sociology. I’m interested in social theory, education, and social media. One question I’m thinking about right now is under what conditions are universities' sites of social mobility vs. sites of social reproduction. I’m originally from Boston, MA, but have lived in NYC and LA since undergrad. I hold a BA in Social Studies, with high honors, from Harvard College. I identify as Black, queer, and working-class (first-gen).

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...