We may earn an affiliate commission when you visit our partners.
Josh Bernhard ,
Karl Krueger,
Derek Steer,
Richard Kalehoff,
and
Juno Lee
Register for this course and see more details by visiting:
OpenCourser.com/course/ab4gsb/sql
Two deals to help you save
We found two deals and offers that may be relevant to this course.
Save money when you learn.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Use code at checkout.
Valid for a limited time only
Bootcamp level quality
Complete hands-on projects and get personalized feedback with Udacity.
Take
40%
off
UDACITY40
Valid for a limited time only
Future-proof your career
Access O'Reilly books, live events, courses, and more. Save with an annual subscription.
Take
15%
off
What's inside
Syllabus
In this lesson, you will learn about data types, measures of center, and the basics of statistical notation.
In this lesson, you will learn about measures of spread, shape, and outliers as associated with quantitative data. You will also get a first look at inferential statistics.
Read more
Syllabus
In this lesson, you will learn about data types, measures of center, and the basics of statistical notation.
In this lesson, you will learn about measures of spread, shape, and outliers as associated with quantitative data. You will also get a first look at inferential statistics.
Read more
In this lesson, you will learn about the basic functionality for spreadsheet software, use cell referencing and menu shortcuts.
In this lesson, you will learn basic spreadsheet function: sort and filter data, use text and math functions, split columns and remove duplicates.
In this lesson, you will learn how to summarize data with aggregation and conditional functions. You will learn how to use pivot tables and lookup functions.
In this lesson you will build data visualizations for quantitative and categorical data; create pie, bar, line, scatter, histogram, and boxplot charts, and build professional presentations.
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Teaches fundamentals of statistics, which are highly relevant in academia and data-driven fields
Introduces spreadsheet functionality essential for data analysis
Explores advanced techniques for summarizing and visualizing data
Save this course
Save SQL Project Additional Resources to your list so you can find it easily later:
Save
Save
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in SQL Project Additional Resources with these
activities:
Review Basic Statistical Concepts
Show steps
Refresh your foundational understanding of statistical concepts before starting the course.
Browse courses on
Statistical Notation
Show steps
-
Review notes, textbooks, or online resources on basic statistical concepts.
-
Complete practice problems or quizzes to test your comprehension.
Practice Spreadsheet Basics
Show steps
Brush up on basic spreadsheet skills to ensure a smooth transition into the course.
Browse courses on
Spreadsheet Software
Show steps
-
Create a new spreadsheet and familiarize yourself with the user interface.
-
Practice entering, editing, and formatting data.
-
Use basic formulas and functions to perform simple calculations.
Spreadsheet Resources Compilation
Show steps
Gather and organize a comprehensive collection of resources to support your spreadsheet skills.
Browse courses on
Spreadsheet Software
Show steps
-
Identify and locate useful resources such as tutorials, articles, and reference materials.
-
Organize the resources into a central location (e.g., a document, spreadsheet, or online repository).
-
Review and update the compilation regularly to ensure its relevance and accuracy.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Explore Spreadsheet Functions Tutorial
Show steps
Expand your proficiency in spreadsheet software by following guided tutorials on various functions.
Browse courses on
Spreadsheet Functions
Show steps
-
Identify the specific functions you want to learn.
-
Locate and access relevant tutorials on these functions.
-
Follow the instructions and complete the practice exercises provided in the tutorials.
Participate in Spreadsheet Function Discussion Forum
Show steps
Engage with peers to clarify concepts and share knowledge related to spreadsheet functions.
Browse courses on
Spreadsheet Functions
Show steps
-
Join or create a discussion forum dedicated to spreadsheet functions.
-
Participate in discussions, ask questions, and share your own insights.
-
Review and contribute to responses provided by other members of the forum.
Practice Statistical Notations Drills
Show steps
Strengthen your understanding of the basics of statistics by practicing statistical notation drills.
Browse courses on
Statistical Notation
Show steps
-
Review the provided resources on statistical notation.
-
Complete the practice exercises provided in the course materials.
-
Check your answers and identify areas for improvement.
Calculate Measures of Spread
Show steps
Enhance your ability to analyze data by practicing the calculation of measures of spread.
Browse courses on
Measures of Spread
Show steps
-
Review the different measures of spread (range, variance, standard deviation).
-
Apply the appropriate formula to calculate the measures of spread for given datasets.
-
Interpret the results and discuss their implications.
Design Data Visualization
Show steps
Solidify your understanding of data visualization by creating your own charts and presentations.
Browse courses on
Data Visualization
Show steps
-
Select a dataset and identify the key variables you want to visualize.
-
Choose appropriate chart types to represent the data effectively.
-
Create the visualizations using a spreadsheet software or data visualization tool.
-
Refine and iterate on your designs to improve clarity and impact.
Review Basic Statistical Concepts
Show steps
Refresh your foundational understanding of statistical concepts before starting the course.
Browse courses on
Statistical Notation
Show steps
Show steps
Show steps
- Review notes, textbooks, or online resources on basic statistical concepts.
- Complete practice problems or quizzes to test your comprehension.
Practice Spreadsheet Basics
Show steps
Brush up on basic spreadsheet skills to ensure a smooth transition into the course.
Browse courses on
Spreadsheet Software
Show steps
Show steps
Show steps
- Create a new spreadsheet and familiarize yourself with the user interface.
- Practice entering, editing, and formatting data.
- Use basic formulas and functions to perform simple calculations.
Spreadsheet Resources Compilation
Show steps
Gather and organize a comprehensive collection of resources to support your spreadsheet skills.
Browse courses on
Spreadsheet Software
Show steps
Show steps
Show steps
- Identify and locate useful resources such as tutorials, articles, and reference materials.
- Organize the resources into a central location (e.g., a document, spreadsheet, or online repository).
- Review and update the compilation regularly to ensure its relevance and accuracy.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Explore Spreadsheet Functions Tutorial
Show steps
Expand your proficiency in spreadsheet software by following guided tutorials on various functions.
Browse courses on
Spreadsheet Functions
Show steps
Show steps
Show steps
- Identify the specific functions you want to learn.
- Locate and access relevant tutorials on these functions.
- Follow the instructions and complete the practice exercises provided in the tutorials.
Participate in Spreadsheet Function Discussion Forum
Show steps
Engage with peers to clarify concepts and share knowledge related to spreadsheet functions.
Browse courses on
Spreadsheet Functions
Show steps
Show steps
Show steps
- Join or create a discussion forum dedicated to spreadsheet functions.
- Participate in discussions, ask questions, and share your own insights.
- Review and contribute to responses provided by other members of the forum.
Practice Statistical Notations Drills
Show steps
Strengthen your understanding of the basics of statistics by practicing statistical notation drills.
Browse courses on
Statistical Notation
Show steps
Show steps
Show steps
- Review the provided resources on statistical notation.
- Complete the practice exercises provided in the course materials.
- Check your answers and identify areas for improvement.
Calculate Measures of Spread
Show steps
Enhance your ability to analyze data by practicing the calculation of measures of spread.
Browse courses on
Measures of Spread
Show steps
Show steps
Show steps
- Review the different measures of spread (range, variance, standard deviation).
- Apply the appropriate formula to calculate the measures of spread for given datasets.
- Interpret the results and discuss their implications.
Design Data Visualization
Show steps
Solidify your understanding of data visualization by creating your own charts and presentations.
Browse courses on
Data Visualization
Show steps
Show steps
Show steps
- Select a dataset and identify the key variables you want to visualize.
- Choose appropriate chart types to represent the data effectively.
- Create the visualizations using a spreadsheet software or data visualization tool.
- Refine and iterate on your designs to improve clarity and impact.
Career center
Learners who complete SQL Project Additional Resources will develop knowledge and skills
that may be useful to these careers:
Data Scientist
Data Scientist
Data scientists use their knowledge of statistics, data analysis, and machine learning to extract insights from data. This course may help build a foundation in statistical notation, data analysis, and spreadsheet functionality, which are essential skills for data scientists.
Machine Learning Engineer
Machine Learning Engineer
Machine learning engineers use their knowledge of statistics, data analysis, and machine learning to develop and implement machine learning models. This course may help build a foundation in statistical notation, data analysis, and spreadsheet functionality, which are essential skills for machine learning engineers.
Operations Research Analyst
Operations Research Analyst
Operations research analysts use their knowledge of statistics and mathematics to improve the efficiency of business operations. This course may help build a foundation in statistical notation and data analysis and interpretation, which are essential skills for operations research analysts.
Statistician
Statistician
Statisticians may work in a variety of industries, including healthcare, finance, and government. They use their knowledge of statistics to collect, analyze, and interpret data. This course may help build a foundation in data analysis and statistical notation, which are essential skills for statisticians.
Data Analyst
Data Analyst
Data analysts use their skills in data collection, analysis, and interpretation to help businesses make informed decisions. This course may help build a foundation in data analysis, statistical notation, and spreadsheet functionality, which are all essential skills for data analysts.
Financial Analyst
Financial Analyst
Financial analysts use their knowledge of finance and statistics to evaluate investments and make recommendations to clients. This course may help build a foundation in statistical notation and data analysis and interpretation, which are essential skills for financial analysts.
Risk Analyst
Risk Analyst
Risk analysts use their knowledge of statistics and data analysis to identify and assess risks. This course may help build a foundation in statistical notation and data analysis and interpretation, which are essential skills for risk analysts.
Quantitative Analyst
Quantitative Analyst
Quantitative analysts use their knowledge of statistics and mathematics to develop and implement financial models. This course may help build a foundation in statistical notation and data analysis and interpretation, which are essential skills for quantitative analysts.
Actuary
Actuary
Actuaries use their knowledge of statistics and mathematics to assess and manage financial risks. This course may help build a foundation in statistical notation and data analysis and interpretation, which are essential skills for actuaries.
Business Intelligence Analyst
Business Intelligence Analyst
Business intelligence analysts use their knowledge of data analysis and reporting to help businesses make informed decisions. This course may help build a foundation in data analysis, statistical notation, and spreadsheet functionality, which are all essential skills for business intelligence analysts.
Epidemiologist
Epidemiologist
Epidemiologists use their knowledge of statistics and public health to investigate the causes and spread of diseases. This course may help build a foundation in statistical notation and data analysis and interpretation, which are essential skills for epidemiologists.
Biostatistician
Biostatistician
Biostatisticians use their knowledge of statistics and biology to design and analyze clinical trials and other health-related studies. This course may help build a foundation in statistical notation and data analysis and interpretation, which are essential skills for biostatisticians.
Market Research Analyst
Market Research Analyst
Market research analysts use their knowledge of statistics and data analysis to understand consumer behavior and trends. This course may help build a foundation in statistical notation and data analysis and interpretation, which are essential skills for market research analysts.
Survey Statistician
Survey Statistician
Survey statisticians use their knowledge of statistics and survey design to collect and analyze data from surveys. This course may help build a foundation in statistical notation and data analysis and interpretation, which are essential skills for survey statisticians.
Data Mining Engineer
Data Mining Engineer
Data mining engineers use their knowledge of data analysis, statistics, and machine learning to extract valuable information from large datasets. This course may help build a foundation in data analysis, statistical notation, and spreadsheet functionality, which are all essential skills for data mining engineers.
For more career information including salaries, visit:
OpenCourser.com/course/ab4gsb/sql
Reading list
We've selected nine books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
SQL Project Additional Resources.
Save
Provides a comprehensive overview of computer vision techniques. It good choice for students and practitioners who want to learn more about the theoretical and practical aspects of computer vision.
Provides a probabilistic approach to machine learning. It good choice for students and practitioners who want to learn more about the theoretical and practical aspects of machine learning.
Save
Provides a comprehensive overview of pattern recognition and machine learning techniques. It good choice for students and practitioners who want to learn more about the theoretical and practical aspects of pattern recognition and machine learning.
Save
Provides a comprehensive overview of deep learning techniques. It good choice for students and practitioners who want to learn more about the theoretical and practical aspects of deep learning.
Provides a comprehensive overview of database systems. It good choice for students who want to learn more about the理論tical and practical aspects of database systems.
Provides a comprehensive overview of data mining techniques. It good choice for students and practitioners who want to learn more about the theoretical and practical aspects of data mining.
Save
Covers the basics of SQL, including data types, operators, and queries. It also provides an overview of database design and optimization.
Save
Provides a theoretical overview of the principles of web data management. It good choice for researchers who want to learn more about the theoretical foundations of web data management.
Quick and easy introduction to SQL. It is perfect for beginners who want to learn the basics of SQL in a short amount of time.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/ab4gsb/sql
Share
Similar courses
Similar courses are unavailable at this time. Please try again later.
Time
600 hours
Level
Introductory
Via
Udacity
Instructors
Josh Bernhard
Karl Krueger
Derek Steer
Richard Kalehoff
Juno Lee
Language
English
Good to know
Teaches fundamentals of statistics, which are highly relevant in academia and data-driven fields
Introduces spreadsheet functionality essential for data analysis
Explores advanced techniques for summarizing and visualizing data
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser