We may earn an affiliate commission when you visit our partners.
Course image
Charles Russell Severance

سيتعرف الطلاب خلال هذه الدورة على أساسيات لغة الاستعلام البنوية (SQL) وتصميم قاعدة البيانات الأساسية لتخزين البيانات كجزءٍ من جمع البيانات متعددة الخطوات وتحليلها ومعالجتها. تستخدم الدورة التدريبية SQLite3 قاعدة بيانات لها. نعمل أيضًا على إنشاء متتبعات الويب وعمليات جمع البيانات متعددة الخطوات وتصورها. نستخدم مكتبة D3.js لإجراء تصور البيانات الأساسية. تتناول هذه الدورة الفصلين 14 و15 من كتاب "Python for Everybody". كي تجتاز هذه الدورة، ينبغي أن تكون على دراية بالمواد المذكورة في الفصل الأول إلى الفصل 13 من الكتاب الدراسي والدورات الثلاث الأولى في هذا التخصص. تتناول هذه الدورة Python 3.

Enroll now

What's inside

Syllabus

Python الموجهة للعناصر
نغطي في بداية هذا الفصل أساسيات Python الموجهة للعناصر. لن نكتب كائنات خاصة بنا، ولكن نظرًا لأن العديد من الأمور التي نستخدمها مثل BeautifulSoup، والسلاسل، والقواميس، واتصالات قاعدة البيانات تستخدم جميعها أنماطًا موجهة للعناصر (OO)، فينبغي أن نفهم على الأقل بعض أنماطها ومصطلحاتها.
Read more
لغة الاستعلام البنوية الأساسية
نتعلم عمليات CRUD الأساسية الأربع (التي ترمز إلى Create وRead وUpdate وDelete) لإدارة البيانات المخزنة في قاعدة بيانات.
نماذج البيانات ولغة الاستعلام البنوية الارتباطية
سنتعرف في هذا القسم على كيفية تخزين البيانات في جداول متعددة في قاعدة بيانات وكيفية ربط الصفوف (على سبيل المثال، نعمل على إنشاء ارتباطات) في قاعدة البيانات.
علاقات متعدد بمتعدد في لغة الاستعلام البنوية
سنتعرف في هذا القسم على كيفية نمذجة مواقف، مثل الطلاب المسجلين في الدورات حيث يوجد في كل دورة العديد من الطلاب وكل طالب مسجل في العديد من الدورات.
قواعد البيانات والتصور
سنجمعها معًا في هذا القسم، ونسترجع بعض البيانات ونعالجها ثم نستخدم منصة خرائط جوجل لتصوير بياناتنا.

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Presents a solid introduction to SQL, database design and web scraping, useful for individuals interested in data analysis and processing
Covers essential elements of Python object-oriented programming, valuable for learners seeking a deeper understanding of the language
Demonstrates how to connect and extract data from databases, building foundational skills for data-driven decision-making
Provides hands-on practice in data visualization using D3.js library, giving learners practical experience in presenting data insights
Requires prior knowledge of Python programming concepts, which may limit accessibility for absolute beginners
Assumes familiarity with the first 13 chapters of 'Python for Everybody', potentially excluding learners who have not covered those topics

Save this course

Save Python استخدام قواعد البيانات مع 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 Python استخدام قواعد البيانات مع with these activities:
Review Linear Algebra
Review the fundamentals of linear algebra, including matrices, vectors, matrix operations, and vector spaces. This will provide a strong foundation for understanding data analysis and machine learning concepts.
Browse courses on Linear Algebra
Show steps
  • Review notes and textbooks on linear algebra
  • Solve practice problems and exercises
  • Attend a workshop or online course on linear algebra
إجراء تمارين CRUD باستخدام SQLite3
يغطي هذا القسم من الدورة عمليات CRUD الأساسية. ستساعدك ممارسة هذه العمليات على تطوير إتقانك للعمل مع قواعد البيانات.
Browse courses on sqlite3
Show steps
  • إنشاء قاعدة بيانات SQLite3 وتوصيلها.
  • إجراء عمليات الإنشاء والقراءة والتحديث والحذف على الجداول والبيانات.
  • استخدام معلمات الاستعلام للبيانات الآمنة.
SQL Coding Exercises
Engage in hands-on SQL coding exercises to reinforce your understanding of database queries, data manipulation, and the syntax of SQL.
Browse courses on SQL
Show steps
  • Complete online SQL coding challenges
  • Create a database and practice writing SQL queries
Three other activities
Expand to see all activities and additional details
Show all six activities
Collaborative Data Analysis Project
Participate in a collaborative data analysis project with peers. This will provide hands-on experience working with data and enhance your teamwork and communication skills.
Browse courses on Data Analysis
Show steps
  • Form a team and select a data analysis project
  • Collect and clean the data
  • Analyze the data and draw insights
  • Present your findings to the class
