Support H-Net | Buy Books Here | Help Support the NBN and NBN en Español on Patreon | Visit New Books Network en Español!
- African Studies
- African American Studies
- American Politics
- American Studies
- American South
- American West
- Asian American Studies
- Australian and New Zealand Studies
- British Studies
- Canadian Studies
- Caribbean Studies
- Central Asian Studies
- Chinese Studies
- East Asian Studies
- Eastern European Studies
- European Politics
- French Studies
- German Studies
- Iberian Studies
- India Studies
- Indian Ocean World
- Iranian Studies
- Irish Studies
- Israel Studies
- Italian Studies
- Japanese Studies
- Korean Studies
- Latino Studies
- Latin American Studies
- Mexican Studies
- Middle Eastern Studies
- Native American Studies
- Pacific Studies
- Polish Studies
- Russian and Eurasian Studies
- Southeast Asian Studies
- South Asian Studies
- Turkish Studies
- Ukrainian Studies
- Western European Studies
- World Affairs
- Animal Studies
- Anthropology
- Archaeology
- Business, Management, and Marketing
- Media
- Critical Theory
- Disability Studies
- Drugs, Addiction and Recovery
- Education
- Economics
- Finance
- Geography
- Gender Studies
- Genocide Studies
- Higher Education
- Human Rights
- Journalism
- Language
- Law
- LGBTQ+ Studies
- National Security
- Philosophy
- Policing, Incarceration, and Reform
- Political Science
- Politics & Polemics
- Public Policy
- Sex, Sexuality, and Sex Work
- Sociology
- Sound Studies
- Sports
- Urban Studies
Dec 19, 2022
SQL for Data Scientists
A Beginner's Guide for Building Datasets for Analysis
Summary
Economists and other social scientists are used to working with data that comes nicely organized into a table with a series of variable names across the top and a list of observations or datapoints down the right hand side. Data also naturally falls into this format when it comes from surveys we run. But the vast amounts of data generated by businesses and by all our online activities are usually organized in different ways. In corporate settings that first step of getting the right data and putting it into a table where it can be analyzed can be as important and challenging as the subsequent analyses. SQL (Structured Query Language) has been the standard language for accessing information in databases since the 1980s.
In this episode I interview Renee Teate, also known as “Data Science Renee” on Twitter, about her new book, SQL for Data Scientists: A Beginner’s Guide for Building Datasets for Analysis (Wiley, 2022). I learned about Renee from her popular blog and podcast, “Becoming a Data Scientist,” in which she talked about the paths she and others took to becoming a data scientist. While she was coming from more of an engineering background, many economists have been becoming data scientists from the other direction. They are building up their skills with databases and programming to complement their statistical and social science training, either because of new jobs in the tech sector or because of the new academic research possibilities this opens up. SQL is a crucial part of this toolkit, and this book is a great way to get started learning it.
In our conversation, we also discuss her current role as a lead data scientist at higher education analytics company Heliocampus, and some of her tips for aspiring data scientists as they apply for and interview for their first jobs.
For more information about the book (and an interactive SQL editor), go here.
Host Peter Lorentzen is the Chair of the Economics Department at the University of San Francisco, where he created a new Master’s degree in Applied Economics designed specifically to train students in a combination of economics and data science skills that equips them to succeed in the new digital economy.
Your Host
Peter Lorentzen
Peter Lorentzen is economics professor at the University of San Francisco. He heads USF's Applied Economics Master's program, which focuses on the digital economy. His research is mainly on China's political economy.