|
PART 1 DATABASE FUNDAMENTALS |
|
|
1 | (262) |
|
|
3 | (67) |
|
The Importance Of Databases In The Internet And Mobile App World |
|
|
4 | (3) |
|
|
7 | (1) |
|
What Are The Problems With Using Lists? |
|
|
7 | (3) |
|
Using Relational Database Tables |
|
|
10 | (6) |
|
How Do I Process Relational Tables' |
|
|
16 | (2) |
|
What Is A Database System? |
|
|
18 | (5) |
|
Personal Versus Enterprise-Class Database Systems |
|
|
23 | (6) |
|
What Is A Web Database Application? |
|
|
29 | (1) |
|
What Are Data Warehouses And Business Intelligence (BI) Systems? |
|
|
29 | (1) |
|
|
30 | (1) |
|
|
30 | (1) |
|
The Access Workbench Section 1 Getting Started With Microsoft Access |
|
|
31 | (39) |
|
|
61 | (1) |
|
|
62 | (1) |
|
|
62 | (2) |
|
|
64 | (1) |
|
Access Workbench Key Terms |
|
|
65 | (1) |
|
Access Workbench Exercises |
|
|
65 | (2) |
|
San Juan Sailboat Charters Case Questions |
|
|
67 | (1) |
|
Garden Glory Project Questions |
|
|
68 | (1) |
|
James River Jewelry Project Questions |
|
|
69 | (1) |
|
The Queen Anne Curiosity Shop Project Questions |
|
|
69 | (1) |
|
|
70 | (63) |
|
|
70 | (4) |
|
|
74 | (9) |
|
The Problem Of Null Values |
|
|
83 | (1) |
|
To Key Or Not To Key---that Is The Question! |
|
|
84 | (1) |
|
Functional Dependencies And Normalization |
|
|
85 | (16) |
|
The Access Workbench Section 2 Working With Multiple Tables In Microsoft Access |
|
|
101 | (32) |
|
|
119 | (1) |
|
|
120 | (1) |
|
|
120 | (2) |
|
|
122 | (2) |
|
Access Workbench Key Terms |
|
|
124 | (1) |
|
Access Workbench Exercises |
|
|
124 | (4) |
|
Regional Labs Case Questions |
|
|
128 | (1) |
|
Garden Glory Project Questions |
|
|
129 | (1) |
|
James River Jewelry Project Questions |
|
|
130 | (1) |
|
The Queen Anne Curiosity Shop Project Questions |
|
|
130 | (3) |
|
3 Structured Query Language |
|
|
133 | (130) |
|
|
134 | (7) |
|
SQL For Data Definition (DDL)---Creating Tables And Relationships |
|
|
141 | (14) |
|
SQL For Data Manipulation (DML)---Inserting Data |
|
|
155 | (4) |
|
SQL For Data Manipulation (DML)---Single Table Queries |
|
|
159 | (3) |
|
Submitting SQL Statements To The DBMS |
|
|
162 | (2) |
|
SQL Enhancements For Single Table Queries |
|
|
164 | (12) |
|
SQL Queries That Perform Calculations |
|
|
176 | (4) |
|
Grouping Rows Using SQL Select Statements |
|
|
180 | (3) |
|
SQL For Data Manipulation (DML)---multiple Table Queries |
|
|
183 | (14) |
|
SQL For Data Manipulation (DML)---data Modification And Deletion |
|
|
197 | (3) |
|
SQL For Data Definition (DDL)---Table And Constraint Modification And Deletion |
|
|
200 | (2) |
|
|
202 | (1) |
|
The Access Workbench Section 3 Working With Queries In Microsoft Access |
|
|
202 | (40) |
|
|
231 | (2) |
|
|
233 | (1) |
|
|
233 | (5) |
|
|
238 | (1) |
|
Access Workbench Key Terms |
|
|
239 | (1) |
|
Access Workbench Exercises |
|
|
239 | (3) |
|
Heather Sweeney Designs Case Questions |
|
|
242 | (21) |
|
Garden Glory Project Questions |
|
|
253 | (3) |
|
James River Jewelry Project Questions |
|
|
256 | (1) |
|
The Queen Anne Curiosity Shop Project Questions |
|
|
256 | (7) |
|
|
263 | (100) |
|
4 Data Modeling And The Entity-Relationship Model |
|
|
265 | (52) |
|
|
266 | (1) |
|
The Entity-Relationship Data Model |
|
|
267 | (5) |
|
Entity-Relationship Diagrams |
|
|
272 | (10) |
|
Developing An Example E-R Diagram |
|
|
282 | (8) |
|
The Access Workbench Section 4 Prototyping Using Microsoft Access |
|
|
290 | (22) |
|
|
308 | (1) |
|
|
309 | (1) |
|
|
309 | (2) |
|
|
311 | (1) |
|
Access Workbench Key Terms |
|
|
311 | (1) |
|
Access Workbench Exercises |
|
|
311 | (1) |
|
High Line University Mentor Program Case Questions |
|
|
312 | (2) |
|
Writer's Patrol Case Questions |
|
|
314 | (3) |
|
Garden Glory Project Questions |
|
|
315 | (1) |
|
James River Jewelry Project Questions |
|
|
315 | (1) |
|
The Queen Anne Curiosity Shop Project Questions |
|
|
315 | (2) |
|
|
317 | (46) |
|
The Purpose Of A Database Design |
|
|
318 | (1) |
|
Transforming A Data Model Into A Database Design |
|
|
318 | (1) |
|
Representing Entities With The Relational Model |
|
|
319 | (8) |
|
Representing Relationships |
|
|
327 | (13) |
|
Database Design At Heather Sweeney Designs |
|
|
340 | (8) |
|
The Access Workbench Section 5 Relationships In Microsoft Access |
|
|
348 | (12) |
|
|
354 | (1) |
|
|
355 | (1) |
|
|
355 | (1) |
|
|
356 | (1) |
|
Access Workbench Key Terms |
|
|
357 | (1) |
|
Access Workbench Exercises |
|
|
357 | (1) |
|
San Juan Sailboat Charters Case Questions |
|
|
358 | (2) |
|
Writer's Patrol Case Questions |
|
|
360 | (3) |
|
Garden Glory Project Questions |
|
|
360 | (1) |
|
James River Jewelry Project Questions |
|
|
360 | (1) |
|
The Queen Anne Curiosity Shop Project Questions |
|
|
360 | (3) |
|
PART 3 DATABASE MANAGEMENT |
|
|
363 | (179) |
|
6 Database Administration |
|
|
365 | (57) |
|
The Heather Sweeney Designs Database |
|
|
366 | (1) |
|
The Need For Control, Security, And Reliability |
|
|
366 | (2) |
|
|
368 | (6) |
|
SQL Transaction Control Language And Declaring Lock Characteristics |
|
|
374 | (4) |
|
|
378 | (2) |
|
|
380 | (7) |
|
Database Backup And Recovery |
|
|
387 | (4) |
|
Additional DBA Responsibilities |
|
|
391 | (1) |
|
The Access Workbench Section 6 Database Administration In Microsoft Access |
|
|
392 | (30) |
|
|
412 | (1) |
|
|
413 | (1) |
|
|
414 | (1) |
|
|
415 | (1) |
|
Access Workbench Key Terms |
|
|
416 | (1) |
|
Access Workbench Exercises |
|
|
416 | (1) |
|
Marcia's Dry Cleaning Case Questions |
|
|
417 | (1) |
|
Garden Glory Project Questions |
|
|
418 | (1) |
|
James River Jewelry Project Questions |
|
|
419 | (1) |
|
The Queen Anne Curiosity Shop Project Questions |
|
|
420 | (2) |
|
7 Database Processing Applications |
|
|
422 | (66) |
|
A Web Database Application For Heather Sweeney Designs |
|
|
425 | (1) |
|
The Web Database Processing Environment |
|
|
425 | (4) |
|
Database Server Access Standards |
|
|
429 | (29) |
|
Database Processing, XML And JSON |
|
|
458 | (4) |
|
The Access Workbench Section 7 Web Database Processing Using Microsoft Access |
|
|
462 | (26) |
|
|
478 | (1) |
|
|
479 | (1) |
|
|
479 | (2) |
|
|
481 | (2) |
|
Access Workbench Exercises |
|
|
483 | (1) |
|
Marcia's Dry Cleaning Case Questions |
|
|
483 | (2) |
|
Garden Glory Project Questions |
|
|
485 | (2) |
|
James River Jewelry Project Questions |
|
|
487 | (1) |
|
The Queen Anne Curiosity Shop Project Questions |
|
|
487 | (1) |
|
8 Data Warehouses, Business Intelligence Systems, And Big Data |
|
|
488 | (54) |
|
Business Intelligence Systems |
|
|
491 | (1) |
|
The Relationship Between Operational And BL Systems |
|
|
491 | (1) |
|
Reporting Systems And Data Mining Applications |
|
|
491 | (1) |
|
Data Warehouses And Data Marts |
|
|
492 | (11) |
|
|
503 | (4) |
|
Distributed Database Processing |
|
|
507 | (3) |
|
Object-Relational Databases |
|
|
510 | (1) |
|
|
511 | (1) |
|
|
511 | (2) |
|
Big Data And The Not Only SQL Movement |
|
|
513 | (5) |
|
The Access Workbench Section 8 Business Intelligence Systems Using Microsoft ACCESS |
|
|
518 | (24) |
|
|
531 | (2) |
|
|
533 | (1) |
|
|
533 | (2) |
|
|
535 | (2) |
|
Access Workbench Exercises |
|
|
537 | (1) |
|
Marcia's Dry Cleaning Case Questions |
|
|
537 | (1) |
|
Garden Glory Project Questions |
|
|
538 | (1) |
|
James River Jewelry Project Questions |
|
|
539 | (1) |
|
The Queen Anne Curiosity Shop Project Questions |
|
|
539 | (3) |
Glossary |
|
542 | (11) |
Index |
|
553 | |