Data Visualization with Tableau
Explore data visualization techniques using Tableau, a powerful data visualization tool. This will enhance your ability to communicate data insights effectively.
Browse courses on Data Visualization
Show steps
  • Follow online tutorials on Tableau
  • Create interactive data visualizations using Tableau
  • Attend a workshop or training on data visualization with Tableau
Data-Driven Business Case Proposal
Develop a data-driven business case proposal. This will challenge you to apply your data analysis skills to real-world business scenarios.
Show steps
  • Identify a business problem or opportunity
  • Collect and analyze relevant data
  • Develop a solution and create a business case proposal
  • Present your proposal to a panel of experts

Career center

Learners who complete Python استخدام قواعد البيانات مع will develop knowledge and skills that may be useful to these careers:
Business Analyst
Business Analysts help companies understand their business needs and identify opportunities for improvement. They use a variety of tools and techniques to analyze data, including SQL and Python. This course provides a strong foundation in both of these tools, making it a valuable resource for aspiring Business Analysts. The course also covers data visualization, which is an essential skill for Business Analysts who want to communicate their findings effectively.
Data Analyst
Data Analysts collect and interpret data to help companies make better decisions. They use a variety of tools and techniques to analyze data, including SQL and Python. This course provides a strong foundation in both of these tools, making it a valuable resource for aspiring Data Analysts. The course also covers data visualization, which is an essential skill for Data Analysts who want to communicate their findings effectively.
Database Administrator
Database Administrators manage and maintain databases. They use a variety of tools and techniques to ensure that databases are available, reliable, and secure. This course provides a strong foundation in SQL, which is the most widely used database language. The course also covers database design and administration, which are essential skills for Database Administrators who want to manage and maintain complex databases.
Data Engineer
Data Engineers design and build the systems that store and process data. They use a variety of programming languages and tools, including Python and SQL. This course provides a strong foundation in both of these tools, making it a valuable resource for aspiring Data Engineers. The course also covers data modeling and database design, which are essential skills for Data Engineers who want to design and build scalable and efficient data systems.
Data Scientist
Data Scientists use data to solve business problems. They use a variety of tools and techniques to analyze data, including Python and SQL. This course provides a strong foundation in both of these tools, making it a valuable resource for aspiring Data Scientists. The course also covers machine learning and artificial intelligence, which are essential skills for Data Scientists who want to develop data-driven solutions to business problems.
Statistician
Statisticians collect, analyze, and interpret data. They use a variety of tools and techniques to analyze data, including Python and SQL. This course provides a strong foundation in both of these tools, making it a valuable resource for aspiring Statisticians. The course also covers probability and statistics, which are essential skills for Statisticians who want to analyze data and draw meaningful conclusions.
Software Engineer
Software Engineers design, develop, and maintain software applications. They use a variety of programming languages and tools, including Python and SQL. This course provides a strong foundation in both of these tools, making it a valuable resource for aspiring Software Engineers. The course also covers object-oriented programming and data structures, which are essential skills for Software Engineers who want to design and develop scalable and efficient software applications.
Web Developer
Web Developers design and develop websites and web applications. They use a variety of programming languages and tools, including Python and SQL. This course provides a strong foundation in Python, which is a popular language for web development. The course also covers HTML, CSS, and JavaScript, which are essential skills for Web Developers who want to design and develop interactive and user-friendly websites and web applications.
Quantitative Analyst
Quantitative Analysts use data to develop and implement trading strategies. They use a variety of tools and techniques to analyze data, including Python and SQL. This course provides a strong foundation in both of these tools, making it a valuable resource for aspiring Quantitative Analysts. The course also covers machine learning and artificial intelligence, which are essential skills for Quantitative Analysts who want to develop data-driven trading strategies.
Financial Analyst
Financial Analysts use data to make investment decisions, advise companies on financial matters, and manage portfolios. They use a variety of tools and techniques to analyze data, including Python and SQL. This course provides a strong foundation in both of these tools, making it a valuable resource for aspiring Financial Analysts. The course also covers financial modeling and analysis, which are essential skills for Financial Analysts who want to make sound investment decisions.
Market Researcher
Market Researchers collect and analyze data to help companies understand their customers and make better decisions. They use a variety of tools and techniques to analyze data, including Python and SQL. This course provides a strong foundation in both of these tools, making it a valuable resource for aspiring Market Researchers. The course also covers data visualization, which is an essential skill for Market Researchers who want to communicate their findings effectively.
Data Management Analyst
Data Management Analysts plan, design, and implement data management solutions. They use a variety of tools and techniques to manage data, including Python and SQL. This course provides a strong foundation in both of these tools, making it a valuable resource for aspiring Data Management Analysts. The course also covers data governance and data quality, which are essential skills for Data Management Analysts who want to ensure that data is accurate, reliable, and secure.
Business Intelligence Analyst
Business Intelligence Analysts use data to improve business performance. They use a variety of tools and techniques to analyze data, including Python and SQL. This course provides a strong foundation in both of these tools, making it a valuable resource for aspiring Business Intelligence Analysts. The course also covers data mining and business intelligence, which are essential skills for Business Intelligence Analysts who want to identify trends and patterns in data and make recommendations for improvement.
Data Architect
Data Architects design and build the architecture for data systems. They use a variety of tools and techniques to design and build data systems, including Python and SQL. This course provides a strong foundation in both of these tools, making it a valuable resource for aspiring Data Architects. The course also covers data modeling and database design, which are essential skills for Data Architects who want to design and build scalable and efficient data systems.
Information Security Analyst
Information Security Analysts protect computer systems and networks from unauthorized access, use, disclosure, disruption, modification, or destruction. They use a variety of tools and techniques to secure computer systems and networks, including Python and SQL. This course provides a strong foundation in Python, which is a popular language for developing security tools and applications. The course also covers network security and cybersecurity, which are essential skills for Information Security Analysts who want to protect computer systems and networks from cyber threats.

