SQL and Data: Exploration and Analysis

3 units

This course is designed to provide students with a basic understanding of common tools needed to explore and analyze data and to create actionable information. Spreadsheets, databases, and a programming language to manipulate data form the foundation of this toolset. While there are many applications available in these three categories, this class will utilize Microsoft Excel, Microsoft Access, and Structured Query Language (SQL) to understand the fundamentals. By the end of this course, students should be familiar using spreadsheets and databases for data queries, analysis, and visualization. Any basic statistics required for the class will be covered. No prerequisites, but college algebra, plus basic knowledge in spreadsheets, would be helpful (but not necessary).