SQL
المدرس
eduadmin
- الوصف
- المنهاج
- المراجعات
-
11 - intro ( SQL AND MYSQL )
-
22 - Select (SQL _ MYSQL)
-
33 OrderBy AND Limit
-
44 - WHERE NOT - AND - OR (SQL - MYSQL)
-
55 - insert
-
66 - update ( SQL - MYSQL )
-
77 - Select distinct (SQL - MYSQL)
-
88 - DELETE (SQL - MYSQL )
-
99 - Min & Max & Count & Avg & Sum
-
1010 - Like
-
1111 - BETWEEN & In
-
1212 - Aliases
-
1313 - Group By - HAVING
-
1414 - constraint ( UNIQUE - Not Null )
-
1515 - constraint ( PRIMARY KEY vs UNIQUE )
-
1616 - constraint ( DEFAULT )
-
1717 - Relationships
-
1818 - one to many ( foreign key constraint)
-
1919 - one to one ( foreign key constraint)
-
2020 - many to many
-
2121 - join ( INNERJOIN - LEFTJOIN - RIGHTJOIN )
-
2222 - WHERE EXISTS
-
2323 - any
-
2424 - UNION AND UNION ALL
-
2525 - IFNULL & COALESCE
-
2626 - datatype part 1
-
2727 - datatype part 2
-
2828 - datatype part 3
-
2929 - create And drop ( Database )
-
3030 - create And drop ( table )
-
3131 - ALTER TABLE
-
3232 - view (MYSQL - SQL)
-
33the End
Please, login to leave a review