Instructor: John Price, data scientist, Regenstrief Institute
Course objectives:
- Define SQL and discuss how SQL differs from other computer languages
- Explain the differences between one-to-one, one-to-many, and many-to-many relationships with databases
- Write basic SELECT statements as well as use other primary syntax such as WHERE, BETWEEN, IN, OR, NOT, LIKE, ORDER BY, and GROUP BY clauses and operators.
- Use the wildcard function to search for more specific or parts of records, including their advantages and disadvantages, and how best to use them.
- Use basic math operators, as well as aggregate functions like AVERAGE, COUNT, MAX, MIN, and others to begin analyzing our data.
- Identify and define several types of JOINs, including the Cartesian join, an inner join, left and right joins, full outer joins, and a self join.
- Modify strings by concatenating, trimming, changing the case, and using the substring function
- Apply SQL in the context of public health data management.