|
|
1. Introduction Video
|
|
|
10. SOLUTION- SELECT - FROM Video
|
|
|
11. SELECT DISTINCT Video
|
|
|
12. ASSIGNMENT- SELECT DISTINCT Video
|
|
|
13. SOLUTION- SELECT - FROM Video
|
|
|
14. The WHERE Clause Video
|
|
|
15. Common WHERE Operators Video
|
|
|
16. ASSIGNMENT- The WHERE Clause Video
|
|
|
17. SOLUTION- The WHERE Clause Video
|
|
|
18. Combining WHERE - AND Video
|
|
|
19. ASSIGNMENT- WHERE - AND Video
|
|
|
2. Getting to Know the Database Video
|
|
|
20. SOLUTION- WHERE - AND Video
|
|
|
21. Combining WHERE - OR Video
|
|
|
22. ASSIGNMENT- Combining WHERE - OR Video
|
|
|
23. SOLUTION- Combining WHERE - OR Video
|
|
|
24. Combining WHERE - IN Video
|
|
|
25. The LIKE Operator Video
|
|
|
26. LIKE Wildcard Examples Video
|
|
|
27. ASSIGNMENT- The LIKE Operator Video
|
|
|
28. SOLUTION- The LIKE Operator Video
|
|
|
29. The GROUP BY Clause Video
|
|
|
3. The -Big 6- Video
|
|
|
30. GROUP BY Example Video
|
|
|
31. PRO TIP- Using Comments - Aliases Video
|
|
|
32. ASSIGNMENT- GROUP BY Video
|
|
|
33. SOLUTION- GROUP BY Video
|
|
|
34. Multiple Dimension GROUP BY Clauses Video
|
|
|
35. Aggregate Functions Video
|
|
|
36. ASSIGNMENT- Aggregate Functions Video
|
|
|
37. SOLUTION- Aggregate Functions Video
|
|
|
38. The HAVING Clause Video
|
|
|
39. HAVING Example Video
|
|
|
4. The SELECT Statement Video
|
|
|
40. ASSIGNMENT- The HAVING Clause Video
|
|
|
41. SOLUTION- The HAVING Clause Video
|
|
|
42. The ORDER BY Clause Video
|
|
|
43. ORDER BY Example Video
|
|
|
44. ASSIGNMENT- The ORDER BY Clause Video
|
|
|
45. SOLUTION- The ORDER BY Clause Video
|
|
|
46. RECAP- The -Big 6- Video
|
|
|
5. The FROM Clause Video
|
|
|
6. SELECT - FROM Video
|
|
|
7. The Use Statement Video
|
|
|
8. Selecting Specific Columns Video
|
|
|
9. ASSIGNMENT- SELECT - FROM Video
|