|
|
Building Queries for Relational Databases |
|
| |
|
|
|
| CD04 |
|
|
|
| Focus On: |
|
Query Section |
|
|
Lesson No |
File Name |
Duration |
| |
Intro |
CD04 Introduction |
1:42 |
| |
1 |
01 Viewing the Query Section |
4:23 |
| |
2 |
02 Using Data Models |
3:03 |
| |
3 |
03 Inserting a Query |
1:28 |
| |
4 |
04 Adding Tables to Query |
1:30 |
| |
5 |
05 Joining Tables |
2:16 |
| |
6 |
06 Adding Items to the Request Bar |
3:24 |
| |
7 |
07 Reordering Items on the Request Bar |
3:20 |
| |
8 |
08 Removing Items from the Request Bar |
2:03 |
| |
9 |
09 Hiding Request Items |
2:28 |
| |
10 |
10 Processing Queries |
2:36 |
| |
11 |
11 Saving Queries |
2:11 |
| |
12 |
12 Cancelling Queries |
1:39 |
| |
13 |
13 Setting Query Processing Order |
3:05 |
| |
14 |
14 Duplicating a Query |
1:57 |
| |
15 |
15 Looking at the Limit Dialog Box |
6:23 |
| |
16 |
16 Adding Limits to the Limit Bar |
3:33 |
| |
17 |
17 Setting a Variable Limit |
3:00 |
| |
18 |
18 Adding Sorts to the Query |
4:19 |
| |
19 |
19 Setting Query Options |
3:37 |
| |
20 |
20 Estimating Query Size |
1:27 |
| |
21 |
21 Using the SUM Function |
4:18 |
| |
22 |
22 Using Local Results |
3:07 |
| |
23 |
23 Adding a Computed Item to a Query |
4:49 |
| |
24 |
24 Displaying Show Remarks |
2:42 |
| |
25 |
25 Viewing Details |
1:41 |
| |
26 |
26 Viewing Table Properties |
3:06 |
| |
|
Total Time |
1:20:57 |
