We may earn an affiliate commission when you visit our partners.
Calcul de données en SQL
Hodroj Jamal
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.
Read more
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.
Read more
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/1488lb/calcul
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
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
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
Show steps
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
Show steps
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
Show steps
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
Suivre un tutoriel sur SQL
Show steps
Aide à renforcer les concepts de base de SQL et à préparer le cours.
Browse courses on
SQL
Show steps
Show steps
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
Show steps
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
Show steps
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
Show steps
Permet d'acquérir des connaissances et des compétences supplémentaires auprès d'experts du secteur.
Browse courses on
SQL
Show steps
Show steps
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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.
For more career information including salaries, visit:
OpenCourser.com/course/1488lb/calcul
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.
Save
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.
Save
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.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/1488lb/calcul
Share
Similar courses
Here are nine courses similar to
Calcul de données en SQL.
Agrégation de Données avec des Requêtes SQL
OpenCourser.com/course/1td75y/agregation
Agrégation de Données avec des Requêtes SQL
Most relevant
Tri et filtrage dans SQL
OpenCourser.com/course/3lsmi2/tri
Tri et filtrage dans SQL
Most relevant
Fondamentaux du Système de Base de Données
OpenCourser.com/course/auaov5/fondamentaux
Fondamentaux du Système de Base de Données
Most relevant
Comment créer une connexion à une base de données SQL Server
OpenCourser.com/course/claonq/comment
Comment créer une connexion à une base de données SQL...
Most relevant
Comprendre la Syntaxe de Base de SQL.
OpenCourser.com/course/a9jmvt/comprendre
Comprendre la Syntaxe de Base de SQL.
Most relevant
Analyser les données pour répondre aux questions
OpenCourser.com/course/5jivad/analyser
Analyser les données pour répondre aux questions
Most relevant
Créér une plateforme d'aprentissage avec SQL, C# et ASP.net
OpenCourser.com/course/bm967h/creer
Créér une plateforme d'aprentissage avec SQL, C# et...
Most relevant
Initiation aux conteneurs avec Docker
OpenCourser.com/course/p7vxm4/initiation
Initiation aux conteneurs avec Docker
Most relevant
Combiner des données de plusieurs tables SQL
OpenCourser.com/course/gt9rnd/combiner
Combiner des données de plusieurs tables SQL
Most relevant
Effort
2 heures
Level
Intermediate
Via
Coursera
Institution
Coursera Project Network
Instructor
Hodroj Jamal
Language
Français
Good to know
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
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