We may earn an affiliate commission when you visit our partners.
Hodroj Jamal
Dans ce projet guidé d'une heure, vous apprendrez à faire une requête SQL pour filtrer des enregistrements, et aussi à trier les données par ordre croissant ou décroissant.
À la fin de ce projet, nous aurons appris à créer et exploiter les requêtes de recherche dans SQL.
Register for this course and see more details by visiting:
OpenCourser.com/course/3lsmi2/tri
What's inside
Syllabus
Module 1
Dans ce projet guidé d'une heure, vous apprendrez à faire une requête SQL pour filtrer des enregistrements, et aussi à trier les données par ordre croissant ou décroissant.
À la fin de ce projet, nous aurons appris à créer et exploiter les requêtes de recherche dans SQL.
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Développer des compétences de base pour les débutants dans le filtrage et le tri de données SQL
Fournit des connaissances pratiques sur les requêtes SQL pour filtrer et trier efficacement les données
Save this course
Save Tri et filtrage dans 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 Tri et filtrage dans SQL with these
activities:
Utiliser le guide officiel de SQL
Show steps
Renforcez votre compréhension de la syntaxe SQL et des concepts fondamentaux.
Show steps
-
Visitez le site officiel de documentation SQL
-
Lisez le guide pas à pas
-
Essayez des exemples de requêtes
Participer à un groupe d'étude SQL
Show steps
Collaborer avec d'autres pour améliorer votre compréhension de SQL.
Show steps
-
Trouvez un groupe d'étude ou créez le vôtre
-
Fixez des objectifs d'étude réguliers
-
Discutez des concepts SQL et résolvez des problèmes ensemble
Bénévole pour des projets basés sur SQL
Show steps
Appliquez vos compétences SQL dans un contexte pratique.
Show steps
-
Recherchez des organisations qui utilisent SQL
-
Contactez les organisations pour proposer vos services
-
Travaillez sur des projets SQL qui répondent aux besoins de l'organisation
Show all three activities
Utiliser le guide officiel de SQL
Show steps
Renforcez votre compréhension de la syntaxe SQL et des concepts fondamentaux.
Show steps
Show steps
Show steps
- Visitez le site officiel de documentation SQL
- Lisez le guide pas à pas
- Essayez des exemples de requêtes
Participer à un groupe d'étude SQL
Show steps
Collaborer avec d'autres pour améliorer votre compréhension de SQL.
Show steps
Show steps
Show steps
- Trouvez un groupe d'étude ou créez le vôtre
- Fixez des objectifs d'étude réguliers
- Discutez des concepts SQL et résolvez des problèmes ensemble
Bénévole pour des projets basés sur SQL
Show steps
Appliquez vos compétences SQL dans un contexte pratique.
Show steps
Show steps
Show steps
- Recherchez des organisations qui utilisent SQL
- Contactez les organisations pour proposer vos services
- Travaillez sur des projets SQL qui répondent aux besoins de l'organisation
Show all three activities
Career center
Learners who complete Tri et filtrage dans SQL will develop knowledge and skills
that may be useful to these careers:
Data Engineer
Data Engineer
Data Engineers design and build data pipelines that collect, clean, and transform data. They work with a variety of data sources, including structured data, unstructured data, and streaming data. This course can help Data Engineers by providing them with the skills they need to filter and sort data in SQL, which is essential for building and maintaining data pipelines.
Machine Learning Engineer
Machine Learning Engineer
Machine Learning Engineers build and maintain machine learning models. They work with a variety of data sources, including structured data, unstructured data, and streaming data. This course can help Machine Learning Engineers by providing them with the skills they need to filter and sort data in SQL, which is essential for preparing data for modeling.
Data Scientist
Data Scientist
Data Scientists use data to build models that can predict future outcomes. They work with a variety of data sources, including structured data, unstructured data, and streaming data. This course can help Data Scientists by providing them with the skills they need to filter and sort data in SQL, which is essential for preparing data for modeling.
Data Analyst
Data Analyst
Data Analysts use data to solve business problems and make informed decisions. They collect, clean, and analyze data from a variety of sources, and then use that data to create reports and visualizations that can be used to identify trends and patterns. This course can help Data Analysts by providing them with the skills they need to filter and sort data in SQL, which is essential for collecting and cleaning data.
Business Analyst
Business Analyst
Business Analysts use data to solve business problems and make informed decisions. They work with a variety of data sources, including structured data, unstructured data, and streaming data. This course can help Business Analysts by providing them with the skills they need to filter and sort data in SQL, which is essential for collecting and cleaning data.
Statistician
Statistician
Statisticians use data to collect, analyze, and interpret data. They work with a variety of data sources, including structured data, unstructured data, and streaming data. This course can help Statisticians by providing them with the skills they need to filter and sort data in SQL, which is essential for collecting and cleaning data.
Risk Analyst
Risk Analyst
Risk Analysts use data to identify and assess risks. They work with a variety of data sources, including structured data, unstructured data, and streaming data. This course can help Risk Analysts by providing them with the skills they need to filter and sort data in SQL, which is essential for collecting and cleaning data.
Financial Analyst
Financial Analyst
Financial Analysts use data to analyze financial performance and make investment recommendations. They work with a variety of data sources, including structured data, unstructured data, and streaming data. This course can help Financial Analysts by providing them with the skills they need to filter and sort data in SQL, which is essential for collecting and cleaning data.
Actuary
Actuary
Actuaries use data to assess and manage financial risks. They work with a variety of data sources, including structured data, unstructured data, and streaming data. This course can help Actuaries by providing them with the skills they need to filter and sort data in SQL, which is essential for collecting and cleaning data.
Market Researcher
Market Researcher
Market Researchers collect and analyze data to understand consumer behavior and trends. They work with a variety of data sources, including structured data, unstructured data, and streaming data. This course can help Market Researchers by providing them with the skills they need to filter and sort data in SQL, which is essential for collecting and cleaning data.
Database Manager
Database Manager
Database Managers are responsible for managing and maintaining databases, ensuring that they are running smoothly and efficiently. They also work with other IT professionals to design and implement new database systems. This course can help Database Managers by providing them with the skills they need to filter and sort data in SQL, which is essential for managing and maintaining databases.
Software Engineer
Software Engineer
Software Engineers design, develop, and maintain software applications. They work with a variety of programming languages and technologies, including SQL. This course can help Software Engineers by providing them with the skills they need to filter and sort data in SQL, which is essential for developing and maintaining software applications.
Database Administrator
Database Administrator
Database Administrators are responsible for managing and maintaining databases, ensuring that they are running smoothly and efficiently. They also work with other IT professionals to design and implement new database systems. This course can help Database Administrators by providing them with the skills they need to filter and sort data in SQL, which is essential for managing and maintaining databases.
Web Developer
Web Developer
Web Developers design and develop websites and web applications. They work with a variety of programming languages and technologies, including SQL. This course can help Web Developers by providing them with the skills they need to filter and sort data in SQL, which is essential for developing and maintaining websites and web applications.
Information Security Analyst
Information Security Analyst
Information Security Analysts are responsible for protecting information systems from unauthorized access, use, disclosure, disruption, modification, or destruction. They work with a variety of security technologies, including firewalls, intrusion detection systems, and encryption. This course can help Information Security Analysts by providing them with the skills they need to filter and sort data in SQL, which is essential for identifying and investigating security threats.
For more career information including salaries, visit:
OpenCourser.com/course/3lsmi2/tri
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
Tri et filtrage dans SQL.
Save
Ce livre fournit une introduction rapide à SQL, y compris le filtrage et le tri des données. Il est idéal pour les débutants qui souhaitent apprendre les bases de SQL.
Save
Ce livre fournit une introduction amusante et engageante à SQL, y compris le filtrage et le tri des données. Il est idéal pour les débutants qui souhaitent apprendre SQL de manière interactive.
Bien que ce livre soit plus approfondi et technique que les autres recommandations, il fournit des informations détaillées sur l’optimisation des requêtes SQL, y compris le filtrage et le tri.
Save
Ce livre fournit des recettes spécifiques à MySQL pour résoudre des problèmes courants, y compris le filtrage et le tri. Il est utile pour les utilisateurs de MySQL qui souhaitent optimiser leurs requêtes.
Ce livre identifie les pièges courants et les mauvaises pratiques dans la conception et l'utilisation des requêtes SQL. Il peut aider les étudiants à éviter les erreurs courantes et à écrire des requêtes plus efficaces.
Ce livre aborde les aspects de conception et d'optimisation des requêtes SQL pour les systèmes à grande échelle. Il est utile pour les architectes de base de données et les développeurs qui travaillent avec des ensembles de données volumineux.
Save
Ce livre fournit des recettes pour résoudre des problèmes courants avec les requêtes T-SQL (Transact-SQL), y compris le filtrage et le tri. Il est utile pour les utilisateurs de Microsoft SQL Server qui souhaitent optimiser leurs requêtes.
Save
Ce livre fournit un aperçu de SQL pour les débutants. Il couvre les bases des filtres et du tri.
Ce livre fournit une introduction conviviale à SQL. Il couvre les bases des filtres et du tri.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/3lsmi2/tri
Share
Similar courses
Here are nine courses similar to
Tri et filtrage dans SQL.
Calcul de données en SQL
OpenCourser.com/course/1488lb/calcul
Calcul de données en SQL
Most relevant
Capstone : Application de la gestion de projets dans le monde réel
OpenCourser.com/course/9e5pp0/capstone
Capstone : Application de la gestion de projets dans le...
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
Créer et gérer des réseaux Docker sous Linux.
OpenCourser.com/course/2fx2c2/creer
Créer et gérer des réseaux Docker sous Linux.
Most relevant
Bases de la gestion de projet
OpenCourser.com/course/od1bqb/bases
Bases de la gestion de projet
Most relevant
Bases de la gestion de projet
OpenCourser.com/course/m416w5/bases
Bases de la gestion de projet
Most relevant
Capstone: Application de la gestion de projets dans le monde réel
OpenCourser.com/course/mgrmvg/capstone
Capstone: Application de la gestion de projets dans le...
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
Le Où, Pourquoi et Comment des Fonctions Lambda en Python
OpenCourser.com/course/aen68w/le
Le Où, Pourquoi et Comment des Fonctions Lambda en Python
Most relevant
Effort
2 heures
Level
Intermediate
Via
Coursera
Institution
Coursera Project Network
Instructor
Hodroj Jamal
Language
Français
Good to know
Développer des compétences de base pour les débutants dans le filtrage et le tri de données SQL
Fournit des connaissances pratiques sur les requêtes SQL pour filtrer et trier efficacement les données
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