Chapter 1 Getting Started

In this section, you will be able to define SQL and discuss how SQL differs from other computer languages. You will be able to compare and contrast the roles of a database administrator and a data scientist, and explain the differences between one-to-one, one-to-many and many-to-many relationships with databases. You will be able to use the SELECT statement and talk about some basic syntax rules. You will be able to add comments in your code and synthesize its importance.

Learning Objectives

  • Distinguish between use of SQL for data science applications and SQL for more common data management operations.
  • Use an Entity Relationship diagram, describing the data elements, their relationships and inter-dependencies and determine if the existent data is sufficient to address a business question.
  • Identify a subset of data needed from a column or set of columns and write and SQL query to limit to those results.
  • Create an analysis environment and use INSERT to put data into a table
  • Add effective comments in your queries so that:
    1. You can remember what you are doing
    2. others can review your work