𝘍𝘳𝘦𝘦 𝘐𝘯𝘵𝘦𝘳𝘯𝘦𝘵 𝘝𝘗𝘕
Open in Telegram
𝘍𝘳𝘦𝘦 𝘐𝘯𝘵𝘦𝘳𝘯𝘦𝘵 𝘝𝘱𝘯 Well Come To Our Channel 👉 In this channel you will get 🌍Update News on crypto and Airdrop 🌍 Free servers on supported Networks 🌍Techs and Trick tips For Ads @Spider_Boy_7 Buy ads: https://telega.io/c/internet_366
Show more9 878
Subscribers
+3624 hours
+1117 days
+38830 days
Posts Archive
9 878
❗️ይኸው full Video ✔️
📌በOnline ግዢ (Online Shopping) ለመፈጸም።
📌በተለያዩ Apps እና Websites ላይ ክፍያ ለመክፈል።
📌 Subscription ክፍያዎችን ለመክፈል።
📌 International የኦንላይን ክፍያዎች ለመፈጸም ይጠቅማችሁአል።
📌 Referral Code ይሄን አስገቡ 👉 [
RPYTNW ]
➡️ @internet_366
➡️ @internet_3669 878
❗️ይኸው full Video ✔️
📌በOnline ግዢ (Online Shopping) ለመፈጸም።
📌በተለያዩ Apps እና Websites ላይ ክፍያ ለመክፈል።
📌 Subscription ክፍያዎችን ለመክፈል።
📌 International የኦንላይን ክፍያዎች ለመፈጸም ይጠቅማችሁአል።
📌 Referral Code ይሄን አስገቡ 👉 [
RPYTNW ]
➡️ @internet_366
➡️ @internet_3669 878
import sqlite3
# Connect to database
conn = sqlite3.connect('mydb.db')
cursor = conn.cursor()
# Create table
cursor.execute('''
CREATE TABLE IF NOT EXISTS users (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
email TEXT UNIQUE,
age INTEGER
)
''')
# Insert data
cursor.execute(
"INSERT INTO users (name, email, age) VALUES (?, ?, ?)",
('John', 'john@email.com', 25)
)
# Query data
cursor.execute("SELECT * FROM users")
users = cursor.fetchall()
for user in users:
print(user)
# Commit and close
conn.commit()
conn.close()
——————————————
*🎯 Best Practices*
✅ Use meaningful table/column names (users not u)
✅ Always define PRIMARY KEY for each table
✅ Use NOT NULL for required fields
✅ Add INDEX on columns used in WHERE clauses
✅ Use transactions for multiple operations
✅ Backup regularly
✅ Use parameterized queries (prevent SQL injection)
——————————————
*🧠 Common Mistakes*
❌ Not using indexes (slow queries)
❌ Forgetting WHERE in UPDATE/DELETE (updates ALL rows!)
❌ Storing passwords as plain text (use hashing)
❌ Not normalizing data (redundant information)
❌ Ignoring NULL values in queries
❌ Using SELECT * in production
——————————————
*📚 Popular SQL Databases*
• *PostgreSQL* → Advanced, open-source, feature-rich
• *MySQL* → Popular, fast, easy to start
• *SQLite* → Lightweight, file-based, mobile
• *Microsoft SQL* → Enterprise, powerful, paid
• *Oracle* → Large enterprise, expensive
• *MariaDB* → MySQL fork, open-source
——————————————
*🔍 Quick SQL Cheatsheet*
Show all databases: SHOW DATABASES;
Use a database: USE mydb;
Show all tables: SHOW TABLES;
Describe table: DESCRIBE users;
Drop table: DROP TABLE users;
Add column: ALTER TABLE users ADD COLUMN phone VARCHAR(20);
Delete column: ALTER TABLE users DROP COLUMN phone;
——————————————
*🎓 Summary*
DATABASE → Contains TABLES
TABLE → Has COLUMNS (fields) and ROWS (records)
SQL → Language to manage data
Primary Key → Unique ID for each row
Foreign Key → Links tables together
JOIN → Combines data from multiple tables
Show reaction to this kind of post in future9 878
*🗄️ SQL Databases - The Complete Beginner's Guide*
*🤔 What is a SQL Database?*
SQL = Structured Query Language
It's like a digital filing cabinet:
• Data is stored in TABLES (like spreadsheets)
• Each table has ROWS (records) and COLUMNS (fields)
• You use SQL queries to add, read, update, or delete data
——————————————
*🏗️ Database Structure*
DATABASE
└── TABLE 1 (Users)
├── Columns: id, name, email, age
└── Rows: (1, "John", "john@email.com", 25)
(2, "Sarah", "sarah@email.com", 30)
└── TABLE 2 (Orders)
├── Columns: order_id, user_id, product, price
└── Rows: (101, 1, "Laptop", 999)
(102, 2, "Phone", 599)
——————————————
*📊 Common Data Types*
INT → Whole numbers (age, quantity)
VARCHAR(n) → Text with max length (name, email)
TEXT → Long text (description, comments)
DATE → Date values (birthday, created_at)
BOOLEAN → True/False (is_active, verified)
DECIMAL(10,2) → Numbers with decimals (price, salary)
BIGINT → Large whole numbers (user_id, order_id)
TIMESTAMP → Date + Time (created_at, updated_at)
——————————————
*📝 SQL Commands (CRUD Operations)*
*🔍 READ (SELECT)*
SELECT * FROM users;
SELECT name, email FROM users WHERE age > 18;
SELECT * FROM users ORDER BY name ASC;
*➕ CREATE (INSERT)*
INSERT INTO users (name, email, age)
VALUES ('John', 'john@email.com', 25);
*✏️ UPDATE (UPDATE)*
UPDATE users SET age = 26 WHERE name = 'John';
*❌ DELETE (DELETE)*
DELETE FROM users WHERE name = 'John';
——————————————
*🔗 Table Relationships*
*1️⃣ One-to-One (1:1)*
User ↔ Passport (one user has one passport)
*2️⃣ One-to-Many (1:N)*
User ↔ Orders (one user can have many orders)
users.id = orders.user_id
*3️⃣ Many-to-Many (N:N)*
Students ↔ Courses (many students can take many courses)
Uses a JOIN TABLE (enrollments)
——————————————
*🏗️ Creating Tables Example*
CREATE TABLE users (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(100) NOT NULL,
email VARCHAR(255) UNIQUE NOT NULL,
age INT CHECK (age >= 18),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
CREATE TABLE orders (
order_id INT PRIMARY KEY AUTO_INCREMENT,
user_id INT,
product VARCHAR(255) NOT NULL,
price DECIMAL(10,2),
order_date DATE DEFAULT CURRENT_DATE,
FOREIGN KEY (user_id) REFERENCES users(id)
);
——————————————
*🔑 Important Keys*
PRIMARY KEY → Unique identifier for each row (id)
FOREIGN KEY → Links to another table's primary key (user_id)
UNIQUE KEY → Ensures all values are different (email)
INDEX → Speeds up searches (index on name)
——————————————
*📊 Real Example - E-Commerce Database*
*Tables:*
1. customers (id, name, email, phone)
2. products (id, name, price, stock)
3. orders (id, customer_id, order_date)
4. order_items (id, order_id, product_id, quantity)
*Query to get customer orders:*
SELECT c.name, p.name AS product, oi.quantity, p.price
FROM customers c
JOIN orders o ON c.id = o.customer_id
JOIN order_items oi ON o.id = oi.order_id
JOIN products p ON oi.product_id = p.id
WHERE c.id = 1;
——————————————
*⚡ Advanced SQL Concepts*
*WHERE Filters*
SELECT * FROM users WHERE age BETWEEN 20 AND 30;
SELECT * FROM users WHERE name LIKE 'J%'; -- starts with J
*GROUP BY (Aggregations)*
SELECT country, COUNT(*) FROM users GROUP BY country;
SELECT AVG(age) FROM users;
*JOIN Types*
• INNER JOIN → Only matching records
• LEFT JOIN → All from left table + matches
• RIGHT JOIN → All from right table + matches
• FULL JOIN → All records from both
——————————————
*🛠️ Common SQL Functions*
COUNT() → Count rows → SELECT COUNT(*) FROM users;
SUM() → Add values → SELECT SUM(price) FROM orders;
AVG() → Average → SELECT AVG(age) FROM users;
MAX() → Maximum value → SELECT MAX(price) FROM products;
MIN() → Minimum value → SELECT MIN(price) FROM products;
NOW() → Current time → INSERT INTO logs (timestamp) VALUES (NOW());
——————————————
*💻 Python Example with SQLite*9 878
የቴሌግራም ጥቅል ትገዙ እና ለሁሉም SOCIAL MEDIA 👉𝘈𝘱𝘱 👉 𝗛𝗧𝗧𝗣 𝗜𝗡𝗝𝗘𝗖𝗧𝗢𝗥 👉𝘌𝘹𝘱𝘪𝘳𝘦 𝘥𝘢𝘵e = 𝟕 𝐃𝐀𝐘
𝗥𝗲𝗮𝗰𝘁 አድርጋቺሁ እለፉ ቤተሰብ
9 878
Telegram package ገዝታችሁ
በዚህ ተጠቀሙ🔥
APP : DARK TUNNEL 🔥
Speed ቦምብ በሉት 💣💣
React ያንሳል እንዴ ቤተሰብ እንዲ እያለፋን 🤧
9 878
Telegram package ገዝታችሁ
በዚህ ተጠቀሙ🔥
APP : DARK TUNNEL 🔥
Speed ቦምብ በሉት 😁
React ያንሳል እንዴ ቤተሰብ እንዲ እያለፋን 🤧
9 878
Repost from .
Buying tinder accounts 🌐
Male age 27+
Female age 23+
2014-2025
Good rates for 2025 7-12
CHECK FIRST: @Tinder_checker3bot
Bulk sellers = top priority. Quick payment.
DM here @codeofsaladin
9 878
❖ 𝗫𝗥𝗔𝗬 𝗧𝗚 𝗣𝗔𝗖𝗞𝗔𝗚𝗘 ❖ 𝗛𝗧𝗧𝗣 𝗜𝗡𝗝𝗘𝗖𝗧𝗢𝗥 ❖ 𝗘𝗫𝗣 𝗗𝗔𝗧𝗘 𝗦𝗘𝗣𝗧 𝟲 ❖ 𝗥𝗘𝗔𝗖𝗧 𝗙𝗢𝗥 𝗠𝗢𝗥𝗘 🔥
ምናልባት አንዱ 𝐅𝐈𝐋𝐄 እምቢ ቢል ሌላኛውን ቀይራችሁ መጠቀም አትርሱ ቤተሰብ 😐
9 878
4 Rᴇᴘᴏʀᴛs ᴀʀᴇ Bʟᴏᴄᴋᴇᴅ ʙʏ @teleprotectorbot
648 Cʜᴀɴɴᴇʟs ᴀʀᴇ Sᴀᴠᴇᴅ Fʀᴏᴍ Rᴇᴘᴏʀᴛs ɪɴ Lᴀsᴛ 24 Hᴏᴜʀs
9 878
Telegram package አዲስ HOST ተገኝቷል በSSH እና XRAY በዚህኛው ለሁላችሁም ይሰራላችኋል👍
REACT አድርጉ እና ልልቀቀው እስኪ🤗
9 878
Telegram package አዲስ HOST ተገኝቷል በSSH እና XRAY በዚህኛው ለሁላችሁም ይሰራላችኋል👍
REACT አድርጉ እና ልልቀቀው እስኪ🤗
9 878
Family የ4$ ስራ ወይም የ700ብር Post አድርጌዋለሁ ስሩት ለባአላችን እንሸቅል 🤩
በነገርኳቹሁ መሰረት ይሄው ላሰራቹሁ ነው ቶሎ ጀምሩት 👇
https://t.me/kyc_work_Zone
9 878
Transform Your Photos Instantly 🔥 Are you ready to elevate your selfies? 🚀 Unleash the magic of Mimika.AI - where your ordinary photos become extraordinary in just seconds!
Imagine creating stunning portraits, personalized avatars, and engaging videos without any editing skills! 👩🎨✨ With a plethora of styles to choose from, you can achieve eye-catching results perfect for every social media platform. 📸
- 🎨 Unique Styles: From cinematic scenes to fantasy characters!
- ⚡ Instant Results: Transform your images in seconds!
- 🌟 Creative Expression: Stand out like never before!
Join thousands of satisfied users and discover your creative side today! 👉 Get Started Now
#ad 📢 InsideAd
9 878
Repost from .
🆕 ፈጣን የትርጉም እና የገቢ ማስገኛ ቦት!😀
ጽሑፎችን ከ100 በላይ ቋንቋዎች መተርጎም፣ ከፎቶ ላይ ጽሑፍ ማውጣት (OCR) እና ጓደኞችን በመጋበዝ ገንዘብ መስራት ይፈልጋሉ?
ይህን ሁለገብ ቦት አሁኑኑ ይጠቀሙ! 😀
💡 ዋና ዋና አገልግሎቶች:
• 🌐 ፈጣን የጽሑፍ ትርጉም — ከ100 በላይ አለም አቀፍ እና የሀገር ውስጥ ቋንቋዎች (አማርኛ፣ ኦሮምኛ፣ ትግርኛ፣ ሶማሊኛ፣ እንግሊዝኛ...)
• 📌 ምስል አንባቢ (OCR) — ከማንኛውም ፎቶ ላይ ጽሑፍ በቀላሉ ማውጣት
• 💎 ገቢ ማግኘት — ጓደኞችን በመጋበዝ በእያንዳንዱ ሰው 1 ብር ያግኙ
• 💵 ፈጣን ክፍያ — በቴሌብር (Telebirr) አስተማማኝ እና ፈጣን ወጪ አደራረግ
🎯 አሁኑኑ ቦቱን አስጀምረው መስራት ይጀምሩ:
👉 @Amharic_Translate_Robot
