SQL Boot Camp: Building and Querying Databases
The SQL Boot Camp is a three-day intensive boot camp of seminars and hands-on programming sessions to provide an overview on the design of relational databases and querying data from existing data sources using the SQL programming language.
This three-day intensive bootcamp covers the fundamentals of relational databases, including database design, and writing queries using the SQL language. The bootcamp will integrate seminar lectures with extensive hands-on sessions using two commonly available database software programs: Microsoft Access and MySQL. The first half of the bootcamp will cover building databases with proper design to maintain data integrity, while the second half will focus on retrieval and manipulation using SQL (Structured Query Language).
During this workshop, participants will:
-
Learn the pitfalls of using Excel for data storage
-
Build small relational databases in Microsoft Access and MySQL
-
Formulate SQL queries to 1) create and modify database objects, and 2) populate and retrieve data from database tables
-
Optimize SQL queries for best performance
Investigators at all career stages are welcome to attend. This workshop will particularly benefit those who will be actively involved in research data management.
PREREQUISITES AND REQUIREMENTS
There are two prerequisites and requirements to attend this training:
-
Basic experience working with data (e.g., data cleaning or analysis) is beneficial, but not required.
-
Each participant must have a laptop with Zoom installed. To get the most out of breakout groups, we also recommend a working microphone and webcam. Participants may also wish to share their screen with instructors during one-on-one questions.
ADDITIONAL INFORMATION
Register or view more information.
Subscribe for updates.
Email us at [email protected].
Capacity is limited. Paid registration is required to attend.
