|
|
01- Understanding SQL.en.srt
|
SRT
|
1.9 KB
|
|
|
01- Understanding SQL.mp4
|
MP4
|
22.7 MB
|
|
|
02- How to use the exercise files.en.srt
|
SRT
|
1.8 KB
|
|
|
02- How to use the exercise files.mp4
|
MP4
|
2.5 MB
|
|
|
03- Course overview.en.srt
|
SRT
|
2.5 KB
|
|
|
03- Course overview.mp4
|
MP4
|
2.6 MB
|
|
|
04- Installing on Windows.en.srt
|
SRT
|
9.7 KB
|
|
|
04- Installing on Windows.mp4
|
MP4
|
16.3 MB
|
|
|
05- Installing on a Mac.en.srt
|
SRT
|
12.5 KB
|
|
|
05- Installing on a Mac.mp4
|
MP4
|
17.9 MB
|
|
|
06- About SQL.en.srt
|
SRT
|
6.1 KB
|
|
|
06- About SQL.mp4
|
MP4
|
6.2 MB
|
|
|
07- Database organization.en.srt
|
SRT
|
4.5 KB
|
|
|
07- Database organization.mp4
|
MP4
|
5.5 MB
|
|
|
08- The SELECT statement.en.srt
|
SRT
|
8.6 KB
|
|
|
08- The SELECT statement.mp4
|
MP4
|
12.8 MB
|
|
|
09- Selecting rows.en.srt
|
SRT
|
3.7 KB
|
|
|
09- Selecting rows.mp4
|
MP4
|
7.7 MB
|
|
|
10- Selecting columns.en.srt
|
SRT
|
2.2 KB
|
|
|
10- Selecting columns.mp4
|
MP4
|
4.7 MB
|
|
|
11- Counting rows.en.srt
|
SRT
|
2.9 KB
|
|
|
11- Counting rows.mp4
|
MP4
|
4.3 MB
|
|
|
12- Inserting data.en.srt
|
SRT
|
2.8 KB
|
|
|
12- Inserting data.mp4
|
MP4
|
4.3 MB
|
|
|
13- Updating data.en.srt
|
SRT
|
3 KB
|
|
|
13- Updating data.mp4
|
MP4
|
5.2 MB
|
|
|
14- Deleting data.en.srt
|
SRT
|
1.6 KB
|
|
|
14- Deleting data.mp4
|
MP4
|
2.7 MB
|
|
|
15- Creating a table.en.srt
|
SRT
|
4.5 KB
|
|
|
15- Creating a table.mp4
|
MP4
|
6.3 MB
|
|
|
16- Deleting a table.en.srt
|
SRT
|
3.4 KB
|
|
|
16- Deleting a table.mp4
|
MP4
|
5 MB
|
|
|
17- Inserting rows.en.srt
|
SRT
|
4.6 KB
|
|
|
17- Inserting rows.mp4
|
MP4
|
7.9 MB
|
|
|
18- Deleting rows.en.srt
|
SRT
|
3 KB
|
|
|
18- Deleting rows.mp4
|
MP4
|
4.9 MB
|
|
|
19- The NULL value.en.srt
|
SRT
|
7.7 KB
|
|
|
19- The NULL value.mp4
|
MP4
|
14.2 MB
|
|
|
20- Constraining columns.en.srt
|
SRT
|
7 KB
|
|
|
20- Constraining columns.mp4
|
MP4
|
11.1 MB
|
|
|
21- Changing a schema.en.srt
|
SRT
|
3.8 KB
|
|
|
21- Changing a schema.mp4
|
MP4
|
5.8 MB
|
|
|
22- ID columns.en.srt
|
SRT
|
5.4 KB
|
|
|
22- ID columns.mp4
|
MP4
|
7.3 MB
|
|
|
23- Filtering data.en.srt
|
SRT
|
10.1 KB
|
|
|
23- Filtering data.mp4
|
MP4
|
19.5 MB
|
|
|
24- Removing duplicates.en.srt
|
SRT
|
4.6 KB
|
|
|
24- Removing duplicates.mp4
|
MP4
|
7.8 MB
|
|
|
25- Ordering output.en.srt
|
SRT
|
5.2 KB
|
|
|
25- Ordering output.mp4
|
MP4
|
8.6 MB
|
|
|
26- Conditional expressions.en.srt
|
SRT
|
4.1 KB
|
|
|
26- Conditional expressions.mp4
|
MP4
|
6.1 MB
|
|
|
27- Understanding JOIN.en.srt
|
SRT
|
3.7 KB
|
|
|
27- Understanding JOIN.mp4
|
MP4
|
4.2 MB
|
|
|
28- Accessing related tables.en.srt
|
SRT
|
10.2 KB
|
|
|
28- Accessing related tables.mp4
|
MP4
|
15.9 MB
|
|
|
29- Relating multiple tables.en.srt
|
SRT
|
7.6 KB
|
|
|
29- Relating multiple tables.mp4
|
MP4
|
13.8 MB
|
|
|
30- About SQL strings.en.srt
|
SRT
|
2.5 KB
|
|
|
30- About SQL strings.mp4
|
MP4
|
3 MB
|
|
|
31- Finding the length of a string.en.srt
|
SRT
|
2.8 KB
|
|
|
31- Finding the length of a string.mp4
|
MP4
|
4.6 MB
|
|
|
32- Selecting part of a string.en.srt
|
SRT
|
5.2 KB
|
|
|
32- Selecting part of a string.mp4
|
MP4
|
8.3 MB
|
|
|
33- Removing spaces.en.srt
|
SRT
|
2.5 KB
|
|
|
33- Removing spaces.mp4
|
MP4
|
3.3 MB
|
|
|
34- Folding case.en.srt
|
SRT
|
3.6 KB
|
|
|
34- Folding case.mp4
|
MP4
|
5.4 MB
|
|
|
35- Numeric types.en.srt
|
SRT
|
5 KB
|
|
|
35- Numeric types.mp4
|
MP4
|
4.9 MB
|
|
|
36- What type is that value.en.srt
|
SRT
|
3.4 KB
|
|
|
36- What type is that value.mp4
|
MP4
|
4.9 MB
|
|
|
37- Integer division.en.srt
|
SRT
|
2.9 KB
|
|
|
37- Integer division.mp4
|
MP4
|
4.3 MB
|
|
|
38- Rounding numbers.en.srt
|
SRT
|
1.7 KB
|
|
|
38- Rounding numbers.mp4
|
MP4
|
2.6 MB
|
|
|
39- Dates and times.en.srt
|
SRT
|
3.5 KB
|
|
|
39- Dates and times.mp4
|
MP4
|
3.5 MB
|
|
|
40- Date- and time-related functions.en.srt
|
SRT
|
3.2 KB
|
|
|
40- Date- and time-related functions.mp4
|
MP4
|
5.2 MB
|
|
|
41- What are aggregates.en.srt
|
SRT
|
7.6 KB
|
|
|
41- What are aggregates.mp4
|
MP4
|
11.9 MB
|
|
|
42- Using aggregate functions.en.srt
|
SRT
|
2 KB
|
|
|
42- Using aggregate functions.mp4
|
MP4
|
3.6 MB
|
|
|
43- Aggregating DISTINCT values.en.srt
|
SRT
|
2.8 KB
|
|
|
43- Aggregating DISTINCT values.mp4
|
MP4
|
4 MB
|
|
|
44- What are transactions.en.srt
|
SRT
|
3.5 KB
|
|
|
44- What are transactions.mp4
|
MP4
|
3.5 MB
|
|
|
45- Data integrity.en.srt
|
SRT
|
6.3 KB
|
|
|
45- Data integrity.mp4
|
MP4
|
10.6 MB
|
|
|
46- Performance.en.srt
|
SRT
|
4.3 KB
|
|
|
46- Performance.mp4
|
MP4
|
7.3 MB
|
|
|
47- Automating data with triggers.en.srt
|
SRT
|
6.8 KB
|
|
|
47- Automating data with triggers.mp4
|
MP4
|
10.7 MB
|
|
|
48- Preventing updates.en.srt
|
SRT
|
6.5 KB
|
|
|
48- Preventing updates.mp4
|
MP4
|
9.7 MB
|
|
|
49- Example - Timestamps.en.srt
|
SRT
|
5.3 KB
|
|
|
49- Example - Timestamps.mp4
|
MP4
|
9.4 MB
|
|
|
50- Creating a subselect.en.srt
|
SRT
|
4.4 KB
|
|
|
50- Creating a subselect.mp4
|
MP4
|
8.2 MB
|
|
|
51- Searching within a result set.en.srt
|
SRT
|
4.7 KB
|
|
|
51- Searching within a result set.mp4
|
MP4
|
8.3 MB
|
|
|
52- Creating a view.en.srt
|
SRT
|
3.2 KB
|
|
|
52- Creating a view.mp4
|
MP4
|
6.3 MB
|
|
|
53- Creating a joined view.en.srt
|
SRT
|
4 KB
|
|
|
53- Creating a joined view.mp4
|
MP4
|
8 MB
|
|
|
54- Embedding SQL.en.srt
|
SRT
|
8.6 KB
|
|
|
54- Embedding SQL.mp4
|
MP4
|
13.4 MB
|
|
|
55- The SELECT functions.en.srt
|
SRT
|
9.8 KB
|
|
|
55- The SELECT functions.mp4
|
MP4
|
17.8 MB
|
|
|
56- The INSERT, UPDATE, and DELETE functions.en.srt
|
SRT
|
5.8 KB
|
|
|
56- The INSERT, UPDATE, and DELETE functions.mp4
|
MP4
|
9.8 MB
|
|
|
57- Goodbye.en.srt
|
SRT
|
1.8 KB
|
|
|
57- Goodbye.mp4
|
MP4
|
3.5 MB
|
|
|
Ex_Files_SQL_EssT.zip
|
ZIP
|
259.7 KB
|