Reading list

We've selected 11 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 Python استخدام قواعد البيانات مع.
يوفر هذا الكتاب مقدمة جيدة لمبادئ SQL الأساسية، مثل إنشاء الجداول والاستعلام عنها وتعديلها. يعتمد هذا الكتاب على نهج عملي، مما يجعله مفيدًا للمبتدئين في مجال قواعد البيانات.
هذا الكتاب هو دليل عملي لمكتبة D3.js، والتي تُستخدم في هذه الدورة لتصور البيانات. يغطي الكتاب مواضيع مثل إنشاء المخططات التفاعلية، ومعالجة البيانات، وتقنيات التفاعل.
يوفر هذا الكتاب نظرة عامة شاملة لمكتبة Pandas، وهي مكتبة Python شائعة الاستخدام لتحليل البيانات. يغطي الكتاب مواضيع مثل التلاعب بالبيانات، والتنظيف، والتجميع.
هذا الكتاب مفيد كمرجع للمكتبة القياسية لـ Python، والتي تُستخدم بكثافة في هذه الدورة. يغطي الكتاب مواضيع مثل معالجة الملفات، ومعالجة النصوص، والتعامل مع قواعد البيانات.
يقدم هذا الكتاب مقدمة شاملة لبرمجة Python، بما في ذلك تغطية متقدمة لموضوعات مثل برمجة كائنات Python وإدارة الذاكرة. يُوصى بهذا الكتاب للمتعلمين الذين يرغبون في الحصول على فهم عميق للغة Python.
يقدم هذا الكتاب نهجًا عمليًا لاستخدام Python لأتمتة المهام. يغطي الكتاب مواضيع مثل كشط الويب، ومعالجة النصوص، والتلاعب بالملفات.
يقدم هذا الكتاب نظرة عامة شاملة لمكتبة Beautiful Soup، وهي مكتبة Python شائعة الاستخدام لكشط الويب. يُوصى بهذا الكتاب للمتعلمين الذين يرغبون في تعلم كيفية استخراج البيانات من مواقع الويب.
يغطي هذا الكتاب مجموعة من أفضل ممارسات برمجة Python وأسلوبها. يُوصى بهذا الكتاب للمتعلمين الذين يرغبون في تحسين جودة رمز Python الخاص بهم.
يغطي هذا الكتاب مجموعة واسعة من تقنيات تصور البيانات باستخدام Python و JavaScript. يُوصى بهذا الكتاب للمتعلمين الذين يرغبون في توسيع نطاق مهاراتهم في تصور البيانات.
يوفر هذا الكتاب مقدمة جيدة لمبادئ برمجة Python الأساسية. يُوصى بهذا الكتاب للمتعلمين الذين ليس لديهم خبرة سابقة في برمجة Python.

Share

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

Similar courses

Here are nine courses similar to Python استخدام قواعد البيانات مع.
المشروع المتقدم لمهندس قاعدة البيانات
Most relevant
منهجية علم البيانات
Most relevant
مقدمة عن قواعد البيانات
Most relevant
الجمع بين أجزاء متعددة من البيانات في سيكويل
Most relevant
Python معالجة مسبقة للبيانات و تحليلها بواسطة
Most relevant
بايثون لعلوم البيانات والذكاء الصناعي
Most relevant
هياكل قواعد البيانات وإدارتها باستخدام MySQL
Most relevant
تحليل البيانات في سْكِيل: عالج و حلّل البيانات
Most relevant
مقدمة عن قواعد بيانات للتطوير على الخادم
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