Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Introduction to SQL and MySQL
Introduction
1. Introduction (1:32)
Environment
2. Installing MySQL server (6:28)
Databases
3. Non-relational database systems (2:51)
4. Relational database systems (4:51)
5. The Structured Query Language (SQL) (3:43)
6. Data structure behind SQL - B-trees (5:05)
7. Variants of SQL (3:18)
Table Manipulation
8. Data types (5:43)
9. Creating a table (7:45)
10. Inserting into a table (3:05)
11. Delete row from a table (4:52)
12. Updating a row (2:46)
13. Changing table structure (3:14)
14. Drop tables (2:09)
Basic SQL
16. SQL dump - the city and country tables (3:30)
17. SELECT (2:41)
18. WHERE (2:28)
19. IN (2:12)
20. BETWEEN (3:28)
21. NOT - negation in SQL (2:07)
22. Logical operators (4:03)
23. Wildcards (3:27)
24. Functions (5:51)
25. ORDER BY (4:40)
26. GROUP BY example I (3:05)
27. GROUP BY example II (2:33)
28. HAVING (3:02)
Joining Multiple Tables
30. Configuring the database tables - PERSON and UNIVERSITY (2:55)
31. Inner join introduction (4:46)
32. Inner join example (3:55)
33. Left join introduction (3:05)
34. Left join example (2:15)
35. Right join introduction (1:36)
36. Right join example (1:28)
37. JOIN example - number of cities (5:11)
38. JOIN example - total population by continent (3:23)
39. Online SQL console (1:03)
40. JOIN example - customers and orders (2:53)
41. JOIN example - number of orders by customers (3:18)
42. JOIN example - number of orders by country (2:05)
Advanced SQL - Subqueries
44. Subqueries introduction (6:36)
45. Non-correlated scalar subquery (2:05)
46. Non-correlated multiple-row subquery (2:45)
47. Correlated subquery (2:50)
48. Subqueries and joins (1:52)
49. Transforming subquery into join (3:04)
Advanced SQL - Transactions
51. Transactions introduction - locking (9:25)
52. Transactions introduction - transactions (3:37)
53. ACID principles (3:39)
54. Transaction example - COMMIT (4:28)
55. Transaction example - ROLLBACK (2:32)
56. Transaction example - SAVEPOINT (5:30)
Advanced SQL - Views
58. Views introduction (4:54)
59. Views example - initialize database (1:38)
60. Views example - create views (3:57)
61. Views example - update views (2:59)
62. Views example - dropping views (0:57)
Advanced SQL - Indexes And Constraints
64. Indexes introduction (6:32)
65. Indexes example (4:37)
66. Constraints introduction (1:23)
67. Primary keys (3:08)
68. Unique constraints (2:55)
42. JOIN example - number of orders by country
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock