#1 Best SQL Video Tutorials App For Beginners
★ 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.