آموزش SQLite Essentials: از مبتدی تا متخصص - آخرین آپدیت

مقدمه Introduction

• SQLITE CLASS 2: دانلود و نصب مرورگر DB SQLITE CLASS 2 : DOWNLOAD AND INSTALL DB BROWSER

• SQLITE CLASS 3: ایجاد جدول SQLITE CLASS 3 : CREATE TABLE

• SQLITE CLASS 4: مقادیر را درج کنید SQLITE CLASS 4 : INSERT VALUES

• SQLITE CLASS 5: SELECT COMMAND SQLITE CLASS 5 : SELECT COMMAND

• SQLITE کلاس 6: فرمان متمایز SQLITE CLASS 6 : DISTINCT COMMAND

• SQLITE CLASS 7: WHERE CLAUSE SQLITE CLASS 7 : WHERE CLAUSE

• SQLITE CLASS 8: AND OR NOT Command SQLITE CLASS 8 : AND OR NOT COMMAND

• SQLITE CLASS 9: LIMIT Command SQLITE CLASS 9 : LIMIT COMMAND

• SQLITE CLASS 10: بین و نه بین دستور SQLITE CLASS 10 : BETWEEN AND NOT BETWEEN COMMAND

• SQLITE CLASS 11: IN و NOT IN COMMAND SQLITE CLASS 11 : IN AND NOT IN COMMAND

• SQLITE CLASS 12: MIN AND MAX SQLITE CLASS 12 : MIN AND MAX

• SQLITE CLASS 13: COUNT، SUM، AVG Commands SQLITE CLASS 13 : COUNT , SUM , AVG COMMANDS

• SQLITE CLASS 14: AS Command SQLITE CLASS 14 : AS COMMAND

• SQLITE CLASS 15: UNION Command SQLITE CLASS 15 : UNION COMMAND

• SQLITE کلاس 16: سفارش با دستور SQLITE CLASS 16 : ORDER BY COMMAND

• SQLITE کلاس 17: گروه بر اساس فرمان SQLITE CLASS 17 : GROUP BY COMMAND

• SQLITE CLASS 18: داشتن فرمان SQLITE CLASS 18 : HAVING COMMAND

• SQLITE CLASS 19: مانند فرمان SQLITE CLASS 19 : LIKE COMMAND

• SQLITE CLASS 20: JOIN داخلی SQLITE CLASS 20 : INNER JOIN

• SQLITE CLASS 21: CROSS JOIN SQLITE CLASS 21 : CROSS JOIN

• SQLITE CLASS 22: به روز رسانی فرمان SQLITE CLASS 22 : UPDATE COMMAND

• SQLITE CLASS 23: ALTER Command SQLITE CLASS 23 : ALTER COMMAND

• SQLITE CLASS 24: SAVEPOINT، ROLLBACK، COMMIT SQLITE CLASS 24 : SAVEPOINT , ROLLBACK , COMMIT

• SQLITE CLASS 25: دستور را رها و حذف کنید SQLITE CLASS 25 : DROP AND DELETE COMMAND