In this tutorial we'll see how we can chop off strings and use only parts of them using the SUBSTR(), RIGHT() and LEFT() Functions.

1. Introduction to SQL
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

A collection of 56 great (not bad, despite the name) tutorials on how to get started with SQL (Structured Query Language), covering basic INSERT, SELECT, UPDATE, and DELETE statements, and more advanced concepts such as string functions, date & time, ALTER TABLE, and others.