Database Fundamentals MTA Exam 98-364 Video Course DVD

Duration : 7:00 Hours
Example files : not available 
Video format : MP4 
Video : AVC, 1280x720, 16: 9, 15fps, 500kbps 
Audio : AAC, 22.05kHz, 64kbps, mono


Content :

1. Welcome to Database Fundamentals (9 min) 
2. Getting Started with Databases (15 min) 
3. The Relational Database (19 min) 
4. The SQL Language (26 min) 
5. Lab: Creating a Database (7 min) 
6 Creating Tables (24 min) 
7. Lab: Working with Tables (16 min) 
8. Writing Basic Queries (23 min) 
9. Enhancing Queries with Conditions (23 min) 
10. Modifying Data with Queries
11. Lab : Working with SQL (25 min) 
12. Normalization (16 min) 
13. Keys & Constraints (21 min) 
14. Indexes (14 min) 
15. Writing Advanced Queries (18 min) 
16. Lab: Designing a Database (12 min ) 
17. Creating Views (11 min)
18. Creating Stored Procedures (17 min) 
19. Creating Functions (18 min) 
20. Lab: Working with Database Objects (15 min) 
21. Security (14 min) 
22. Backup & Recovery (16 min) 
23. Ongoing Maintenance ( 15 min) 
24. Lab: Administering a Database (12 min)