Learn how to effectively use spreadsheets and SQL for data extraction, organization, and protection. Get practical tips from data analysts at Google who provide hands-on ways to accomplish common tasks with industry-standard tools and helpful resources. This is the third course in the Google Data Analytics Certificate, a series designed to prepare you for an introductory-level data analyst role.

Syllabus

Data types and structures

Introduction to data exploration
Course 3 overview
Hallie: Fascinating data insights
Data collection in our world
Determine what data to collect
Select the right data
Practice Quiz: Test your knowledge on collecting data
Discover data formats
Data formats in practice
Practice Quiz: Optional Self-Reflection: Unstructured data
Continue exploring structured data
The effects of different structures
Data modeling levels and techniques
Practice Quiz: Test your knowledge on data formats and structures
Know the type of data you're working with
Use Boolean logic
Data table components
Step-by-Step: Meet wide and long data
Meet wide and long data
Transforming data
Practice Quiz: Hands-On Activity: Introduction to Kaggle
Practice Quiz: Test your knowledge on data types, fields, and values
Glossary terms from module 1
Graded Quiz: Module 1 challenge

Data responsibility

Introduction to bias, credibility, privacy, and ethics
Bias: From questions to conclusions
Biased and unbiased data
Understand bias in data
Practice Quiz: Test your knowledge on unbiased and objective data
Identify good data sources
What is "bad" data?
Practice Quiz: Test your knowledge on data credibility
Essential data ethics
Optional refresher: Alex and the importance of data ethics
Prioritize data privacy
Data anonymization
Andrew: The ethical use of data
Practice Quiz: Test your knowledge on data ethics and privacy
Features of open data
The open data debate
Andrew: Steps for ethical data use
Resources for open data
Practice Quiz: Hands-On Activity: Kaggle datasets
Practice Quiz: Test your knowledge on open data
Glossary terms from module 2
Graded Quiz: Module 2 challenge

Database essentials

All about databases
Database features and components
Maximize databases in data analytics
Inspect a dataset: A guided, hands-on tour
Practice Quiz: Test your knowledge on working with databases
Demystify metadata
Metadata is as important as the data itself
Metadata and metadata repositories
Manage data with metadata
Megan: Fun with metadata
Practice Quiz: Test your knowledge on metadata
So many places to find data
Working with .csv files
Step-by-Step: Import data from spreadsheets and databases
Import data from spreadsheets and databases
Import data dynamically
Explore public datasets
Practice Quiz: Test your knowledge on accessing data sources
Sort and filter to focus on relevant data
Practice Quiz: Hands-On Activity: Clean data in spreadsheets with sorting and filtering
Practice Quiz: Self-Reflection: Compare databases and spreadsheets
Practice Quiz: Test your knowledge on sorting and filtering
Get to know BigQuery, including sandbox and billing options
Set up your BigQuery account
Get started with BigQuery
Step-by-Step: BigQuery in action
BigQuery in action
Practice Quiz: Hands-On Activity: Introduction to BigQuery
In-depth guide: SQL best practices
Practice Quiz: Hands-On Activity: Create a custom table in BigQuery
Practice Quiz: Hands-On Activity: Choose the right tool for the job
Practice Quiz: Hands-On Activity: More practice with SQL
Practice Quiz: Test your knowledge on using SQL with large datasets
Glossary terms from module 3
Graded Quiz: Module 3 challenge