APKPure Appを使用する
Learn SQL : Video Tutorialsの旧いバージョンをダウンロードすることが可能
初心者のための＃1最高のSQLビデオチュートリアルアプリ
★ Table of Contents ★
1) Introduction
2) Installing MySQL
3) MySQL Workbench and Command Line Client
4) Things You Need To Know About Tables
5) Create, Use and Drop Databases
6) Data-Types in SQL (Part-1)
7) Data-Types in SQL (Part-2)
8) Constraints in SQL
9) Create Table Statement
10) Creating Tables from Other Tables
11) Removing Tables from Database
12) Inserting Data Into Tables
13) Inserting Data Into a Table From Another Table
14) The SELECT Query
15) Arithmetic Operators
16) Comparison Operators
17) Logical Operators (Part-1)
18) Logical Operators (Part-2)
19) The WHERE Clause
20) AND & OR Operators
21) The UPDATE Query
22) The DELETE Query
23) The LIKE Operator and Wildcard Characters
24) The TOP and LIMIT Clauses
25) The ORDER BY Clause
26) The GROUP BY Clause
27) The DISTINCT Keyword
28) Aliasing Through AS Clause
29) SQL JOINS
30) Using GROUP BY Clause with SQL JOINS
31) Left Outer JOIN
32) Right Outer JOIN
33) ABS() Function
34) ROUND() Function
35) DIV() & MOD() Functions
36) Useful Numeric Functions Part-1
37) Useful Numeric Functions Part-2
38) The CONCAT() Function
39) UPPER() and LOWER() Functions
40) The TRIM() Function
41) SUBSTR(), RIGHT() & LEFT() Functions
42) The LENGTH() & INSERT() Functions
43) REPEAT() & REPLACE() Functions
44) REVERSE() & STRCMP() Functions
45) Date & Time Functions (Part-1)
46) Date & Time Functions (Part-2)
47) Date & Time Functions (Part-3)
48) Views in SQL (Part-1)
49) Views in SQL (Part-2)
50) Views in SQL (Part-3)
51) Aggregate Functions (Part-1)
52) Aggregate Functions (Part-2)
53) The TRUNCATE TABLE Command
54) Subqueries in SQL
55) The ALTER TABLE Command
56) Conclusion
-------------------------------------------------------
Disclaimer : Developer claims no credit for any video embedded in this app unless otherwise noted. Videos embedded in this app are copyright to its respectful owners. If there is an video appearing in this app that belongs to you and you do not want it to appear in this app, please contact us via email and it will be promptly removed.
最新バージョン 1.0 の更新情報
Last updated on 2020年08月19日
We are hearing you and constantly improving the App. This time round we have made some minor improvements and bug fixes to enhance your learning experience with us!
We love hearing your reviews and suggestions so please don't stop sending them in!
Love us? Give us 5 stars! Help us make the App even more awesome by sending us your feedback.
翻訳中...
Learn SQL : Video Tutorials
1.0 by SikApps Developers
2020年08月19日