OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Course image
Course image
Coursera logo

تجميع البيانات باستخدام لغة الاستعلام البنيوية إسكيوإل

Nour Nasser

في هذه الدورة التدريبية القائمة على المشروع والتي تستغرق ساعة واحدة، ستتعرف على كيفيّة تجميع البيانات من خلال دوال التجميع باستخدام لغة الاستعلام البنيوية إسكيوإل.

Read more

في هذه الدورة التدريبية القائمة على المشروع والتي تستغرق ساعة واحدة، ستتعرف على كيفيّة تجميع البيانات من خلال دوال التجميع باستخدام لغة الاستعلام البنيوية إسكيوإل.

في نهاية الدورة، ستصبح قادرًا على كتابة دوال التجميع مع إستعلامات إسكيوإل كالمعدّل، الإحصاء، أعلى قيمة،أدنى قيمة، والمجموع.

Enroll now

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.
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

تجميع البيانات باستخدام إستعلامات إسكيوإل
في هذه الدورة التدريبية القائمة على المشروع والتي تستغرق ساعة واحدة، ستتعرف على كيفيّة تجميع البيانات من خلال دوال التجميع باستخدام إستعلامات إسكيوإل. في نهاية الدورة، ستصبح قادرًا على كتابة دوال التجميع مع إستعلامات إسكيوإل كالمعدّل، الإحصاء، أعلى قيمة،أدنى قيمة، والمجموع.

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Builds a solid foundation for beginners seeking to organize data through SQL aggregation functions
Emphasizes practical application by guiding learners through hands-on exercises
Exclusively taught in العربية, which may limit accessibility for non-Arabic speakers
Focuses on fundamental aggregation functions, suitable for learners with no prior SQL experience

Save this course

Save تجميع البيانات باستخدام لغة الاستعلام البنيوية إسكيوإل 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 تجميع البيانات باستخدام لغة الاستعلام البنيوية إسكيوإل with these activities:
Watch video tutorials on aggregate functions
Watching video tutorials is a great way to learn about aggregate functions at your own pace and in a visual way.
Browse courses on Aggregate Functions
Show steps
  • Search for video tutorials on aggregate functions on YouTube or other video-sharing platforms.
  • Watch the tutorials and take notes.
  • Try out the examples shown in the tutorials.
Join a study group or online forum focused on SQL
Joining a study group or online forum will give you the opportunity to connect with other learners and discuss aggregate functions.
Browse courses on Aggregate Functions
Show steps
  • Find a study group or online forum that focuses on SQL.
  • Introduce yourself and start participating in discussions.
  • Ask questions and share your knowledge with others.
دليل خطوة بخطوة لكتابة استعلامات إسكيوإل باستخدام دالات التجميع
يوفر هذا الدليل إرشادات واضحة حول كيفية استخدام دالات التجميع في استعلامات إسكيوإل، مما يساعدك على تطوير مهاراتك خطوة بخطوة.
Show steps
  • اتبع الخطوات الموجودة في الدليل لكتابة استعلامات إسكيوإل باستخدام دالات التجميع
  • جرب الأمثلة المقدمة في الدليل لفهم كيفية استخدام الدالات
  • اطرح الأسئلة على المنتديات أو المجتمعات عبر الإنترنت عند مواجهة صعوبات
Six other activities
Expand to see all activities and additional details
Show all nine activities
Solve practice problems on aggregate functions
Solving practice problems will help you solidify your understanding of aggregate functions and how to use them effectively in SQL queries.
Browse courses on Aggregate Functions
Show steps
  • Find a set of practice problems online or in a textbook.
  • Work through the problems, step-by-step.
  • Check your answers against the provided solutions.
تطبيق دالات التجميع على مجموعة البيانات الخاصة بك
ستساعدك هذه التمارين على تطبيق دالات التجميع في استعلامات إسكيوإل الخاصة بك، مما يعزز فهمك لكيفية استخدامها لمعالجة البيانات وتلخيصها.
Show steps
  • اختر مجموعة بيانات ذات صلة بعملك أو اهتماماتك
  • اكتب استعلامات إسكيوإل باستخدام دالات التجميع مثل SUM و AVERAGE و COUNT
  • حلل نتائج الاستعلامات لفهم كيفية تلخيص البيانات
Write a blog post or article about aggregate functions
Writing a blog post or article will help you synthesize your knowledge of aggregate functions and communicate it to others.
Browse courses on Aggregate Functions
Show steps
  • Choose a topic related to aggregate functions that you're interested in.
  • Research the topic and gather information from reliable sources.
  • Write a draft of your blog post or article.
  • Edit and revise your draft.
  • Publish your blog post or article.
