Summary of "كيف تطبق ما تعلمته في البرمجة ؟"

Summary of the Video: “كيف تطبق ما تعلمته في البرمجة؟” (How to Apply What You Learned in Programming?)

This video highlights the importance of practicing programming by applying what you learn through hands-on problem-solving on various websites. It targets beginners who often find many challenge sites too difficult and introduces several beginner-friendly platforms to practice coding effectively. The presenter also briefly promotes a hosting service sponsor before diving into the main content.

Main Ideas and Concepts

Importance of Applying Programming Knowledge:
- Practicing coding by solving problems is crucial to deepen understanding.
- Writing code by hand and testing it helps solidify concepts learned in courses.
Challenges with Existing Programming Challenge Sites:
- Many popular challenge sites are geared toward advanced programmers.
- Beginners often find them difficult and discouraging.
Introduction of Beginner-Friendly Coding Practice Sites:
- The video introduces several websites suitable for beginners to practice programming.

Detailed Breakdown of Recommended Websites and Their Features

1. Rosetta Code (rosettacode.org)

Purpose: Offers a wide range of programming problems with solutions in many programming languages.
Features:
- Problems explained with inputs and expected outputs.
- Multiple solutions shown side-by-side in different languages (e.g., C, Python).
- No built-in code editor; users must write and test code locally.
Pros:
- Good exposure to different programming concepts and languages.
- Useful for seeing various ways to solve the same problem.
Cons:
- Lacks an integrated coding environment.
- The site interface is somewhat outdated.

2. Exercism (exercism.org)

Purpose: A platform suitable for all levels, especially beginners with basic programming knowledge.
Features:
- Requires account creation to save progress.
- Offers tracks by programming language (e.g., Python).
- Built-in code editor and test runner.
- Problems come with clear instructions and comments.
- Gamified experience with ranking and gradual unlocking of new exercises.
- Allows switching between exercises and saves unfinished work.
- Difficulty levels labeled (easy, medium, hard).
Pros:
- User-friendly UI.
- Encourages continuous practice and progression.
- Supports learning by doing rather than teaching from scratch.

3. Adept (adept.com)

Purpose: Another excellent site for practicing coding problems.
Features:
- Allows choosing programming language and difficulty level.
- Problems come with explanations, a code editor, and the ability to test and submit solutions.
- Includes community features like comments and solution viewing (with a penalty on points).
- Tracks user progress and awards points.
Example: Solving a problem to calculate the perimeter of a rectangle.
Pros:
- Clear problem descriptions.
- Interactive coding and testing.
- Supports learning through practice and community interaction.

4. SQL Practice Sites

Two sites are introduced for practicing SQL queries, important for database learning.

First SQL Site (Unnamed)

Features:
- Presents tables (e.g., “world”) with data.
- Tasks involve editing SQL queries to retrieve specific information (e.g., GDP of Germany).
- Includes quizzes to test understanding.
Pros:
- Good for beginners to learn basic SQL commands.

Second SQL Site (Unnamed, described as nicer)

Features:
- Interactive database with multiple tables (e.g., Actor, Address, City).
- Tasks require writing SQL queries from scratch.
- Provides feedback on query correctness.
- Offers hints for writing correct queries.
Example Tasks:
- Selecting all records from a table.
- Retrieving movie titles from a “movie” table.
Pros:
- Hands-on SQL practice.
- Immediate feedback and hints.
- Suitable for beginners and intermediate learners.

Methodology / Instructions for Using These Sites

Always create an account to save your progress and track your improvement.
Start with easy problems and gradually move to medium and hard ones.
Use the built-in editors and test features to write and validate your code.
If stuck, use hints or view solutions sparingly to learn without losing points.
Switch between exercises if one seems too difficult; return later with fresh ideas.
Engage with community comments for additional tips and explanations.
Practice regularly to build confidence and mastery.

For SQL Practice

Understand the database schema and tables before writing queries.
Write and test simple SELECT statements first.
Use provided hints and feedback to refine your queries.
Progress from basic queries to more complex ones involving conditions and ordering.

Additional Notes

The video emphasizes that practicing coding by writing and testing code is essential to truly understand programming.
The presenter encourages viewers to like, subscribe, and share the video.
A brief sponsor message for Hostinger hosting service is included at the beginning.

Speakers / Sources Featured

Main Speaker / Presenter: The video host (name not explicitly mentioned in subtitles, but coupon code suggests “Gharib Al-Sheikh”).
Sponsor Mentioned: Hostinger (hosting service).

This summary captures the key points and practical advice from the video, providing a clear guide for beginners to start applying their programming knowledge effectively.