3.3.Databases: Where data lives - sj50179/Google-Data-Analytics-Professional-Certificate GitHub Wiki

When you’re analyzing data, you’ll access much of the data from a database. It’s where data lives. In this part of the course, you’ll learn all about databases, including how to access them and extract, filter, and sort the data they contain. You’ll also check out metadata to discover the different types and how analysts use them.

Learning Objectives

• Describe databases with references to their functions and components
• Explain metadata as it relates to databases
• Discuss the importance of metadata and how it relates to the work of a data analyst
• Demonstrate an understanding of the issues and steps involved in accessing data from multiple sources
• Explain the use of filters and sorting functionality in spreadsheets
• Demonstrate an understanding of how to use spreadsheet functionality to import and inspect a given set of data
• Demonstrate an understanding of how to use SQL functions to extract data from a database

---

• Working with databases & Managing data with metadata
• Accessing different data sources
• Sorting and filtering & Working with large datasets in SQL
• Weekly challenge 3