ورشة عمل حول دالات التجميع لاستعلامات إسكيوإل
توفر ورشة العمل هذه بيئة عملية لتطبيق مهاراتك في كتابة استعلامات إسكيوإل مع دالات التجميع، مما يساعدك على تطوير فهم متعمق.
Show steps
  • حضر ورشة العمل وتفاعل مع المدربين والمتدربين الآخرين
  • شارك في التدريبات العملية لكتابة استعلامات إسكيوإل باستخدام دالات التجميع
  • ناقش أفضل الممارسات واستراتيجيات تحسين الاستعلامات مع الآخرين
إنشاء دليلك الخاص لاستخدام دالات التجميع في استعلامات إسكيوإل
سيتيح لك إنشاء الدليل الخاص بك فرصة لتلخيص معرفتك وترتيبها، مما يساعدك على تعميق فهمك لدالات التجميع.
Show steps
  • جمع الموارد والمعلومات حول دالات التجميع في استعلامات إسكيوإل
  • تنظيم المعلومات في مخطط منطقي أو هيكل هرمي
  • كتابة المحتوى الخاص بك باستخدام لغة واضحة وموجزة
  • تضمين الأمثلة والمراجع لإثراء محتوى الدليل
إكمال مشروع تحليل البيانات باستخدام دالات التجميع
يوفر لك إكمال مشروع عملي فرصة لتطبيق مهاراتك في استخدام دالات التجميع في سياق حقيقي، مما يعزز فهمك وتعزيز مهاراتك.
Show steps
  • حدد مجموعة بيانات ومشكلة تحليل البيانات التي تريد معالجتها
  • استخدم دالات التجميع في استعلامات إسكيوإل لتحليل البيانات وتلخيصها
  • بناء مرئيات أو تقارير لعرض نتائج التحليل
  • مناقشة النتائج واستخلاص الاستنتاجات

Career center

