| Call Number | 17207 |
|---|---|
| Day & Time Location |
W 5:30pm-8:20pm To be announced |
| Points | 3 |
| Grading Mode | Standard |
| Approvals Required | None |
| Instructor | Zoe Verzani |
| Type | INDEPENDENT |
| Method of Instruction | In-Person |
| Course Description | In this course, you will learn to design and build relational databases in MySQL and to write and optimize queries using the SQL programming language. Application of skills learned in this course will be geared toward research and data science settings in the healthcare field; however, these skills are transferable to many industries and application areas. You will begin the course examining the pitfalls of using Excel spreadsheets as a data storage tool and then learn how to build properly-designed relational databases to eliminate the issues related to spreadsheets and maintain data integrity when storing and modifying data. You will then learn two aspects of the SQL programming language: 1) the data manipulation language (DML), which allows you to retrieve data from and populate data into database tables (e.g., SELECT, INSERT INTO, DELETE, UPDATE, etc.), and 2) the data definition language (DDL), which allows you to create and modify tables in a database (e.g., CREATE, ALTER, DROP, etc.). You will additionally learn how to optimize SQL queries for best performance, use advanced SQL functions, and utilize SQL within common statistical software programs: R and SAS. |
| Web Site | Vergil |
| Department | Biostatistics |
| Enrollment | 35 students (35 max) as of 10:06AM Thursday, November 21, 2024 |
| Status | Full |
| Subject | Biostatistics |
| Number | P8180 |
| Section | 002 |
| Division | School of Public Health |
| Open To | GSAS, Public Health |
| Note | Sec 002 (Wednesday) meets online |
| Section key | 20241BIST8180P002 |