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.