[CBT Nuggets / Garth Schulte] Database Fundamentals [2016, ENG]

Содержание

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 (16 min)
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)

Об авторе

"I've always believed the best way to learn anything is to see it happen and try it yourself. My first experience with CBT Nuggets reinforced that belief and I'm both proud and honored to be a part of a company that strives to enrich people's lives with the power of knowledge!"
Garth Schulte began training on Office products about 20 years ago. His love of training led him to branch out to technical VB6 and SQL Server training. One of CBT Nuggets’ longest-tenured trainers, he recently worked as a product manager, lead .NET windows programmer and SQL Server architect for one of the top back-end real estate software companies in the country. He is a Google Authorized Trainer.