SQL: Building and Querying Databases
Master SQL in three days. Immerse yourself in seminars and hands-on sessions to design databases and query data using SQL.
Modules/Weeks
Weekly Effort
Discipline
School
Format
Cost
Course Description
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.
- Recognize the limitations of Excel for data storage, understanding the importance of relational databases for efficient data management.
- Acquire skills in designing and building small relational databases using MySQL, ensuring proper design principles for maintaining data integrity.
- Develop proficiency in formulating SQL queries to create and modify database objects, as well as populate and retrieve data from database tables, empowering efficient data manipulation.
- Learn techniques to optimize SQL queries for improved performance, enhancing efficiency in data retrieval and manipulation within relational databases.
To contact support for this course, please email [email protected].
Course Prerequisites
- 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.
What You Will Learn
This three-day intensive boot camp covers the fundamentals of relational databases, including database design, and writing queries using the SQL language. The boot camp will integrate seminar lectures with extensive hands-on sessions using the commonly available database software program MySQL. The first half of the boot camp 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 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
Instructors
Debra D'Angelo is the assistant director of biostatistics services in the Weill Cornell Medicine (WCM) Division of Biostatistics. She holds a Master of Science in biostatistics from the Columbia University Mailman School of Public Health, a graduate degree in statistics from University College London and a bachelor's degree in music and psychology from The State University of New York (SUNY) Potsdam and Crane School of Music. Before joining WCM, Debra was a biostatistician at the Risk Management Department of the Hospitals Insurance Company (HIC) in New York, NY, where she provided statistical consulting and data management support for research projects and patient safety initiatives. Prior to that, she worked as a biostatistician in the Department of Biostatistics at the Columbia University Mailman School of Public Health, performing statistical analyses for a large, international research consortium focused on autism spectrum disorders.
Debra is responsible for the recruitment and supervision of new biostatistician/programmer analyst staff for the Meyer Cancer Center, assisting with exploring and facilitating new biostatistical collaborations and contracts with WCM divisions, departments, and centers, and assisting with administratively directing/managing the Biostatistics, Epidemiology and Research Design [BERD] Core of the Clinical & Translational Science Center (CTSC). She has collaborations with the Department of Radiology and the Division of Endocrinology, Diabetes & Metabolism, and she supervises and helps recruit staff for the Division in general. Debra is also Debby actively involved with teaching in the PHS education programs.