Learners who complete تجميع البيانات باستخدام لغة الاستعلام البنيوية إسكيوإل will develop knowledge and skills that may be useful to these careers:
Data Analyst
Data Analysts are experts in collecting and cleaning data, and using statistical and computational techniques to extract insights from data. This course on aggregating data using SQL will help Data Analysts build a foundation in SQL, which is a critical tool for data analysis. The course will teach Data Analysts how to use SQL to aggregate data, which is a key step in data analysis. The course will also teach Data Analysts how to use SQL to perform basic statistical analysis, which is another key skill for Data Analysts.
See salaries and explore the career path for Data Analyst
Statistician
Statisticians use mathematical and statistical techniques to collect, analyze, and interpret data. This course on aggregating data using SQL will help Statisticians build a foundation in SQL, which is a critical tool for data analysis. The course will teach Statisticians how to use SQL to aggregate data, which is a key step in data analysis. The course will also teach Statisticians how to use SQL to perform basic statistical analysis, which is another key skill for Statisticians.
See salaries and explore the career path for Statistician
Business Analyst
Business Analysts use data to help businesses make better decisions. This course on aggregating data using SQL will help Business Analysts build a foundation in SQL, which is a critical tool for data analysis. The course will teach Business Analysts how to use SQL to aggregate data, which is a key step in data analysis. The course will also teach Business Analysts how to use SQL to perform basic statistical analysis, which is another key skill for Business Analysts.
See salaries and explore the career path for Business Analyst
Database Administrator
Database Administrators are responsible for managing and maintaining databases. This course on aggregating data using SQL will help Database Administrators build a foundation in SQL, which is a critical tool for database management. The course will teach Database Administrators how to use SQL to aggregate data, which is a key step in data management. The course will also teach Database Administrators how to use SQL to perform basic statistical analysis, which is another key skill for Database Administrators.
See salaries and explore the career path for Database Administrator
Software Engineer
Software Engineers design, develop, and maintain software systems. This course on aggregating data using SQL will help Software Engineers build a foundation in SQL, which is a critical tool for software development. The course will teach Software Engineers how to use SQL to aggregate data, which is a key step in software development. The course will also teach Software Engineers how to use SQL to perform basic statistical analysis, which is another key skill for Software Engineers.
See salaries and explore the career path for Software Engineer
Data Scientist
Data Scientists use data to build models that can predict future events. This course on aggregating data using SQL will help Data Scientists build a foundation in SQL, which is a critical tool for data science. The course will teach Data Scientists how to use SQL to aggregate data, which is a key step in data science. The course will also teach Data Scientists how to use SQL to perform basic statistical analysis, which is another key skill for Data Scientists.
See salaries and explore the career path for Data Scientist
Machine Learning Engineer
Machine Learning Engineers design, develop, and maintain machine learning models. This course on aggregating data using SQL will help Machine Learning Engineers build a foundation in SQL, which is a critical tool for machine learning. The course will teach Machine Learning Engineers how to use SQL to aggregate data, which is a key step in machine learning. The course will also teach Machine Learning Engineers how to use SQL to perform basic statistical analysis, which is another key skill for Machine Learning Engineers.
See salaries and explore the career path for Machine Learning Engineer
Data Engineer
Data Engineers design, build, and maintain data pipelines. This course on aggregating data using SQL will help Data Engineers build a foundation in SQL, which is a critical tool for data engineering. The course will teach Data Engineers how to use SQL to aggregate data, which is a key step in data engineering. The course will also teach Data Engineers how to use SQL to perform basic statistical analysis, which is another key skill for Data Engineers.
See salaries and explore the career path for Data Engineer
Database Architect
Database Architects design and maintain databases. This course on aggregating data using SQL will help Database Architects build a foundation in SQL, which is a critical tool for database architecture. The course will teach Database Architects how to use SQL to aggregate data, which is a key step in database architecture. The course will also teach Database Architects how to use SQL to perform basic statistical analysis, which is another key skill for Database Architects.
See salaries and explore the career path for Database Architect
Business Intelligence Analyst
Business Intelligence Analysts use data to help businesses make better decisions. This course on aggregating data using SQL will help Business Intelligence Analysts build a foundation in SQL, which is a critical tool for business intelligence. The course will teach Business Intelligence Analysts how to use SQL to aggregate data, which is a key step in business intelligence. The course will also teach Business Intelligence Analysts how to use SQL to perform basic statistical analysis, which is another key skill for Business Intelligence Analysts.
See salaries and explore the career path for Business Intelligence Analyst
Information Architect
Information Architects design and organize information systems. This course on aggregating data using SQL will help Information Architects build a foundation in SQL, which is a critical tool for information architecture. The course will teach Information Architects how to use SQL to aggregate data, which is a key step in information architecture. The course will also teach Information Architects how to use SQL to perform basic statistical analysis, which is another key skill for Information Architects.
See salaries and explore the career path for Information Architect
Data Steward
Data Stewards ensure that data is accurate, complete, and consistent. This course on aggregating data using SQL will help Data Stewards build a foundation in SQL, which is a critical tool for data stewardship. The course will teach Data Stewards how to use SQL to aggregate data, which is a key step in data stewardship. The course will also teach Data Stewards how to use SQL to perform basic statistical analysis, which is another key skill for Data Stewards.
See salaries and explore the career path for Data Steward
Data Governance Analyst
Data Governance Analysts develop and implement data governance policies and procedures. This course on aggregating data using SQL will help Data Governance Analysts build a foundation in SQL, which is a critical tool for data governance. The course will teach Data Governance Analysts how to use SQL to aggregate data, which is a key step in data governance. The course will also teach Data Governance Analysts how to use SQL to perform basic statistical analysis, which is another key skill for Data Governance Analysts.
See salaries and explore the career path for Data Governance Analyst
Privacy Analyst
Privacy Analysts develop and implement privacy policies and procedures. This course on aggregating data using SQL will help Privacy Analysts build a foundation in SQL, which is a critical tool for privacy analysis. The course will teach Privacy Analysts how to use SQL to aggregate data, which is a key step in privacy analysis. The course will also teach Privacy Analysts how to use SQL to perform basic statistical analysis, which is another key skill for Privacy Analysts.
See salaries and explore the career path for Privacy Analyst
Risk Analyst
Risk Analysts identify and assess risks to an organization. This course on aggregating data using SQL will help Risk Analysts build a foundation in SQL, which is a critical tool for risk analysis. The course will teach Risk Analysts how to use SQL to aggregate data, which is a key step in risk analysis. The course will also teach Risk Analysts how to use SQL to perform basic statistical analysis, which is another key skill for Risk Analysts.
See salaries and explore the career path for Risk Analyst

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 تجميع البيانات باستخدام لغة الاستعلام البنيوية إسكيوإل.
Cover image
SQL Performance Explained
Save
يقدم الكتاب دليلًا عمليًا لتحسين أداء استعلامات SQL. يحدد تقنيات فعالة لضبط الاستعلامات وتقليل أوقات التشغيل.
(English) SQL Performance Explained Everything Developers...
Paperback
$$
Cover image
SQL Antipatterns, Volume 1
Save
يحدد الكتاب الممارسات السيئة الشائعة في استعلامات SQL. مفيد لتجنب الأخطاء وتحسين جودة الاستعلامات.
(English) SQL Antipatterns, Volume 1: Avoiding the Pitfalls...
Paperback
$$
(English) SQL Antipatterns, Volume 1
Kindle Edition
$$
Cover image
SQL Queries for Mere Mortals
Save
كتاب مفيد في مجال تحليل البيانات للمبتدئين والمتوسطين. يغطي أساسيات استعلامات SQL ويقدم أمثلة عملية. يمكن استخدام الكتاب كمصدر رئيسي أو كتاب تكميلي.
(English) SQL Queries for Mere Mortals: A Hands-On Guide to...
Kindle Edition
$$
(English) SQL Queries for Mere Mortals: A Hands-On Guide to...
Paperback
$$
(English) SQL Queries for Mere Mortals: A Hands-on Guide to...
Paperback
$$
(English) SQL Queries for Mere Mortals: A Hands-On Guide to...
Paperback
$$
Cover image
SQL Injection Attacks and Defense
Save
كتاب يركز على أمان استعلامات SQL. يغطي تقنيات حقن SQL وطرق الحماية منها.
(English) SQL Injection Attacks and Defense
Paperback
$$$
(English) SQL Injection Attacks and Defense
Paperback
$$$
(English) SQL Injection Attacks and Defense
Kindle Edition
$$
(English) SQL Injection Attacks and Defense
Kindle Edition
$$
Cover image
Data Analysis Using SQL and Excel
Save
كتاب يركز على تطبيقات استعلامات SQL في تحليل البيانات. يغطي تقنيات التحليل الشائعة باستخدام SQL وExcel.
(English) Data Analysis Using SQL and Excel
Paperback
$$
(English) Data Analysis Using SQL and Excel
Paperback
$$
(English) Data Analysis Using SQL and Excel
Kindle Edition
$$
Cover image
Seven Databases in Seven Weeks
Save
كتاب استكشافي يغطي مجموعة متنوعة من أنظمة قواعد البيانات، بما في ذلك SQL. يقدم نظرة عامة على المفاهيم الأساسية ووجهات نظر مختلفة.
(English) Seven Databases in Seven Weeks: A Guide to Modern...
Paperback
$$
(English) Seven Databases in Seven Weeks: A Guide to Modern...
Kindle Edition
$$
Cover image
MySQL Crash Course
Save
كتاب موجز ومباشر مثالي للمبتدئين الذين يرغبون في تعلم أساسيات استعلامات SQL بسرعة.
(English) MySQL Crash Course
Paperback
$$
(English) MySQL Crash Course
Kindle Edition
$$
(中文) MySQL必知必会 (图灵程序设计丛书 97) (Chinese Edition)
Kindle Edition
$
(中文) MySQL Crash Course(Chinese Edition)
Paperback
$$
Cover image
NoSQL Distilled
Save
على الرغم من أنه لا يركز بشكل أساسي على استعلامات SQL، إلا أن هذا الكتاب يوفر نظرة ثاقبة على أنظمة قواعد البيانات الحديثة. مفيد لفهم السياق الأوسع لاستعلامات SQL.
(English) NoSQL Distilled: A Brief Guide to the Emerging...
Kindle Edition
$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to تجميع البيانات باستخدام لغة الاستعلام البنيوية إسكيوإل.
تصور البيانات باستخدام Power BI: انشئ لوحة معلومات للتسويق
Most relevant
تجربة العملاء وخلق القيمة
إدارة الفئات المتقدمة وتنفيذ منهجية 5 للإدخار والقيمة و...
معالجة البيانات من غير نظيفة إلى نظيفة
تصميم مجموعة ترحيب العميل باستخدام كانفا
تصميم مواد تكميلية وموثقة للدورة التدريبية الرقمية على...
(c++) تعلم أساسيات لغة سي بلس بلس من خلال التطبيق العملي
قواعد البيانات وSQL (لغة الاستعلام البنيوية) لعلم البيانات
C++ بلغة Snake Game برمجة لعبة الثعبان
Course image
Effort
ساعتين
Level
Intermediate
Via
Coursera
Institution
Coursera Project Network
Instructor
Nour Nasser
Language
العربية
Good to know
Builds a solid foundation for beginners seeking to organize data through SQL aggregation functions
Emphasizes practical application by guiding learners through hands-on exercises
Exclusively taught in العربية, which may limit accessibility for non-Arabic speakers
Focuses on fundamental aggregation functions, suitable for learners with no prior SQL experience
Share and help others discover this course.
Facebook LinkedIn X Reddit Link Email
Don't miss out
Enroll today to gain access to this course
Enroll in this course
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