We may earn an affiliate commission when you visit our partners.
Course image
Hodroj Jamal

Dans ce projet guidé d'une heure, vous apprendrez à faire une requête SQL pour calculer les données, et aussi à les grouper et calculer les données d’un groupe des enregistrements.

À la fin de ce projet, nous aurons appris à créer et exploiter les requêtes de recherche avec les fonctions d'agrégations et les clauses GROUP BY et HAVING dans SQL.

Enroll now

What's inside

Syllabus

Module 1
Dans ce projet guidé d'une heure, vous apprendrez à faire une requête SQL pour calculer les données, et aussi à les grouper et calculer les données d’un groupe des enregistrements. À la fin de ce projet, nous aurons appris à créer et exploiter les requêtes de recherche avec les fonctions d'agrégations et les clauses GROUP BY et HAVING dans SQL.

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Explores SQL, a standard tool for working with data
Builds core skills for working with and analyzing data
Provides a strong foundation for beginners in SQL
Teaches skills that are highly relevant to industry and academia
Course duration is short, taking only one hour to complete

Save this course

Save Calcul de données en SQL to your list so you can find it easily later:
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 Calcul de données en SQL with these activities:
Suivre un tutoriel sur SQL
Aide à renforcer les concepts de base de SQL et à préparer le cours.
Browse courses on SQL
Show steps
  • Trouver un tutoriel en ligne adapté à votre niveau de connaissance
  • Suivre les instructions du tutoriel et écrire les requêtes SQL
  • Tester vos requêtes sur un ensemble de données d'exemple
Créer une base de données et effectuer des requêtes
Permet de mettre en pratique vos compétences en matière de création et d'interrogation de bases de données.
Browse courses on SQL
Show steps
  • Concevoir une base de données avec des tables, des champs et des relations
  • Créer la base de données à l'aide d'un système de gestion de base de données
  • Insérer des données dans les tables
  • Écrire des requêtes SQL pour récupérer et manipuler les données
Participer à un atelier sur SQL
Permet d'acquérir des connaissances et des compétences supplémentaires auprès d'experts du secteur.
Browse courses on SQL
Show steps
  • Trouver un atelier sur SQL adapté à votre niveau de connaissance
  • S'inscrire à l'atelier et y assister
  • Participer activement aux discussions et aux exercices
Show all three activities

Career center

Learners who complete Calcul de données en SQL will develop knowledge and skills that may be useful to these careers:
Business Intelligence Analyst
A Business Intelligence Analyst uses SQL to gather data from various sources, analyze it, and create reports and visualizations to help businesses make informed decisions. This course can help build a foundation for a career as a Business Intelligence Analyst by providing a solid understanding of SQL functions, aggregation, and grouping.
Data Analyst
A Data Analyst uses SQL to analyze databases and extract business insights from raw data. This course can help build a foundation for a career as a Data Analyst by providing a solid understanding of SQL functions, aggregation, and grouping.
Data Scientist
A Data Scientist uses SQL to explore and analyze data, build machine learning models, and develop predictive analytics solutions. This course can help build a foundation for a career as a Data Scientist by providing a solid understanding of SQL functions, aggregation, and grouping.
Database Administrator
A Database Administrator uses SQL to manage and maintain databases, ensuring data integrity, security, and performance. This course can help build a foundation for a career as a Database Administrator by providing a solid understanding of SQL functions, aggregation, and grouping.
Operations Research Analyst
An Operations Research Analyst uses SQL to analyze data, develop mathematical models, and solve business problems. This course can help build a foundation for a career as an Operations Research Analyst by providing a solid understanding of SQL functions, aggregation, and grouping.
Market Researcher
A Market Researcher uses SQL to analyze market data, identify trends, and develop marketing strategies. This course can help build a foundation for a career as a Market Researcher by providing a solid understanding of SQL functions, aggregation, and grouping.
Software Engineer
A Software Engineer uses SQL to design and develop software applications that interact with databases. This course can help build a foundation for a career as a Software Engineer by providing a solid understanding of SQL functions, aggregation, and grouping.
Financial Analyst
A Financial Analyst uses SQL to analyze financial data, create financial models, and make investment recommendations. This course can help build a foundation for a career as a Financial Analyst by providing a solid understanding of SQL functions, aggregation, and grouping.
Product Manager
A Product Manager uses SQL to analyze data, identify customer needs, and develop product strategies. This course can help build a foundation for a career as a Product Manager by providing a solid understanding of SQL functions, aggregation, and grouping.
Sales Analyst
A Sales Analyst uses SQL to analyze sales data, identify sales trends, and develop sales strategies. This course may be helpful for building a foundation for a career as a Sales Analyst by providing a solid understanding of SQL functions, aggregation, and grouping.
Statistician
A Statistician uses SQL to analyze data, develop statistical models, and make statistical inferences. This course may be helpful for building a foundation for a career as a Statistician by providing a solid understanding of SQL functions, aggregation, and grouping.
Risk Analyst
A Risk Analyst uses SQL to analyze data, identify risks, and develop risk management strategies. This course may be helpful for building a foundation for a career as a Risk Analyst by providing a solid understanding of SQL functions, aggregation, and grouping.
Writer
A Writer uses SQL to research data, develop content strategies, and create written content. This course may be helpful for building a foundation for a career as a Writer by providing a solid understanding of SQL functions, aggregation, and grouping.
Web Analyst
A Web Analyst uses SQL to analyze website data, identify website traffic trends, and develop website optimization strategies. This course may be helpful for building a foundation for a career as a Web Analyst by providing a solid understanding of SQL functions, aggregation, and grouping.
Project Manager
A Project Manager uses SQL to track project progress, identify risks, and manage resources. This course may be helpful for building a foundation for a career as a Project Manager by providing a solid understanding of SQL functions, aggregation, and grouping.

Reading list

We've selected six 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 Calcul de données en SQL.
Offers a concise and accessible introduction to SQL, making it a great starting point for those who are new to the language. It covers the basics of data querying and manipulation, providing a solid foundation for further learning.
Offers a practical guide to machine learning with popular Python libraries, such as Scikit-Learn, Keras, and TensorFlow. It provides hands-on examples and case studies that showcase the application of machine learning techniques in real-world scenarios.
Provides a comprehensive introduction to the R language for data science. It covers data import, manipulation, and visualization, and offers insights into statistical modeling.
Offers a comprehensive guide to Flask, another popular Python web framework. It covers the fundamentals of web development, from routing to templating, and provides insights into building scalable and secure applications.
Provides a comprehensive introduction to machine learning with Python. It covers the theoretical foundations, practical algorithms, and hands-on examples for building and evaluating machine learning models.
Introduces Python tools for data analysis, such as Pandas and NumPy. It covers data manipulation, cleaning, and visualization tasks that are often used in conjunction with SQL.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Calcul de données en SQL.
Agrégation de Données avec des Requêtes SQL
Most relevant
Tri et filtrage dans SQL
Most relevant
Fondamentaux du Système de Base de Données
Most relevant
Comment créer une connexion à une base de données SQL...
Most relevant
Comprendre la Syntaxe de Base de SQL.
Most relevant
Analyser les données pour répondre aux questions
Most relevant
Créér une plateforme d'aprentissage avec SQL, C# et...
Most relevant
Initiation aux conteneurs avec Docker
Most relevant
Combiner des données de plusieurs tables SQL
Most relevant
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