Description:

NOTE: This is an all-day workshop. Lunch will be provided.
Have you heard about databases but aren’t really sure what they are? Is your data growing beyond what you can manage in Excel? Do you need to learn SQL to access databases you want to use? Have you heard that data scientists use SQL and want to learn more? This workshop will cover the basics of database design and show you how to use SQL to work with relational databases.

Things you’ll learn in this workshop:

Principles of database design
SQL
Selecting, filtering, and aggregating data
Joining database tables together
Creating a database and defining tables
Inserting, updating, and deleting data
Importing and exporting data
Querying a database from R or Python
Prerequisites: None