We may earn an affiliate commission when you visit our partners.
Sandro Raabe
In diesem zweistündigen Projekt wirst du Daten aus Datenbanktabellen mit dem SQL-GROUP-BY-Statement in Verbindung SQL-Aggregationsfunktionen abrufen. Wir werden die Aggregationsfunktionen COUNT(), SUM(), MIN(), MAX() und AVG() kennen lernen. Aggregationsfunktionen werden verwendet, um Zeilen einer Tabelle in einen einzigen Wert zusammen zu fassen. Außerdem wirst du lernen, wie du das gruppierten und aggregierten Ergebnis mit HAVING filtern kannst.
Hinweis: Du musst kein Data Analyst sein, um in diesem angeleiteten Projekt erfolgreich zu sein! Grundlegende Kenntnis von SQL SELECT- und WHERE-Statements sollte genügen.
Register for this course and see more details by visiting:
OpenCourser.com/course/1ekonx/datenaggregation
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Explores SQL-GROUP-BY-Statement, which is standard in industry
Teaches SQL SELECT- and WHERE-Statement, which helps learners use other SQL commands
Develops skills in using SQL-Aggregationsfunktionen, which are core skills for data analysis
Taught by Sandro Raabe, who are recognized for their expertise in data analysis
Examines SQL-Aggregationsfunktionen, which is highly relevant to data analysis
Builds a strong foundation for beginners in SQL
Save this course
Save Datenaggregation mit SQL 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 Datenaggregation mit SQL with these
activities:
Gather Resources and Tools for SQL
Show steps
Enhance your SQL knowledge by gathering and organizing valuable resources and tools.
Browse courses on
SQL
Show steps
-
Search for online tutorials, documentation, and articles on SQL.
-
Identify and bookmark useful SQL tools and software.
-
Create a central location to store and access these resources and tools.
Review SQL SELECT and WHERE Statements
Show steps
Refresh your knowledge of SQL SELECT and WHERE statements to ensure a solid foundation for this course.
Browse courses on
SQL
Show steps
-
Review the syntax and usage of the SQL SELECT statement.
-
Review the syntax and usage of the SQL WHERE statement.
-
Practice writing SQL SELECT and WHERE statements.
Follow a Tutorial on SQL GROUP BY and Aggregation Functions
Show steps
Deepen your understanding of SQL GROUP BY and aggregation functions through guided tutorials.
Browse courses on
SQL
Show steps
-
Search for a tutorial on SQL GROUP BY and aggregation functions.
-
Follow the steps in the tutorial to learn how to use these functions.
-
Practice using SQL GROUP BY and aggregation functions on your own.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Practice SQL GROUP BY and Aggregation Functions with Coding Exercises
Show steps
Solidify your skills in using SQL GROUP BY and aggregation functions through coding exercises.
Browse courses on
SQL
Show steps
-
Find coding exercises on SQL GROUP BY and aggregation functions.
-
Solve the exercises to practice using these functions.
-
Review the solutions to check your answers and identify areas for improvement.
Mentor a Peer in SQL
Show steps
Reinforce your understanding of SQL and develop leadership skills by mentoring a peer.
Browse courses on
SQL
Show steps
-
Identify a peer who could benefit from your guidance in SQL.
-
Set up regular meetings to provide support and guidance.
-
Review SQL concepts, answer questions, and provide feedback on their progress.
Create a Data Visualization Using SQL GROUP BY and Aggregation Functions
Show steps
Expand your understanding of SQL GROUP BY and aggregation functions by creating a data visualization.
Browse courses on
Data Visualization
Show steps
-
Identify a dataset that you can use to create a data visualization.
-
Use SQL GROUP BY and aggregation functions to prepare the data for visualization.
-
Choose a data visualization tool and create a visualization that represents the data.
Contribute to an Open-Source Project Related to SQL
Show steps
Gain practical experience and enhance your understanding of SQL by contributing to an open-source project.
Browse courses on
SQL
Show steps
-
Find an open-source project related to SQL that you are interested in.
-
Review the project's documentation and codebase.
-
Identify an area where you can contribute.
-
Make a pull request to the project with your contribution.
Gather Resources and Tools for SQL
Show steps
Enhance your SQL knowledge by gathering and organizing valuable resources and tools.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Search for online tutorials, documentation, and articles on SQL.
- Identify and bookmark useful SQL tools and software.
- Create a central location to store and access these resources and tools.
Review SQL SELECT and WHERE Statements
Show steps
Refresh your knowledge of SQL SELECT and WHERE statements to ensure a solid foundation for this course.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Review the syntax and usage of the SQL SELECT statement.
- Review the syntax and usage of the SQL WHERE statement.
- Practice writing SQL SELECT and WHERE statements.
Follow a Tutorial on SQL GROUP BY and Aggregation Functions
Show steps
Deepen your understanding of SQL GROUP BY and aggregation functions through guided tutorials.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Search for a tutorial on SQL GROUP BY and aggregation functions.
- Follow the steps in the tutorial to learn how to use these functions.
- Practice using SQL GROUP BY and aggregation functions on your own.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Practice SQL GROUP BY and Aggregation Functions with Coding Exercises
Show steps
Solidify your skills in using SQL GROUP BY and aggregation functions through coding exercises.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Find coding exercises on SQL GROUP BY and aggregation functions.
- Solve the exercises to practice using these functions.
- Review the solutions to check your answers and identify areas for improvement.
Mentor a Peer in SQL
Show steps
Reinforce your understanding of SQL and develop leadership skills by mentoring a peer.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Identify a peer who could benefit from your guidance in SQL.
- Set up regular meetings to provide support and guidance.
- Review SQL concepts, answer questions, and provide feedback on their progress.
Create a Data Visualization Using SQL GROUP BY and Aggregation Functions
Show steps
Expand your understanding of SQL GROUP BY and aggregation functions by creating a data visualization.
Browse courses on
Data Visualization
Show steps
Show steps
Show steps
- Identify a dataset that you can use to create a data visualization.
- Use SQL GROUP BY and aggregation functions to prepare the data for visualization.
- Choose a data visualization tool and create a visualization that represents the data.
Contribute to an Open-Source Project Related to SQL
Show steps
Gain practical experience and enhance your understanding of SQL by contributing to an open-source project.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Find an open-source project related to SQL that you are interested in.
- Review the project's documentation and codebase.
- Identify an area where you can contribute.
- Make a pull request to the project with your contribution.
Career center
Learners who complete Datenaggregation mit SQL will develop knowledge and skills
that may be useful to these careers:
Statistician
Statistician
Statisticians use SQL to manage and analyze large datasets. This course introduces aggregation functions, which are helpful for summarizing data and identifying trends. By understanding how to use SQL's GROUP BY statement, statisticians can identify patterns, draw conclusions, and make predictions from data, which are valuable skills for any statistician.
Data Scientist
Data Scientist
Data scientists use SQL to extract insights from data. This course will help build a foundation for data scientists by teaching them how to use SQL's GROUP BY statement along with aggregation commands (COUNT, SUM, MIN, MAX, AVG) to summarize data and filter the results using HAVING.
Data Analyst
Data Analyst
Data analysts use SQL to extract insights from data. This course will help build a foundation for data analysts by teaching them how to use SQL's GROUP BY statement along with aggregation commands (COUNT, SUM, MIN, MAX, AVG) to summarize data and filter the results using HAVING. Additional skills, such as data mining, data wrangling, and statistics will help data analysts develop a successful career.
Database Administrator
Database Administrator
Database administrators use SQL to design and maintain databases. This course will help build a foundation for database administrators by teaching them how to use SQL's GROUP BY statement to aggregate data and identify trends, which are crucial skills for maintaining a database.
Business Analyst
Business Analyst
Business analysts use SQL to understand how a business is operating and to make recommendations that help the business. This course introduces aggregation functions, which are helpful for summarizing data and identifying trends that impact a business. By understanding how to use SQL's GROUP BY statement, business analysts can identify which factors most influence a business' success and make confident recommendations to stakeholders.
Product Manager
Product Manager
Product managers use SQL to understand how users interact with a product. This course introduces aggregation functions, which are helpful for summarizing data. This allows a product manager to better understand usage statistics and make data-driven decisions for product development.
Operations Manager
Operations Manager
Operations managers use SQL to track the efficiency of their operations. This course introduces aggregation functions, which are helpful for summarizing data. By understanding how to use SQL's GROUP BY statement, operations managers can identify the most efficient processes and make data-driven decisions for future operations.
Data Engineer
Data Engineer
Data engineers use SQL to design and build data pipelines. This course will help build a foundation for data engineers by teaching them how to use SQL's GROUP BY statement to aggregate data and identify trends, which are important steps for building and maintaining a data pipeline.
Risk Manager
Risk Manager
Risk managers use SQL to track the risks associated with a business. This course introduces aggregation functions, which are helpful for summarizing data. By understanding how to use SQL's GROUP BY statement, risk managers can identify the most significant risks and make data-driven decisions for future risk management.
Marketing Manager
Marketing Manager
Marketing managers use SQL to track the effectiveness of marketing campaigns. This course introduces aggregation functions, which are helpful for summarizing data. By understanding how to use SQL's GROUP BY statement, marketing managers can identify the most successful campaigns and make data-driven decisions for future campaigns.
Customer Success Manager
Customer Success Manager
Customer success managers use SQL to track the satisfaction of customers. This course introduces aggregation functions, which are helpful for summarizing data. By understanding how to use SQL's GROUP BY statement, customer success managers can identify the most satisfied customers and make data-driven decisions for future customer interactions.
Project Manager
Project Manager
Project managers use SQL to track the progress of a project and ensure that it is on track. This course will help build a foundation for project managers by teaching them how to use SQL's GROUP BY statement to aggregate data and identify trends that will allow them to manage resources and make better decisions.
Sales Manager
Sales Manager
Sales managers use SQL to track the performance of their sales team. This course introduces aggregation functions, which are helpful for summarizing data. By understanding how to use SQL's GROUP BY statement, sales managers can identify the most successful sales strategies and make data-driven decisions for future sales efforts.
Software Engineer
Software Engineer
Software engineers use SQL to interact with databases. This course introduces aggregation functions, which are helpful for optimizing queries and reducing the amount of data that needs to be processed.
Financial Analyst
Financial Analyst
Financial analysts use SQL to track the performance of financial investments. This course introduces aggregation functions, which are helpful for summarizing data. By understanding how to use SQL's GROUP BY statement, financial analysts can identify the most successful investments and make data-driven decisions for future investments.
For more career information including salaries, visit:
OpenCourser.com/course/1ekonx/datenaggregation
Reading list
We've selected eight 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
Datenaggregation mit SQL.
Save
Provides a comprehensive guide to SQL, covering both basic and advanced concepts. It valuable resource for anyone who wants to learn more about SQL or improve their skills.
Practical guide to writing SQL queries. It covers all the basics of SQL, as well as some more advanced techniques.
Guide to tuning SQL queries for performance. It covers all the different factors that can affect the performance of a query, and how to optimize them.
Dieses Buch ist eine praktische Anleitung zum Verständnis und zur Anwendung von Datenbank-Systemen. Es deckt alle grundlegenden Konzepte ab, sowie einige fortgeschrittene Themen.
Save
Dieses Buch ist eine einfache Einführung in die wichtigsten Befehle und Funktionen von SQL. Es ist perfekt für Anfänger, die lernen möchten, wie man SQL verwendet.
Save
Quick and easy introduction to SQL. It is perfect for beginners who want to learn the basics of SQL quickly.
Guide to avoiding common SQL mistakes. It covers all the different types of SQL antipatterns, and how to avoid them.
Guide to protecting your SQL applications from SQL injection attacks. It covers all the different types of SQL injection attacks, and how to defend against them.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/1ekonx/datenaggregation
Share
Similar courses
Here are nine courses similar to
Datenaggregation mit SQL.
Teambuilding in Canva
OpenCourser.com/course/4aj4h9/teambuilding
Teambuilding in Canva
Most relevant
Bearbeite deine Fotos für soziale Medien mit Easil
OpenCourser.com/course/klo5vy/bearbeite
Bearbeite deine Fotos für soziale Medien mit Easil
Most relevant
Bearbeite Fotos für soziale Medien mit Canva
OpenCourser.com/course/yjynhs/bearbeite
Bearbeite Fotos für soziale Medien mit Canva
Most relevant
Erstelle ein Mockup in Canva
OpenCourser.com/course/fq3u27/erstelle
Erstelle ein Mockup in Canva
Most relevant
Datenanalyse mit deskriptiver Statistik in R
OpenCourser.com/course/gbbq6f/datenanalyse
Datenanalyse mit deskriptiver Statistik in R
Most relevant
Kreiere Logos für dein Unternehmen mit Canva
OpenCourser.com/course/0tkur3/kreiere
Kreiere Logos für dein Unternehmen mit Canva
Most relevant
Einführung in Zeitreihenanalyse mit R
OpenCourser.com/course/uojfno/einfuhrung
Einführung in Zeitreihenanalyse mit R
Most relevant
Datenanalyse mit R und dplyr
OpenCourser.com/course/6wc9lo/datenanalyse
Datenanalyse mit R und dplyr
Most relevant
Erstelle ein digitales Moodboard in Canva
OpenCourser.com/course/xy75l1/erstelle
Erstelle ein digitales Moodboard in Canva
Most relevant
Time
2 hours
Via
Coursera
Institution
Coursera Project Network
Instructor
Sandro Raabe
Good to know
Explores SQL-GROUP-BY-Statement, which is standard in industry
Teaches SQL SELECT- and WHERE-Statement, which helps learners use other SQL commands
Develops skills in using SQL-Aggregationsfunktionen, which are core skills for data analysis
Taught by Sandro Raabe, who are recognized for their expertise in data analysis
Examines SQL-Aggregationsfunktionen, which is highly relevant to data analysis
Builds a strong foundation for beginners in SQL
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