New INFO 521 Course in Spring 2022
Category : Student Opportunities
INSTRUCTOR NAME: Ramesh Manyam
INSTRUCTOR CONTACT INFORMATION
EMAIL: ramesh [dot] manyam [at] emory [dot] edu
COURSE DESCRIPTION
In this course, you’ll learn about the basic structure of relational databases and how to read and write simple and complex SQL statements and advanced data manipulation techniques. By the end of this course, you’ll have a solid working knowledge of structured query language. You’ll feel confident in your ability to write SQL queries to create tables; retrieve data from single or multiple tables; delete, insert, and update data in a database; and gather significant statistics from data stored in a database. This course will teach key concepts of Structured Query Language (SQL), and gain a solid working knowledge of this powerful and universal database programming language. This course provides a comprehensive introduction to the language of relational databases: Structured Query Language (SQL). Topics covered include: Entity-Relationship modeling, the Relational Model, the SQL language: data retrieval statements, data manipulation and data definition statements. Homework will be done using databases running in MySQL which students install on their machines and proc SQL in SAS. Students develop a real-world database project using MySQL during the course. Prerequisite: SAS proficiency (BIOS 500 or equivalent)
COURSE LEARNING OBJECTIVE
Upon completion of this course, students will be able to:
• Learn structured query language (SQL) to an intermediate/advanced level.
• Be able to write data retrieval queries and evaluate the result set.
• Be able to write SQL statements that edit existing data.
• Be able to write SQL statements that create database objects.
• Understand the structure and design of relational databases.
• Understand the importance and major issues of database security and the maintenance of data integrity.
INFO Concentration COMPETENCIES:
■ Develop public health information systems to support public health efforts
■ Assist in the development and adoption of information technology in public health
■ Identify software for the interface of data entry and statistical analysis
■ Apply standard statistical methods in the analysis of public health information
Click below to read more:
