Name: Mastering MySQL | From Zero to Database Hero - Mefth
Price: 49.3 USD
Rating: 0 (0 reviews)

Mastering MySQL | From Zero to Database Hero

🚀 MySQL ካብ ባዶ ተማሃሩ! ናይ SQL queries ምጽሓፍ፣ ዳታቤዝ ዲዛይን ምግባርን ዳታ ከም ፕሮ ምምሕዳርን-ተመኩሮ ኣየድልን። 🚶‍♂️ጉዕዞ ዳታኹም ሎሚ ጀምሩ! 💡💻

0 (0 Ratings) 0 Students 13 hours of videos. Course in: Tigrinya Language For Beginners Level Last updated on: 1 June, 2025

Biniam Abdenur

Course Features

Lectures : 82

Duration : 13 hours

Access: Lifetime

$69$59 Enroll

ካብዛ ስልጠና እንታይ ኢኹም ክትመሃሩ፧

📊መእተዊ ብዛዕባ ዳታን ዳታቤዝን 📋ምርዳእ ብዛዕባ ኣቃውማ ዳታ (Data Structure) 🛠️ምጽዓንን ምድህሳስን ማይ-ኤስኪውኤል ኣብ ኮምፕዩተርና (Installing & Setting Up MySQL in local) 🧱ሓበሬታ ኣብ ሰርቨር ምእታው፡ ምድምሳስ፡ ምትዕርራይን ምውጻእን (CRUD operations) 📝ሐበሬታ ምስራዕ፡ ምድላይ፡ ሰሪዕኻ ምውጻእ፡ ምጽማቁን ምጽንባርን ኣብ ሰርቨር (Filtering, Sorting & Joining Data) ➕✏️❌ 📤መኽዘን ሓበሬታ ንዕብየት ድሉውን ተዓጻጻፍን ምግባር (Build efficient, scalable databases) ኣብነታት ብፕሮጀክት

ነዛ ስልጠና ክትወስድዋ ከተማልእዎ ዘለኩም ረቛሒታት:

🙌ናይ ፕሮግራሚን ወይ ዳታቤዝ ተመክሮ ግዴታ ክህልወና ኣይኮነን 💻ኮምፑተር (Windows, macOS, or Linux) 🌐ኢንተርነት 🚀ድሌት ናይ ትምህርትን ነገራት ምድህሳስን! 🤓(ብምርጫ) ህንጥዩነት ዳታ ኣብ ድሕሪ መጋረጃ ብከመይ ከምዝሰርሕ ንምፍላጥ ✍️ኩሎም መሳርያታት ዳውንሎድ ንገብሮምን ንስራሕ ድሎዋት ክኾኑ ነመዓራርዮምን ብነጻን ብምኻኖም -ንኣጠቓቕመኦም ዝምልከት ሓደ ብሓደ ክንመርሓኩም ኢና!

እዛ ስልጠና ንመን'ያ፧

🐣 ነቶም ጀመርቲን ብዛዕባ ናይ SQL ይኹን Database ጭራሽ ተመክሮ ዘይብልኩም 💻 ነቶም ኣብ ዝተፈላለዩ ዓበይትን ናኣሽቱን ትካላት ከም ፉልስታክ ደቨሎፐርስ ኮይንኩም ክትሰርሑ ትደልዩ 📊 ነቶም ኣብ ዳታ ኣናልይቲክስ ማለት ጸብጻባት ሓበሬታ ክትነጥፉ ትደልዩ 🧑‍🎓 ነቶም ኣብ ኩሉ ጽላት ቴክኖሎጂ ክትነጥፉ ትደልዩ እዚ ናይ ማይ-ኤስኪውኤል (MYSQL) ስልጠና'ዚ ነዓኹም'ዩ፡ 🤓 ኣፍቀርቲ ቴክኖሎጂ ዳታ ብድሕሪ መጋረጃ ከመይ ከም ዝሰርሕ ክፈልጡ ዝደልዩ 🌱ዝኾነ ሰብ፡ ድልዱል መሰረት ኣብ MySQLን SQLን ክሃንጽ ንዝደሊ

እዛ ስልጠና ኣጠቓሊላቶም ዘላ:

Lectures : 82 Language: Tigrinya Duration : 13 hours Students : 0 Certificate: Yes Payment: Once Access: on any device Access: Lifetime

ናይዛ ስልጠና ትሕዝቶታት

Section 1: 📘Introduction to the Course (1)

1.1: Master SQL with MySQL From Dat...

- 3 min - Free

Section 2: 🔍Understanding Data & Data... (12)

2.1: What is Data and Data structur...

- 15 min

2.2: Understanding Data & Data ...

2.3: What is Database?

- 14 min

2.4: ምድህሳስ ብዛዕባ Databaseዛት፥ relatio...

2.5: What is really SQL?

- 9 min

2.6: መረዳእታ ብዛዕባ SQL: Language, Quer...

2.7: Entity-Relationship Diagrams: ...

- 12 min

2.8: መረዳእታ ብዛዕባ ER Diagrams & ...

2.9: SQL Data Types Explained: Choo...

- 15 min

2.10: Mastering SQL Data Types: እንታይ...

2.11: Relational Model Basics: Sets,...

- 15 min

2.12: ምርዳእ ብዛዕባ Relational Models: S...

Section 3: ⚙️Getting Started with MySQL (4)

3.1: MySQL Setup Preview: Understan...

- 4 min

3.2: Installing MySQL DBMS from My...

- 9 min

3.3: 🔍 Database vs Table – What...

- 5 min

3.4: Getting Started with MySQL Wor...

- 9 min

Section 4: ✍️Writing Basic SQL Queries (2)

4.1: Creating a Database with SQL +...

- 10 min

4.2: Dropping a Database & Unde...

- 5 min

Section 5: 🔧Data Manipulation (12)

5.1: Creating Tables & Viewing ...

- 10 min

5.2: Renaming or Dropping Tables in...

- 4 min

5.3: Modifying Tables in MySQL: Add...

- 10 min

5.4: Inserting Single & Multipl...

- 12 min

5.5: Understanding NULL & NOT N...

- 10 min

5.6: Using DEFAULT Values & NOT...

- 10 min

5.7: Primary Key & AUTO_INCREME...

- 13 min

5.8: The SELECT Statement in SQL: R...

- 8 min

5.9: Filtering Data with WHERE Clau...

- 6 min

5.10: Using Aliases in SQL: Rename C...

- 3 min

5.11: UPDATE Statement in SQL: Modif...

- 12 min

5.12: DELETE Statement in SQL: Remov...

- 5 min

Section 6: 🎯Data Handling & Query Enh... (11)

6.1: UNIQUE Constraint in SQL: Ensu...

- 12 min

6.2: CHECK Constraint in SQL: Valid...

- 6 min

6.3: Exporting a MySQL Database: Ba...

- 11 min

6.4: Importing a Database in MySQL ...

- 3 min

6.5: Logical Operators in SQL: AND,...

- 12 min

6.6: BETWEEN Operator in SQL: Filte...

- 4 min

6.7: IN Operator in SQL: Match Mult...

- 4 min

6.8: ORDER BY in SQL: Sort Your Dat...

- 8 min

6.9: LIMIT in SQL: Control the Numb...

- 5 min

6.10: LIKE Operator in SQL: Search w...

- 10 min

6.11: DISTINCT in SQL: Eliminate Dup...

- 5 min

Section 7: 🔢Data Analysis & Functions... (6)

7.1: Aggregate Functions in SQL (Pa...

- 12 min

7.2: Aggregate Functions in SQL (Pa...

- 18 min

7.3: GROUP BY in SQL(Part 1): Organ...

- 13 min

7.4: GROUP BY in SQL(Part 2): Organ...

- 13 min

7.5: String Functions in SQL (Part ...

- 12 min

7.6: String Functions in SQL (Part ...

- 15 min

Section 8: 📦Data Types in SQL (5)

8.1: Part 1. CHAR in SQL: Fixed-Len...

- 16 min

8.2: Part 2. VARCHAR in SQL: Flexib...

- 11 min

8.3: DECIMAL, FLOAT & DOUBLE in...

- 17 min

8.4: DATE, TIME, DATETIME & TIM...

- 15 min

8.5: Working with Current Date &...

- 15 min

Section 9: 🏁 Milestone Achievement (1)

9.1: 🎉 Congratulations on Completin...

- 2 min

Section 10: 🔗 Working with Multiple Tables (7)

10.1: From Single Tables to RealWorl...

- 5 min

10.2: The Problem with Single Tables...

- 10 min

10.3: What Is a Foreign Key? Underst...

- 6 min

10.4: Cleaning the Mess: Using Forei...

- 13 min

10.5: Normalization and Creating Dat...

- 16 min

10.6: Updating and Deleting a FOREIG...

- 6 min

10.7: Inserting data to RELATIONAL D...

- 10 min

Section 11: 🧱Database Design & Best Pr... (3)

11.1: SQL vs Database: What’s the Re...

- 14 min

11.2: Student Enrollment Project: De...

- 17 min

11.3: Importing Data from Excel to M...

- 27 min

Section 12: 🔗 Mastering SQL JOINs: Connect... (10)

12.1: How to Combine Tables — Joins ...

- 8 min

12.2: What Are SQL Joins?

- 5 min

12.3: When to Use SQL Joins

- 7 min

12.4: Understanding the World of SQL...

- 5 min

12.5: No JOIN: Starting from Separat...

- 9 min

12.6: INNER JOIN Explained Visually ...

- 16 min

12.7: INNER JOIN Explained Visually ...

- 10 min

12.8: LEFT JOIN for Enriching Your D...

- 14 min

12.9: Right Join — The Mirror of Lef...

- 10 min

12.10: Full Join — Merging All Worlds

- 13 min

Section 13: 🔸 Deep Dive: Advanced Joins in... (8)

13.1: Left Anti Join – Find What...

- 10 min

13.2: Right Anti Join – Reverse the ...

- 6 min

13.3: Full Anti Join – What’s Missin...

- 9 min

13.4: Cross Join – All Possible Comb...

- 9 min

13.5: Choosing the Right Join – Quic...

- 4 min

13.6: Mastering Multi-Table Joins in...

- 13 min

13.7: Challenging SQL Join Project 💪...

- 17 min

13.8: Challenging SQL Join Project 💪...

- 15 min

Course Description

ስልጠና ማይ-ኤስኪውኤል ( MYSQL) ንጀመርቲ

👋 እንቋዕ ደሓን መጻኹም ናብ ስልጠና ማይ-ኤስኪውኤል ንጀመርቲ🎉📚

1️⃣ብዛዕባ ኣብ ኦንላይን ዘሎ ናትና ሓበሬታ ኣበይ ይቕመጥ ሓሲብኩም ትፈልጡ'ዶ፧ ንኣብነት ኣብ ፈስቡክ ዘሎ ፖስትታት፡ ኣብ ዩትዩብ ዘሎ ኣዝዩ ብዙሕ ቪድዮታት ብሓፈሻ ኣብ ኩሉ ሶሻል ሚድያ ዘሎ ትሕዝቶታት ኣበይ ይቕመጥ ሓሲብናሉ ንፈልጥ'ዶ፧

2️⃣ሐራይ እዚ ኣበይ ይቕመጥ'ሲ ዘይንፈልጥ ክንከውን ንኽእል ኢና፡ ናይ ሞባይልና ስእልታትን ቪድዮታትን'ከ፡ ኦው 😊

ናይ ሞባይልና ስእልታትን ቪድዮታትን ኣብ ናይ ሞባይልና ሚሞርይ ከም ዝቕመጥ ንፈልጥ ኢና ሓቀይ 😊

ሐራይ ናይዞም ዝበልናዮም ዓበይቲ ሶሻል ሚድያ ሓበሬታ'ኸ፧

💡መልሱ፡ ንሱ'ውን ኣብ ናቶም ኮምፕዩተር'ዩ ዝቕመጥ፡ ንሕና ከኣ ብመገዲ ኢንተርነት ተጠቂምና ክንከታተሎ ክኢልና ኣለና ማለት'ዩ፡ ዋላ'ውን እዛ ተንብብዋ ዘለኹም ጽሕፍቲ ትኹን እዚ ኣብዛ ስልጠና ዘሎ ኩሉ ዓይነት ቪድዮታት'ውን እንተኾነ ኣብ ናይ Mefth Academy ኮምፕዩተር ማለት ሰርቨር'ዩ ተኸዚኑ ዘሎ፡

እዞም ኩሎም ዝበልናዮም ዓበይቲ ናይ ሶሻል ሚድያ ፕላትፎርምታት ንሓበሬታቶም ከቐምጥዎ እንከለው ናቱ ኣገባብ ኣቐማምጣ መንገዲ ኣለዎ፡ ምኽንያቱ ከምዚ ናይ ሞባይልና ኩሉ ቪድዮታትን ስእልታን ብሓንሳብ ኣብ ጋለሪ ትረኽቦ ክኸውን ስለ ዘይብሉ'ዩ፡ ናይዚ ምኽንያት ከኣ፡ ናይቲ ሓደ ዩትዩበር ቪድዮታት እቲ ሓደ ከይቆጻጸሮ ነናቶም ቪድቶታት ባዕሎም ከም ድላዮም ክቆጻጸርዎ እንተኾይኖም እቲ ቪድዮታቶም ብዝተፈልየ ኣገባብ ከተሓዝ ኣለዎ፡ ነዚ ሓበሬታ'ዚ ዋንነቱን ኣቀማምጡኡን ከነማሓድረሉ ዘኽለና'ምበኣር ሓደ ካብቶም ብዙሓት እዚ ኣብዛ ኮርስ ትመሃርዎ ማይ-ኤስኪውኤል'ዩ (MYSQL)።

ብዘይኩኡ ኣብ ሶሻል ሚድያ ብኢመይልናን ፓስዎርድናን ተመዝጊብና ናትና ኣካውንት ሒዝና ክንነጥፍ እንከለና፡ እቲ ፓስዎርድ ክንጋገ እንከለና ተጋጊኹም ዝብለና ብዓቡኡ እዚ ብመንገዲ ማይ-ኤስኪውኤል (MYSQL)'ን ከሙኡ ዝኣመሰሉ ናይ ሓበሬታ መማሓደርቲ ፕሮግራሚን ላንጎጅስ'ዩ ዝካየድ፡

ማይ-ኤስኪውኤል (MYSQL) ኣብ ዕዳጋ ሓደ ካብቶም ዝበዝሕ ተጠቀምቲ ዘለዎ ኮይኑ ነዚ ኣብ ሰርቨር (ኮምፕዩተር ናይ ዓበይቲ ፕላትፎርምታት) ዝተቐመጠ ሓበሬታ መማሓደሪ ንጥቀመሉ ዓይነት ፕሮግራሚን ላንጎጅ'ዩ፡

እዛ ስልጠና'ዚኣ እምበኣር ንጀመርቲ ኮይና ኣብ ማይ-ኤስኪውኤል (MYSQL) ካብ ዘለዎም ውሑድ ኣፍልጦ ናብ ስፊሕን ብዙሕን ከም ዝምዕብል ብምግባር ኣብ ምሕደራ ሓበሬታ ኣብ ንኣሽቱ ይኹን ኣብ ዓበይት ፕላትፎርምታት ብዙሕ ኣፍልጦ ክድልቡ ትሕግዞም'ያ፡

እዛ ስልጠና'ዚኣ ንጀመርቲ ኮይና ብፍላይ ግን፡

ነቶም ኣማዕበልቲ ወብሳይት ወይ ኣፕሊኬሽን ዝኾንኩም
ንባክ-አንድ ደቨሎፐርስ ዝኾንኩም
ነቶም ኣብ ዝተፈላለዩ ዓበይትን ናኣሽቱን ትካላት ከም ፉልስታክ ደቨሎፐርስ ኮይንኩም ክትሰርሑ ትደልዩ
ነቶም ኣብ ዳታ ኣናልይቲክስ ማለት ጸብጻባት ሓበሬታ ክትነጥፉ ትደልዩ
ነቶም ኣብ ናይ ምቁጽጻርን ምምሕዳርን ሓበሬታ ናይ ትካላት ስራሕ ክትነጥፉ ትደልዩ
ነቶም ኣብ ኩሉ ጽላት ቴክኖሎጂ ክትነጥፉ ትደልዩ እዚ ናይ ማይ-ኤስኪውኤል (MYSQL) ስልጠና'ዚ ነዓኹም'ዩ፡

ኣነ ጀማሪ/ት ኢየ፡ እዛ ስልጠና ክወስዳ ይኽእል'ዶ፧

እወ ክትወስዳ/ድያ ትኽእል/ሊ ኢኻ/ኺ፡
ከም ሓቂ'ውን እዛ ስልጠና ንከምዚ ከማኻ/ኺ ዝበለ ጀማሪ/ት ናይ ማይ-ኤስኪውኤል (MYSQL) ዝኾነ/ነት ሰብ'ያ ተዳልያ።

ስለዚ እወ፡ ጀመርቲ ዝኾነ ኣፍልጦ ናይ ማይ-ኤስኪውኤል (MYSQL) ዘይብሎምን ቁሩብ ጀሚሮም ኣብ ደሓን ዝኾነ ማእከላይ ደረጃ ዝጸንሑ ተማሃሮ ነዛ ስልጠና ክወስድዋ ይኽእሉ'ዮም፡

🎯 ዕላማኹም ክትመልኩ ሓደ ስጉምቲ ቀሪብኩም ኣለኹም።

🙏 ኣብ መርበብ ሓበሬታ ኮርስና ስለ ዝበጻሕኩም የቐንየልና — 🚀 ሰናይ ምጀማር!

Instructor

Biniam Abdenur

Total students: 28

Total Courses: 4

Total Feedback: 9

Total Rating: (4.1)

I am experienced Python developer with a passion for innovative and user-friendly applications. Skilled in Django, Flask, and various Python libraries. Proficient in InDesign and Autodesk Fusion 360 for design and 3D CAD. Constantly seeking opportunities to enhance knowledge and skills. Let's c... Learn more