|
Please note that this page does not hosts or makes available any of the listed filenames. You
cannot download any of those files from here.
|
| [CourseClub.Me].url |
122B |
| [CourseClub.Me].url |
122B |
| [CourseClub.Me].url |
122B |
| [CourseClub.Me].url |
122B |
| [CourseClub.Me].url |
122B |
| [GigaCourse.Com].url |
49B |
| [GigaCourse.Com].url |
49B |
| [GigaCourse.Com].url |
49B |
| [GigaCourse.Com].url |
49B |
| [GigaCourse.Com].url |
49B |
| 1.1 sample_data.sql |
865.43KB |
| 1. Add data to the table.mp4 |
31.95MB |
| 1. Add data to the table.srt |
8.83KB |
| 1. Case study 1 Database construction.mp4 |
59.75MB |
| 1. Case study 1 Database construction.srt |
12.71KB |
| 1. Creating a Database.mp4 |
12.46MB |
| 1. Creating a Database.srt |
3.46KB |
| 1. Database Basics.mp4 |
76.57MB |
| 1. Database Basics.srt |
17.81KB |
| 1. Database import (restore)(1).mp4 |
53.67MB |
| 1. Database import (restore)(1).srt |
9.94KB |
| 1. Equal formula.mp4 |
24.48MB |
| 1. Equal formula.srt |
5.33KB |
| 1. How to use subqueries.mp4 |
21.62MB |
| 1. How to use subqueries.srt |
5.28KB |
| 1. Introduction.mp4 |
29.63MB |
| 1. Introduction.srt |
6.81KB |
| 1. Overview of JOIN UNION.mp4 |
113.89MB |
| 1. Overview of JOIN UNION.srt |
22.10KB |
| 1. Overview of stored routines.mp4 |
32.75MB |
| 1. Overview of stored routines.srt |
6.96KB |
| 1. Primary key setting (1).mp4 |
33.65MB |
| 1. Primary key setting (1).srt |
12.78KB |
| 1. SQL Coding Tips.mp4 |
17.76MB |
| 1. SQL Coding Tips.srt |
6.55KB |
| 1. Utilization of basic calculation formulas.mp4 |
33.15MB |
| 1. Utilization of basic calculation formulas.srt |
9.28KB |
| 1. Utilization of SELECT.mp4 |
36.11MB |
| 1. Utilization of SELECT.srt |
6.67KB |
| 1. Utilization of VIEW.mp4 |
21.58MB |
| 1. Utilization of VIEW.srt |
4.58KB |
| 10. CROSS JOIN.mp4 |
23.10MB |
| 10. CROSS JOIN.srt |
4.32KB |
| 10. Functions related to strings (2).mp4 |
14.57MB |
| 10. Functions related to strings (2).srt |
3.93KB |
| 10. SQL query command for previous lecture.html |
774B |
| 10. SQL query command for previous lecture.html |
600B |
| 10. SQL query from the previous lecture.html |
98B |
| 10. Subquery in HAVING clause.mp4 |
9.43MB |
| 10. Subquery in HAVING clause.srt |
2.79KB |
| 10. Utilization of Rollback.mp4 |
39.42MB |
| 10. Utilization of Rollback.srt |
9.37KB |
| 11. How to delete data.mp4 |
18.30MB |
| 11. How to delete data.srt |
4.02KB |
| 11. Logical formula by IN.mp4 |
11.99MB |
| 11. Logical formula by IN.srt |
3.12KB |
| 11. SQL query command for previous lecture.html |
651B |
| 11. SQL query command for previous lecture.html |
960B |
| 11. SQL query command for previous lecture.html |
399B |
| 11. SQL query from the previous lecture.html |
295B |
| 11. Utilization of LIMIT.mp4 |
16.26MB |
| 11. Utilization of LIMIT.srt |
3.60KB |
| 12. Add INDEX.mp4 |
8.57MB |
| 12. Add INDEX.srt |
3.07KB |
| 12. ANY SOME ALL formula.mp4 |
19.09MB |
| 12. ANY SOME ALL formula.srt |
4.63KB |
| 12. Functions related to strings (3).mp4 |
16.10MB |
| 12. Functions related to strings (3).srt |
3.75KB |
| 12. SELF JOIN.mp4 |
13.78MB |
| 12. SELF JOIN.srt |
3.92KB |
| 12. SQL query command for previous lecture.html |
1.58KB |
| 12. SQL query command for previous lecture.html |
790B |
| 12. SQL query from the previous lecture.html |
162B |
| 13. Case Study Exercise 1 Problem.mp4 |
2.05MB |
| 13. Case Study Exercise 1 Problem.srt |
850B |
| 13. Difference between DROP TRUNCATE DELETE.mp4 |
9.85MB |
| 13. Difference between DROP TRUNCATE DELETE.srt |
3.61KB |
| 13. SQL query command for previous lecture.html |
620B |
| 13. SQL query command for previous lecture.html |
398B |
| 13. SQL query command for previous lecture.html |
1.17KB |
| 13. SQL query from the previous lecture.html |
63B |
| 13. Utilization of LIKE.mp4 |
18.57MB |
| 13. Utilization of LIKE.srt |
4.77KB |
| 14. 3 or more tables To JOIN.mp4 |
19.32MB |
| 14. 3 or more tables To JOIN.srt |
4.36KB |
| 14. Case Study Exercise 1 Explanation.mp4 |
11.39MB |
| 14. Case Study Exercise 1 Explanation.srt |
1.53KB |
| 14. Case Study Exercise 1 Problem.mp4 |
1.99MB |
| 14. Case Study Exercise 1 Problem.srt |
780B |
| 14. Date and time functions (1).mp4 |
20.42MB |
| 14. Date and time functions (1).srt |
721B |
| 14. Delete table data_issue.mp4 |
7.19MB |
| 14. Delete table data_issue.srt |
1.71KB |
| 14. Null value setting.mp4 |
39.78MB |
| 14. Null value setting.srt |
8.87KB |
| 14. SQL query command for previous lecture.html |
881B |
| 15. Case Study Exercise 1 Explanation.mp4 |
28.25MB |
| 15. Case Study Exercise 1 Explanation.srt |
3.91KB |
| 15. SQL query command for previous lecture.html |
304B |
| 15. SQL query command for previous lecture.html |
509B |
| 15. SQL query command for previous lecture.html |
2.18KB |
| 15. SQL query from the previous lecture.html |
880B |
| 15. Table Data Deletion Assignment Explanation.mp4 |
25.03MB |
| 15. Table Data Deletion Assignment Explanation.srt |
3.02KB |
| 15. Utilization of GROUP BY.mp4 |
14.02MB |
| 15. Utilization of GROUP BY.srt |
2.79KB |
| 16. Case study exercises2 Problem..mp4 |
2.25MB |
| 16. Case study exercises2 Problem..srt |
677B |
| 16. Date and time functions (2).mp4 |
18.57MB |
| 16. Setting the default value.mp4 |
14.04MB |
| 16. Setting the default value.srt |
3.72KB |
| 16. SQL query command for previous lecture.html |
1.25KB |
| 16. SQL query command for previous lecture.html |
286B |
| 16. SQL query from the previous lecture.html |
447B |
| 16. UNION.mp4 |
15.51MB |
| 16. UNION.srt |
3.76KB |
| 17. Case Study Exercise 2 Explanation.mp4 |
15.49MB |
| 17. Case Study Exercise 2 Explanation.srt |
2.34KB |
| 17. Case Study Exercise 2 Problem.mp4 |
2.32MB |
| 17. Case Study Exercise 2 Problem.srt |
584B |
| 17. SQL query command for previous lecture.html |
633B |
| 17. SQL query command for previous lecture.html |
2.72KB |
| 17. SQL query from the previous lecture.html |
406B |
| 17. Utilization of HAVING.mp4 |
8.20MB |
| 17. Utilization of HAVING.srt |
2.51KB |
| 18. Case Study Exercise 1 Problem.mp4 |
3.65MB |
| 18. Case Study Exercise 1 Problem.srt |
1.19KB |
| 18. Case Study Exercise 2 Explanation.mp4 |
26.62MB |
| 18. Case Study Exercise 2 Explanation.srt |
3.81KB |
| 18. Other functions.mp4 |
27.98MB |
| 18. Other functions.srt |
1.78KB |
| 18. SQL query command for previous lecture.html |
177B |
| 18. SQL query command for previous lecture.html |
930B |
| 19. Case Study Exercise 1 Explanation.mp4 |
26.37MB |
| 19. Case Study Exercise 1 Explanation.srt |
5.06KB |
| 19. Case study exercises3 Problem..mp4 |
1.22MB |
| 19. Case study exercises3 Problem..srt |
498B |
| 19. Case study using SELECT statement1.mp4 |
3.27MB |
| 19. Case study using SELECT statement1.srt |
1.03KB |
| 19. SQL query command for previous lecture.html |
502B |
| 19. SQL query command for previous lecture.html |
889B |
| 2. Database import (restore) (2).mp4 |
10.92MB |
| 2. Database import (restore) (2).srt |
2.50KB |
| 2. Download the text.html |
204B |
| 2. INNER JOIN(1).mp4 |
22.17MB |
| 2. INNER JOIN(1).srt |
4.48KB |
| 2. In the database Data type.mp4 |
46.50MB |
| 2. In the database Data type.srt |
12.25KB |
| 2. Organize long code.mp4 |
6.91MB |
| 2. Organize long code.srt |
2.78KB |
| 2. Primary key setting (2).mp4 |
42.72MB |
| 2. Primary key setting (2).srt |
9.16KB |
| 2. Relational Database Overview.mp4 |
19.92MB |
| 2. Relational Database Overview.srt |
5.40KB |
| 2. SQL query command for previous lecture.html |
209B |
| 2. SQL query command for previous lecture.html |
802B |
| 2. SQL query command for previous lecture.html |
949B |
| 2. SQL query command for previous lecture.html |
269B |
| 2. SQL query from the previous lecture.html |
659B |
| 2. Subquery in FROM clause.mp4 |
28.74MB |
| 2. Subquery in FROM clause.srt |
7.26KB |
| 2. Utilization of stored procedures.mp4 |
21.74MB |
| 2. Utilization of stored procedures.srt |
6.60KB |
| 2. 【Answer1】 Creating a database of personnel information.mp4 |
3.14MB |
| 2. 【Answer1】 Creating a database of personnel information.srt |
1003B |
| 20. Case Study Exercise 1 Problem.mp4 |
4.86MB |
| 20. Case Study Exercise 1 Problem.srt |
1.42KB |
| 20. Case Study Exercise 3 Explanation.mp4 |
8.58MB |
| 20. Case Study Exercise 3 Explanation.srt |
1.57KB |
| 20. Case Study Exercise 3 Problem.mp4 |
1.82MB |
| 20. Case Study Exercise 3 Problem.srt |
595B |
| 20. Case study using SELECT Explanation1.mp4 |
8.96MB |
| 20. Case study using SELECT Explanation1.srt |
1.84KB |
| 20. SQL query command for previous lecture.html |
1.04KB |
| 21. Case Study Exercise 1 Explanation.mp4 |
9.55MB |
| 21. Case Study Exercise 1 Explanation.srt |
2.08KB |
| 21. Case Study Exercise 2 Problem.mp4 |
2.51MB |
| 21. Case Study Exercise 2 Problem.srt |
709B |
| 21. Case Study Exercise 3 Explanation.mp4 |
17.17MB |
| 21. Case Study Exercise 3 Explanation.srt |
2.05KB |
| 21. SQL query command for previous lecture.html |
426B |
| 21. SQL query command for previous lecture.html |
213B |
| 22. Case Study Exercise 2 Explanation.mp4 |
18.41MB |
| 22. Case Study Exercise 2 Explanation.srt |
3.35KB |
| 22. Case study exercises4 Problem..mp4 |
1.57MB |
| 22. Case study exercises4 Problem..srt |
484B |
| 22. Case study using SELECT statement2.mp4 |
1.11MB |
| 22. Case study using SELECT statement2.srt |
525B |
| 22. SQL query command for previous lecture.html |
856B |
| 22. SQL query command for previous lecture.html |
895B |
| 23. Case Study Exercise 2 Problem.mp4 |
1.70MB |
| 23. Case Study Exercise 2 Problem.srt |
565B |
| 23. Case Study Exercise 4 Explanation.mp4 |
4.66MB |
| 23. Case Study Exercise 4 Explanation.srt |
927B |
| 23. Case Study Exercise 4 Problem.mp4 |
20.46MB |
| 23. Case Study Exercise 4 Problem.srt |
2.27KB |
| 23. Case study using SELECT Explanation2.mp4 |
8.03MB |
| 23. Case study using SELECT Explanation2.srt |
1.68KB |
| 23. SQL query command for previous lecture.html |
2.08KB |
| 24. Case Study Exercise 2 Explanation.mp4 |
2.66MB |
| 24. Case Study Exercise 2 Explanation.srt |
778B |
| 24. Case Study Exercise 3 Problem.mp4 |
1.14MB |
| 24. Case Study Exercise 3 Problem.srt |
446B |
| 24. Case Study Exercise 4 Explanation.mp4 |
30.36MB |
| 24. Case Study Exercise 4 Explanation.srt |
4.88KB |
| 24. SQL query command for previous lecture.html |
205B |
| 24. SQL query command for previous lecture.html |
227B |
| 25. Case Study Exercise 3 Explanation.mp4 |
10.88MB |
| 25. Case Study Exercise 3 Explanation.srt |
1.79KB |
| 25. Case study exercises5 Problem..mp4 |
1.24MB |
| 25. Case study exercises5 Problem..srt |
496B |
| 25. Case study using SELECT statement3.mp4 |
1.36MB |
| 25. Case study using SELECT statement3.srt |
509B |
| 25. SQL query command for previous lecture.html |
351B |
| 25. SQL query command for previous lecture.html |
3.08KB |
| 26. Case Study Exercise 3 Problem.mp4 |
2.06MB |
| 26. Case Study Exercise 3 Problem.srt |
682B |
| 26. Case Study Exercise 5 Explanation.mp4 |
6.70MB |
| 26. Case Study Exercise 5 Explanation.srt |
1.53KB |
| 26. Case study using SELECT Explanation3.mp4 |
8.74MB |
| 26. Case study using SELECT Explanation3.srt |
1.21KB |
| 26. SQL query command for previous lecture.html |
2.33KB |
| 27. Case Study Exercise 3 Explanation.mp4 |
10.73MB |
| 27. Case Study Exercise 3 Explanation.srt |
2.60KB |
| 27. Case Study Exercise 4 Problem.mp4 |
2.21MB |
| 27. Case Study Exercise 4 Problem.srt |
666B |
| 27. SQL query command for previous lecture.html |
382B |
| 27. SQL query command for previous lecture.html |
366B |
| 28. Case Study Exercise 4 Explanation.mp4 |
16.06MB |
| 28. Case Study Exercise 4 Explanation.srt |
2.72KB |
| 28. Case study using SELECT statement4.mp4 |
2.93MB |
| 28. Case study using SELECT statement4.srt |
756B |
| 28. SQL query command for previous lecture.html |
877B |
| 29. Case Study Exercise 4 Problem.mp4 |
919.45KB |
| 29. Case Study Exercise 4 Problem.srt |
396B |
| 29. Case study using SELECT Explanation4.mp4 |
14.97MB |
| 29. Case study using SELECT Explanation4.srt |
1.95KB |
| 29. SQL query command for previous lecture.html |
1.01KB |
| 3. Add table.mp4 |
11.76MB |
| 3. Add table.srt |
5.10KB |
| 3. Aggregate function (1).mp4 |
14.71MB |
| 3. Aggregate function (1).srt |
4.14KB |
| 3. Data addition task.mp4 |
2.72MB |
| 3. Data addition task.srt |
1.57KB |
| 3. Database export (backup).mp4 |
22.32MB |
| 3. Database export (backup).srt |
4.53KB |
| 3. Logical formula by inequality sign.mp4 |
13.53MB |
| 3. Logical formula by inequality sign.srt |
3.36KB |
| 3. MySQL Overview.mp4 |
21.39MB |
| 3. MySQL Overview.srt |
5.15KB |
| 3. SQL query command for previous lecture.html |
2.62KB |
| 3. SQL query command for previous lecture.html |
1.75KB |
| 3. SQL query command for previous lecture.html |
1009B |
| 3. SQL query from the previous lecture.html |
121B |
| 3. SQL query from the previous lecture.html |
1.46KB |
| 3. Utilization of WHERE.mp4 |
12.91MB |
| 3. Utilization of WHERE.srt |
2.94KB |
| 3. Your First MySQL DB and SQL Experience.mp4 |
18.34MB |
| 3. Your First MySQL DB and SQL Experience.srt |
4.82KB |
| 3. 【Answer2】Creating the Employee Information Table.mp4 |
14.84MB |
| 3. 【Answer2】Creating the Employee Information Table.srt |
2.76KB |
| 30. Case Study Exercise 4 Explanation.mp4 |
3.87MB |
| 30. Case Study Exercise 4 Explanation.srt |
939B |
| 30. Case Study Exercise 5 Problem.mp4 |
3.07MB |
| 30. Case Study Exercise 5 Problem.srt |
462B |
| 30. SQL query command for previous lecture.html |
542B |
| 31. Case Study Exercise 5 Explanation.mp4 |
21.69MB |
| 31. Case Study Exercise 5 Explanation.srt |
3.16KB |
| 31. Case study using SELECT statement5.mp4 |
1.91MB |
| 31. Case study using SELECT statement5.srt |
618B |
| 31. SQL query command for previous lecture.html |
365B |
| 32. Case Study Exercise 5 Problem.mp4 |
1.56MB |
| 32. Case Study Exercise 5 Problem.srt |
477B |
| 32. Case study using SELECT Explanation5.mp4 |
9.47MB |
| 32. Case study using SELECT Explanation5.srt |
1.48KB |
| 32. SQL query command for previous lecture.html |
3.63KB |
| 33. Case Study Exercise 5 Explanation.mp4 |
2.33MB |
| 33. Case Study Exercise 5 Explanation.srt |
803B |
| 33. SQL query command for previous lecture.html |
128B |
| 34. Case study using SELECT statement6.mp4 |
1.94MB |
| 34. Case study using SELECT statement6.srt |
654B |
| 34. SQL query command for previous lecture.html |
335B |
| 35. Case study using SELECT Explanation6.mp4 |
13.77MB |
| 35. Case study using SELECT Explanation6.srt |
2.29KB |
| 36. SQL query command for previous lecture.html |
548B |
| 4. Add data Explanation.mp4 |
10.55MB |
| 4. Add data Explanation.srt |
2.57KB |
| 4. Check the structure of the table.mp4 |
4.48MB |
| 4. Check the structure of the table.srt |
1.66KB |
| 4. ER diagram creation.mp4 |
8.44MB |
| 4. ER diagram creation.srt |
1.64KB |
| 4. Foreign key settings (1).mp4 |
27.38MB |
| 4. Foreign key settings (1).srt |
9.90KB |
| 4. INNER JOIN(2).mp4 |
17.12MB |
| 4. INNER JOIN(2).srt |
4.80KB |
| 4. Register for an AWS account.mp4 |
12.32MB |
| 4. Register for an AWS account.srt |
4.07KB |
| 4. SQL Overview.mp4 |
49.38MB |
| 4. SQL Overview.srt |
10.65KB |
| 4. SQL query command for previous lecture.html |
428B |
| 4. SQL query command for previous lecture.html |
1.22KB |
| 4. SQL query command for previous lecture.html |
518B |
| 4. Subquery in SELECT clause.mp4 |
15.11MB |
| 4. Subquery in SELECT clause.srt |
4.13KB |
| 4. Utilization of parameters.mp4 |
26.72MB |
| 4. Utilization of parameters.srt |
6.27KB |
| 4. 【Answer3】Create a personnel evaluation table.mp4 |
13.29MB |
| 4. 【Answer3】Create a personnel evaluation table.srt |
3.09KB |
| 5. Aggregate function (2).mp4 |
11.23MB |
| 5. Aggregate function (2).srt |
2.92KB |
| 5. Delete table.mp4 |
3.04MB |
| 5. Delete table.srt |
1.27KB |
| 5. Foreign key settings (2).mp4 |
32.00MB |
| 5. Foreign key settings (2).srt |
5.55KB |
| 5. Logical formula by NOT LIKE.mp4 |
11.20MB |
| 5. Logical formula by NOT LIKE.srt |
2.38KB |
| 5. MySQL DB and SQL experience (1) (Building RDS).mp4 |
31.54MB |
| 5. MySQL DB and SQL experience (1) (Building RDS).srt |
4.42KB |
| 5. RDS Overview.mp4 |
59.51MB |
| 5. RDS Overview.srt |
13.27KB |
| 5. SQL query command for previous lecture.html |
1.55KB |
| 5. SQL query command for previous lecture.html |
344B |
| 5. SQL query command for previous lecture.html |
1011B |
| 5. SQL query from the previous lecture.html |
300B |
| 5. Utilization of AS.mp4 |
8.82MB |
| 5. Utilization of AS.srt |
2.28KB |
| 5. 【Answer1】Create a payroll information table.mp4 |
13.25MB |
| 5. 【Answer1】Create a payroll information table.srt |
2.90KB |
| 6. Definition of stored function.mp4 |
40.13MB |
| 6. Definition of stored function.srt |
8.51KB |
| 6. Delete database.mp4 |
3.93MB |
| 6. Delete database.srt |
1.82KB |
| 6. Foreign key settings (3).mp4 |
77.07MB |
| 6. Foreign key settings (3).srt |
12.54KB |
| 6. How to update data.mp4 |
23.83MB |
| 6. How to update data.srt |
7.25KB |
| 6. LEFT JOIN.mp4 |
12.17MB |
| 6. LEFT JOIN.srt |
3.03KB |
| 6. MySQL DB and SQL experience (2) (Installing MySQL Workbench).mp4 |
15.87MB |
| 6. MySQL DB and SQL experience (2) (Installing MySQL Workbench).srt |
2.37KB |
| 6. Overview of MySQL Workbench.mp4 |
34.16MB |
| 6. Overview of MySQL Workbench.srt |
7.33KB |
| 6. SQL query command for previous lecture.html |
291B |
| 6. SQL query command for previous lecture.html |
939B |
| 6. SQL query command for previous lecture.html |
124B |
| 6. SQL query from the previous lecture.html |
2.96KB |
| 6. Subquery in WHERE clause.mp4 |
17.82MB |
| 6. Subquery in WHERE clause.srt |
4.27KB |
| 7. Aggregate function (3).mp4 |
12.98MB |
| 7. Aggregate function (3).srt |
3.31KB |
| 7. Logical expression by AND and OR.mp4 |
16.01MB |
| 7. Logical expression by AND and OR.srt |
3.79KB |
| 7. MySQL DB and SQL experience (3) (Connecting to and operating RDS).mp4 |
47.69MB |
| 7. MySQL DB and SQL experience (3) (Connecting to and operating RDS).srt |
8.15KB |
| 7. SQL queries in this section.html |
611B |
| 7. SQL query command for previous lecture.html |
426B |
| 7. SQL query command for previous lecture.html |
1.78KB |
| 7. SQL query command for previous lecture.html |
1.17KB |
| 7. SQL query from the previous lecture.html |
97B |
| 7. SQL query from the previous lecture.html |
1.78KB |
| 7. Utilization of DISTINCT.mp4 |
13.85MB |
| 7. Utilization of DISTINCT.srt |
3.92KB |
| 8. Data update Issue.mp4 |
1.78MB |
| 8. Data update Issue.srt |
784B |
| 8. RIGHT JOIN.mp4 |
20.14MB |
| 8. RIGHT JOIN.srt |
3.83KB |
| 8. SQL query command for previous lecture.html |
737B |
| 8. SQL query command for previous lecture.html |
1.01KB |
| 8. SQL query command for previous lecture.html |
239B |
| 8. Unique key settings.mp4 |
29.68MB |
| 8. Unique key settings.srt |
5.63KB |
| 8. Use of EXISTS.mp4 |
17.86MB |
| 8. Use of EXISTS.srt |
4.36KB |
| 9. BETWEEN formula.mp4 |
15.15MB |
| 9. BETWEEN formula.srt |
3.46KB |
| 9. Data update Explanation.mp4 |
3.90MB |
| 9. Data update Explanation.srt |
1.01KB |
| 9. Functions related to strings (1).mp4 |
34.55MB |
| 9. Functions related to strings (1).srt |
6.62KB |
| 9. SQL query command for previous lecture.html |
835B |
| 9. SQL query command for previous lecture.html |
704B |
| 9. SQL query from the previous lecture.html |
957B |
| 9. Utilization of ORDER BY.mp4 |
22.97MB |
| 9. Utilization of ORDER BY.srt |
1.12KB |