Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Complete WAMP & MySQL Course
First Section
1) intro (0:41)
3) What is a Database? (1:35)
4) What will this class cover? (0:47)
5) Lets discuss a music festival (1:46)
6) Look at these examples of Databases (1:42)
7) Tools In Our Database Toolbox (3:10)
8) Initial Discussion About Tables (5:38)
9) Foreign Keys (1:49)
10) Download WAMP (1:16)
11) Needs Fixes Installing WAMP (3:41)
12) Simple Tour Of PHPMyAdmin (1:24)
13) Creating Our Database and First Table (5:14)
14) Walk Through of PHP My Admin From a Database Standpoint (1:37)
15) Creating Our Vendor And Customer Tables (5:47)
16) Creating our first vendor and customer table (5:47)
18) Filling out Our Data (8:26)
Second Section
20) Fill Out Vendors (10:44)
21) Insert 1 Record By Script (3:10)
22) Massive Customer Import (4:38)
23) Massive Import Script (4:38)
24) Working Examples of a Select Statement (6:25)
25) answers to those excercises (3:20)
26) Order by Clause (3:30)
27) Where Clause In Detail (4:56)
28) The Like Statement (3:53)
30) How to export and import data (2:15)
31) Database Redesign (5:31)
32) Lets do another Foreign Key (6:39)
Third Section
33) Adding a band member table (8:09)
35) Answer to exercise (0:53)
36) The IN Statement (5:16)
37) Using Rand Function to make random data (5:58)
38) Create random demographic data (4:11)
Fourth Section
39) What is a sub-query and how to use it (7:27)
Fifth Section
40) SQL Exercise (1:09)
42) Explanation of the exercise (2:17)
43) Basic analytics using aggregate functions (1:51)
45) Explanation of the analytics exercise (2:36)
Sixth Section
46) Our first Group By (4:03)
16) Creating our first vendor and customer table
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock